Ok. I am going to try to explain what I need.


A B C D
1 Month D
2
3
4 Current JAN FEB
5 Sales 300 200 300
6 Expenses 50 100 50


Ok, every month I need to have the current month column equal the
current month. Lets say Feb is my current month, so I need b5 and b6
to relate to the Feb column which is d5 and d6. The current formula in
b5 is =c5. Every month I need to go thru every cell in the B column and
change it to the next current month, for example, Lets say I just got
down doing the month of Jan. The cell in b5 is =c5. I am now doing
Feb so I have to go into B5 and change the field to =d5. As you can
see this can be time consuming if I have a number of categories. I was
thinking it has to be possible to just change b1 and it would relate to
that column. I am not sure how to do it though. So every month I
would just change b1 and it would relate to the correct month to use
for the Current column.

Any help would be great..

Thanks

Tony


--
tonydepo
------------------------------------------------------------------------
tonydepo's Profile: http://www.excelforum.com/member.php...o&userid=15306
View this thread: http://www.excelforum.com/showthread...hreadid=381912