Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
We run weekly reports that grow from week to week. We are looking for a
method to take last weeks worksheet and merge with the latest worksheet. For example last weeks worksheet had 5 events, this weeks worksheet has 7 (5 of the 7 events are the same as last weeks events) - we only want to see the 2 new events. Any and all ideas are welcome. |
#2
![]() |
|||
|
|||
![]()
Can you pick out a unique id for each event?
If you can, you could look at the new worksheet (with 7 events) and add a column to find out which events are carried over from the previous week. I'm gonna use sheet1 for last week's data and sheet2 for this weeks data and column A as the column that contains the unique event code. Insert a new column (column B???) in sheet2. use a formula like: In B2 (headers in row 1???) =isnumber(match(a2,sheet1!a:a,0)) and drag down. If the formula evaluates to True, it's old. If it's false, it's new. tlozier wrote: We run weekly reports that grow from week to week. We are looking for a method to take last weeks worksheet and merge with the latest worksheet. For example last weeks worksheet had 5 events, this weeks worksheet has 7 (5 of the 7 events are the same as last weeks events) - we only want to see the 2 new events. Any and all ideas are welcome. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
Merge Worksheets | Excel Worksheet Functions | |||
Trying to merge two excel worksheets | Excel Discussion (Misc queries) | |||
how to merge worksheets in the same workbook | Excel Worksheet Functions | |||
Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) |