importing data from other workbooks

G

Guest

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
 
D

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
 
G

Guest

Many thanks - removing the $ did the job.

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

Don Guillett said:
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)
Mark said:
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
Click to expand...
Click to expand...
 
D

Don Guillett

Glad to help
--
Don Guillett
SalesAid Software
(e-mail address removed)
Mark said:
Many thanks - removing the $ did the job.

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

Don Guillett said:
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)
Mark said:
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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert text into range reference? 5
summarizing data from various workbooks 3
Using Dialog to select a Workbook, Worksheet and Range 2
Consolidate many WBs into one ... 2
Update multiple sheets at once 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Linking to other workbooks question 4
Need macros for copy data into new workbooks 2

Top