Appending spreadsheets

D

Derek Wittman

Good morning
I'd like to take about 16 Excel spreadsheets and merge them into one. They will combined still fit within the 65536 row limit and have all identical column/fields. Without outputting them to CSV and doing a DOS append/save command, and without copy/pasting them into a new workbook/sheet, do I have any other alternatives

Thank you
Derek
 
R

Ron de Bruin

Hi Derek
and without copy/pasting them into a new workbook/sheet
Click to expand...

What problem do you have with that??
Try http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




Derek Wittman said:
Good morning,
I'd like to take about 16 Excel spreadsheets and merge them into one. They will combined still fit within the 65536 row limit
Click to expand...
and have all identical column/fields. Without outputting them to CSV and doing a DOS append/save command, and without
copy/pasting them into a new workbook/sheet, do I have any other alternatives?
 
Top