Using formulas in another file without including a link to file of origin.
I have a worksheet that has a lot of formulas that I can use in other files. What is the best way for me to transfer this sheet to another file? I find that if I use Move/Copy worksheet it works well EXCEPT that it is now referring to its file of origin :-(. Any suggestions on how I can use this sheet in other files without referencing the original file. Thank you. I think I should know this but turns out I don't :-(
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Are you all set with this now, or do you need more help? If all set, could you please close it out now. If you need help with the question close process take a look at:
Just realised might be referring to UDF with code in source workbook, use of the UDF when the sheet is copied will refer to original sheet unless code is in the specific sheet code rather than a separate module
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
Are you all set with this now, or do you need more help? If all set, could you please close it out now. If you need help with the question close process take a look at:
»bp