We have an Excel sheet with some formula and macros. We want to save the data as an another Excel sheet without formula and macros before we run macros on the current sheet.
It should just save the values. One way is copy the entire data and paste them as values in another Excel sheet and save it. But is there any other simple way to do this?