LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Valerian
 
Posts: n/a
Default Is it possible to merge data from two worksheets?

You are correct in that there is a master document. However, the new report
(week 2, 3, 4) May have new information, action items to be addressed. I
don't want to duplicate work, so I am looking for a way to import the NEW
information into the master document. It is a Backlog Report and each week
(day) new things get added to the report and old things get taken off. Does
that make my problem a little more clear? Thanks.

"MartinW" wrote:

Hi Valerian,

Sounds like you are editing the master instead of a copy.
If you open your master and do a "save as" (week 1,
week 2, week 3 etc) then your weekly comments are saved
with the current information at time of saving and your
master is free to update unimpeded. There should be no
need to merge documents, or am I missing something here.



 
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
Create single chart with data from seperate worksheets MATT Charts and Charting in Excel 1 May 10th 06 04:09 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Putting data from multiple worksheets into one Teffy Excel Discussion (Misc queries) 3 July 16th 05 08:52 AM
Extract Data for Mail Merge Rashid Khan Excel Discussion (Misc queries) 7 December 24th 04 05:47 PM
Merge Data From Multiple Worksheets Corby Excel Worksheet Functions 1 December 22nd 04 03:25 PM


All times are GMT +1. The time now is 11:22 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"