Importing Data from another worksheet

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

 

[Milly Staples [MVP - Outlook]]

You might get a faster response if you use the microsoft.public.excel news
group where the people who use Excel hang out.

This group is a general catch-all group so finding an Excel expert here may
take more time than in an Excel specific news group.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, Blake Kaos asked:

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

 

[Harlan Grove]

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?

=aaa!b20

 

[Gordon]

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?

Click in A10 on ddd. Type the = sign. then click on b20 in aaa. It's as easy
as that.