rename worksheet

HI All, I am running the below which splits a sheets into separate sheets depending on the column name in column A. I need the length to be not greater than 31 which I have in place. What is happening now is sometime when I take the first 31 characters of the value, it is the same as the...

I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...

Hi, I'm new to VBA and need to use it for something similar to what was posted in this thread ( https://www.mrexcel.com/forum/excel-questions/813294-vba-code-create-new-sheet-template-rename-list.html ), but with a few differences. I have a workbook that tracks the names of various assets &...

Hi all, I've inherited a workbook with the following code which renames the worksheet (tab) name as per the contents of a given cell, say cell A1. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Set Target = Range("A1") If Target = "" Then Exit Sub Application.ActiveSheet.Name =...

I created a macro to format a daily report. The file, and hence, the worksheet will always be named "ACK_#", where # is the day of the month (ex. ACK_23). I want to create a copy of the worksheet named, "ACK_#" and rename it "Summary." My problem is that I created the macro from a...

Hi, I am trying to rename multiple worksheets with the left 6 characters in cell A3. Can anyone suggest a VBA macro that would rename all worksheets in one run. Thanks in advance!

I'm working to automate as much as possible a rather simple process that starts after I download a report, never more than once a day. With a lot of learning by MUCH Googling, trial and many, many errors, I have a set of vba routines that run through about half the steps. Being ignorant and of...

Hi All, I have a workbook that I am using to track all my new clients. I have a worksheet called 'MasterData' that lists all my client names in Column B(Cell B3 and beyond) and this is formatted as a table. Column B currently has 52 entries and I keep adding to the list. I also have a...

Hello All, I have searched without success to find code I could adapt to what I want to do. I want to copy my existing worksheet (named "2014") including the command buttons and the code that goes with them, to a new worksheet (named "2015") and so on every year. And I would like this to happen...

Hi, I have a monthly workbook, which is currently being managed manually. Massive pain as you can imagine. It has the following worksheets: -Graph -Data -01-05-14....etc There is a worksheet for each day in the month. How would I go about creating a macro to rename the existing worksheets for...

Hello, This is my first post to MrExcel, so please let me know how to improve my post if it is too detailed/not detailed enough or simply not clear. Thank you in advance for your help. Contained in worksheet "SSU 1" I have built a table to pull and summarize information from a pivot table...

Hello all, I purchased VBA and Macros from the Mr Excel library and another book of macros, and have used this forum as a lurker for a couple of weeks, and while I have successfully taught myself to program a command button to work properly I'm still stuck on a few issues here and was hoping...

I have created a "Time Clock" spreadsheet that is shared with other hourly employees in my office. I have some vba code which will copy a "template" worksheet and rename it according to the employee using the workbook. It works fine until I set the workbook to be a SHARED workbook. How can I...

This is an age old question that people everywhere have tried to solve. I didn't notice it in this forum though. How do you prevent excel from crashing when you rename a worksheet if you have udfs. You'd figure by 2010 this would be solved, but it isn't.

I'm trying to figure out how to make a macro that once pressed saves a copy of the workbook in the same folder it currently exists in as it's name with "Version x" and the date on the end. For example, it could originally be called: Workbook.xlsm And once the button was clicked it would be...