Remove item from drop down list once selected

ffwilson26

New Member
Joined
Nov 18, 2009
Messages
19
I have a work book with a tab labeled Training with about150 training topics.
I then have a calendar with each month its own separate tab.
What I would like to do is, put a pull down box of thetraining topics in each day of each month that requires training and then oncea training topic has been selected, then that topic is removed from the dropdown list so that its not available to be selected on another training day.
Thanks is advance for any help.

 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
18,711
Office Version
  1. 2013
Platform
  1. Windows
We would need a lot more details.
You have two different workbooks?

Or are we only dealing with One Workbook.

And then you have one Worksheet named Training and then a separate sheet for each Month of the year.

How are these sheets named?

Then you want a:
put a pull down box "Your words"

What is a Pull down Box?

Do you mean a Data Validation list?

And you want a Data Validation list in all columns of each Monthly sheet.
Do you already have this part done?

And if you select Math from the list you want Math removed from the Data Validation List ?

We would need to know in what columns of the 12 sheets are these Data Validation list.

I would assume each sheet would have 7 column since there are 7 ways in the week.

So would this be columns(1) to (7) of Each of the Monthly sheets?

See these are the details we would need to help you.

Please be sure and answer all questions. This keeps us from having to ask the same questions again.
And I never open files posted on this forum. So please do not say: Here is a link to my file just open the file and see my setup.
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,305
Messages
5,836,539
Members
430,436
Latest member
Emilycr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top