Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compare info in 4 worksheets and highlight fields that are the sam
I have someone who has 4 Excel spreadsheets with info in different columns.
Is there a way to have Excel compare all columns he chooses and highlight or somehow indicate the fields that are the same in multiple columns/worksheets? |
#2
|
|||
|
|||
compare info in 4 worksheets and highlight fields that are the sam
you asked in the function posting sooooo avoiding vba code:
FOR 2 list compare==== I would use 3 columns top of col 1 first list copy & paste in col 2 add list 2 to bottom of col 1 and copy and paste over to same rows in col 3 now block used areas of col 1,2,3 and DATAAdvanced Filter on col 1 with unique values checked col 1 is unique alph sorted listing and if in list 1 it will be repeated in col 2 if in list 2 will be repeated in col 3 depending on how often you are going to do this you could automate but this is the easiest process without VBA "Ellen" wrote: I have someone who has 4 Excel spreadsheets with info in different columns. Is there a way to have Excel compare all columns he chooses and highlight or somehow indicate the fields that are the same in multiple columns/worksheets? |
#3
|
|||
|
|||
compare info in 4 worksheets and highlight fields that are the
Thanks for the response. I've sent it onto the person who asked about this
and also let him know that vba is a possibility. Unfortunately we don't have anyone in IT who knows and supports VBA. The app dev staff do their programming in .net and don't want to support VBA. Would this be hard to do in VBA? "Vacation's Over" wrote: you asked in the function posting sooooo avoiding vba code: FOR 2 list compare==== I would use 3 columns top of col 1 first list copy & paste in col 2 add list 2 to bottom of col 1 and copy and paste over to same rows in col 3 now block used areas of col 1,2,3 and DATAAdvanced Filter on col 1 with unique values checked col 1 is unique alph sorted listing and if in list 1 it will be repeated in col 2 if in list 2 will be repeated in col 3 depending on how often you are going to do this you could automate but this is the easiest process without VBA "Ellen" wrote: I have someone who has 4 Excel spreadsheets with info in different columns. Is there a way to have Excel compare all columns he chooses and highlight or somehow indicate the fields that are the same in multiple columns/worksheets? |
#4
|
|||
|
|||
compare info in 4 worksheets and highlight fields that are the
If you do not have anyone with VBA knowledge then I suggest you proceed with the methood I posted using find time spent manually setting this up is a lot less than requirements to learn VBA. "Ellen" wrote: Thanks for the response. I've sent it onto the person who asked about this and also let him know that vba is a possibility. Unfortunately we don't have anyone in IT who knows and supports VBA. The app dev staff do their programming in .net and don't want to support VBA. Would this be hard to do in VBA? "Vacation's Over" wrote: you asked in the function posting sooooo avoiding vba code: FOR 2 list compare==== I would use 3 columns top of col 1 first list copy & paste in col 2 add list 2 to bottom of col 1 and copy and paste over to same rows in col 3 now block used areas of col 1,2,3 and DATAAdvanced Filter on col 1 with unique values checked col 1 is unique alph sorted listing and if in list 1 it will be repeated in col 2 if in list 2 will be repeated in col 3 depending on how often you are going to do this you could automate but this is the easiest process without VBA "Ellen" wrote: I have someone who has 4 Excel spreadsheets with info in different columns. Is there a way to have Excel compare all columns he chooses and highlight or somehow indicate the fields that are the same in multiple columns/worksheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Two Worksheets | Excel Discussion (Misc queries) | |||
How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
how to merge 2 worksheets and highlight differences | Excel Worksheet Functions |