#1
|
|||
|
|||
Linking cells on Excel 2010
I am creating something on excel.
I have created a drop down box for a couple of columns, but i want to do it, where when i select something from the drop down box, i want it to change what is available in other drop down boxes. e.g. B2 - Select option 1, certain things available in other drop down boxes and then if i select option 2, the values in the other drop down boxes are different to option 1 hope this makes sense, quite hard for me to explain |
#2
|
|||
|
|||
Hi teza2k06
Have a look at the link below for data validation & dependant lists. Kevin Excel Data Validation With Dependent Lists |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |
linking in excel | OssOss | Excel Programming | 8 | 07-23-2012 10:46 PM |
linking cells between files when cell address changes | joneckenrod | Excel | 6 | 02-13-2012 01:12 PM |
Excel 2010 Format cells to use as Gantt or Plan | Kizzie | Excel | 0 | 12-13-2011 02:31 AM |
Excel to powerpoint linking | mugezhn | Excel | 0 | 07-08-2010 02:56 AM |