I have dates in columns like this:
25/09/06 02/10/06 09/10/06 16/10/06 23/10/06 etc
And on another worksheet I have:
5000 in cell A1 and then 02/10/06 in cell B1 and 16/10/06 in cell C1
I would like 5000 to appear under the column headings for 02/10/06, 09/10/06, and 16/10/06 in my first worksheet - based on the values in cell A1 and the date range in B1 and C1.
Is there a formula that can do this?
Any help would be very much appreciated. Thanks.
Bookmarks