ExcelBanter - Bring filtered data from another file

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Bring filtered data from another file (https://www.excelbanter.com/excel-discussion-misc-queries/252943-bring-filtered-data-another-file.html)

cousinexcel

Bring filtered data from another file

I have a Birthdays file

I have a Calendar file
After each date in this calendar file I have 4 empty lines
(assumption: max 4 birthdays on the same day)
15.01.2010
.........
.........
.........
.........
16.01.2010
.........
.........
.........
.........

How can I bring the names for each date from the Birthdays file.

Thanks and regards,

CousinExcel

All times are GMT +1. The time now is 09:38 PM.