Linking Data

[Guest]

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.

 

[Guest]

Thank you so much!!