rename

Hi, It’s time I cleaned up some of my Macro names from when I first started to record them. Example. You see a suggested macro name of say Macro12 so I just kept it. I assigned the Macro to a button and works well. Some time down the road I now want to clean up / rename these odd Macros...

Need some help writing a macro that will do the following; 1. Prompt for cell selection 2. Copy a hidden "template" worksheet to the end of the sheets 3. Rename that worksheet based on the cell selection from step 1 4. Hyperlink the cell selection to the newly copied worksheet Update- I did...

I know that I'm missing something simple and am hoping that someone can point out what I'm missing :smile: Here goes: I have an 8 tab spreadsheet (Excel 2013) Formulas in Sheet1 151:A157 update with DAY()+1 based on the date entered into Sheet1 A1. So with 9/8/18 entered into A1, A151=9...

I am work events where photographers are sorting their pictures into folders based on the Routine number while at the event. But each routine also has a unique ID number that is never repeated that is actually used internally back at the office. So I was wondering if I had an excel sheet that...

I have a series of hyperlinks that I want to rename on a hidden sheet. I have renamed these by using the edit hyperlink function. My problem is that I have a formula on a separate sheet that does a Hlookup on the sheet with the hyperlinks in to bring back the correct link. Before I rename the...

Hi folks, I am trying to create a macro to enable me to rename the tabs in a worksheet based on a cell in a different worksheet in the same workbook. The macro button will be located on the same sheet as C4. I have a tab called Revised which has a year in cell C4. I have 12 sheets Jan2018...

Hi Guys I am trying to rename cell G1 to collateral and cell I1 to documentation . Each time i rename the mentioned cells the desire names does not appear in the respective cells. Please find link https://www.dropbox.com/s/rruy1b719wxjqpe/testing1.xlsx?dl=0. Your help will be...

How can we rename sheet1 to sheet 31 as date of every month? if we need this next october month fully from 1st date to 31st Oct 2018. How can we do? Can it possible if we put only Month/Year as OCT/2018 THEN IT SHOULD AUTO RENAME ON EVERY SHEETS NAME FROM 01-OCT-2018 TO 31-OCT-2018 OR...

Hi Ideally I need something that will rename any cells in the top row into a format conducive for named ranges.. Eg - "Your title here" would become Your_title_here I then want the contents of the each column to be a named range. Column A is titled "Member Name" and has names from A2:A422 -...

I have code that pulls one particular sheet from all workbooks in a directory. Once all the sheets are in, I have them renaming based on the value of a cell. Unfortunately, my preferred name for the sheet does not exist anywhere on the sheet except as a string inside a cell reference. (for...

Hello all can I have some help please on this with some VBA code i want to rename multiple tabs based on the cell value in each tab cell values are D8, G15 result would be D8 - G15 is this possible please

Simply put I have a device that saves tables in a standard csv format.....but it names them as a .etf Wondering if there is a way to allow add a custom extension name to excel.... and tell it to to treat it as a csv...... and when I save it, to retain the .etf name(and not name it .csv) so I...

Hi everyone, Can someone show me the code to rename the files in a folder? Renaming is simply adding a fixed text string "IMG_" to the existing filename. It should replace the existing file (in the same folder). Thanks

Hi everyone, hopefully I can explain the complexity of my problem and hope you can give me some advices. I want to combine the code, I wrote for two different types of data and adopt a similar logic for both, to reduce my number of modules. However, I am struggling in renaming the headers of the...

Hi, I have a folder located at 'C:\Users\Steve\Desktop\2018 Data' and it has lots of subfolders and sub-sub folders. Throughout all the folders there are lots of .pptx files that I want to rename. The target files have a mixture of names but they all end in 'v1.0(A3)', eg. 'London v1.0(A3)'...

I have a macro that will save a file directly from Outlook into a directory based on an Outlook Rule. (Currently it is saving in my Documents Folder) What I want to be able to do, is chain that into another Macro that Renames that file. The main issue I have is that I won't know the name of the...

I know I can add code to rename a tab Me.Name = "Summary" But what I want to do is rename Sheet3. I am asking specifically just to rename sheet3 so if the user copies the tab, the code that renames doesn't happen on the new/copied tab. I tried (obviously without success) Sheet3.Name = "Summary"

I have a list of inventory forms that I keep up with every month. I've been trying to automate a lot of what I do and am close to finishing my macro excel document. The format of all the workbook names is *FirstInitialLastname_Inventory_Year.xls. I have my workbook pull the sheets from these...

Hello, I'm looking for some help! I have several rows of data with the following sample information: <tbody> A B C 1 Item Decription Units Prop. Line 2 Removing Asphaltic Surface SY 0004 3 Removing Guardrail LF 0014 </tbody> I also have a "Templates" folder with template excel files...

Hi, I've got a macro that will take data from a worksheet, generate a Pivot Table and then create a Pivot Chart. This works fine (and thanks for the help in the past!) Currently the Pivot Chart ends up with a generic name. I would like to rename the Pivot Chart with the name of the company...