I have an excel file that I am currently using to create a chart every month. As it currently stands every month I have to change the cell it is referring to. On one sheet I have the multiple business units and months Example:
Col A Col B Col C Col D ..... Row1= Unit 1 - Jan - Feb - Mar - Etc..... Row2= Del Exp .02 .03 .07..... Row3= WH Exp .05 .07 .06.....
On the other sheet I have to manually go in and change it every month for the current month. So if the month is February I have to go change all the January numbers to look at the February column. I'm wondering if there is a function that would easily identify the data for the current month? So that when February numbers are entered it automatically populates it for the graph. Would I be able to add a MTD column at the end of my first sheet that looks to see the last data entry in that row, and then on the other sheet just reference that cell?
Any help is greatly appreciated.