mburruss00
New Member
- Joined
- Mar 17, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi!
Okay, so I am making a study/pass tracker for school.
The headers (in black) and the KEY (on the right) are the same on every one of the three sheets.
I would like to move a row (which has a study video or lecture or worksheet, etc.) from "learning" (sheet 1) to "reviewing" (sheet 2) once I have gone over (passed) the content 3 times. So, I'll put 1, 2, or 3 for how many times I have seen the content and update it as I go through the week and study it again, adding 1 to the pass column.
Now, I would like to have a code (can be VBA) where once I input "3" into the column "passes", that row is moved from "learning" (sheet 1) to "reviewing" (sheet 2) underneath the header.
I will also be putting "3" in the passes column on multiple rows, so the second sheet will have many rows of material, and I would like if the new rows moved over there would automatically go under the last one, and not on top of the last one (I don't want them layering on top of each other and clearing the info underneath).
ALSO, I would only want the section of the row from column A to column G, as the key is already on the other sheets, and I do not want it moved when I type 3 in a row and a row is moved.
*Basically* I would like to move a row (range A to G) to the next sheet, underneath the last filled row in that sheet, once I input "3" into the "passes" column.
Is this possible? And if so, what code should I use and how should it look?
Thank you so much!!!!!
Okay, so I am making a study/pass tracker for school.
The headers (in black) and the KEY (on the right) are the same on every one of the three sheets.
I would like to move a row (which has a study video or lecture or worksheet, etc.) from "learning" (sheet 1) to "reviewing" (sheet 2) once I have gone over (passed) the content 3 times. So, I'll put 1, 2, or 3 for how many times I have seen the content and update it as I go through the week and study it again, adding 1 to the pass column.
Now, I would like to have a code (can be VBA) where once I input "3" into the column "passes", that row is moved from "learning" (sheet 1) to "reviewing" (sheet 2) underneath the header.
I will also be putting "3" in the passes column on multiple rows, so the second sheet will have many rows of material, and I would like if the new rows moved over there would automatically go under the last one, and not on top of the last one (I don't want them layering on top of each other and clearing the info underneath).
ALSO, I would only want the section of the row from column A to column G, as the key is already on the other sheets, and I do not want it moved when I type 3 in a row and a row is moved.
*Basically* I would like to move a row (range A to G) to the next sheet, underneath the last filled row in that sheet, once I input "3" into the "passes" column.
Is this possible? And if so, what code should I use and how should it look?
Thank you so much!!!!!