Copying formulas from one document to another

Question

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 master document, they don't function in a new document. I am copying the formulas only. Please help.ImageAreaModificationCustom QuoteQtyPatternDescription&nbsp;Net&nbsp;&nbsp;1-5 Discount&nbsp;&nbsp;6+ Discount&nbsp;&nbsp;Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5%10%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586-004&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,723#REF!#REF!#REF!

sergeibaklan · Answer

Awolbert&nbsp;
Most probably you need not only copy formulas but adjust references used by them as well.

awolbert · Answer

The columns haven't changed. I just deleted the data to input new, but left the formulas.

sergeibaklan · Answer

Awolbert&nbsp;
If columns are the same what was the need to copy formulas? Keep them as they were.

awolbert · Answer

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.

sergeibaklan · Answer

Awolbert&nbsp;
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 ?

Forum Discussion

Copying formulas from one document to another

9 Replies

Resources

Image	Area	Modification	Custom Quote	Qty	Pattern	Description	Net	1-5 Discount	6+ Discount	Total
								5%	10%

				5	86-004		$ 4,723	#REF!	#REF!	#REF!