Combining combo box data from different sheets in to one sheet

rajniissh

New member
Joined
Jun 16, 2016
Messages
7
Reaction score
0
Points
0
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
 

Attachments

  • User1.xlsm
    51.4 KB · Views: 33
You posted in the "Data Exchange XML" forum . Is this correct? If not, let me know, I will move it. ( Do not start a new thread please)
 
Back
Top