I would like to use a book similar to the one attached to track daily sales of individual products. As seen in the attachment I would copy and past a daily update that is emailed to me every workday to the tab named load daily here. From this I would like to have the other two sheets auto update.
For tab 1 (Inventory List) I would like to add any new data including new items. I know some of the fields would still be blank but they would be filled manually. I would also like the Quantity in Stock column to move to Previous Day Onhand column. Finally on the tab marked Daily Sales I would like to see auto population of rows that changed by date. I would like to keep this data to complete a running total so new data would have to load in the next empty row. I would like negatives that are caused by inventory receipt to equal 0 so it doesn't subtract from sales but when the next day loads I would like to continue tracking sales.
The list of items I am working with is about 500 items so I don't want to auto populate every item everyday.
I am running Excel 2016 now
I hope I have enough detail here and hope the attachment is on this post
Thank you in advance for any help.
Bookmarks