I have a question about saving Excel changes
I have a macro that when activated by an operator copies data from worksheet A to worksheet D
How can I automatically save the copied data in Worksheet D in case the operator hits the x o
closes workbook without saving changes

thank