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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bgamble77" wrote in message
...
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!

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!!

"Ragdyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bgamble77" wrote in message
...
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!

Appreciate the feed-back.
--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"bgamble77" wrote in message
...
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!!

"Ragdyer" wrote:

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.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"bgamble77" wrote in message
...
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!