Sunday, August 7, 2011

Pulling information from next tab?

I have monthly tabs (jan,feb,mar...) with information. I also have a summary sheet for each month (jan,feb,mar) pulling information from different columns to create statistical info. Every month, I copy the formula to the next month in the summary sheet and then replace jan with feb, feb with mar and so on in the the formula. Is there a way to tell excel to pull the date from the next month's tab when I pull the formula to the next cell so I do not have to make the changes manually?

No comments:

Post a Comment