But the "absolute" referencing is giving a lot of trouble.īoth workbooks must be open for this to work. Given that these sheets have no dependant cells on other sheets, like a summary report, it is desirable for us to just copy and merge the sheets back into the original xlsx. Concurrently, another person may also be making changes to another sheet. We constantly need to make "upgrades" to this xlsx and so one person may create a copy and his changes there for a single sheet. I have a production xlsx in use for daily operations. If I choose paste formula, it still gives absolute references. Excel treats "values" as calculated values rather than the actual formulas in the cell. I want to maintain "relative" cell references instead of "absolute" cell references (i shall invent this terminology in Excel world if it does not yet exists).Īnother possible alternative that I cannot get it to work is the option to paste cell "values" only. the formula =B!23 becomes =!B!23 when copied over. How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |