Solved

Naming Separate Tabs Based on Cell Contents

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

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 22

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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