Hi,
I have 50 separate xls sheets from 50 users and every sheet has set of 10 combo box, i want to combine data in user sheets in to one sheet. For instance first row would have date from sheet 1 as - user 1 combo box 1 combo box 2 .... combo box 10, then second row would have data from sheet 2 as - User 2 combo box 1 combo box 2 .... combo box 10.
Attached sample data sheet for reference
Could someone please help as how this could be done.
Regards
Rajnish
I have 50 separate xls sheets from 50 users and every sheet has set of 10 combo box, i want to combine data in user sheets in to one sheet. For instance first row would have date from sheet 1 as - user 1 combo box 1 combo box 2 .... combo box 10, then second row would have data from sheet 2 as - User 2 combo box 1 combo box 2 .... combo box 10.
Attached sample data sheet for reference
Could someone please help as how this could be done.
Regards
Rajnish