Forum Discussion
Solved
Save / Restore all formulas on a worksheet
Hello all. I have laid out a complex time edit sheet in excel. It pulls values from one table, the users will edit the values on this sheet and the edits will save to a second table for submitting t...
The macro writes one formula in 10000 cells in this example. In cell I2 the formula =B2*C2 is entered, in cell I3 formula =B3*C3 and so on. If any changes are made in column I the formulas can be re-entered by running the macro. I wanted to show that the original formulas can be re-entered in almost no time with the help of a macro.
Can you share the formulas of your sheet? Maybe the formulas can be written into the file with the R1C1 code.
I have created similar spreadsheets before and the easiest solution for me is to change the attributes of the file where the end users input their data to read-only. This will keep them from making any changes and also allow more than one person to use it at the same time.