Macro to loop through rows of data

[paul_sykes00]

Hi, Hope someone can help with below macro. Thanks in advance

Iteration 1
Sheet 2 includes formulae with cell references to row 1 of Sheet 1, a second macrox runs with these cell references

Iteration 2
Sheet cell references are updated to row 2 of Sheet 1, macrox runs again

Iteration 3
Sheet cell references are updated to row 3 of Sheet 1, macro x runs again

This continues until cell references contain no data

 

[StephenCrump]

Try: https://www.mrexcel.com/forum/excel...op-through-multiple-rows-cell-references.html

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...op-through-multiple-rows-cell-references.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).