How do I set up a macro where it will do the following actions each time

I'm a complete newbie here and am stuck with a task I have to repeat over the next few days. I would very much appreciate your kind help. Thanks so much in advance.

Setup:

• There are 2 sheets.
• On Sheet1, there is a bunch of data.
• On Sheet2, there is a data table with the same format as in sheet1, but the table is empty.

.

Desired actions:

1) Go to the first row of the data table in Sheet1.

2) If the value of the most right column of that row is "1", copy the whole row. If not, go to the next row and check again. Repeat this until something is copied.

3) Go to the first empty row of the data table in Sheet2. Paste values of what was just copied.

4) Retu to 1) but start from where you left off. Repeat the whole thing until all data with said condition in Sheet1 has been copied over to Sheet2.

Recent Questions...