Macros To Save Worksheet as New xlsx file & Save Another Worksheet As A Text File

Assistance appreciated please.

I’m looking for a couple of macros to do the following on a worksheet as per the attached example, ExampleData_04.xlsx:-

Macro 1 – To save the sheet “Data Sheet” as a new xlsx file with values and formatting, and use the name taken from cell C8 on the “Reference “ sheet for the filename. The “Data Sheet” sheet will be of variable length and will include blank rows.

Macro 2 – To save the contents of column A in sheet “Config” down to the last row that is used, into a text file using the name taken from cell C6 on the “Reference” sheet for the filename. The “Config” sheet will be of variable length up to approx 3000 rows and will include blank rows.

I believe that this can be done using shell commands but this is not something that I have experience of. Any help would be greatly appreciated.

Thanks

Keith