Copying formulas from one document to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2218222%22%20slang%3D%22en-US%22%3ECopying%20formulas%20from%20one%20document%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2218222%22%20slang%3D%22en-US%22%3E%3CP%3EI%20received%20help%20from%20the%20community%20on%20some%20If%2C%20then%20formulas%20and%20now%20want%20to%20build%20similar%20excel%20summaries%20around%20individual%20projects.%20When%20I%20try%20to%20copy%20the%20formulas%20which%20work%20perfectly%20in%20my%20master%20document%2C%20they%20don't%20function%20in%20a%20new%20document.%20I%20am%20copying%20the%20formulas%20only.%20Please%20help.%3C%2FP%3E%3CTABLE%20width%3D%221016%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22128%22%3EImage%3C%2FTD%3E%3CTD%20width%3D%2255%22%3EArea%3C%2FTD%3E%3CTD%20width%3D%2281%22%3EModification%3C%2FTD%3E%3CTD%20width%3D%2261%22%3ECustom%20Quote%3C%2FTD%3E%3CTD%20width%3D%2237%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%22127%22%3EPattern%3C%2FTD%3E%3CTD%20width%3D%22201%22%3EDescription%3C%2FTD%3E%3CTD%20width%3D%2282%22%3E%26nbsp%3BNet%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282%22%3E%26nbsp%3B1-5%20Discount%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282%22%3E%26nbsp%3B6%2B%20Discount%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E%26nbsp%3BTotal%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E5%25%3C%2FTD%3E%3CTD%3E10%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E86-004%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%2C723%3C%2FTD%3E%3CTD%3E%23REF!%3C%2FTD%3E%3CTD%3E%23REF!%3C%2FTD%3E%3CTD%3E%23REF!%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2218222%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2218227%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20formulas%20from%20one%20document%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2218227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F968401%22%20target%3D%22_blank%22%3E%40Awolbert%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20you%20need%20not%20only%20copy%20formulas%20but%20adjust%20references%20used%20by%20them%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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 Net  1-5 Discount  6+ Discount  Total 
        5%10% 
           
    586-004  $       4,723#REF!#REF!#REF!
9 Replies

@Awolbert 

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.

@Awolbert 

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.

@Awolbert 

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 ?

I deleted the cells that had text, quantity and price since the discounts columns and the extension all reference the price, once that was gone, it left only the formulas. Does that make sense? Happy St Patrick's Day. It's time for green beer on EDT US.

@Awolbert , you too.

 

You deleted the cells or cells values?

Ah, cell values. I thought. I just highlighted and hit the delete button. Do you ever run up against people like me with such elementary skills? I feel like I need to apologize.

@Awolbert , no problem.

 

If you may share a file or/and text of formula in question (copy from formula bar) before and after that will be more clear.

 

Sorry, I'm off for today.