Hi All,
Quick question. Is there a way to return week number in column D based on my orders (column A). For example, if i have 1000 orders listed in column A1:C1000 (variable range). Where column A is the description of the order, Column B is hours taken and Column C is the department.
I want to sum these orders. If the sum of first few orders equal to 160 hours (broken down by department i.e. 140 hours for production and 20 hours for R&D) then return current week. Move to next orders listed and assign next week number. keep looping it till the end of the sheet.
I am doing this to forecast my projected delivery week on receipt of orders and when the next order can be made.
Either vba or excel formula can work. Thank you for your time inadvance.
Kind Regards,
week#.xlsx
Bookmarks