Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. archwayguy

    Profile Problem w/Long Filenames

    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...
  2. archwayguy

    Why are YOU still running Windows 2000

    Apparently we are stuck on Win2k because the entire domain was built around it and Novell. Also some really ridiculous legacy apps.
  3. archwayguy

    Intranet site different than Internet site

    I'll check it out tonight and post my info or the results.
  4. archwayguy

    Excel Script Re-Write?

    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...
  5. archwayguy

    Excel Script Re-Write?

    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...
  6. archwayguy

    Locate Serial Numbers over Network?

    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...
  7. archwayguy

    Intranet site different than Internet site

    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...
  8. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    Well, thanks for the prodding at least.
  9. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  10. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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?
  11. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  12. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  13. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  14. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  15. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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.
  16. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  17. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  18. archwayguy

    Excel 2000: Conditional Formatting: Match Values

    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...
  19. archwayguy

    Intranet opens up searchportal.information.com

    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?
  20. archwayguy

    Active Directory Migration for remote laptops

    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.

Part and Inventory Search

Back
Top