I have an excel workbook consisting of 2 sheets.
Sheet 1 = Entry
Sheet 2 = Compiled
What I'd like to have happen is to have a macro to save a copy of the Compiled sheet as a text file with a filename identified in Sheet1 cell C2.
The end result being a text copy of the Compiled sheet saved with a button click so I can continue working on the Entry form to create yet another. I've tried several variants on this theme on here and google found, but I lack the ability to modify it enough to meet my need so am hoping for help.