Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating several spreadsheets
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...o&userid=34359 View this thread: http://www.excelforum.com/showthread...hreadid=541361 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating several spreadsheets
Hi 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. -- Richard "Linda J" wrote: 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...o&userid=34359 View this thread: http://www.excelforum.com/showthread...hreadid=541361 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating several spreadsheets
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 -- Richard "Richard" wrote: Hi 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. -- Richard "Linda J" wrote: 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...o&userid=34359 View this thread: http://www.excelforum.com/showthread...hreadid=541361 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More problems linking spreadsheets | Excel Discussion (Misc queries) | |||
Linking spreadsheets | Excel Discussion (Misc queries) | |||
Combine information about products from 2 spreadsheets | Excel Worksheet Functions | |||
Spreadsheets are cut off when you paste and link? | Excel Worksheet Functions | |||
Consolidating spreadsheets | Excel Worksheet Functions |