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.
 
Back
Top