WHAT IT DOES
Easily move/archive a row of data from one Google Sheet™ (tab) to another, within the same file. If you prefer something a bit quicker than cut/paste and with less chance of human-error.

It will also remember your individual preferences for each file so it is even quicker to use next time around.


NEW FEATURES
January 2022:
A new 'Settings' page allowing you to select more than just cell values when archiving row data. You can now also select:
> Text formatting: bold, italics, colour, size and style.
> Cell: background colour, Notes and wrapping.


HOW TO USE
After installing:

1) You can access the tool from any Google Sheet™, by clicking the 'Show side panel' button at the far bottom right of the Sheet. Then select the 'Archive Sheet data' icon to open the Add-on (if you already had your Google Sheet™ open when you installed the Add-on then you may need to refresh the page first for the new icon to appear).

2) When you are ready click 'GET STARTED'. Use the dropdown boxes to select where you are moving data from/to (your preferences will automatically be saved for future). Remember to ensure you have copied the Header row to your destination tab so that the row of data can be appended under it.

3) Now click anywhere in the row of the data that you want archiving and then select the 'ARCHIVE ROW' button.

4) A success message will confirm it has been moved. Click the 'BACK' button to return and continue archiving to your heart's content!

Use the 'Settings' button in order to adjust the type of formatting you want to preserve.


CAVEATS
At the moment the Add-on does not transfer:
> Cell Comments - recommended you create a separate column for Comments if you wish to retain these.

Also note:
> Tickboxes will retain their value but will become 'true' or 'false' in the destination tab.
> Formulas will be lost but the resultant value maintained eg if you have a 'SUM' formula in a cell it will archive the total of that Sum.
> There will be no 'cell history' available as the entire source row is deleted after the move. 'Version history' still remains available however.