Helpp Please
(Using Aug as an Ex).At the End of the month, we woud like to have a formula
to replace the data of the corresponding month with updated data located on a
seperate worksheet. Information must remain constant until end of month due
to 12 month review cycle. Example: the end of this month, the information in
A8 and B8 should be updated ( Changing the month (A8) , is not as significant
as the data...but would be nice) with actual data located from a seperate
production sheet.
A B
1. Jan'07 95
2. Feb'07 94
3. Mar'07 93
4. April'07 96
5. May'07 97
6. June'07 92
7. July'07 91
8. Aug'06 92
9. Sept'06 90
10. Oct'06 99
11. Nov'06 93
12 Dec'06 90
Thanks for any assistance you can provide.
|