| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Data from two excel sheets!
I have sheets created with two columns A1 first name & B1 as the last name in
both sheets. Sheet 1 is my (master) sheet and sheet two is new (data) sheet. What I want it do is take the information from sheet two (Data) and compare it to sheet 1 (master) and give me a results of what is not part of the sheet1 (master) that needs to be added. Example Sheet 1 (master) Saku Koivu Erik Cole Danny Markov Jim Dowd Sheet 2 (Data) Saku Koivu Erik Cole Danny Markov Matt Stajan Jim Dowd Result = Matt Stajan I very new at this stuff so could you please explain it to me in detail. Any help would be appreciated. Thanks ahead |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Comparing two Excel sheets | Excel Discussion (Misc queries) | |||
| how do i find data in multiple sheets in excel | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Threaded Mode
