importing data from other workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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...
 
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
How to import cels from another workbook 2
Concatenation issue - Help, PLEASE! 2
Consolidate many WBs into one ... 2
Using Dialog to select a Workbook, Worksheet and Range 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Update multiple sheets at once 1

Back
Top