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