ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combine Data (https://www.excelbanter.com/excel-discussion-misc-queries/228608-combine-data.html)

osaka78

Combine Data
 
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!

Ron de Bruin

Combine Data
 
You can start here
http://www.rondebruin.nl/merge.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"osaka78" wrote in message ...
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!



All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com