Hi there,

I have an excel file that pulls data from another worksheet. The file is updated quarterly, and each time, I copy and paste this formula into the next row:

=SUM(FH!B42:B43)/SUM(FH!D42:D43)*1000

and it gives me:

=SUM(FH!B43:B44)/SUM(FH!D43:D44)*1000

But, I'd like it to give me this (automatically):

=SUM(FH!B44:B45)/SUM(FH!D44:D45)*1000

Basically, I would like it to not repeat the row from the first formula, but just move on to the next row. Does anyone have any thoughts?

Thank you!