Match two Arrays from different worksheets

[boldcode]

hello,

I want to create a macro that matches each record from a worksheet I call "ATemplate" with another worksheet I call "BTemplate" using an unique ID (the ID row title is called "AT2RecID") that exists in both worksheets. For the sake of simplicity I only used several records as opposed to the thousands that I have in both worksheets. The workbook I provide with this post includes the following worksheets:

- ATemplate
- BTemplate
- Output Results

What I want the Macro to create in a new worksheet is the example found under worksheet "Output Results". In worksheet "Output Results" row titles should start IN ROW 2 and the data should start IN ROW 3. Row Titles B THROUGH M along with its associated data from worksheet "ATemplate" come over to the "Output Results" worksheet and Row Titles O and P along with its associated data from worksheet "BTemplate" come over to the "Output Results" worksheet. Again the records are matched up by the row title "AT2RecID" found in both worksheets "ATemplate" and "BTemplate". I understand I can do this in Access, but I would really like to see how it works in VBA.

thanks much!

[AB33]

Try this code

Please Login or Register  to view this content.

[boldcode]

AB33,

The code seem to work just fine; is there some code that will create a new worksheet "Output Results" and put the results there as oppose to me creating "Output Results" manually in order for the code to work.

Thank you for your help AB33.

- BC

[AB33]

Please see above amended code.

[mike7952]

Another way

Please Login or Register  to view this content.

[boldcode]

mike7952,

I will test out your code and let you know where I stand. Thanks for the help.

- BC

[boldcode]

Mike7952,

Is there any way to change your code so that results are displayed in the Active Worksheet as opposed to a predifined one.

Thanks,

Bc

[boldcode]

mike7952,

I figured out how to use the ActiveSheet so no worries there. Question about your variables, how come variables aArr, w, and aOutput() are not defined as anything. I would like to define them so they are not Variant or defaulted to Variant.

- BC

[mike7952]

BC,

They need to be variant.

[boldcode]

Mike,

I figured out with the those variant variables mean, but I can't figure out what the "n" variable variant does. I was wondering if you could shed some insight on that particular variable.

- BC

[boldcode]

Mike,

I figured it out. Thank you for your solution!

- Bc