How to transfer data from one table to another so that the first table erases the entered values ​​after the transfer?

Question

Macros

There are two tables: a table with a menu designer (hereinafter - table 1) and an order accounting table (hereinafter - table 2).
In table 1, a person must select, using the drop-down list, the items he needs in the menu for different categories, then click ready and this data should be redirected to table 2, which collects all orders.
It is necessary to make sure that after sending the data from table 1, the entered values ​​​​are deleted and the table is available to other people.

Answer 1

Google script will help

var sprsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet1 = sprsheet.getSheetByName('List1');
  var sheet2 = sprsheet.getSheetByName('List2');
  sheet2.getRange("Диапазон куда вставлять").setValues(
         sheet1.getRange("Диапазон откуда копировать").getValues()
)
sheet1.getRange("Диапазон откуда копировать").clear()