excel

[EvoRevo]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I use spreadsheets to keep track of all of the financials for my business. I want to use an old spreadsheet, copy it, delete the information that had been imputed, and replace it with new text and values without getting rid of the formulas that are within the old spreadsheet. I basically want to use the formulas but not the information that was inputed b/c it has changed. Please help.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I use spreadsheets to keep track of all of the financials for my business. I
want to use an old spreadsheet, copy it, delete the information that had been
imputed, and replace it with new text and values without getting rid of the
formulas that are within the old spreadsheet. I basically want to use the
formulas but not the information that was inputed b/c it has changed. Please
help.

You should be able to just copy the data and paste it into the same
locations in the new sheet leaving the formulas in tact.

 

[Jijin]

You need to paste special as values for the cells that does not have formula.
And then the data changes which will update your formula alone...

-Jij