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
|
|||
|
|||
Update Multiple Links
I have an Excel Application that contains multiple columns
of 15 cells vertically all these cells are linked and need to be updated every month to a new data feed. The field/cell names are the same every time. However, I need to do an update to all the linked fields/cells so that the data from the new data source gets reflected. Is there a way to update all the linked fields/cells in one fell swoop? Any suggestions will be welcome. Thanks |
#2
|
|||
|
|||
Update Multiple Links
Russ,
I suggest you look at the Indirect Function. This will allow you to place a fully qualified reference to your data source on the sheet, say at A2, and then have the data source reflected in the linked cells. As soon as you change the data source to a valid new file, then the new data will be reflected. Steve "Russ" wrote in message ... I have an Excel Application that contains multiple columns of 15 cells vertically all these cells are linked and need to be updated every month to a new data feed. The field/cell names are the same every time. However, I need to do an update to all the linked fields/cells so that the data from the new data source gets reflected. Is there a way to update all the linked fields/cells in one fell swoop? Any suggestions will be welcome. Thanks |
Thread Tools | |
Display Modes | |
|
|