Linking Cell Reference

  • Thread starter Thread starter anshu
  • Start date Start date
A

anshu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Display 12.5 but not 25.0 (drop .0’s) 5
Data Validation - Cell Colour 3
Copy dropdown list 1
Excel, assign cells in multiple worksheets from one sheet 1
linking within a workbook and sorting 2
How to copy drop down list to next sheet 3
Filtered drop down list 2
Cell References 2

Back
Top