How to save a copy of an excel sheet using macros?
Posts Sunday February 11, 2018Registration date
February 11, 2018
Feb 11, 2018 at 10:16 AM - Latest reply: ac3mark9309
Posts Monday June 3, 2013Registration dateModeratorStatus
May 16, 2018
- Feb 13, 2018 at 04:59 PM
I am struggling with a problem which should be easy (i think), but with my lack of knowledge of VBA i am stuck.
I have an excel file where daily data from production batches is filled in. It calculates some waste numbers etc.
I can select different products (though Vlookup's) to change some cells with text and/or values.
What i need is that with a click on a macro, a copy of sheet1 is being saved in a new file (workbook) where the filename is coming from a cell from the original file. After the succesfull save (pop up maybe?) the original file should keep its original name.