Sir Babydum GBE
03-01-2019, 05:52 AM
Hi, long time no sea!
I would like to have Sheets 3, 4, 5, 6, 7 and 8 of a 10-sheet workbook saved as six individual workbooks (in the same location as wherever the current workbook is saved in). IE each new wb will consist of only the one sheet.
Columns B & C need to have all formulae converted to values
The Names that appear on the sheet tabs may be changed by the user, so i need vba to ignore them and use the hidden vba name for the sheets which is sheet3, sheet4 etc.
the filename for the sheet needs to be a date (yyyy/mm) a space and whatever is in cell B2 of each of the sheets.
Any help would be greatly appreciated.
thanks
Sir BD
I would like to have Sheets 3, 4, 5, 6, 7 and 8 of a 10-sheet workbook saved as six individual workbooks (in the same location as wherever the current workbook is saved in). IE each new wb will consist of only the one sheet.
Columns B & C need to have all formulae converted to values
The Names that appear on the sheet tabs may be changed by the user, so i need vba to ignore them and use the hidden vba name for the sheets which is sheet3, sheet4 etc.
the filename for the sheet needs to be a date (yyyy/mm) a space and whatever is in cell B2 of each of the sheets.
Any help would be greatly appreciated.
thanks
Sir BD