Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LG LG is offline
external usenet poster
 
Posts: 6
Default I have 1 master excel file & want to rec. data from 7 other files

I have one master excel spreadsheet and want to merger seven other excel
spreadsheets into my master. These are not workbooks within one file. These
are all seperate files, 1 master and seven that gets updated by other folks.
I'm looking for an easier way to merge the seven into the master without
cutting and pasting each time. Can someone Help?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default I have 1 master excel file & want to rec. data from 7 other files

Hi LG

I have code examples and a add-in on my site

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"LG" wrote in message ...
I have one master excel spreadsheet and want to merger seven other excel
spreadsheets into my master. These are not workbooks within one file. These
are all seperate files, 1 master and seven that gets updated by other folks.
I'm looking for an easier way to merge the seven into the master without
cutting and pasting each time. Can someone Help?

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
merging data from 1 excel file, into a master excel file motSwE New Users to Excel 2 September 13th 06 06:39 PM
linking multiple excel files to a master CharlG Excel Discussion (Misc queries) 0 April 27th 06 09:59 AM
combining data from several excel files into one file bobman Excel Discussion (Misc queries) 3 March 12th 06 08:34 AM
To get client data from a saved file back to the master file Darmac54 Excel Discussion (Misc queries) 0 August 18th 05 03:29 AM
Combine multiple Excel files into one master [email protected] Excel Discussion (Misc queries) 1 November 26th 04 11:20 PM


All times are GMT +1. The time now is 02:13 AM.

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

About Us

"It's about Microsoft Excel"