Hey guys!
Currently making sort of a scheduling program on Excel.
I need to make a scheduling calendar that keeps note of the delivery shipments. I first used VBA to make a data entry form which lists all the data on another sheet.
My problem is matching the data from this sheet onto the calendar. If the product name matches and shipping date matches, the quantity ordered should appear. Also, I have to make sure that when someone inputs another set of data for the same item and shipping date, the quantity shown on the calendar should be their sum.
Photo for reference: Imgur: The most awesome images on the Internet
Any tips?
Currently making sort of a scheduling program on Excel.
I need to make a scheduling calendar that keeps note of the delivery shipments. I first used VBA to make a data entry form which lists all the data on another sheet.
My problem is matching the data from this sheet onto the calendar. If the product name matches and shipping date matches, the quantity ordered should appear. Also, I have to make sure that when someone inputs another set of data for the same item and shipping date, the quantity shown on the calendar should be their sum.
Photo for reference: Imgur: The most awesome images on the Internet
Any tips?