N
Nornny
Hi everyone. So I'm creating a 13-month report of sorts. There are 1
sheets, each of which will hold data for each month. There is also on
summary sheet, per say, that uses all that data to create the dat
tables for graphs. The summary table is set up like so:
Code
-------------------
-----------Jan '01--------Feb '01-----------...-------------Jan '02
Cats-------3----------------4------------------...---------------6
Dogs-------5----------------6------------------...---------------5
-------------------
So within the data cells, say Cats in Jan '01, the formula would b
something like COUNTA('Jan ''01'!A:A) where Jan '01 is the name of th
January worksheet.
What I want to do is to make it so that there's a continuous cycle as
add a new month. For example, I want Feb '01 to Feb '02 now. All
would have to do is add a sheet called Feb '02 and delete Jan '01. Th
other worksheets will still remain, and the data should stay, but no
the summary table would change to reflect that. Can I do this in a
easy way?
My guess is to change the data cells and using INDIRECT (which I don'
know how to do, and it might be the wrong function), so it will alway
link to the first month's sheet, as opposed to Jan '04. Would macros b
required and is there some code I can start off with if so?
Thank you so much in advance
sheets, each of which will hold data for each month. There is also on
summary sheet, per say, that uses all that data to create the dat
tables for graphs. The summary table is set up like so:
Code
-------------------
-----------Jan '01--------Feb '01-----------...-------------Jan '02
Cats-------3----------------4------------------...---------------6
Dogs-------5----------------6------------------...---------------5
-------------------
So within the data cells, say Cats in Jan '01, the formula would b
something like COUNTA('Jan ''01'!A:A) where Jan '01 is the name of th
January worksheet.
What I want to do is to make it so that there's a continuous cycle as
add a new month. For example, I want Feb '01 to Feb '02 now. All
would have to do is add a sheet called Feb '02 and delete Jan '01. Th
other worksheets will still remain, and the data should stay, but no
the summary table would change to reflect that. Can I do this in a
easy way?
My guess is to change the data cells and using INDIRECT (which I don'
know how to do, and it might be the wrong function), so it will alway
link to the first month's sheet, as opposed to Jan '04. Would macros b
required and is there some code I can start off with if so?
Thank you so much in advance