I have a worksheet which has a bunch of formulas in rows (i.e. data entered
in columns C through F result in formulas results in columns G through
whatever).

All I want to do is to copy a row and move the formulas into another
worksheet while keeping the references to the original worksheet intact. So:

=COUNTIF(G$3:G301,G301)

becomes...

=COUNTIF(Data!G$3:G301,Data!G301), or however you lock the worksheet down.

I'm copying from row 300 in the original to Row 2, to make things a little
more complicated, but isn't there a way to do this?

Thanks in advance!