Paste as Values Automation/ Function

Josh Reed

Hey all,

I'm wondering if there is some way to automate the pasting of cells as values across entire columns or sheets. We currently have an archiving process that involves rows on an intake/tracking sheet and another "roster file" associated with that row. These two things have cell links between them but need these links turned into static values when archived.

For the row coming from the tracker to an archive tracker, this process happens organically. When a row is moved from one sheet to another it seems SS automatically converts all linked cells to values.

I would like some way to do this for the roster files as well... for this the links are in a column rather than a row. WCS we just copy/paste as values during the archive process... but the rest happens through automation so it would be a major bummer to have to leave any part of it manual.

Thanks!

Josh

Andrée Starå

Hi @Josh Reed

I hope you're well and safe!

You could add a section in the sheet to format them to be on a row, or you could add a so-called helper sheet and cell-link them to a row and, in both cases, have them copied over to the sheet where you need them to have the values stored.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!