JamesBarlow
Mechanical
- Feb 4, 2002
- 186
I am looking for a way to take a number of excel files and combine them into one.
We currently create our BOM's in excel, creating a new file for every assembly. My current machine has about 100 files, each representing an assembly of the machine. The formats of each file are the same with the only difference being the number of rows used. The larger the assembly, the more rows.
I would like to be able to combine all the files into one to be able to get information of the entire job such as cost and time of manufacture.
Does anyone know how this can be done. My current method is to copy and paste each workbook into a master job workbook. This is a nightmare that I would like to avoid.
I am running Excel 2000 under Windows NT 4.0
We currently create our BOM's in excel, creating a new file for every assembly. My current machine has about 100 files, each representing an assembly of the machine. The formats of each file are the same with the only difference being the number of rows used. The larger the assembly, the more rows.
I would like to be able to combine all the files into one to be able to get information of the entire job such as cost and time of manufacture.
Does anyone know how this can be done. My current method is to copy and paste each workbook into a master job workbook. This is a nightmare that I would like to avoid.
I am running Excel 2000 under Windows NT 4.0