Remove links from copied sheet?
I have a sheet that pulls some information from a master sheet using an INDEX/MATCH formula. Is there a way to make a copy of this sheet and retain the contents of the cells without the formulas?
Basically, I want to make an archive of the current state without it updating in the future to new information if the master sheet changes.
Comments
-
Okay, well I figured out an inelegant solution, in case anyone has the same question.
First I made a copy of the sheet to recreate the columns, then deleted all the rows from that sheet. Then I selected all the rows in the original sheet and used the row action Copy to Another Sheet, which copied all the values to the new sheet except the Predecessors. Then I copied the Predecessors column and pasted it into the new sheet.
-
Hello Brian,
Thanks for getting in touch, I'll be happy to help with your query.
We currently don't have a programmed functionality for exporting a sheet whilst retaining the current value of data obtained via formulas, but I've let our Product team know about this request. We appreciate your input!
Let me know if you need any further assistance.Thanks
Lewis
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 467 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives