I would like to convert demand orders to batch production records. I would like to sum sheet1 Demand based on "like" item#s and then create a production record for each total. Example below:
sheet1
Item# Description Demand
Item#,Description,Demand
2064, Vitamin A ,5.3
2064, Vitamin A ,0.4
2064, Vitamin A ,0.1
2064, Vitamin A ,0.1
2064, Vitamin A ,0.1
2087, Vitamin B ,3
2088, Vitamin C ,3
2109, Vitamin D,1.5
2109, Vitamin D,1.5
2109, Vitamin D,1.5
2109, Vitamin D,1.5
2110, Vitamin E ,5.5
2110, Vitamin E ,1.5
2110, Vitamin E ,3.5
2110, Vitamin E ,0.1
2110, Vitamin E ,0.4
2530, Vitamin K ,1.6
2530, Vitamin K ,0.9
2530, Vitamin K ,0.3
2530, Vitamin K ,0.2
result sheet2
Item#,Description,Batches
2064, Vitamin A ,1
2064, Vitamin A ,1
2064, Vitamin A ,1
2064, Vitamin A ,1
2064, Vitamin A ,1
2064, Vitamin A ,1
2087, Vitamin B ,1
2087, Vitamin B ,1
2087, Vitamin B ,1
2088, Vitamin C ,1
2088, Vitamin C ,1
2088, Vitamin C ,1
2109, Vitamin D,1
2109, Vitamin D,1
2109, Vitamin D,1
2109, Vitamin D,1
2109, Vitamin D,1
2109, Vitamin D,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2110, Vitamin E ,1
2530, Vitamin K ,1
2530, Vitamin K ,1
2530, Vitamin K ,1
2530, Vitamin K ,1
Thank you,
Mark
Bookmarks