What I have is multiple worksheets that track different accounts. In the end I have a summary worksheet, such that I pull some random info from the other worksheets into that one.
On a spreadsheet for a Credit Card, for instance, I make entries that keep scrolling down (have the rows frozen just about the headings).
Different accounts will have a different # of entries, so there is no static cell that I can pull the most current info from a certain sheet to the status sheet. So what I want to do is setup a status 'row' in the current sheet, that will always take the furtherest value down in its column. For instance, I'll keep row 5 as my status column in a certain sheet. This means, I want to keep the most current (furthest down) values copied into this row.
Row 5 - xxx yyy zzzz
Row 6 -
Row 7 - 111 111 1111
Row 8 - 222 222 2222
Row 9 - xxx 333 3333
Row 10 - 444 4444
Row 11 - yyy 5555
Row 12 - zzzz
The values in row 5 will always change to whatever the last cell in its respective column has, as long as its not blank. I will then take row 5 and reference it from my status sheet to pull the most current values to that sheet.
Is this possible? Do I need to explain it further?
[edit - this forum deleted my white spaces. There is no value for column 1 after row 9. No value for column 2 after row 11. Only column 3 has a value in row 12]
Edited by triple h, 28 March 2007 - 04:25 AM.