# Subsheets Populate in Master Sheet Help

#### mandy71480

##### New Member
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.

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Replies
5
Views
143
Replies
30
Views
518
Replies
8
Views
189
Replies
3
Views
265
Replies
0
Views
95

1,196,373
Messages
6,014,897
Members
441,854
Latest member
Amstaff

### 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.

### Which adblocker are you using?

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

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