Excel Macro help Required [Closed]

Report
-
 Crackinhunk -
Hello,

I have an Excel Workbook that has 140 names/ID's that have different Composite roles agianst it, I want to create a macro or run a macro so that each tab on worksheet has only single Name/ID and should pick details of the breakup of the composite roles from 6 other workbooks.

Please advise

Thanks

1 reply

Hello,

I have an Excel Workbook that has 140 names/ID's that have different Composite roles agianst it, I want to create a macro or run a macro so that each tab on worksheet has only single Name/ID and should pick details of the breakup of the composite roles from 6 other workbooks.


For Example

User ID Name Roles

1000001 Krazy Admin
1000001 Krazy Purchasing
1000001 Krazy MRR

In a similar way i have 140 User ID and the roles have Admin have breakup of the duties in a differrent workbook2, Purchasing in workbook 3 & MRR in workbook 4.

i want to create a macro or run a macro so that the result is displayed as

User ID Name Roles

1000001 Krazy Admin
-To maintain Services
-Vendor Selection
1000001 Krazy Purchasing
-Procure Goods
1000001 Krazy MRR
-Create reciepts when items recieved

under admin purchasing and MRR are sub roles that are in the same workbook which defines the Roles.

Please advise

Thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!