LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 259
Default copy and paste data only to a new file

On 28/01/2012 6:48 PM, Fawn Lagimodiere wrote:
I have 50 different files with one master worksheet in each. What I want to
do is to copy and paste the master sheet from 50 different files into one
new workbook so that I can link the data to access.

Is this possible?

thanks


Hi Fawn

Try these links from Ron DeBruin

http://www.rondebruin.nl/copy3.htm
http://www.rondebruin.nl/fso.htm

HTH
Mick.
 
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
Copy, paste without file name referenced after paste AusTexRich Excel Discussion (Misc queries) 6 September 23rd 08 02:57 AM
Copy data from an HTML file and paste into excel using a macro Karl S Excel Programming 1 March 18th 07 07:51 PM
Copy Pivot Table Data and Paste into New File S Sainsbury Excel Programming 1 November 15th 05 01:17 PM
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro Steven Excel Programming 1 October 17th 05 08:56 AM


All times are GMT +1. The time now is 05:27 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"