Moving a row to the next sheet when I input a certain value in a cell within that row. (For a study tracker)

mburruss00

New Member
Joined
Mar 17, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi!

Okay, so I am making a study/pass tracker for school.

Screenshot 2021-03-17 134030.png


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!!!!!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,130,124
Messages
5,640,250
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top