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
|
|||
|
|||
question on links where info is added and cell location is wrong
Hi,
I have a question on excel links. Say a user has 2 workbooks, Workbook Red and Workbook Blue. In Workbook Red, a user has a 3 credits in cells B2, B3, and B4 that are added together and shown as a total in cell B5. The user creates a link from cell B5 in Workbook Red into cell A1 in Workbook Blue in order to grab the Total. Later the user finds out that every day he has to add another credit to Workbook Red. Therefore the Total will no longer be in cell B5 and the link will not grab the Total unless the user changes the link formula every day. Aside from putting the total on a row well down the page (thus leaving empty cells in that column above the total for adding new credits) is there any way for the link to allow for dynamic additions to a column (such as knowing it is tied to the cell just to the right of the cell labeled “Total”) without having to update the link location everyday since the total is bumped down one cell after every addition to the column? |
#2
|
|||
|
|||
question on links where info is added and cell location is wrong
Why not name the cell containing the total (Insert Name Define)
And reference the name in the link formula = [Red.xls]!Total Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|