Linking Data
 

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?

Linking Data
 

=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

Linking Data
 

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