Copy the same 2 columns from multiple spreadsheets into one new sh

Tas

Guest

Posts: n/a

7th Dec 2007

Hi All,

I have 350+ spreasheets that are in the same directory. All were created
using the same template. There are multiple worksheets in each file.

What I'd like to do is find a way to go into each spreadsheet, go to the
particular worksheet, and copy the data from 2 columns (G and H) into a new
file. The individual sheets contain anywhere from 10 to 50 rows .

I don't want to have to manually open each file and copy/paste the data I
need.

Is there a formula I can use that will somehow do this for me?

Many thanks.

Tas

« How do i design a ledger size (11 x 17) spread sheet in excell | Excel 2007 Question »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spreadsheets tab names	Dave	Microsoft Excel Programming	15	7th Jan 2011 12:31 AM
Copy from one source to multiple spreadsheets	msdrolf	Microsoft Excel Programming	1	23rd Nov 2009 05:59 PM
Match multiple columns in 2 spreadsheets	Ruthey	Microsoft Excel Misc	1	27th Jun 2009 11:14 AM
Merging multiple spreadsheets by matching columns	Loganthor	Microsoft Access	0	4th Jan 2008 05:31 PM
Copy Multiple Spreadsheets into One Workbook	Astroplastic	Microsoft Excel Programming	1	16th Jul 2003 02:33 PM