| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing data from other workbooks
I am importing (linking data) from other workbooks into a master workbook.
For example I have linked the following into a master workbook - ='[Demonstrator Sales.xls]Sheet1'!$C$11+'[Demonstrator Sales.xls]Sheet1'!$N$11+'[Demonstrator Sales.xls]Sheet1'!$C$49+'[Demonstrator Sales.xls]Sheet1'!$N$49+'[Demonstrator Sales.xls]Sheet1'!$C$87+'[Demonstrator Sales.xls]Sheet1'!$N$87+'[Demonstrator Sales.xls]Sheet1'!$C$125+'[Demonstrator Sales.xls]Sheet1'!$N$125+'[Demonstrator Sales.xls]Sheet1'!$C$163+'[Demonstrator Sales.xls]Sheet1'!$N$163 What I want to do now is copy this into the next cell in the master worksheet and have each value automatically increased by 1 column and 1 row so that it will be linked to the adjacent cells in the original workbook. Is there any way to do this other than changing each link by hand. I am using Office XP Any help will be much appreciated and save me hours of time as I have a lot of information to bring into one master workbook. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
| Importing information from 2 workbooks into a 3rd one | Excel Worksheet Functions | |||
| Importing information from 2 workbooks into a 3rd one | Excel Discussion (Misc queries) | |||
| Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
| Importing Workbooks into a Master Workbook | Excel Worksheet Functions | |||
Threaded Mode
