How do I pull data for consecutive months in an Excel spreadsheet
Patti Ayala wrote:
Every month I have to add the next consecutive month's data to my formulas in
an Excel spreadsheet. For instance, in March 2008 I need to include YTD
sales comparison data from a work sheet that has 2007 monthly sales, so my
formulas pull from the January, February and March 2007 cells. When I move
on to April 2008, I have to go back and manually change my formulas to add
the cells that include April 2007 sales data. Is there any way to set this
up so I don't have to make these changes manually every month?
I'm sure there is, but it would help if you would show what your data and
formula looks like now.
|