Consolidating several spreadsheets

Giganews Newsgroups
Subject: Consolidating several spreadsheets
Posted by:  Linda J (Linda.J.27o46n_1147392603.858@excelforum-nospam.com)
Date: Thu, 11 May 2006

I have a master spreadsheet that contains 100 worksheets, the worksheets
are named 100-200.

I have 100 separate spreadsheets named 100.xls to 200.xls. Each of
those spreadsheets has just one worksheet and I'm wanting to link or
import the data from those worksheets into the corresponding worksheet
on my master i.e. the data from 100.xls will go into the worksheet
named 100 on my master spreadsheet.

Is there any easy way of doing this?

--
Linda J
------------------------------------------------------------------------
Linda J's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34359
View this thread:http://www.excelforum.com/showthread.php?threadid=541361

Replies