Forum Discussion
Copying formulas from one document to another
I received help from the community on some If, then formulas and now want to build similar excel summaries around individual projects. When I try to copy the formulas which work perfectly in my maste...
Most probably you need not only copy formulas but adjust references used by them as well.
The columns haven't changed. I just deleted the data to input new, but left the formulas.
If columns are the same what was the need to copy formulas? Keep them as they were.
- I created a new document and used the original as a template. At first I copied the formulas into a new excel document making sure the columns were aligned with the formulas. (E=quantity, H=price, etc). That didn't work. Next I did a save as and just removed all of the data except the formulas and created REF! too. As you can see in the example from my first email.
For the second variant when you make the copy of your file (e.g. in file explorer copy file, paste it, rename and open, formulas still work), how exactly did you delete the data ?