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!
Bookmarks