excel work
Budget: $30 – $250 USD
I have an Excel worksheet with a list of wine sales transaction lines including a wine name.
I have a second worksheet with a list of inventory items including wine name and bottle count.
37,793 transactions
996 individual inventoried items
common item between the two lists is the wine name
I need to extract the wine sales transaction lines for the wines on the inventory list up to the total bottle count on the inventory list.
This will result in a list of transactions for the inventory on the list. On the initial list there are more transactions for a particular wine than the count on the inventory list.
I have a second worksheet with a list of inventory items including wine name and bottle count.
37,793 transactions
996 individual inventoried items
common item between the two lists is the wine name
I need to extract the wine sales transaction lines for the wines on the inventory list up to the total bottle count on the inventory list.
This will result in a list of transactions for the inventory on the list. On the initial list there are more transactions for a particular wine than the count on the inventory list.