Tag Info

New answers tagged


Fastest solution for me is with a macro. Put a button on the sheet where you want to conserve the already existing data, and link it to the procedure below: Sub MyProgram() Dim MyRange As Range Set MyRange = Range("A1") MyRange = MyRange.Value End Sub Change A1 in the line Set MyRange = Range("A1") to whichever cell's value you want to preserve.

Top 50 recent answers are included