Find additional options

[NickYOW]

I am looking for some assistance, I have a list of tasks and I am trying to join them together of if the user puts an X next sweeping a X will go next to Moping as well, and if they put an X next to cooking an X will go next to the wishes and wipe counters.

so I have the list as column A and the column B is where I would like the X to be
cooking
dishes
mop
sweeping
wipe counters

I have been attempting to put it as a If then statement as macro but unable to get the return in the right box. Any assistance would be great.

 

[Saurabhj]

Hi, Welcome to MrExcel board.

Please share an example to understand the requirement.

 

[NickYOW]

here is the example if you put (add) in the box under casher for washing floor then sweep floor will say needed, if you (remove) from wash floor from warehouse then Sweep floor will say remove as well.
my basic code I have is
sub add()
dim answer as string
if Range("C6").value = "add" then
Range ("C7").value="required"
answer =msgbox("do you want to add this", vbyesno, otions)
if answer vbyes then
range("C6:C7"). value ="added"
else
range("C6:C7").value= Optional
end if
end if

I would like to have it work on the sheet so if the cell is changed it will run the macro
I have one as well for Remove
sub remove()
if Range("C7").value = "remove" then
Range ("C6").value=" sweep floor required"
answer =msgbox("do you want to remove this", vbyesno, options)
if answer vbyes then
range("C6:C7"). value ="removed"
else
range("C6:C7").value= "added"
end if
end if

this is a basic state to represent what I am attempting the big project has 170 jobs and 29 positions.

current on load I have
each of the cells set to required, optional or blank as needed.

any help I can get for a cross check when the cell is change from one value to another would be helpful.


thanks in advance.

 

[NickYOW]

Hi, Welcome to MrExcel board.

Please share an example to understand the requirement.

thank you, please see the example if you put (add) in the box under casher for washing floor then sweep floor will say needed, if you (remove) from wash floor from warehouse then Sweep floor will say remove as well.
my basic code I have is
sub add()
dim answer as string
if Range("C6").value = "add" then
Range ("C7").value="required"
answer =msgbox("do you want to add this", vbyesno, "options")
if answer vbyes then
range("C6:C7"). value ="added"
else
range("C6:C7").value= Optional
end if
end if

I would like to have it work on the sheet so if the cell is changed it will run the macro
I have one as well for Remove
sub remove()
if Range("C7").value = "remove" then
Range ("C6").value=" sweep floor required"
answer =msgbox("do you want to remove this", vbyesno, "options")
if answer vbyes then
range("C6:C7"). value ="removed"
else
range("C6:C7").value= "added"
end if
end if

this is a basic state to represent what I am attempting the big project has 170 jobs and 29 positions.

current on load I have
each of the cells set to required, optional or blank as needed.

any help I can get for a cross check when the cell is change from one value to another would be helpful.


thanks in advance.