Excel Month Question

[Inpatient]

I made a workout form in Excel and have 12 tabs - one for each month. I did January and separated the weeks grouping Monday through Sunday and have rows with formulas to total both cross and down and then averages and counts that sum for so many entries. Point here is that when I make the next month since I have the weeks separated, I have to do a lot of work. Is there an easy way to put in those weekly rows and retain all my formula work. Excel is very smart at figuring out what kind of pattern I am doing, so I though this might be possible. Does anyone know? Thanks

[dilipandey]

Hi Inpatient,

Welcome to the forum.

If you have Mondays/ Sundays appearing through formulas where are referencing to the Month (January here), yes.. it can be easily done... upload a sample workbook to have more idea after looking into the structure and data arrangements you have.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Pepe Le Mokko]

Why use 12 tabs anyway?

Given the amount of data will not be that large, using one sheet with the appropriate columns would be sufficient. You can than analyze easily any way you need to