Hi Forum,
Need your help in making a master excel sheet that will consolidate data(textual data- names) from multiple sheets from a defined range ( but these ranges can be dynamic as in each sheet the total number of names will be different).
It is a 9 box model used in HR, as the different sheets are sent out to different managers (Each manager has a different organization size and therefore the size of the individual ranges may be different) and also consolidating every name in the master sheet has to be dynamic as we would have no control on where an employee would be placed by their manager.
There is another thread on this forum for a 9 box chart (not able to attach a link) that has worked on something similar but my requirement is little different. I have also attached the sample document.
The data has to be consolidated from the input sheet 1,2 (this can go upto 25 sheets) into the master sheet, so all employees in a current grid in all the input sheets have to be consolidated in the same grid on the master sheet.
Thank you for your help.
Regards,
Bookmarks