Importing data from another worksheet in the same spreadsheet

  • Thread starter Thread starter Blake Kaos
  • Start date Start date
B

Blake Kaos

Working in Office2007, how can I import (link) data from another worksheet
on the same spreadsheet?

In other words, say my spreadsheet abc.xls has 4 worksheets (named aaa, bbb,
ccc, ddd) and I want to populate cell A10 of worksheet ddd with the data in
column b20 of aaa; how can I do this?
 
Go to B20 in aaa and copy it, then go to A10 in ddd and do edit>paste
special
and select paste link

--


Regards,


Peo Sjoblom
 
In cell A10 of worksheet ddd, type the following

=aaa!B20


ALTERNATIVELY

-In the destination cell, type '=' (without quotes)
-navigate to the source sheet and click on the source cell
-press the [Enter] key.



One doing either of the above, drag or copy the result to other cells you
need linked.
 
Peo

What is the advantage of this when the result in the same workbook?
 
Exactly and you can do multiple cells at the same time

--


Regards,


Peo Sjoblom
 
You must log in or register to reply here.

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

row comparison 5
Compare a range of cells 5
Excel Issue 1
find data 5
Function for identifying the last entry in a table 2
How to prepare imported data for Excel to autosize properly width of the cell? 4
Find Mismatched Data 5
PivotTable buttons remembers old unactual values 4

Back
Top