| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine data | Excel Discussion (Misc queries) | |||
| Combine data | Excel Discussion (Misc queries) | |||
| Combine data - Please help | Excel Worksheet Functions | |||
| Combine Data | Excel Worksheet Functions | |||
| Need to combine and add data | Excel Discussion (Misc queries) | |||
Linear Mode
