PDA

View Full Version : Combining combo box data from different sheets in to one sheet



rajniissh
2016-06-22, 09:18 AM
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

Pecoflyer
2016-06-22, 09:28 AM
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)

rajniissh
2016-06-22, 01:14 PM
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)

Yes that's right