stg_williams
New Member
- Joined
- Jan 29, 2016
- Messages
- 2
What I want to do is:
If the checkbox in cell X1 is true then copy cell X2 and then paste in Cell X3 but only if Cell X4 is equal to todays date.
If it's not todays date then check cell Y4 for todays date.
If not then check cell Z4...
And so on until the cell with todays date is found.
So if Today's date, for example is found in cell Z4 then it would paste in Cell Z3. Found in Cell Y4 it would paste in cell Y3.
I have a list of checkboxes that is a checklist. This checklist needs to paste tasks in the list to the cell that represents "today".
Thanks
If the checkbox in cell X1 is true then copy cell X2 and then paste in Cell X3 but only if Cell X4 is equal to todays date.
If it's not todays date then check cell Y4 for todays date.
If not then check cell Z4...
And so on until the cell with todays date is found.
So if Today's date, for example is found in cell Z4 then it would paste in Cell Z3. Found in Cell Y4 it would paste in cell Y3.
I have a list of checkboxes that is a checklist. This checklist needs to paste tasks in the list to the cell that represents "today".
Thanks