hi.
I don't think you will be able to do what you want with formulas.
If i understand correctly, you have the formulas on sh2 drawing data from sh1.
are you trying to create a data base of receipts?
To do this with formulas, you would have to.....
1. put absolute references in the formula on sh2. (dollar signs in front of
the column number and row number.)
2. with each receipt, you would have to go to sh2, copy the fomulas down one
row then copy and paste the the receipt 1 row as values thus turning the
formulas into hard numbers.
3. go back to sh1 and enter recreipt 2.
4. repeat for each receipt.

yeah i know. labor intensive. but that's with formulas. it would work.
but i would recomend writing a macro to do this and reduce it to a one
button click.
unfortunately, you didn't provide enough info to suggest anything further.

regards
FSt1


"Bobbykm" wrote:

Sh1 is a receipt (that I created in Excel) to be filled out by me with the
first receipt being #1. When filling out, the info is transferred via
formulas to their respected columns in Sh2 where I want to save the info. I
want to be able to change receipt to #2 but save the info in Sh2 from receipt
#1.

Thanks
Bobby