May 07 2021 11:36 AM
I have an excel sheet with multiple tables defined (FIN, AR, MT...etc)
Each table has the same column structure (Income, Expense, Total).
From Each table, I need to get the value from the Total column in the last row and display in another sheet.
My question is how to I get the last row value.
Ex: In my FIN table, the Total is in column F
FIN table has 6 rows. This will be increased every day during data entry.
I need to access the Total in the last row of FIN table and show in the second sheet.
I can get the no of records in my table by using Rows(FIN) function.
So, if I have 6 rows, I need to get F6. If I try to use string concatenate F & rows(FIN), it doesn't work. Error out. Any way that I could get the value from the last row?
May 07 2021 11:46 AM
SolutionMay 07 2021 11:46 AM
Solution