Solved

Naming Separate Tabs Based on Cell Contents

Posted on 2016-10-25
4
38 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
  • 2
  • 2
4 Comments
 
LVL 21

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 21

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

OfficeMate Freezes on login or does not load after login credentials are input.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now