Automated copy from row to a new row in the same and single sheet.

Romano el Polako

Hello Smart-Heads!

This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet.

The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:

The desired outcome is to automatically create a row below with information from A-E.

Option 1:

Highlight + "pull down", not acceptable as changes last digit

Option 2:

Optional: Insert above / below

Highlight + "copy" + paste below or in created row.

The automation is required to ensure that the reviewers don't make stupid mistakes and fail to paste correct value in column E.

Thanks,

Roman

Eric Law

@Romano el Polako You can use a helper sheet. What you will do is set up an automation to Copy the row to another sheet. On the helper sheet, you can then set up an automation to Move the row to the original sheet, thus creating a duplicate. If you need certain fields blank, you would also set up an automation for new sheets that changes certain cells to blank.

Hope that makes sense and helps you.

Eric Law

@Romano el Polako You can use a helper sheet. What you will do is set up an automation to Copy the row to another sheet. On the helper sheet, you can then set up an automation to Move the row to the original sheet, thus creating a duplicate. If you need certain fields blank, you would also set up an automation for new sheets that changes certain cells to blank.

Hope that makes sense and helps you.

Romano el Polako

Hey @Eric Law

Thanks for your response, yes this actually makes a lot of sense:

1. check box as a trigger for copy to helper sheet.
2. automation in helper sheet with 'move when new row is added"
3. minor adjustments with blank / copied content.

Thanks, will check it and come back to this threat!

Romano