Last Used Cell Formula

[BNatale1]

I'm looking for a formula to return the address of the last used cell in the same workbook but on a different sheet:

So I have a summary tab and nine other tabs, all data in the nine tabs are in column A. As an example, in the 9th tab the last used cell is A28; which shows: " 5 Dir(s) 87,313,903,616 bytes free"...I want to be able to pull, on the summary tab, that tab 9 has "5 Dir(s)"; so I need to find the address of the last used cell and then apply a mid() formula to extract the "5 Dir(s)"...is this possible?

Thanks!

 

[Stormseed]

I don't really know if this can help you...the formula is one of these created by Aladin. You can tweak to suit your needs. Check this out:

http://www.mrexcel.com/archive/Dates/26688.html

 

[Aladin Akyurek]

I'm looking for a formula to return the address of the last used cell in the same workbook but on a different sheet:

So I have a summary tab and nine other tabs, all data in the nine tabs are in column A. As an example, in the 9th tab the last used cell is A28; which shows: " 5 Dir(s) 87,313,903,616 bytes free"...I want to be able to pull, on the summary tab, that tab 9 has "5 Dir(s)"; so I need to find the address of the last used cell and then apply a mid() formula to extract the "5 Dir(s)"...is this possible?

Thanks!

This set up might be easier...

Y2:

=TRIM(LOOKUP(REPT("z",255),NinthTab!A:A))

X2:

=LEFT(X2,FIND(" ",X2)-1)

 

[BNatale1]

Thanks it worked!