How do you run macro automatically each time workbook is saved?
I have a macro that copies some data to another worksheet in the workbook.
It copies the data as values only. (Some of the date in the first worksheet
is result of formulas and I just want the data to be copied) Anyway, how can
I run the macro each time the workbook is saved so that the second worksheet
always has update data in it? Any ideas?
|