|
|
#1
12-27-2018, 01:53 PM
|
|||
|
|||
save selected worksheets, named by cell value
 I need a macrosI 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. 
|
|
#2
12-27-2018, 01:56 PM
|
|||
|
|||
|
Ross needs help!
Last edited by rossmortimore; 12-28-2018 at 02:38 AM.
|
|
| Tags |
| macros in excel, new files, save |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Column B Cell 25 of all worksheets copies data found in the lower cells ...
|
rpcalo | Excel | 3 | 03-10-2016 03:38 AM |
|
how do i use a named cell for each worksheet
|
cwkotch | Excel | 3 | 11-03-2015 09:04 AM |
| Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
| Can't use a zero in a named cell | TechEd | Excel | 2 | 10-16-2012 10:06 PM |
| Can't save worksheets anymore | Lesq | Excel | 0 | 07-21-2010 08:43 AM |
Windows 10 
Office 2016
Linear Mode
