Formulas to pull data based on date range from one worksheet to another in same workbook

I have a spreadsheet with 4 tabs. One has all quarterly data, the other 3 tabs are labeled per month.

I want to pull the data from Q3 into each month, based on dates 7/1/16 to 7/31/16 for July, 8/1/16 to 8/31/16 for Aug, etc.

the data to be pulled will be multiple rows & columns.

spreadsheet capture.JPG

Can anyone help me?

Can you post a representative sample workbook (use: Go Advanced > Manage Attachments) with any sensitive data removed or altered?

Take a look at the attachment and see if it does the trick. It uses essentially the same formula:

=IFERROR(INDEX('Q3 2016'!$B$2:$N$400,SMALL(IF(MONTH('Q3 2016'!$I$2:$I$400)=7,ROW('Q3 2016'!$I$2:$I$400)-1),ROW(1:1)),MATCH(B$1,'Q3 2016'!$B$1:$N$1,0)),"")

...in B2 of each monthly sheet. It should be confirmed with Ctrl + Shift + Enter and filled down, then right. To change the month, all I've done is change "=7" (JULY) to "=8" (AUG). The formula is currently built to account for entries through row 400 on your Quarterly sheet. If you need it to be bigger, change all of the "400"s in the formula to something bigger. Make sure they're all changed to the same number, though - the arrays need to be the same size. Fair warning: bigger = slower. You can speed things up a little by deleting the formulae from the columns that don't require it.

See if it'll do. Once you add a date to an entry in the Q3 sheet, the appropriate month should automatically add that entry to the next available row.

I think this is correct! Thank you so much! Such a big help!

My pleasure, glad I could help!