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:
.
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.
برچسب:
نویسنده: استخدام کار