Need help with merging data from two different sheets

[nekken22]

Hi,

Thank you so much for reading and helping me out. Here is my issue.

So I have two sets of data on two different spreadsheet.
Let's call them A and B

I need my new spreadhseet; let's call it C
to have the following:

When the PEIN (Field) is typed in at Spredsheet C,
it should use the PEIN as a search keyword; it needs to find
the exact match of the PEIN in spreadsheet A and B

In both A and B, the PEIN maybe duplicated; but it has with different information on the same field
(Let's say, the dates are different, or the amount of the commission is different).

Assuem this:
Spreadsheet A, PEIN ABC123; it has three matches.
Spreadsheet B, PEIN ABC123; it has two matches.

Under each match, there are different fields on the same row; let's assume
"Order" "Date" "Commission"

What I want to do on Spredsheet C is that
when i put in PEIN, it will shows me all the fields
on Spreasheet A, and B Associated with the PEIN.


Further more, it will create tap for me after I run the Macro; Tab name can be the PEIN number.

So basically, I need a Field that can put in the PEIN, a button that generates the information that will
create another sheet for me with the information I need.

Thank you for helping once again, It would be cool if you can let me know where i should start or writing this code for me. most likely i will need to do some modification on it.

[walruseggman]

Try this. Like you said, it will need some modification because you provided incomplete information. Off the top of my head, the following will need to be updated:

• Worksheet Names
• Where the PIEN value is on sheet C
• Where the order, date, and commission values are on A and B
• Where the order, date, and commission should go on the new sheet
• How the macro gets triggered

Please Login or Register  to view this content.

[nekken22]

U r awesome! I will let you know if it works out for me in two days.

THanks so much