software

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: www.excelforum.com/member.php...oamp;userid=34359
View this thread: www.excelforum.com/showthread...hreadid=541361Hi Linda

Open your master spreadsheet. You could then go into the individual
spreadsheets and right click on the Sheet tab for that spreadsheet at the
bottom and choose 'Move a copy' then choose the master spreadsheet from the
dropdown list and tick Create a copy box then click on OK.
--
Richardquot;Linda Jquot; wrote:

gt;
gt; I have a master spreadsheet that contains 100 worksheets, the worksheets
gt; are named 100-200.
gt;
gt; I have 100 separate spreadsheets named 100.xls to 200.xls. Each of
gt; those spreadsheets has just one worksheet and I'm wanting to link or
gt; import the data from those worksheets into the corresponding worksheet
gt; on my master i.e. the data from 100.xls will go into the worksheet
gt; named 100 on my master spreadsheet.
gt;
gt; Is there any easy way of doing this?
gt;
gt;
gt; --
gt; Linda J
gt; ------------------------------------------------------------------------
gt; Linda J's Profile: www.excelforum.com/member.php...oamp;userid=34359
gt; View this thread: www.excelforum.com/showthread...hreadid=541361
gt;
gt;

If you want to link the spreadsheets you could use:
='[100.xls]Sheet1'!A1
where 100.xls is the name of the spreadsheets 100 to 200
--
Richardquot;Richardquot; wrote:

gt; Hi Linda
gt;
gt; Open your master spreadsheet. You could then go into the individual
gt; spreadsheets and right click on the Sheet tab for that spreadsheet at the
gt; bottom and choose 'Move a copy' then choose the master spreadsheet from the
gt; dropdown list and tick Create a copy box then click on OK.
gt; --
gt; Richard
gt;
gt;
gt; quot;Linda Jquot; wrote:
gt;
gt; gt;
gt; gt; I have a master spreadsheet that contains 100 worksheets, the worksheets
gt; gt; are named 100-200.
gt; gt;
gt; gt; I have 100 separate spreadsheets named 100.xls to 200.xls. Each of
gt; gt; those spreadsheets has just one worksheet and I'm wanting to link or
gt; gt; import the data from those worksheets into the corresponding worksheet
gt; gt; on my master i.e. the data from 100.xls will go into the worksheet
gt; gt; named 100 on my master spreadsheet.
gt; gt;
gt; gt; Is there any easy way of doing this?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Linda J
gt; gt; ------------------------------------------------------------------------
gt; gt; Linda J's Profile: www.excelforum.com/member.php...oamp;userid=34359
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=541361
gt; gt;
gt; gt;