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