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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing data from other workbooks
Many thanks - removing the $ did the job.
Thanks again for the quick answer - saved me hours of work and potential mistakes "Don Guillett" wrote: if you are saying that you want to get info from the next column in the destination column, simply remove the $ (absolutes) & drage copy to the right. If you then want to take those formulas DOWN the sheet, simply grab the line and drag copy down ='[MENU.xls]try this'!D1 ='[MENU.xls]try this'!E1 ='[MENU.xls]try this'!D2 ='[MENU.xls]try this'!E2 -- Don Guillett SalesAid Software "Mark" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing data from other workbooks
Glad to help -- Don Guillett SalesAid Software "Mark" wrote in message ... Many thanks - removing the $ did the job. Thanks again for the quick answer - saved me hours of work and potential mistakes "Don Guillett" wrote: if you are saying that you want to get info from the next column in the destination column, simply remove the $ (absolutes) & drage copy to the right. If you then want to take those formulas DOWN the sheet, simply grab the line and drag copy down ='[MENU.xls]try this'!D1 ='[MENU.xls]try this'!E1 ='[MENU.xls]try this'!D2 ='[MENU.xls]try this'!E2 -- Don Guillett SalesAid Software "Mark" wrote in message ... 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 |
Reply |
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 |