Loop to Copy Range and Paste Values in Same Location

  • Rookie here...I have looked at multiple threads and cant' figure out the proper coding to accomplish what I need.


    I have a table of formulas, columns R - AG. If column AI of the corresponding row = "Yes", I would like to copy and paste values on that same row (simply replacing the formulas with values). If the corresponding AI column is not equal to "Yes", I would like the formulas in columns R - AG to remain and for the macro to loop to the next row (if column AI is not equal to "Yes", do nothing and move on to evaluate the next row).


    Thank you in advance for your help!

  • Hi, check this out

    I made a sample sheet here. butler.xlsm