PLEASE ADVISE: VBA MACRO - combing two excel sheets into One

[Marketa]

Hi, I would like to combine two excel sheets into one as follows:
Sheet 1:
Column A: Name
Column B: Role

Sheet 2:
Column A: Role
Column B: T- Code

Sheet after macro:
Column A: Name
Column B: Role
Column C: T-Code

The problem is that 1 Name hase more than 1 roles and one Role has more than 1 T-codes. The number of roles and T-Codes is never the same, so I need to count the number of T-Codes per role and add the number of rows under one name and insert the matching t-codes.

Thanks!

Marketa

 

[Abdul Matheen]

Hi Marketa,

As per your query i have done the VBA code, check the attached workbook and run the macro.

Regards
Abdul Matheen

 

[Marketa]

Hi Abdul,

I tried to copy the macro into my sheet with real data, but after running it, the third sheet called "after macro" stays blank. There are 59 users and 453 roles with T-codes. Can you please advise?

Thanks!

Marketa

 

[Abdul Matheen]

Hi Marketa,

could send me that workbook, i will look into the that.

Regards
Abdul Matheen

 

[Marketa]

Hi Marketa,

could send me that workbook, i will look into the that.

Regards
Abdul Matheen

 

[Marketa]

Thanks a lot!

 

[Marketa]

Please take this one. I made a little change in the file. Thanks!

 

[Marc L]

Hi,

no needs a code !
In Users worksheet, just enter this formula in cell D3 : =VLOOKUP(C3,Roles!$B$3:$C$455,2,FALSE) …
Copy it down and, voilà !

Regards !
​