Merge files

spstrans · May 24th, 2002, 12:09 PM

How do I merge several excel files into one. They are all the same format as far as data contained in the individual columns.

Jack in the UK · May 25th, 2002, 01:26 PM

If the data is not to many cells I would select the required cells and just copy and past over.

I say this as you sate the headers are all OK and align correctly.

Sorry no magical fix, this is the simplest way I feel.

Chris Davison · May 26th, 2002, 06:23 AM

"Consolidating" the data may also be an option....

check out "consolidating data" in the help index, choosing "Guidelines for specifying source areas for a consolidation" from the list of options

spstrans · May 28th, 2002, 12:30 PM

Thank you for your help!

May 25th, 2002, 01:26 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	If the data is not to many cells I would select the required cells and just copy and past over. I say this as you sate the headers are all OK and align correctly. Sorry no magical fix, this is the simplest way I feel. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 26th, 2002, 06:23 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	"Consolidating" the data may also be an option.... check out "consolidating data" in the help index, choosing "Guidelines for specifying source areas for a consolidation" from the list of options __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 12:09 PM	#1
spstrans New Member Join Date: May 2002 Posts: 7	How do I merge several excel files into one. They are all the same format as far as data contained in the individual columns.

May 28th, 2002, 12:30 PM	#4
spstrans New Member Join Date: May 2002 Posts: 7	Thank you for your help!