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: "...