|
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 |
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 |
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 |
| All times are GMT +1. The time now is 03:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com