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.
If you have access to Inquire, a quick solution is to run Workbook Analysis which will create a workbook listing all formulas.
https://support.microsoft.com/en-us/office/analyze-a-workbook-with-spreadsheet-inquire-5991e8fa-f1c1-401a-ae3f-469384ae3e3b#:~:text=%20Start%20the%20workbook%20analysis%20%201%20In,cell%20or%20range%20of%20cells%2C%20data...%20More%20
https://support.microsoft.com/en-us/office/analyze-a-workbook-with-spreadsheet-inquire-5991e8fa-f1c1-401a-ae3f-469384ae3e3b#:~:text=%20Start%20the%20workbook%20analysis%20%201%20In,cell%20or%20range%20of%20cells%2C%20data...%20More%20