VBA code help for looping the macro. I need to loop the VBA code which does the following "Whenever the value in cell B2 of sheet1 changes and it is greater than zero, then value is copied and pasted into sheet2 column A in the next blank cell, ie, A2,B2,C2. I need help to change this code to loop through the cells of Column B ie through B2 to B100."
Solved by B. J. in 15 mins