Copy formula with values instead of reference

[whielkem]

Hi, for some reason in need to copy a formula, but with the values of the references instead of the reference.

for instance

=AVERAGE(A1,A2)

with A1 and A2 repectively being 1 and 3, should be copied to another excel as

=AVERAGE(1,3)

Why I need this: I am unable to make any changes to the destination sheet, so I can't put a permanent formula in there, but the people looking at it, do want to see both values in the cell.
To make life easier for my team, I want them to just be able to type in the raw data in another sheet and then copy it to the destination file.

 

[XcelXpert]

I tried to create a test spreadsheet based on your description. Let me know if this is what you were looking for.

Here is a link to a test document that I made.

averageTest.xlsx

drive.google.com