1 reply
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.
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
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!
