Hi All,
I am looking to create a macro that will loop through a column of at most 10 rows. The macro needs to identify the next number > 0 in the column, set the cell value of the adjacent cell to "X" then stop. When the macro is executed again, it needs to delete the "X" it just created prior to identifying the next number > 0 and placing an "X" in it's corresponding adjacent cell. If the macro has reached the bottom of the range it needs to go back to the top of the range and begin again.
I'm feeling pretty stuck here and could use some guidance. Attached please find the template for reference.
Thanks in advance,
MIACG
X_Loop.xlsm
Bookmarks