|Check out our Excel Resources|
Here a formula-based solution.
Assuming your entries are in A from A2 on.
If A1 is blank,
In B2 enter: =counta(A:A)+1
If A1 contains a label, remove +1 from the above formula. If A1 is blank, keep the formula as is.
In B3 enter: 10 (this is your criterion of last 10 entries)
In C2 enter: =IF(ROW()-1<=$B$3,INDIRECT(ADDRESS($B$2-$B$3+ROW()-1,COLUMN($A$2:$A$100))),"")
Copy down the formula in C2 as far as needed.
It is probably better to do this with a macro.
Try this :-
With Range(Range("A2"), Range("A65536").End(xlUp).Offset(-10, 0)).EntireRow
.Hidden = True
.Hidden = False
Another method would be to use a Dynamic Named Range. If you are not sure how to do this then follow my link to my web site and click the "Dynamic Named Ranges" link.
Lets say you call your dynamic range "MyDates" you could then use this formula starting from Row 2(first row for heading) in any Column on any sheet.
Copy this down to Row 11.
OzGrid Business Applications
If I could ask one more favor. It lists the dates perfectly from column A, but, is there a way for it to list everything from column A all the way to the last cell on the right, column H?
Thanks again, this already has been a tremendous help.