call a Macro based on intersection

[NickYOW]

I am trying to call a macro based on a cell with cross reference to task and Position. Currently I am using
IF range("C4").value = "Add" then
call cashierwashadd
else
call cashierwashremove
end if
if range("D4").value ="Add" then
call supervisorwashadd
else
call supervisorwashremove
end if

but the Problem is if I add a Task then C4 is no longer addressed with wash and all my code would have to be change.

I need some code that say if active cell is in column(cashier) and in row(wash) then call cashierwashadd else cashierwashremove & would move with it if the case was cashier wash was to move to cell C5.

any help would be great thanks in advance.

 

[NickYOW]

That suggests that you have a space after "wash" in the cell, best option would be to edit the cell to get rid of the space.

thanks this has been amazing. you have been a great help..

 

[Fluff]

Glad to help & thanks for the feedback.

 

[NickYOW]

Glad to help & thanks for the feedback.

You have been such a great help and I am now trying to simply my code once again.

The macro that I have now is that if F5 is set to Add then RUN managerstockadd.

within that code it states to have F7 & F8 become optional and a msgbox" do you want to add optional jobs" and F16 Becomes Required, but this is many many lines of code, and again if I add a row above F5 in then the code within the macro become incorrect as F7 will not be sweep floor anymore.

I was thing about an offset code though not sure that would work. I'm think a look up verification table would work better.

I'm reaching out again as you have been a great help and my code has worked but updating it and changing all the cell reference will take too much time and the code your have been providing is been very helpful. I'm some what new to VBA and have been doing things the long way.

 

[Fluff]

We would need to see the code in order to help, but as this is a totally different question to your op, it needs a new thread. Thanks

 

[NickYOW]

We would need to see the code in order to help, but as this is a totally different question to your op, it needs a new thread. Thanks

thank you for the info I have done so, title is Link tasks to profiles within a macro, and I have included some of the code. you long with other have been a great help I am happy to have found this group of people.