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.
