Solved

Naming Separate Tabs Based on Cell Contents

Posted on 2016-10-25
4
66 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

738 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