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
