If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatic updating
I am familiar with how to do basic linking between worksheets/workbooks.
I have multiple worksheets (some on Sharepoint, some on local drive) with different headers that I would like to link/feed automatically into one master worksheet (in a different workbook) without having to manually link each line separately. The information is updated daily in the multiple worksheets by various people. There are also reports generated from an online service that we convert and drop into Excel. The reports are all basically timelines of customer questions, date recv'd, our responses & resolutions. Is this possible to link the whole worksheet automatically? Thanks |
Thread Tools | |
Display Modes | |
|
|