Copy sheet from multiple files

Posted to microsoft.public.excel.programming

Steph[_7_] Steph[_7_] is offline

external usenet poster

Posts: 7

Copy sheet from multiple files

Hello. I have a folder that has multiple files. I need several of the
files, but not all. Each file has only 1 sheet in it.

I would like to use multiselect to choose the files I need, and copy the
sheet from each of the selected files into a single file. So for example,
if I chose 7 files, my master file would have 7 sheets in it.

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Opening Multiple files and Copying the info all to one other sheet	MsLucy	Excel Discussion (Misc queries)	2	January 6th 06 05:41 PM
How do I edit a worksheet and copy to multiple files?	artex	Excel Discussion (Misc queries)	0	August 31st 05 11:08 PM
How do I pull data from multiple files and copy into one file	JT	Excel Programming	2	May 3rd 05 07:42 PM
Copy text files into multiple sheets of 1 workbook	Steve[_56_]	Excel Programming	0	January 14th 04 08:30 PM
Copy worksheet from multiple files in one DIR to another DIR & rename	Mike Taylor	Excel Programming	1	July 13th 03 03:28 PM

All times are GMT +1. The time now is 04:17 PM.

Menu

About Us