Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match/Overwrite
I have sheets in seperate workbooks, both have the same two columns I am
looking to match (User and Date). Sheet1 is updated every week and used to send data to sheet2. How do I check sheet2 for matches in these two columns before adding data from sheet1? Also, If there are any matches how do I delete/overwrite them so only the newest data is recorded? Sheet1 Sheet 2 User Date User Date 1 1/2/2009 1 1/9/2009 2 1/2/2009 1 1/9/2009 1 1/9/2009 1 1/9/2009 4 1/2/2009 1 1/9/2009 5 12/26/2008 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match/Overwrite
Sorry, formatting was funky.
"Jason W" wrote: I have sheets in seperate workbooks, both have the same two columns I am looking to match (User and Date). Sheet1 is updated every week and used to send data to sheet2. How do I check sheet2 for matches in these two columns before adding data from sheet1? Also, If there are any matches how do I delete/overwrite them so only the newest data is recorded? Sheet1 Sheet 2 User Date User Date 1 1/2/2009 1 1/9/2009 2 1/2/2009 1 1/9/2009 1 1/9/2009 1 1/9/2009 4 1/2/2009 1 1/9/2009 5 12/26/2008 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As / Overwrite | Excel Discussion (Misc queries) | |||
Overwrite Protection | Excel Discussion (Misc queries) | |||
Overwrite Changes when saving | Charts and Charting in Excel | |||
Overwrite changes dialogue box | Excel Discussion (Misc queries) | |||
Q: overwrite during saveas | Excel Discussion (Misc queries) |