Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Importing Data from another worksheet
1 view
Skip to first unread message
Blake Kaos
Oct 12, 2008, 2:01:42 PM10/12/08
to
Working in Office2007, how can I import (link) data from another worksheet
on the same spreadsheet?
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]
Oct 12, 2008, 2:26:15 PM10/12/08
to
You might get a faster response if you use the microsoft.public.excel news
group where the people who use Excel hang out.
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:
Harlan Grove
Oct 12, 2008, 5:20:21 PM10/12/08
to
"Blake Kaos" <MGKXLAXBU...@spammotel.com> wrote...
...
>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?
...
>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
Oct 13, 2008, 9:19:06 AM10/13/08
to
"Blake Kaos" <MGKXLA...@spammotel.com> wrote in message
news:OZTmgSJ...@TK2MSFTNGP06.phx.gbl...
news:OZTmgSJ...@TK2MSFTNGP06.phx.gbl...
Click in A10 on ddd. Type the = sign. then click on b20 in aaa. It's as easy
as that.
0 new messages