Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare & create list of uniques across books/sheets
Hello,
I wish to compare a Master worksheet A to a second worksheet B store in a separate workbook, where column X is 'SSN' on both sheets. I wan to create a list (SSN, LName, FName) on a SUMMARY sheet for all SSN that do not appear on both A and B. SSN is a unique value for eac person. Right now I have 8 separate worksheets, all saved in one workbook, tha I need to compare to the Master. I am thinking it may be easier t compare each sheet individually (creating 8 SUMMARY sheets) to th Master rather than comparing them all at once to the Master and havin one grand SUMMARY sheet. Am I correct in thinking this? Can anyone provide some assistance? Thank you -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare & create list of uniques across books/sheets
Don't see any advantage in preparing 8 summary sheets unless you need the
information on separate sheets. You can always mark each row as to what sheet was compared to master. -- Regards, Tom Ogilvy "P.Rumpz " wrote in message ... Hello, I wish to compare a Master worksheet A to a second worksheet B stored in a separate workbook, where column X is 'SSN' on both sheets. I want to create a list (SSN, LName, FName) on a SUMMARY sheet for all SSNs that do not appear on both A and B. SSN is a unique value for each person. Right now I have 8 separate worksheets, all saved in one workbook, that I need to compare to the Master. I am thinking it may be easier to compare each sheet individually (creating 8 SUMMARY sheets) to the Master rather than comparing them all at once to the Master and having one grand SUMMARY sheet. Am I correct in thinking this? Can anyone provide some assistance? Thank you. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare a value in two w/books | Excel Discussion (Misc queries) | |||
Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
Compare 2 column list across 2 sheets | Excel Worksheet Functions | |||
compare books macro | Excel Programming | |||
compare books | Excel Programming |