(Msg. 1) Posted: Sun Sep 06, 2009 2:22 pm
Post subject: DropDowns - allowing each value to be used once Archived from groups: microsoft>public>excel>newusers (more info?)
In a 17 worksheet workbook I need to allow one of 32 possible dropdown
entries to be used but once. I have the custom validation box with the 32
entries in worksheet 1 but can not figure out how to eliminate the the
already used entry in worksheet 2, the used values in worksheets 1 and 2 to
not show up in the dropdown or worksheet 3, the used entries in worksheets 1,
2, and 3 not to show up in worksheet 4 and so on?
Any help appriciated.
PS: yup it's me again as football season draws near...
--
To those who have helped in the past and those about to help, Thank You.
There is an intregeing element to Excel that has captured me and that
stimulates my every remaining brain cell. Awesome
(Msg. 2) Posted: Sun Sep 06, 2009 9:49 pm
Post subject: Re: DropDowns - allowing each value to be used once [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
It's somewhat complicated to do for just one drop down list on one sheet.
So, you can expect it to be exponentially more difficult to do over 17
sheets. See this for a starting point:
"Football Express" <FootballExpress DeleteThis @discussions.microsoft.com> wrote in
message news:7C067E36-64D4-425C-B022-6568012EAF59@microsoft.com...
> In a 17 worksheet workbook I need to allow one of 32 possible dropdown
> entries to be used but once. I have the custom validation box with the 32
> entries in worksheet 1 but can not figure out how to eliminate the the
> already used entry in worksheet 2, the used values in worksheets 1 and 2
> to
> not show up in the dropdown or worksheet 3, the used entries in worksheets
> 1,
> 2, and 3 not to show up in worksheet 4 and so on?
> Any help appriciated.
> PS: yup it's me again as football season draws near...
> --
> To those who have helped in the past and those about to help, Thank You.
> There is an intregeing element to Excel that has captured me and that
> stimulates my every remaining brain cell. Awesome
(Msg. 3) Posted: Mon Sep 07, 2009 7:35 am
Post subject: Re: DropDowns - allowing each value to be used once [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If we assume that you use the SAME dropdown list for all, you could have a
worksheet change event macro delete the selection. Biff's suggestion may be
better.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1.DeleteThis@austin.rr.com
"Football Express" <FootballExpress.DeleteThis@discussions.microsoft.com> wrote in
message news:7C067E36-64D4-425C-B022-6568012EAF59@microsoft.com...
> In a 17 worksheet workbook I need to allow one of 32 possible dropdown
> entries to be used but once. I have the custom validation box with the 32
> entries in worksheet 1 but can not figure out how to eliminate the the
> already used entry in worksheet 2, the used values in worksheets 1 and 2
> to
> not show up in the dropdown or worksheet 3, the used entries in worksheets
> 1,
> 2, and 3 not to show up in worksheet 4 and so on?
> Any help appriciated.
> PS: yup it's me again as football season draws near...
> --
> To those who have helped in the past and those about to help, Thank You.
> There is an intregeing element to Excel that has captured me and that
> stimulates my every remaining brain cell. Awesome
(Msg. 4) Posted: Mon Sep 07, 2009 7:35 am
Post subject: Re: DropDowns - allowing each value to be used once [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I think i would be tempted to use a combobox from the control toolbox then
give it a sub on click to move items from the list fill range
"Don Guillett" wrote:
> If we assume that you use the SAME dropdown list for all, you could have a
> worksheet change event macro delete the selection. Biff's suggestion may be
> better.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1.TakeThisOut@austin.rr.com
> "Football Express" <FootballExpress.TakeThisOut@discussions.microsoft.com> wrote in
> message news:7C067E36-64D4-425C-B022-6568012EAF59@microsoft.com...
> > In a 17 worksheet workbook I need to allow one of 32 possible dropdown
> > entries to be used but once. I have the custom validation box with the 32
> > entries in worksheet 1 but can not figure out how to eliminate the the
> > already used entry in worksheet 2, the used values in worksheets 1 and 2
> > to
> > not show up in the dropdown or worksheet 3, the used entries in worksheets
> > 1,
> > 2, and 3 not to show up in worksheet 4 and so on?
> > Any help appriciated.
> > PS: yup it's me again as football season draws near...
> > --
> > To those who have helped in the past and those about to help, Thank You.
> > There is an intregeing element to Excel that has captured me and that
> > stimulates my every remaining brain cell. Awesome
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office