Discussion Re: Copying formulas from one document to another in Excel
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218227#M93341
<P><LI-USER uid="968401"></LI-USER> </P>
<P>Most probably you need not only copy formulas but adjust references used by them as well.</P>Wed, 17 Mar 2021 20:42:23 GMTSergei Baklan2021-03-17T20:42:23ZCopying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218222#M93340
<P>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.</P><TABLE width="1016"><TBODY><TR><TD width="128">Image</TD><TD width="55">Area</TD><TD width="81">Modification</TD><TD width="61">Custom Quote</TD><TD width="37">Qty</TD><TD width="127">Pattern</TD><TD width="201">Description</TD><TD width="82"> Net </TD><TD width="82"> 1-5 Discount </TD><TD width="82"> 6+ Discount </TD><TD width="80"> Total </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>5%</TD><TD>10%</TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>5</TD><TD>86-004</TD><TD> </TD><TD> $ 4,723</TD><TD>#REF!</TD><TD>#REF!</TD><TD>#REF!</TD></TR></TBODY></TABLE>Wed, 17 Mar 2021 20:38:45 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218222#M93340Awolbert2021-03-17T20:38:45ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218227#M93341
<P><LI-USER uid="968401"></LI-USER> </P>
<P>Most probably you need not only copy formulas but adjust references used by them as well.</P>Wed, 17 Mar 2021 20:42:23 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218227#M93341Sergei Baklan2021-03-17T20:42:23ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218247#M93342
The columns haven't changed. I just deleted the data to input new, but left the formulas.Wed, 17 Mar 2021 20:52:01 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218247#M93342Awolbert2021-03-17T20:52:01ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218253#M93343
<P><LI-USER uid="968401"></LI-USER> </P>
<P>If columns are the same what was the need to copy formulas? Keep them as they were.</P>Wed, 17 Mar 2021 20:55:07 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218253#M93343Sergei Baklan2021-03-17T20:55:07ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218285#M93344
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.Wed, 17 Mar 2021 21:07:41 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218285#M93344Awolbert2021-03-17T21:07:41ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218347#M93348
<P><LI-USER uid="968401"></LI-USER> </P>
<P>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 ?</P>Wed, 17 Mar 2021 21:30:32 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218347#M93348Sergei Baklan2021-03-17T21:30:32ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218362#M93349
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.Wed, 17 Mar 2021 21:33:44 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218362#M93349Awolbert2021-03-17T21:33:44ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218381#M93351
<P><LI-USER uid="968401"></LI-USER> , you too.</P>
<P> </P>
<P>You deleted the cells or cells values?</P>Wed, 17 Mar 2021 21:38:32 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218381#M93351Sergei Baklan2021-03-17T21:38:32ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218407#M93357
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.Wed, 17 Mar 2021 21:49:06 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218407#M93357Awolbert2021-03-17T21:49:06ZRe: Copying formulas from one document to another
https://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218423#M93358
<P><LI-USER uid="968401"></LI-USER> , no problem.</P>
<P> </P>
<P>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.</P>
<P> </P>
<P>Sorry, I'm off for today.</P>Wed, 17 Mar 2021 21:54:49 GMThttps://techcommunity.microsoft.com/t5/excel/copying-formulas-from-one-document-to-another/m-p/2218423#M93358Sergei Baklan2021-03-17T21:54:49Z