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!
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!