Results 1 to 4 of 4

Thread: Compare cells and highlight duplicates with a macro

  1. May 3rd, 2005, 12:13 PM #1
    Firestart
    Firestart is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    69

    Question Compare cells and highlight duplicates with a macro

    Hi,

    Can anyone help. I have thousands of alpha numeric id's and I need to compare them to info on another Excel sheet and highlight any duplicates found. Does anyone have any ideas on how I can acheive that?!!


    Many thanks dudes!

    Eric
    Last edited by Firestart; May 6th, 2005 at 05:46 AM.
    Im here until I get good at this,.....the more help I get, the less silly questions you'll get! Thanks
    Reply With Quote Reply With Quote
  2. May 3rd, 2005, 03:12 PM #2
    VBAhack
    VBAhack is offline
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: Compare cells and highlight duplicates with a macro

    Are you looking for drop in code or need help with the conceptual approach? If the latter, you might get better response if you had some specific questions where you are stuck.

    VBAhack
    Reply With Quote Reply With Quote
  3. May 4th, 2005, 03:43 AM #3
    Firestart
    Firestart is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    69

    Re: Compare cells and highlight duplicates with a macro

    Drop i code would be great, of varying approaches too!

    Thanks!
    Im here until I get good at this,.....the more help I get, the less silly questions you'll get! Thanks
    Reply With Quote Reply With Quote
  4. May 6th, 2005, 05:47 AM #4
    Firestart
    Firestart is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    69

    Re: Compare cells and highlight duplicates with a macro

    Any ideas anyone?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width