Hi there. Im trying to keep track of completed tasks. I made a workbook where all tasks are listed in sheet1 (Ark1) and I want rows with completed tasks (identified by marked checkboxes) sequently moved to sheet2 (ark2).
I used this recepie to get med started: https://www.extendoffice.com/documen...ell-value.html. I must admit that I dont understand all lines, so it's somewhat difficult to modify it to suit my needs. Here is my code:
Please Login or Register to view this content.
Here is a screenshot of my first Sheet1 (Ark1) so you can get an idea what I'm trying to do.
Sheet1 (ark1)
sheet1.PNG
Sheet2 (ark2) is just a copy of the first 3 rows
However. Using this code gets me into all kind of strange situations, and I cant figure out how to solve it:
First: I imbedded checkboxes into cells. While the code copies the checkbox from the row correctly, It also copy in checkboxes in the row above the row of interest.
Second: If I have several checkboxes marked at the same time, the code only moves some rows. If I however just run the code over and over, all the rows of interes are included
Third When trying to delete rows in sheet2 it does not let med delete the checkboxes in sheet2. I allso figured out that excel had layered several hundered checkboxses into one cell
BTW I run this code to link my checxboxes:
Not beeing a world champion coder, I would really appreciate some help figuring out how to solve these problemsPlease Login or Register to view this content.
Thanks
Bookmarks