Is it possible to merge data from two worksheets?
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. |
Is it possible to merge data from two worksheets?
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. |
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. |
All times are GMT +1. The time now is 12:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com