Hello Madi,
See if the following does the task for you:-
In a standard module, place this code:-
In the "Volume per shipment" sheet module, place this code:-
This will allow you to select a week value from a drop down list in C3 of the "Volume per shipment" sheet and the required values will instantly be transferred over from the "Forecast" sheet.
There are a few notes for you in the "Volume per shipment" sheet as well.
I hope that this helps.
Cheerio,
vcoolio.
I've attached your sample workbook with codes implemented.
Bookmarks