Is there a way to make a button to export a sheet to a CSV?
I have a worksheet with Sheet1, Sheet2, Sheet 3. I'm wanting to put a button on Sheet 1 that says "Export Sheet2" and a button on sheet 1 that says "Export Sheet3"
I want it to create a CSV by copy and paste values when saving the new sheet so all formula's are gone, and to give me a pop option where I'd like to save the file to. If that's not easily possible, I can have it go to C:\CSV Exports with one named "Sheet2.csv" the other "Sheet3.csv"
I'd like it to do this and leave the original excel file untouched.
Please and thank you!
Bookmarks