Hello All,
I have a workbook with multiple worksheets. I populate the main page with information from the other worksheets.
This has worked fine until I tried to grab a number (not the last number) from column that has a total at the bottom.
I want to populate cell J3 on the main page with the last entered number of column AD on sheet 8. column AD has a total at the bottom that I do not want. I just want the last number in the column above the total. there are a number of empty cells in-between but all are empty.
I have a workbook with multiple worksheets. I populate the main page with information from the other worksheets.
This has worked fine until I tried to grab a number (not the last number) from column that has a total at the bottom.
I want to populate cell J3 on the main page with the last entered number of column AD on sheet 8. column AD has a total at the bottom that I do not want. I just want the last number in the column above the total. there are a number of empty cells in-between but all are empty.