Linking Cell Reference
 

Hi all,

On Sheet 1, I have a drop down list at Cell D9. This is linked with a
list kept somewhere in the same sheet and has a range name (list)

Now, I want a similar drop down in Sheet 2 with the same list and I
also want that when I select any items from Sheet 2, Sheet 1 should
also get changed with that item and vice versa.

Is there a way I can do this?

If there is any parent child concept here, I want Sheet 1 as the
parent and Sheet 2 as child.

Thanks in advance,
Anshuman

Linking Cell Reference
 

Hi,

For imformation, please refer to the following link:

A. http://www.contextures.com/xlDataval02.html
B. http://www.contextures.com/xlForm01.html

Challa Prabhu

"anshu" wrote:

Hi all,

On Sheet 1, I have a drop down list at Cell D9. This is linked with a
list kept somewhere in the same sheet and has a range name (list)

Now, I want a similar drop down in Sheet 2 with the same list and I
also want that when I select any items from Sheet 2, Sheet 1 should
also get changed with that item and vice versa.

Is there a way I can do this?

If there is any parent child concept here, I want Sheet 1 as the
parent and Sheet 2 as child.

Thanks in advance,
Anshuman