I am looking for a Macro or Code that will change the worksheet name(42 tabs) to match what is Cell (B1). Please see following conditions:
1. I want to add the word "Route" to the sheets name and than the Data that is in Cell (B1).
2. If Cell B1 has a Zero(0) than I dont want to have the worksheet change the name.
3. I dont want this done to every worksheet in my workbook. There are 4 worksheets that I dont want this done on.
Joe
Last edited by Jvollmer33; 09-10-2013 at 11:25 AM.
Maybe:
Please Login or Register to view this content.
Forgot to mention:
3. I dont want this done to every worksheet in my workbook. There are 4 worksheets that I dont want this done on.
What are the names of the 4 worksheets?
1. DOIS data Instructions
2. Data
3. 3999 Data
4. Volume Sheet
Maybe:
Please Login or Register to view this content.
Thank you very much this works great. I do have another question concerning this workbook.
How can i create a Macro that will print worksheets if Cell (B1) is greater than zero for all sheets except.
1. DOIS data Instructions
2. Data
3. 3999 Data
4. Volume Sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks