M
moosifer
OK firstly, I tried to use the VBA code on this pag
http://tinyurl.com/6rlrp to attempt to remove the blank cells from
list but it didn't work (although it doesn't mention how you'r
supposed to set the validation up).
Anyhow that was just one solution to the problem, there may well b
more.
I have a workbook with two columns of data. In the first employe
names, in the second their job title.
On another workbook there is a dropdown box for job title, that's nic
and simple (well only because I've separately typed in a list o
available titles.
The problem is that I then want the cell next to the job title to be
drop down list of all the people who have that title. Any idea how thi
could work?
I'd tried making a third column using a formula that would either pu
the person's name there if the first box matched their title, or put
blank cell if it didn't. From that I was trying to use the publishe
solutions on how to make this third column into a list with the blank
removed.
I'm completely stuck! Help
http://tinyurl.com/6rlrp to attempt to remove the blank cells from
list but it didn't work (although it doesn't mention how you'r
supposed to set the validation up).
Anyhow that was just one solution to the problem, there may well b
more.
I have a workbook with two columns of data. In the first employe
names, in the second their job title.
On another workbook there is a dropdown box for job title, that's nic
and simple (well only because I've separately typed in a list o
available titles.
The problem is that I then want the cell next to the job title to be
drop down list of all the people who have that title. Any idea how thi
could work?
I'd tried making a third column using a formula that would either pu
the person's name there if the first box matched their title, or put
blank cell if it didn't. From that I was trying to use the publishe
solutions on how to make this third column into a list with the blank
removed.
I'm completely stuck! Help