importing data from other workbooks

[Mark]

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

 

[Don Guillett]

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

 

[Mark]

Many thanks - removing the $ did the job.

Thanks again for the quick answer - saved me hours of work and potential
mistakes

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
(e-mail address removed)

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

 

[Don Guillett]

Glad to help
--
Don Guillett
SalesAid Software
(e-mail address removed)

Many thanks - removing the $ did the job.

Thanks again for the quick answer - saved me hours of work and potential
mistakes

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
(e-mail address removed)

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