Hello, hoping someone can help with this...
I have a list of role descriptions in a table on a tab 'jobs'
I have another tab 'functions' which captures a list of tasks to be undertaken in a facility
One of the columns on the 'functions' tab contains who does the task (limited to jobs list).
This could normally be achieved using data validation, HOWEVER, I (often) need to be able to manage more than one of the jobs in the cell (separated by ";").
(1) simple data validation is out
(2) the common vba solution for multiple validation entries only works with adding - it falls apart when manually editing to remove jobs from the cell.
(3) I need to be able to add and remove jobs against the task (based on the 'jobs' list).
(4) it also needs to be done on the fly (ie on the 'functions' tab), either in cell or some sort of pop up?
Example:
From this list ('jobs'):
Electrician
Maintenance & Repair Worker
Plumber
Painter
Customer Service Representative
Mason
Civil Engineer
Landscaper & Groundskeeper
Security Guard
Automotive Mechanic
Maintenance Tech
IT Manager
I might have one cell on the 'functions' tab containing:
Electrician; Plumber; Painter (which are contained in the job list)
(other cells in the same column could have combinations of a number of different 'jobs')
Problem: How can I remove (for eg) 'Plumber' from the cell? Then possibly add 'Automotive Mechanic' for instance? Must maintain the integrity of each entry consistent with the 'job's in the master list...
(Ps OK if a solution is custom user form, but a bit of extra detail pleeeease if that's the case
)
Thanks in advance
I have a list of role descriptions in a table on a tab 'jobs'
I have another tab 'functions' which captures a list of tasks to be undertaken in a facility
One of the columns on the 'functions' tab contains who does the task (limited to jobs list).
This could normally be achieved using data validation, HOWEVER, I (often) need to be able to manage more than one of the jobs in the cell (separated by ";").
(1) simple data validation is out
(2) the common vba solution for multiple validation entries only works with adding - it falls apart when manually editing to remove jobs from the cell.
(3) I need to be able to add and remove jobs against the task (based on the 'jobs' list).
(4) it also needs to be done on the fly (ie on the 'functions' tab), either in cell or some sort of pop up?
Example:
From this list ('jobs'):
Electrician
Maintenance & Repair Worker
Plumber
Painter
Customer Service Representative
Mason
Civil Engineer
Landscaper & Groundskeeper
Security Guard
Automotive Mechanic
Maintenance Tech
IT Manager
I might have one cell on the 'functions' tab containing:
Electrician; Plumber; Painter (which are contained in the job list)
(other cells in the same column could have combinations of a number of different 'jobs')
Problem: How can I remove (for eg) 'Plumber' from the cell? Then possibly add 'Automotive Mechanic' for instance? Must maintain the integrity of each entry consistent with the 'job's in the master list...
(Ps OK if a solution is custom user form, but a bit of extra detail pleeeease if that's the case
) Thanks in advance
