I am trying to figure out how to apply a toggle box that enables a macro to run on the current row it is selected on.
I have an example spreadsheet that has 2 worksheets. The first Worksheet for the current Jaunary 2018, and the second worksheet is for the January 2017.
The column A1 is labled by DAY and column B1 is labled by DESCRIPTION.
This would be for worksheet January 2018.
A2 is Day 1 and the B2 Worked on Car
A3 is Day 2 and the B3 Worked on Boat
A4 is Day 3 and the B4 Worked on House
A5 is Day 4 and the B5 Worked on House
A6 is Day 5 and the B6 Worked on Garage
etc.
This would be for worksheet January 2017.
A2 is Day 1 and the B2 Worked on Boat
A3 is Day 2 and the B3 Worked on Car
A4 is Day 3 and the B4 Worked on House
A5 is Day 4 and the B5 Worked on Garage
A6 is Day 5 and the B6 Worked on Garage
etc.
I want to be able to put a check box toggle in C2, then drag it down to the last day. As I select the check box,
I would like to see what was done on that day from the January 2017 worksheet. If i un-check it, it will go back
and show what was previously there.
I hope I did not confuse anyone on this. Thank you for your help and guidance!
I have an example spreadsheet that has 2 worksheets. The first Worksheet for the current Jaunary 2018, and the second worksheet is for the January 2017.
The column A1 is labled by DAY and column B1 is labled by DESCRIPTION.
This would be for worksheet January 2018.
A2 is Day 1 and the B2 Worked on Car
A3 is Day 2 and the B3 Worked on Boat
A4 is Day 3 and the B4 Worked on House
A5 is Day 4 and the B5 Worked on House
A6 is Day 5 and the B6 Worked on Garage
etc.
This would be for worksheet January 2017.
A2 is Day 1 and the B2 Worked on Boat
A3 is Day 2 and the B3 Worked on Car
A4 is Day 3 and the B4 Worked on House
A5 is Day 4 and the B5 Worked on Garage
A6 is Day 5 and the B6 Worked on Garage
etc.
I want to be able to put a check box toggle in C2, then drag it down to the last day. As I select the check box,
I would like to see what was done on that day from the January 2017 worksheet. If i un-check it, it will go back
and show what was previously there.
I hope I did not confuse anyone on this. Thank you for your help and guidance!