This is for Google Sheets.
I need a very simple script that every time a calculation is performed on that spreadsheet because of the change in an input value:
1. Checks in a sheet called OUT the rage of output data resulting from those calculations. The output data in OUT always has the same number of columns (15) but the number of rows varies.
2. Selects and copies all the output data except the headings of the 15 columns located in Row 1
3. Pastes it as values in the next empty row of another sheet called EXPORT which has identical column structure, no heading and it is located on the same spreadsheet.
EXPORT usually already has data on it from previous copy pastes. At regular intervals data in EXPORT is sent to another location and all the data erased.
I'm one of the best Google Sheets experts here (with 1,000+ reviews) that's why I'm sure that you'll be impressed with my work. Could you show me your sample Google Spreadsheet?
Roman