Mar 17 2021 01:38 PM
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.
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! |
Mar 17 2021 01:42 PM
Most probably you need not only copy formulas but adjust references used by them as well.
Mar 17 2021 01:52 PM
Mar 17 2021 01:55 PM
If columns are the same what was the need to copy formulas? Keep them as they were.
Mar 17 2021 02:07 PM
Mar 17 2021 02:30 PM
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 ?
Mar 17 2021 02:33 PM
Mar 17 2021 02:38 PM
Mar 17 2021 02:49 PM
Mar 17 2021 02:54 PM
@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.