Hi,
I have an sheet that contains details about the receipts and issues from our corporate store about various inventory products based on the SKU's and the details of whom (department) , when (date) and how much of the quantity was issued. The receipts and issue of inventory in managed in 2 separate sheets.
My manager asks me for a statement of issues and receipts from the stock for a particular SKU during a period or just the last details of how many were received and whom they were issued to. How can I accomplish this either through VBA or general formulae?
Within the attached sheet, I want the recent incoming and outgoing (last 10 or 15) of any SKU as mentioned in the SKU number cell in sheet one.
https://1drv.ms/x/s!AspBcLz3_XI6itdE-jDy4n2lVpjhgg
I have an sheet that contains details about the receipts and issues from our corporate store about various inventory products based on the SKU's and the details of whom (department) , when (date) and how much of the quantity was issued. The receipts and issue of inventory in managed in 2 separate sheets.
My manager asks me for a statement of issues and receipts from the stock for a particular SKU during a period or just the last details of how many were received and whom they were issued to. How can I accomplish this either through VBA or general formulae?
Within the attached sheet, I want the recent incoming and outgoing (last 10 or 15) of any SKU as mentioned in the SKU number cell in sheet one.
https://1drv.ms/x/s!AspBcLz3_XI6itdE-jDy4n2lVpjhgg