Need to save values from a sheet to be cleared to a "running total" sheet upon clearing

Hello,

I'm the first to admit I'm an inexperienced noob...so please, be gentle...LOL

I have a Google Spreadsheet that I've created, as I'll describe below (see link at bottom, if you want to view it):

- AppSheet app reads QR codes and inputs product info into the "Form Responses 1" tab and customer/shipping info into the "Customer Info" tab
- "BOL - Bulk Bags" tab has formulas (I think that's what they're called?) that pulls the appropriate info from both tabs to populate the applicable cells on the Bill of Lading

Everything above works great; the problem is:
1. I need to be able to clear the data from the cells in the BOL after it has been populated and printed (ideally, I'd LOVE to have the ability to essentially automatically create a "snapshot" of it, which would then be automatically filed in it's own folder on Google Drive, but I'm probably dreaming...lol), and also from the "Form Responses 1" tab and "Customer Info" tab
2. HOWEVER, I need the original data from the "Form Responses 1" tab to be copied/transferred to another tab or sheet, where it will become part of a running list of all bags shipped (this tab/sheet hasn't been created yet) for inventory tracking.

Obviously, what I'm trying to accomplish is inventory control. If anyone has any better ideas for setting this up, I am all ears and willing to try anything that appears like it will meet my needs!!

Here's the link to the spreadsheet: https://docs.google.com/spreadsheets...it?usp=sharing

Thanks in advance,

Stickboy

Hi stickboy and welcome to the forum,

I'm getting older and more confused daily. I'm truly sorry that I don't understand why you would post a question about Google Sheets on a Excel forum. In my mind Google and Excel are competitors. They have different play books and working to sell to the same market. In Seattle we have the Seahawks and in MN you have the Vikings. Your question is like me asking for the Viking's playbook because we both play football.

I guess I'm having a bad day, but it seems strange that you would ask for help with a Google spreadsheet on an Excel forum.

Now that I have that out of my system... Perhaps someone with Google experience can help with your question. I do believe that no question is bad or wrong..

MarvinP

Upon searching the net for Google Sheets Forum, I find:

https://productforums.google.com/forum/#!topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false

Stickboy - you win. I didn't see the forum you had asked the question in.

My apologies.

On the other hand, I don't understand why the Excel Help Forum would try to answer questions about a competitors product.