View Single Post
  #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.