Feb 16 2022 07:05 AM
I have 2 worksheets in one job, one of the worksheets has checkboxes on each row. I would like to click on that checkbox and have the information in that row go to the other worksheet that I have setup. Is this possible?
Feb 17 2022 03:13 AM
This would only work with VBA.
Please note that the control boxes must be set as a check box (ActiveX Control).
Here is a link with such an approach.
How To Move A Certain Row Into A New Sheet When Check Box Is Checked In Excel?
Standard disclaimer: This is a non microsoft site.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
Feb 17 2022 05:28 AM
this gets me very close I have 2 issues with this when I check the box the line is removed from sheet one I need it to stay and I have multiple lines with check boxes can i have a checkbox for each row?
Feb 17 2022 06:54 AM