Hope someone can help
I have a sheet linked to a chart linked to the PowerPoint report.
The sheet column B-M is the months
Row 2-7 is years (2005-2010)
The data is then put into a chart
In Cell I21 I have =IF(K32000,"CLVs Met","CLVs Not Met")
K3 is Oct 06 and has a value of 2100 so I21 comes back as CLVs Met
Question can I have I21 show (change) to the newest data that was put into
another cell without changing the cell (I21) each time?
So if I put in a value of 1200 into L3 (Nov 06) I21 will show €œnot met€�
Thanks
James