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
|
|||
|
|||
Multi-sheet issue
I have several sheets of budget numbers that are linking
from one sheet to another. In linking several sheets by pulling totals from one sheet to create other totals in another sheet we seem to have lost the ability to sort without changing the totals on the endpoint sheet. This happens because we're linking to the source sheet using the Sheet and Cell info and the sort places the totals in different cells than the ones named in the second sheet. Anyway to deal with this problem? Thanks. Koz |
#2
|
|||
|
|||
Multi-sheet issue
if the leftmost column has some identifying value, you could use the vlookup
function to find the appropriate row and return the value. -- Regards, Tom Ogilvy Abir wrote in message ... I have several sheets of budget numbers that are linking from one sheet to another. In linking several sheets by pulling totals from one sheet to create other totals in another sheet we seem to have lost the ability to sort without changing the totals on the endpoint sheet. This happens because we're linking to the source sheet using the Sheet and Cell info and the sort places the totals in different cells than the ones named in the second sheet. Anyway to deal with this problem? Thanks. Koz |
#3
|
|||
|
|||
Thanks Tom!
Thanks Tom. Appreciate it. Abir
-----Original Message----- if the leftmost column has some identifying value, you could use the vlookup function to find the appropriate row and return the value. -- Regards, Tom Ogilvy Abir wrote in message ... I have several sheets of budget numbers that are linking from one sheet to another. In linking several sheets by pulling totals from one sheet to create other totals in another sheet we seem to have lost the ability to sort without changing the totals on the endpoint sheet. This happens because we're linking to the source sheet using the Sheet and Cell info and the sort places the totals in different cells than the ones named in the second sheet. Anyway to deal with this problem? Thanks. Koz . |
Thread Tools | |
Display Modes | |
|
|