Thread: save selected worksheets, named by cell value
View Single Post
 
Old 12-27-2018, 01:53 PM
rossmortimore rossmortimore is offline Windows 10 Office 2016
Novice
  
Join Date: Dec 2018
Location: Brisbane Australia
Posts: 2
rossmortimore is on a distinguished road
Post save selected worksheets, named by cell value
I need a macros
I have a workbook with many worksheets and need to select 3 of these worksheets and save to a new workbook to be placed in a different location. I need to be able to name the new workbook to a name in a cell of another worksheet within the original workbook.
Call my worksheets "Apple", "Orange", "Pear" & "Banana"
I want to save "Apple", "Orange", "Pear" to a new workbook with a filename from a Cell A3 in "Banana".
the new file needs to to be saved in a different location for example \\\G:\ROSS\
My original is .xlsm and my new will be .xlsx

Regards
Ross
Australia
Last edited by rossmortimore; 12-28-2018 at 02:41 AM.
Reply With Quote