Hi
I have 4 rows of data.
Row 1 = Months of the year, Jan, Feb etc
Row 2 = target Values
Row 3 Actual Values
Row 4 Amber Values (vary between 80-90% of target)

I am creating a graph on separate tab and as a summary would like to bring
back the latest value on each row.
So if i complete for July, the summary will show me Target Actual and Amber
in 3 diff cells next to graph for July. If i plug in Aug data, the summary
changes to that data.

I have had a play with various methids, but cant cracki t.
Hopefully i have explained ok for all,
Can anyone help?
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com