Finding the last 12 rows of a range
I am trying to create a dynamic range that will return the last/bottom 12 rows from a range. I need to produce charts which show performance on a rolling 12 month period, I currently have a table which is set out something like this:
Date Actual % Target
Jan 07 67% 90%
Feb 07 77% 90%
Mar 07 52% 90%
Every month new figures are added to the bottom of this table, I would like to be able to pick up the last/bottom 12 entries automatically so the chart gets updated and we still have all the previous months data.
|