| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro copying info/data in multiple excel files into one summary file.
Could someone please help me with an excel macro to copy data/information
from multiple Excel files (each info is in the same cell and same column label in each file) into one Excel file , each source file info going to one row in the destination file. -- I travel 3rd Class because there is no 4th Class- Gandhi. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro copying info/data in multiple excel files into one summary file.
Hi Jskasango
Try this http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jskasango" <u20293@uwe wrote in message news:5e0775d979bc0@uwe... Could someone please help me with an excel macro to copy data/information from multiple Excel files (each info is in the same cell and same column label in each file) into one Excel file , each source file info going to one row in the destination file. -- I travel 3rd Class because there is no 4th Class- Gandhi. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro copying info/data in multiple excel files into one summary file.
Thanks Ron,
I am not an expert but let me study your suggestions and I will let you know my progress. I am asuming that I will cut and paste, and change your examples of cell refs and filenames to suit mine. Kasango. Ron de Bruin wrote: Hi Jskasango Try this http://www.rondebruin.nl/copy3.htm Could someone please help me with an excel macro to copy data/information from multiple Excel files (each info is in the same cell and same column label in each file) into one Excel file , each source file info going to one row in the destination file. -- I travel 3rd Class because there is no 4th Class- Gandhi. Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro copying info/data in multiple excel files into one summary file.
Yes change the folder name and range and try it
-- Regards Ron de Bruin http://www.rondebruin.nl "Jskasango via OfficeKB.com" <u20293@uwe wrote in message news:5e13e3e2a80e9@uwe... Thanks Ron, I am not an expert but let me study your suggestions and I will let you know my progress. I am asuming that I will cut and paste, and change your examples of cell refs and filenames to suit mine. Kasango. Ron de Bruin wrote: Hi Jskasango Try this http://www.rondebruin.nl/copy3.htm Could someone please help me with an excel macro to copy data/information from multiple Excel files (each info is in the same cell and same column label in each file) into one Excel file , each source file info going to one row in the destination file. -- I travel 3rd Class because there is no 4th Class- Gandhi. Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro copying info/data in multiple excel files into one summary file.
I am experimenting with Sub Example2(), my worksheets both in the source and
destination have names. Where in the code do I specify these names? I need to pick information from various cells. Ron de Bruin wrote: Yes change the folder name and range and try it Thanks Ron, I am not an expert but let me study your suggestions and I will let you know [quoted text clipped - 12 lines] label in each file) into one Excel file , each source file info going to one row in the destination file. -- I travel 3rd Class because there is no 4th Class- Gandhi. Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200604/1 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro copying info/data in multiple excel files into one summary file.
It is working now, but I need to pick up more than 50 different pieces of
information from each spreadsheet and take it to the basefile! Is there a way that I can specify one by one cell reference in the code and specify the destination cell ref as well? Jskasango wrote: I am experimenting with Sub Example2(), my worksheets both in the source and destination have names. Where in the code do I specify these names? I need to pick information from various cells. Yes change the folder name and range and try it [quoted text clipped - 3 lines] label in each file) into one Excel file , each source file info going to one row in the destination file. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200604/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Multiple files in one file Macro - Liz | New Users to Excel | |||
| How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
| Opening Multiple files and Copying the info all to one other sheet | Excel Discussion (Misc queries) | |||
| Extract Data From Multiple Excel Files - One File | Excel Programming | |||
| Batch file to start multiple excel files with auto_open() macro. Delay code needed | Excel Programming | |||
Hybrid Mode
