Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 12th 06, 02:47 AM posted to microsoft.public.excel.misc
bobman
 
Posts: n/a
Default combining data from several excel files into one file

I have several excel files (not worksheets within one file) that I want to
combine into one excel file. In other words, I want to combine file1.xls,
file2.xls, file3.xls, etc and put all of the data from all three of those
files into one excel file. The data in each individual file is of the same
information, so this should be done without any problems. How do I combine
the individual files into one excel file?

  #2   Report Post  
Old March 12th 06, 03:03 AM posted to microsoft.public.excel.misc
PY & Associates
 
Posts: n/a
Default combining data from several excel files into one file

If not too many, open each, copy and paste is simplest.

"bobman" wrote in message
...
I have several excel files (not worksheets within one file) that I want to
combine into one excel file. In other words, I want to combine file1.xls,
file2.xls, file3.xls, etc and put all of the data from all three of those
files into one excel file. The data in each individual file is of the

same
information, so this should be done without any problems. How do I

combine
the individual files into one excel file?



  #3   Report Post  
Old March 12th 06, 03:20 AM posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default combining data from several excel files into one file

Are you trying to take worksheets from file1.xls into a new workbook,
then copy the worksheets from file2.xls into the new workbook renaming any worksheet
that has the same name as a sheet already in the file, and the same for the rest of the files.

Are the files in the same directory or are you going to feed in the names.

I would try a google (web) search: excel combine workbooks sub directory

http://www.vbaexpress.com/kb/getarticle.php?kb_id=773
appears to adding all of the rows from all of the sheets of al the workbooks in a directory
into one worksheet. (same file structure, columns, headings, etc.)

http://www.vbaexpress.com/kb/getarticle.php?kb_id=829

Copies all the worksheets from all the workbooks in one folder into the active workbook.

(I expect this is what you are looking for, don't know what you get for sheet names, possibly

numbered copies sheet2 (3)

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bobman" wrote in message ...
I have several excel files (not worksheets within one file) that I want to
combine into one excel file. In other words, I want to combine file1.xls,
file2.xls, file3.xls, etc and put all of the data from all three of those
files into one excel file. The data in each individual file is of the same
information, so this should be done without any problems. How do I combine
the individual files into one excel file?



  #4   Report Post  
Old March 12th 06, 09:34 AM posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default combining data from several excel files into one file

Hi bobman

Look here
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"bobman" wrote in message ...
I have several excel files (not worksheets within one file) that I want to
combine into one excel file. In other words, I want to combine file1.xls,
file2.xls, file3.xls, etc and put all of the data from all three of those
files into one excel file. The data in each individual file is of the same
information, so this should be done without any problems. How do I combine
the individual files into one excel file?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 04:27 PM
How do I update data in 3 related files in Excel? Vellarian Excel Discussion (Misc queries) 0 March 2nd 06 07:17 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
Refresh Imported Data - Does the Excel file have to be open? tinkertoy Excel Discussion (Misc queries) 0 June 23rd 05 07:51 PM
Importing .txt data files increases .xls file size BrianJ Excel Discussion (Misc queries) 1 January 29th 05 03:02 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017