I have a workbook set up that consists of several sheets and a summary
sheet that refers to the third row on every other sheet.
The worksheets that are referenced contain dated information that is
sorted with the most recent entries entered in row 3 and these are the
entries I need to track in the summary sheet.
When I insert a new row 3 in these worksheets, the formula in the
summary automatically updates to line 4 and I need it to always
reference row 3, the newest entry.
This should be simple but I cannot find the solution.
Any ideas?
Thanks,
krisp1950
Bookmarks