Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 12-27-2018, 01:56 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
Default

Ross needs help!

Last edited by rossmortimore; 12-28-2018 at 02:38 AM.
Reply With Quote
Reply

Tags
macros in excel, new files, save

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:25 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft