merging data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master file and 4 workbooks where individuals enter info daily. I
need to update the master file workbook at the end of the day with the info
from the 4 individual notebooks. How would I merge this data? I tried the
"shared workbooks" process but it wouldn't let me do it. Please Help!
 
Since your question is very "general", here's a "general" suggestion:

Explore the use of links.

Have all WBs open.
Right click in a pertinent data cell of one of the 4 WBs, and choose "Copy".
Navigate to the appropriate cell in the "Master" WB.
Right click in this cell and choose "PasteSpecial".
Click on "PasteLink".

Now, any change to the "original" cell will be mirrored in the "Master" WB.
 
Thank you so much RD for your help! It worked and wasn't nearly as difficult
as I thought it would be. Again, many thanks!!
 
Back
Top