Hello everyone,

I'm using the code below to cut data from one sheet to another once the value in ("AM9:AM62") is equal to "Completed". Most of the values I'm cutting over are time values. I'm then adding up the total time of all the values. This workbook is to calculate total lead time per order. The formula for the total sum of time values is in ("AG2:AG10000").

Can I add to the code that after the values are pasted the user is prompted to ask "Did this order run on a Saturday?" is yes then they are asked "How many Shifts?" (only 1, 2, or 3 can be entered). We work 8 hour shifts so if the user selects "2" it will add 16 hours to the AG range for the total lead time.

Any help is much appreciated.

Thank you,

Please Login or Register  to view this content.
Thank you,

Justin