How to Copy Values and formulas simultaenously

[ravi123]

Hello All,

I am having table with some formulas inserted, by inserting unique values in desired cells, it gets calculated with the formulas. this is my daily task, and I have to copy this table from previous spreadsheet (SS) and paste it into new SS for fresh data. Earlier it was copying and pasting data/values and formulas simultaneously in new SS, however now I don't know what wrong has happened accidentally, it is now copying and pasting only values in new SS, now i have to type formulas manually after each pasting.

Any clue to restore previous copy paste format in which values and formulas get copied and paste simultaneously.

 

[jtakw]

Hi,

Try this, Open your workbook,

Press: Alt + F11
Then press: Ctrl + G
In the Immediate window, enter:

Commandbars("Cell").Reset

Go back to your worksheet, your copy/paste functions should be restored.