I am wondering if it is possible to merge two worksheets, that have the exact
same column headings, into one document, eliminating duplicate data based on
a specific column. On a weekly basis I am required to run a report and
evaluate it for action items. I am making notes on my main document and
therefore i would like to merge the new report into the old one eliminating
information that already exists in the old report.

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.

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.