Merge worksheets - exceptions
 

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.

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