Filter multiple values for one date

[stvvnhf]

Hello everyone,

I am new to this forum and have a few questions. For a school assignment I have to make an automated report in word using VBA and excel but I have a problem filtering the data.

The file exists of 3 sheets:
- control (date selection and button to generate word report)
- data (measurements)
- transfer (filtered measurements)

1) I have a range of measurements with multiple values for each date (every day there are 12 measurements with some exceptions). I would like to filter the table and paste the filtered data in a 'transfer' sheet so I can use this to make the report. I tried an index match combination but this only gives me the 1st measurement for each date even when I drag the formula down to the other cells below.

2) when using the drag down menu in the control sheet, excel can not find the date I am looking for (#N/A) but when just entering a date by hand it does.

Thank you in advance,
Steve

control sheet:

data sheet:

transfer sheet:

 

[Legacy 436357]

Hello,

I answered another member question so perhaps it will work for you:

This will return all rows between the dates selected in A2 and B2 (Sheet 2) from Sheet 1.

In cell C1 (Sheet 2)

=SUMPRODUCT((Sheet1!$A$2:$A$22>=A2)*(Sheet1!$A$2:$A$22<=B2))

Then in a blank row in Sheet 2:

=IF(ROWS(A$5:A5)>$C$2,"",INDEX(Sheet1!A$2:A$22,SMALL(IF((Sheet1!$A$2:$A$22>=$A$2)*(Sheet1!$A$2:$A$22<=$B$2),ROW(Sheet1!A$2:A$22)-ROW(Sheet1!$A$2)+1),ROWS(A$5:A5))))

Press CTRL+SHIFT+ENTER to make it an array.

Then drag it over and down for the range you wish.