Limit Drop Down Menu Options Among Cells
I have a drop down menu set up on a number of cells in one column. Problem
is, I want to be able to make a selection within that column only once. Basically, as an item is chosen from the menu, it should no longer be available in subsequent cells within the same column. Is this possible?? -- BP |
Limit Drop Down Menu Options Among Cells
Believe Debra has just the recipe at this oven#:
http://www.contextures.com/xlDataVal03.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "BP" wrote: I have a drop down menu set up on a number of cells in one column. Problem is, I want to be able to make a selection within that column only once. Basically, as an item is chosen from the menu, it should no longer be available in subsequent cells within the same column. Is this possible?? -- BP |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com