Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is there a way to move rows from one sheet to another and keep all the cell formulas that go with it?
This might be a good Enhancement Request. It would be extremely handy if I needed this feature more.
I've always done it per the guide: Moving Rows, Columns & Cells
Formulas and predecessors won't be preserved, but you can copy and paste them between the two sheets
Hope this helps!
Carl & Kris,
This is what I use the free version of Zapier for (www.zapier.com)
Free gives you:
A Zap is an instance of the automation.
I currently have two sheets that I move from. (So 2 Zaps)
And I do it less than 100 times a month so no danger of hitting that until I find more uses for Zapier (actual or testing)
The first one took only a few minutes to get up and running.
Unfortunately as I was writing this, I realized I might not have formulas in the orginal sheet -- and sure enough I didn't. So I tested it ... and it did not bring over the formula.
So a slightly longer check reveals it probably won't.
So nevermind.
Craig
