I was hoping someone could help at least point me in the right direction with this idea. Let me first say that this is not an attempt to get a free job out of the day...part of the reason for doing this is to learn something new. I am fairly computer literate but to too much beyond the basic spreadsheet functions between a few cells on the same worksheet.
So, my idea is this...I am making a spreadsheet to resemble the liquor shelf at the store. You touch the desired product label that needs a quantity sold input. Some will get input daily, other slower products won't see action for who knows how long, meaning it would stay a blank cell for the quantity sold that day. The products that do get input for the day, I want that value and the corresponding product to be pasted to the next available cell into a second worksheet/tab. The purpose of this is to print worksheet two and it be only the products that have a quantity sold for that day for taking to the stock room and calculating the total sales of the day.
Worksheet one has all the product listed and when touching the cell of a product you would get a popup with the values of 1-10 (there's no more than 10 bottles on the shelf of anything) and so if the cell for Jack Daniels received the first input of 3 bottles sold, it would copy and paste the price of JD ($14.50) into A1 of worksheet/tab 2, along with the quantity sold input into B1, "Jack Daniels" into C1, and last being the size (50ml, 200ml, 375ml, 750ml, & Liter) into D1. The next product that receives input on sheet 1 would do the same on row 2, the next into row three and they just follow down through the next empty and available row. If a product doesn't get input then it stays empty and therefore nothing gets copied over to sheet 2 for printing. This way the "stock needed" list isn't the full length of the 60-70 different products and half of them being empty anyway. Finally, once completed, an easy way to erase/clear all quantity inputs for that day on sheet 1 and completely clear sheet two except for the formula to calculate total sales at the end of the column, therefore having a clean start the next day.
I hope this is somewhat clear. I have a tendency to ramble in an effort to thoroughly explain. If there is anything I missed please let me know. I don't know if this is even possible with Numbers, or even DocToGo...or perhaps the complexity of the equations need to be done in Excel and then import the worksheet into Numbers and put the finishing touches on it that way. If I a, shooting for the stars then so be it, but I don't know without asking.
Again...for whoever may choose this challenge, this is intended to be a learning experience in addition to benefiting the family business. I'm not looking for someone to devise and post a half page of VB code for me to just C&P and me not learn a thing about how or why. Whether you want to take me step by step, or just point me to a good tutorial...whatever works. I just know my research on the Internet isn't getting me anywhere, because all they do is post a bunch of code that I can't decipher anyway. If I can just get started with a basic template or something then hopefully I could scale it as needed.
Sorry for the lengthy post but I just wanted to make it as clear as possible.