Importing data from another worksheet in the same spreadsheet

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?
 
P

Peo Sjoblom

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
 
A

AltaEgo

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.
 

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 prepare imported data for Excel to autosize properly width of the cell? 4
Combining Data 1
How to read the specified node value from XML 8
Group Data 2
condionally formatting based on another cells formatting? 2
At each change in data apply formula 4
Other backgroundcolor by another value in the same column 1
combining data from two separate sheets 1

Top