Copy data on new rows

Morena

Hi Guys

I have sheet - SHE Comparison MTD - I want to every month the Data on the screenshot to be copied to the same sheet but on new rows below else if not possible it can be copied to a new sheet, but Now it must say April if we are in April - eg FY2025_Apr 2025. also the Areas must be Process (Apr 24) and Process (Apr 25), is this possible?

Andrée Starå

https://community.smartsheet.com/discussion/137549/copy-data-on-new-rows

Hi,

I hope you're well and safe!

Yes, It's possible, but it's pretty advanced to set up.

One way is to set it up so it copies from another sheet or the main to a helper sheet and then copies/moves back.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!