Single Criteria Multiple Matches

Hi. I am very new to VBA and need help with a macro. I am comparing Sheet1 Column A in two different workbooks. WB1 has the same order numbers as Column A in WB2 but WB2 could have the order number listed multiple times but not always. I need the macro to return the data in 2 columns, H & B of WB2 to Column B & K, respectively, of WB1 for each instance of the order number. This is why a simple vlookup will not work. So a new row needs to be inserted below the order number in WB1 if there is more than one instance of it in WB2. Basically the below steps.

1. Match order #'s in ColA WB1 to ColA WB2.
2. Paste data from WB2 Cols H&B to Cols B&K in original row of WB1.
3. Then insert new row directly beneath order # in WB1 for each duplicate order number and paste order # in ColA and data from Cols H&B to Cols B&K.

Does this make any sense?
Can anyone help?

I have include sample copies of the workbooks.

Thank you.

Hi mtntxn,

If you really are using a Mac 2008 version of Microsoft Excel, I'm not sure they support VBA macros. I believe the newest Mac 2011 version of Excel does support them.

If your profile is incorrect and you are using a PC then please correct it and let us know.

My apologies. I am using Mac 2004.

I believe Apple uses Scripts instead of VBA. I'm clueless on the Apple Script topic.
Here is a link http://support.microsoft.com/kb/113891 but I'm not the guy to help on a Mac question.