Solved

Naming Separate Tabs Based on Cell Contents

Posted on 2016-10-25
4
73 Views
Last Modified: 2016-10-31
I have a file that has been compiled to make a report. Each tab is different. Some tabs have data in cell L9 that can possibly be used but there are a couple of other tabs that I am scratching my head as to what I can use to name. Can anyone help me out here? I have the compiled report and I have the template (end result) file as well. I am attempting to use an excel macro. I sincerely appreciate the help here.

OS: Windows 7 64 Bit
Excel 2013

Please let me know if I need to explain any further. Thanks.
Working-File.xlsx
Template-File.xlsx
0
Comment
Question by:Christopher Wright
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
yo_bee earned 500 total points
ID: 41859619
Here are a couple of ways.  One of them is from  Microsoft's KB.  Note when saving you need to save it as an XLSM file type to retain the macro.  The second link is dynamic in relations to a certain cell.

This macro is not dynamic, and needs to run to apply.
https://support.microsoft.com/en-us/kb/2790229


This one is active when you open the XLSM file.
http://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html
0
 

Author Comment

by:Christopher Wright
ID: 41860473
These do not need to be saved with Macros but as a regular workbook.
0
 
LVL 23

Expert Comment

by:yo_bee
ID: 41860776
If that is the case then you will not have any way to do what you are trying to achieve without a vba or macro backend embedded.  The only way to have a macro embedded is to save it as an XLSM file.
0
 

Author Closing Comment

by:Christopher Wright
ID: 41866934
Thank you for the guided support. I used your suggestions and completed this.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question