Subsheets Populate in Master Sheet Help

mandy71480

New Member
Joined
Oct 12, 2006
Messages
1
I am tring to create a yearly workbook with 1 master sheet that populates all of the monthly sheets into 1 nice worksheet so they can be sorted. Yearly is the name of the master sheet and the monthly sheets are named as appropriate (January, February, March, etc)
Right now my formula looks like this:

=IF(January!A5>0,January!A5, "")

For January Then 33 cells later I have

=IF(February!A5>0,February!A5, "")

for february and so on and so forth. This almost works. My problem is that there may be times I need MORE than 33 cells per month, and times I may need less than 33 cells per month.

How can I have the subsheets data popluate into the yearly sheet without any extra spaces or without having lost cells like I have with the formula I have now.

Come of the cells are dates, some are numerical, and some are text, but all of them have the same header cells.

Thanks in advance for your help!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,136,968
Messages
5,678,870
Members
419,787
Latest member
juanam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top