Copying an entire row with formulas in each cell and pasting to a different document

If a formula refers only to cells within the same table, it will copy/paste to the other document. It appears that your formulas refer to cells in a different table. Even if that same other table exists in the other document it won't paste the formula.

SGIII wrote a script nearly a decade ago that will convert formulas to text in their cells. Select the row(s) you want to copy and run the script and it will turn the formulas into text so you can copy/paste them to the other document. After that, format the cells (or just the formula cells) as "automatic" to turn the formulas back into formulas (in both tables). You can use "undo" in the original table instead of reformatting but it is a cell-by-cell process so it might be a lot of undos if it was a lot of cells.

Try it on a sample document before trying it on your real one. I don't know if SGIII has made any changes to the script over the years. It is also possible that your copy/paste operation could be done with a different script (yet to be written) that would not alter the original table.

tell application "Numbers"
	tell document 1 to tell active sheet
		set t to first table whose selection range's class is range
		repeat with c in t's cells
			if c's formula is not missing value then
				set c's value to "'" & c's formula
			end if
		end repeat
	end tell
end tell