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.
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.
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