Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two spreadsheet
Hello every one ,
Am a new bee to Ms excel. Am trying to find way to compare rows in two different spread sheets lets say spread A and Spread sheet B . I like to compare row with a key for example taking teamnumber as Key in two sheets and update data under Jan Feb march april in spread sheet B and put comments in a file on what was updated with time stamp. Spread sheet A. Id teamname funds jan feb march april 3 greatteam 10 1 2 4 3 Spread Sheet B Location teamname funds jan feb march april Dallas greatteam 11 .5 1 2 1 Out put should look like --------------------------------------------- Spread sheet B Location teamname funds jan feb march april Dallas greatteam 10 1 2 4 3 and it would be great if comments or any other form of log file is creasted with what all are updated. Appreciate the help/input thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel spreadsheet compare | Excel Discussion (Misc queries) | |||
comparing spreadsheets spreadsheet compare add-in | Excel Programming | |||
Compare two different spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet compare? | Excel Discussion (Misc queries) | |||
VLOOKUP for spreadsheet compare | Excel Programming |