B BillyRay New Member Oct 14, 2024 #1 Is there a way to have 'Item Name' on the Inventory sheet have a drop down list dependent on what 'Category' is selected? What I mean is to limit the selection in column F based on what is chosen in column E. Thank you for your help Attachments Food Inventory V1.2.xlsx Food Inventory V1.2.xlsx 538.5 KB · Views: 2
Is there a way to have 'Item Name' on the Inventory sheet have a drop down list dependent on what 'Category' is selected? What I mean is to limit the selection in column F based on what is chosen in column E. Thank you for your help
B BillyRay New Member Oct 14, 2024 #2 I found a way using named ranges and indirect. See attached. Attachments Food Inventory V1.5.xlsx Food Inventory V1.5.xlsx 529.2 KB · Views: 6
