User logs in and the domain gives them a temporary profile. Receives an error indicating "WINDOWS CANNOT COPY FILE,FILE NAME OR EXTENSION IS TOO LONG". There is one file that is a shortcut in their recent folder that is the culprit. I can remove this and get them back in, but this is a link to a...
lol. Last time I asked something of this nature in the Office side, they sent me here. That's ok though, I managed a way around it just using a formula. In case anyone needed to know, I just condensed everything into two columns of new data and old data. Then inserted the info found here...
I'm not a pro in programming in the least bit, in fact, I know nothing about it. I have a script I found on the net that will take two columns in Excel and filter all duplicates to only show unique cells in either column. Now I need something that will do the exact opposite but with multiple...
I have a network with a large amount of HP printers of various models. Some of these are accessible via their web admin portals, others are available through webjet admin. The problem I am having is that some of these devices do not have their serial numbers listed in either portal and I was...
A company I'm working with recently updated their web site and it works great. Except when you goto the website internally, it takes you to the old website and not the new one. I'm not sure what version of IIS this is on, but it is Server 03. I don't have too many details, but I can get'em if...
I found this: http://nerds-central.blogspot.com/2008/05/column-uniquing-in-excel-via-vbscript.html
I ran it on a test with just one site and it worked like a champion. Problem is, I'll have to do it site by site as it won't discriminate between the locations column and I don't want to get the...
I tried Data>Advanced Filter with a test sheet, and I selected two columns of IP addresses and set it to Filter the list in place, and set the list range from $B$2:$C$47 with unique records only. Nothing happened. What am I doing wrong here?
I didn't mean I sorted the list and that's what I got, I mean that's what I want it to look like when it's done. If I could even hide the ones that match/duplicate that would be fantastic and make it much easier to finish this. I need the list for identification and inventory. It's outdated and...
So, original would look something like this:
New York 192.168.1.1 192.168.1.4
New York 192.168.1.2 192.168.1.7
New York 192.168.1.3 192.168.1.2
New York 192.168.1.4 192.168.1.22
And after sorting it would look something like this:
New York 192.168.1.1
New York 192.168.1.2 192.168.1.2...
Le sigh. I have three columns. One is site/location, one is an old list of ip addresses, and the last is a new list of ip addresses.
I want to take both columns of ip address and sort them so that the duplicates (i.e. those address that have not changed or are not new) are next to each other...
No, the site column remains the same, it's just for reference and cataloging. Only the ip address data has changed. Column B is old data, and Column C is the most up to data from the latest live network response. I need to match B & C so I can find old devices that no longer exist and prune them...
Because a vast majority of the information has changed. If I can match the data from B & C, then I will know what is an addition and what is a change. I have a second database that is going to be updated with the change information.
I need to pair the old data in Column B with the new data in Column C.
If something is in C and not in B, it should just leave that value and put a blank cell in Column B beside it.
If it has the same value in B & C, it should put them both in the same row, side by side.
C is larger (has...
I don't know if they will move or not. I haven't done anything yet that can't be undone. B & C have some identical values, but not all. I have two different data pools and I need to know which is accurate. If they match, then they are up to date, if they don't match, then Column C takes...
I have a very large spreadsheet full of network data. I need to cross-reference source A with source B. Basically, I have a physical location in Column A, then an IP address in Column B and C. I need B & C to match and for those ip addresses to stay within their matching locations with Column A...
Can they still access the intranet site by typing it in after this occurs? What is the homepage set to? Are they using a proxy? What browser & version?
Is the domain to remain the same? If their domain and logon information is going to remain the same, then the laptops that are pulling roaming profiles should be fine and will require no changes.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.