Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help - Auto update from multiple spreadsheets
Problem: I have multiple tabs in one spreadsheet that get updated by many
different people. Current methodology: I send the spreadsheet out to people, they each update their tabs and send it back to me. I then open each spreadsheet that is returned, locate the correct tab on the master spreadsheet and paste the updated information in. I am looking for a way that automates much of this updating process. Here are my thoughts, but I am not sure if this is possible. Also, if there are other solutions, I would love to hear about them. I was thinking if I had one separate file for each tab, I could have a tab for each in a master spreadsheet that I could link to the information in the individual files. If the individual file was updated, the tab in the master would automatically be updated with the new information. Notes- I want the actual information in the tab as opposed to just having links to each file. In MS Project this can be done through sub projects. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto update till...... | Excel Discussion (Misc queries) | |||
How do I pull information from multiple existing spreadsheets int. | Excel Discussion (Misc queries) | |||
How do you merge two spreadsheets to update data. | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Auto update entire columns / rows??? | Excel Worksheet Functions |