Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Linking with Absolute Reference | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
How Do I Get a date reference when linking excel worksheets? | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |