How to pull in entire line of data based on being between two date without skipping lines

[AMille]

I have a spreadsheet with rows # 1 to 30. On a separate tab I have data with headers. The data will be copy and pasted into the document with the same headers. I want to pull in the full line of each invoice into the invoice tab, but only if the date on it is after or on the start date that will be inputted into c2 and on or less than the end date that will be in c3. That date will change, which is why I have it as an input cell. Is there anyway to do this without skipping lines? I cannot figure out how to do it without it giving me blanks when the date isn't on or after.

Thank you.

[Moo the Dog]

See that attached revised file. I think it should do what you want it to do.

Cell B7 uses this ARRAY formula (entered with Ctrl + Shift + Enter):

Please Login or Register  to view this content.

Cell C7 uses this:

Please Login or Register  to view this content.

Cell D7 uses this:

Please Login or Register  to view this content.

Cell E7 uses this:

Please Login or Register  to view this content.

Then fill those down all 30 rows. Hope it helps!

- Moo

[Pete_UK]

You could put this formula in a helper column on the Data Upload sheet (I used cell G2):

=IF(AND(B2<>"",B2>=Invoice!$C$2,B2<=Invoice!$C$3),MAX(G$1:G1)+1,"-")

Copy this down to the bottom of your data (or below, if you want to accommodate new data being added). Then you can use this formula in B7 of the Invoice sheet:

=IFERROR(INDEX('Date Upload'!$A:$E,MATCH(ROWS($1:1),'Date Upload'!$G:$G,0),MATCH(B$6,'Date Upload'!$A$1:$E$1,0)),"")

Copy this across into C7:E7, format D7 and E7 in the style you prefer, then copy the 4 formulae down as far as you like.

Then put some dates in C2 and C3 and the data will automatically be displayed.

Hope this helps.

Pete

EDIT: working file attached

[AMille]

Thank you both! I used both methods and they did exactly what they wanted. I'm going to play around with it some and figure out which one to use. Thanks again for both of your help!

[Moo the Dog]

Glad to hear it! Have a great day.

- Moo