I am trying to use a indirect sheet reference to find the final value in a column. The sheet name is held in D2 in the current sheet, the column required is E.
I am able to get the final value using:
=INDIRECT("E"&COUNTA(E:E))
but struggling to get the sheet to change, I have tried:
= INDIRECT(D$2!&"E"&COUNTA(E:E))
Any help would be appreciated. Thanks
This worked for me:
My sheet numbers are Sheet1, Sheet2, Sheet3.
Please Login or Register to view this content.
This returned the count of filled cells in column A
This gave me the contents of the cell:
Please Login or Register to view this content.
Last edited by mehmetcik; 10-05-2014 at 04:20 PM.
Thank you very much, it is working but I have put a slight spanner in the works and I didnt realise the header column would make a difference. I am now just getting the 2nd to last value, can you think of a quick fix?
Last edited by sm9748; 10-05-2014 at 05:12 PM. Reason: Update from previous post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks