Linking Data

[dtmd]

I have a drop down list in one worksheet. I would like a different worksheet
to populate the choice made on WS 1 as well. How do I do this?

[goober]

=Sheet1!A1

Use this formula in the cell you want to equal the one with the list. Just change the Sheet1 and cell reference to whatever you need.

Hope it helps.

[dtmd]

Thank you so much!!

"goober" wrote:

>
> =Sheet1!A1
>
> Use this formula in the cell you want to equal the one with the list.
> Just change the Sheet1 and cell reference to whatever you need.
>
> Hope it helps.
>
>
> --
> goober
> ------------------------------------------------------------------------
> goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
> View this thread: http://www.excelforum.com/showthread...hreadid=486439
>
>