I have a Spreadsheet that represents a "Survey" that is part of a bigger WB. I'm looking for a simple Macro that will take the specific (Hidden) Worksheet representing the Survey, and output it with "no formulas" as an XLS WB/WS with a predetermined name identified withinn the Macro. In other words, upon triggering the Macro in the bigger WB, another Excel WB is created and a particular Worksheet, within the bigger WB, is copied and pasted to the new Workbook as Data only (no formulas). I'm happy to make it a range name if that is easier. The predetermined name of the WB and WS (separate names) should be in the Macro so that it can be easily modified. Finally, no other tabs should exist in the new WB.
Thank you in advance,