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

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Joe[/TD]
[TD]Bloggs[/TD]
[TD]random info[/TD]
[TD]misc info[/TD]
[TD]male[/TD]
[TD]04/07/1986[/TD]
[/TR]
[TR]
[TD]Jane[/TD]
[TD]Smith[/TD]
[TD]random info[/TD]
[TD]misc info[/TD]
[TD]female[/TD]
[TD]08/07/1975[/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Astair[/TD]
[TD]random info[/TD]
[TD]misc info[/TD]
[TD]male[/TD]
[TD]12/04/1994[/TD]
[/TR]
</tbody>[/TABLE]






WB2

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Joe[/TD]
[TD]Bloggs[/TD]
[TD]04/07/1986[/TD]
[/TR]
[TR]
[TD]Jane[/TD]
[TD]Smith[/TD]
[TD]08/07/1975[/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Astair[/TD]
[TD]12/04/1994[/TD]
[/TR]
</tbody>[/TABLE]







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()