Need a formula to have all work-flowed moved cells to go to the top of the sheet

Micah Sheerin

Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top?

Thank you!

Jeff Reisman

@Micah Sheerin

Have you tried an AutoNumber column on the receiving sheet, with the sheet sorted by the AutoNumber column descending?

Micah Sheerin

@Jeff Reisman I just tried that and it doesn't work:/ Once cells are pushed to the receiving sheet, it wont update to the autonumber column

Andrée Starå

Hi @Micah Sheerin

I hope you're well and safe!

To add to Jeff's excellent advice/answer.

• Have you explored using a Report instead?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Micah Sheerin

@Andrée Starå Will I use a report for all three sheets? or just the receiving/end user one?

Andrée Starå

@Micah Sheerin

You could either use it for the last sheet to sort it to the top or use it with all sheets, but then it would show on multiple rows and not on one.

Would that work?

Micah Sheerin

@Andrée Starå Thanks so much! Do you know if a report constantly updates ? or if there is a way to get that function?

Andrée Starå

@Micah Sheerin

Happy to help!

It's always a live view of the sheets each time you open it or as soon as it's refreshed.

Would that work?