Excel Drop Down lists....

[DotNetNewbie]

Hi,

I would like to create a spreadsheet that has 2 worksheets, the first will list jobs that have been carried out, and have a unique reference number.

The second sheet will be used to assign those jobs to an engineer.

This I can do at the moment, however what I would like to do is once a job number has been assigned to an engineer it no longer appears in the drop down list.

Is this possible?

Many thanks in advance.

.net

 

[Andrzejek]

"This I can do at the moment" - and HOW do you do it?
If you show your code, somebody may be able to improve on it.

Have fun.

---- Andy

 

[DotNetNewbie]

Hi Andrzejek,

They are generated from listed created using Data Validation, so at this stage there is no code.

Thanks in advance.

.net

 

[SkipVought]

Well the logic might be triggered by the Worksheet_Change event to conincide with the range containing your Data > Validation cells.

Use the value in the Target cell (see the Worksheet_Change event arguments) to plug into the Find Method in the engineers list, once found Delete - xlShiftUp.

Use your Macro Recorder to record a simulation of the stated process. Post your recorded code for further help customizing.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]