Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tlozier
 
Posts: n/a
Default 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.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Worksheets Mark Jackson Excel Discussion (Misc queries) 1 June 9th 05 11:39 AM
Merge Worksheets Mark Jackson Excel Worksheet Functions 0 June 8th 05 11:42 PM
Trying to merge two excel worksheets Matt Carter Excel Discussion (Misc queries) 0 April 8th 05 04:11 PM
how to merge worksheets in the same workbook how to merge worksheets in a workbook Excel Worksheet Functions 3 January 5th 05 09:49 AM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 3rd 04 12:23 AM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"