 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005merging data
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.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > 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!! > Since your question is very "general", here's a "general" suggestion: > [quoted text clipped - 13 lines] > > 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! ------------------------------------------------------------------- > 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!! [quoted text clipped - 25 lines] > > > 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! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.