Hi there
I'm on the last bit (finally) with this project.
I now need to:
Save as new workbook
Name should be: [Country]_Move_Template_[todaysdate]
Country would equal a named reference on Worksheets("Instructions").Range("Table13[Country]").Value
the user would need to choose the folder and file path of where they want to save it to
but here's the tricky bit..
I need to save without formulas (copy paste special value?) across all sheets except to keep formulas in:
Sheet: COD Mapping
Ranges D3:BA4 & D20:BA21
Sheet: CC Reconfiguration Data
Ranges G3:variable down length but this is a table so should copy down in column right?
and I don't want to keep the 'Instructions' sheet tab?
I also have some datalists in some sheets, would these copy over with the named ranges (lkup sheet containing the drop down lists will be moved over).
Then I want it to have a message question to say: Do you want to notify the team? If yes, it will open up an email with addresses and a standard message but they will have to press send
Is this possible or should I have the last piece in my main macro?
many thanks for any advice!
Melimob
I'm on the last bit (finally) with this project.
I now need to:
Save as new workbook
Name should be: [Country]_Move_Template_[todaysdate]
Country would equal a named reference on Worksheets("Instructions").Range("Table13[Country]").Value
the user would need to choose the folder and file path of where they want to save it to
but here's the tricky bit..
I need to save without formulas (copy paste special value?) across all sheets except to keep formulas in:
Sheet: COD Mapping
Ranges D3:BA4 & D20:BA21
Sheet: CC Reconfiguration Data
Ranges G3:variable down length but this is a table so should copy down in column right?
and I don't want to keep the 'Instructions' sheet tab?
I also have some datalists in some sheets, would these copy over with the named ranges (lkup sheet containing the drop down lists will be moved over).
Then I want it to have a message question to say: Do you want to notify the team? If yes, it will open up an email with addresses and a standard message but they will have to press send
Is this possible or should I have the last piece in my main macro?
many thanks for any advice!
Melimob
Last edited:
