Combine Data

O

osaka78

i have 1000 excel files. Each file has one sheet with rows and columns,
e.g.
A1: Name b1:XYZ
A2: Nationalities B2:UK
A3: Date of Birth B3: 26 C3 Age d3: 1/1/1990

How can I combine selective data i.e(B1,B2,B3,D3) from each sheets in a
different files into one sheet of a new file provided each row in the new
file well have selective data from each sheet ?

I don't want to copy and paste, I have more than 1000 files to combine

Regards
Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top