ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Default In-Cell Dropdown to a specific Index Value? (https://www.excelbanter.com/excel-discussion-misc-queries/186711-default-cell-dropdown-specific-index-value.html)

MAS67

Default In-Cell Dropdown to a specific Index Value?
 
I have a scenario where I use a common list in a parent category (e.g. Work
Unit and a child category (e.g. Line Item) . I would like to default the
Line Item list value to the same list value as the parent Work Unit,
maintaining the in-cell dropdown structure in both cells.


MAS67

Default In-Cell Dropdown to a specific Index Value?
 
This is 2003 btw.

"MAS67" wrote:

I have a scenario where I use a common list in a parent category (e.g. Work
Unit and a child category (e.g. Line Item) . I would like to default the
Line Item list value to the same list value as the parent Work Unit,
maintaining the in-cell dropdown structure in both cells.



All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com