I've hit a wall it seems I am wondering if anyone can help meet out. I'm building a Excel macro but stuck on how to accomplish the following procedure.
Step 1: If any cell(s) in “J” column is greater than or equal to the value in Cell M4, Insert 1 new row above all cells that meet the criteria.
Step 2: Copy and move all cells that meet criteria in step 1: up 1 and to the right 1 (paste in new row). Then enter 0 in the in the original cell that it was copied and moved from.
<strike></strike>
I would post a screenshot to better explain however this site is not exactly newbie friendly I see.