Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I merge and link workbooks into one summary workbook?
hello!
I am desperate - I need to link several workooks from different departments together to create one summary workbook that is automatically updated.. Can anyone help? If I just do "paste link" the format is different and it doesn't really work. In the best case this should be a mutual link - if the summary is updated, the source documents should be as well. is that possible? Thank you! Sylvia |
#2
|
|||
|
|||
Links are one-way only. You can "pull" info out of a cell in another
workbook, but you can't "push" new data back into that cell, at least not without writing VBA code to do it. If your main objection to what you are currently trying to do is the lost formatting, then add an extra step to the process: after you've completed the 'paste link' step, go back into Edit-Paste Special... and paste formats. "Sylvia" wrote: hello! I am desperate - I need to link several workooks from different departments together to create one summary workbook that is automatically updated.. Can anyone help? If I just do "paste link" the format is different and it doesn't really work. In the best case this should be a mutual link - if the summary is updated, the source documents should be as well. is that possible? Thank you! Sylvia |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I merge and link workbooks into one summary workbook?
I have 50+ workbooks that are identical in format. I would like to create 1
summary workbook without opening and clicking on the first cells in all the workbooks and copying the formula to all data cells on each of the sheets. Is there a way to sum the same cell in all the workbooks accross all data cells on each tab without manually clicking each link? The summary file would automatically update when changes are made to the 50+ detail workbooks. "Duke Carey" wrote: Links are one-way only. You can "pull" info out of a cell in another workbook, but you can't "push" new data back into that cell, at least not without writing VBA code to do it. If your main objection to what you are currently trying to do is the lost formatting, then add an extra step to the process: after you've completed the 'paste link' step, go back into Edit-Paste Special... and paste formats. "Sylvia" wrote: hello! I am desperate - I need to link several workooks from different departments together to create one summary workbook that is automatically updated.. Can anyone help? If I just do "paste link" the format is different and it doesn't really work. In the best case this should be a mutual link - if the summary is updated, the source documents should be as well. is that possible? Thank you! Sylvia |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I merge and link workbooks into one summary workbook?
Try the example here
http://www.rondebruin.nl/summary2.htm Or if you only want the values try the add-in (very easy) http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Christine" wrote in message ... I have 50+ workbooks that are identical in format. I would like to create 1 summary workbook without opening and clicking on the first cells in all the workbooks and copying the formula to all data cells on each of the sheets. Is there a way to sum the same cell in all the workbooks accross all data cells on each tab without manually clicking each link? The summary file would automatically update when changes are made to the 50+ detail workbooks. "Duke Carey" wrote: Links are one-way only. You can "pull" info out of a cell in another workbook, but you can't "push" new data back into that cell, at least not without writing VBA code to do it. If your main objection to what you are currently trying to do is the lost formatting, then add an extra step to the process: after you've completed the 'paste link' step, go back into Edit-Paste Special... and paste formats. "Sylvia" wrote: hello! I am desperate - I need to link several workooks from different departments together to create one summary workbook that is automatically updated.. Can anyone help? If I just do "paste link" the format is different and it doesn't really work. In the best case this should be a mutual link - if the summary is updated, the source documents should be as well. is that possible? Thank you! Sylvia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
linking to multiple workbooks | Excel Discussion (Misc queries) | |||
Removing Link to Access Query | Excel Discussion (Misc queries) | |||
Chart appearance using "export" method | Charts and Charting in Excel | |||
Mail merge to a chart | Charts and Charting in Excel |