VBA on existing Inventory to show goods sold by period week, month, quarter and also by saleman
Budget: $10 – $30 USD
I have an existing Inventory sheet of eyeglasses (Rayban, Oakley, Gucci. etc... ) of about 1500 rows which contains about 30 columns (color, size, shape, manufacturers, bought date, etc). I need to make a dashboard that updates daily to show what has been sold today, last week, last month, and last three month, and what remains in stock in the inventory.
I need to have the SOLD dashboard printable, meaning fit on one landscape page.
On a separate dashboard, I need to have a list of what's remaining on the shelf ( IN STOCK Eyeglasses), also printable so that someone can print it, take it to the shelves, and do actual inventory counting against what's on the list.
I need to have the printed IN-STOCK sheet to be a list for someone to print out and do physical inventory - The list of names of frames are dynamic, changing all the time, for example this year we could have Rayban eyeglasses as an item, next year we could drop Rayban and add Nike eyeglasses for example.
The Status of the eyeglasses ( INSTOCK or SOLD), date sold, and saleman name are already being updated automatically via another functioning macro
I need to have the SOLD dashboard printable, meaning fit on one landscape page.
On a separate dashboard, I need to have a list of what's remaining on the shelf ( IN STOCK Eyeglasses), also printable so that someone can print it, take it to the shelves, and do actual inventory counting against what's on the list.
I need to have the printed IN-STOCK sheet to be a list for someone to print out and do physical inventory - The list of names of frames are dynamic, changing all the time, for example this year we could have Rayban eyeglasses as an item, next year we could drop Rayban and add Nike eyeglasses for example.
The Status of the eyeglasses ( INSTOCK or SOLD), date sold, and saleman name are already being updated automatically via another functioning macro