I have no idea how to do this: is it done conditional format, VBA, formula?
on one sheet i have 3 checkboxes (A, B, C) which I want to toggle based on the vlookup value of a client based on a call status.
Call status will only be 1, 2 or 3.(Sheet: Master_Territory)
Checkbox is on a seperate sheet. (Account_Summary)
If Call status is = 1 then toggle check box in A1
If call status = 2 toggle a2
if call status = 3 toggle a3