Macro that finds Names and DOB over 2 Workbooks

[benjinorth]

Hi Guys,

I've hit a brick wall...

I need help making a macro button in WB1 to open WB2, then to find and match a customers information (First Name, Last Name and DOB) and then mark each match as a "YES" or as "Blank" after the last cell on WB1

Here's an example of the workbooks.

WB1

Joe	Bloggs	random info	misc info	male	04/07/1986
Jane	Smith	random info	misc info	female	08/07/1975
Fred	Astair	random info	misc info	male	12/04/1994

<tbody>
</tbody>

WB2

Joe	Bloggs	04/07/1986
Jane	Smith	08/07/1975
Fred	Astair	12/04/1994

<tbody>
</tbody>

In WB1 you can see the DOB is separated by columns with other information
as in WB2 the information I require is grouped together.

I can't move cells or columns around as it is part of a mail merge and other existing macros.

 

[Roderick_E]

can you use formulas? drag down, because then you could use =match()