rename

i have this odd issue original CSV files have data in various columns ... if i rename the csv files to xls manually FIRST then open the file, i am able to delimit according to semi colon because apparently that manual rename moved all the data in column A however, if i rename the csv...

[/IMG]Hi Is this possible... I have a group of signatures on a worksheet (images) I would like to select an image and rename it to the name stored in a combobox by pressing a command button. Is there a way of changing the selected image? activeimage? Thanks Mark

HI How can i create and rename excel sheet in same workbook as per previous name +1 for example when we click on + sign excel add "Sheet2", "Sheet3" and so on but what about sheet name is "abc1". Now i press + then excel should create sheet "abc2","abc3" through vba heaps thanks in advance thanks

Hi There, I need to create excel tab after every 2 minutes as per sheet1 in workbook and rename them as per SR.no provided in sheet1 like below. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> SR.NO 1 2 3 4 5 6 7 8...

Hi, I'm very new to VBA. I have a problem figuring out how to do a macro. I want to rename sheets in my workbook based on values from specific cells on the first page (the front page). Is there someone who can maybe give me some advice. For example I want to put in values in G3, G4, G5, that...

I have a work book that has remained unchanged in excel 2013 for years. I have moved to Office 365 and now every time the book opens I get an error and the excel book is repaired. I then have to save as. Rename the file back to the original name and then reopen it without the error. However...

This is likley very simple for someone but not me...I have looked through several posts and cannot find what I am seeking. I have a workbook with a Sheet named "Master" that I use for a biweekly timesheet. I currently copy this sheet to the end and rename it manually. I want to automate...

Hi, Is it possible to rename the active sheet shapes with cell values, there will only ever be 15 shapes in column C and 15 cell values to use as a name in Column B cells B2,13,24,35,46,57,68,79,90,101,112,123,134,145,156 - Each cell has a different name and will always be a number. Both...

Hi everyone, i've had luck getting VBA to rename a file based on the current date. However, every Monday I work on a file that's dated from Last Sunday to Last Saturday. When I rename this file I name it "POS 20190120-20190126" YY-MM-DD Can anyone help me have VBA automatically name/save the...

Hi everyone! I have a workbook that I have placed a password protection on. When I unprotect the workbook, I can edit all of the contents but it will not let me rename the tab or add a new sheet. How can I fix this?

Hello everyone, I have a bunch of worksheets as from sheet2 to sheet35. I need to rename them based on a list in sheet1 named "List" starting from cell A2. I've already found this, but it doens't work: Sub rename() Dim lr As Long lr = Sheets("List").Cells(Rows.Count, 1).End(xlUp).Row...

Hello, I have a pivot table with Row Labels and Count of Item number. Double clicking the Count of Item opens a new tab for that data. Is there a way to rename that new tab the value in the corresponding Row Label in the pivot table? Thank you! Also, I've found both of these, but I do not...

I tried to google this answer, but I cannot find it. Whenever I rename the column that does the "Show Value As" calculation it also renames the original column. They seem to be connected. Is there a workaround this? Can I make that column independent when it comes to the header? For...

Hi all, I'm after a way to automatically rename a worksheet based on a date entered in cell D2. The date has slashes (/) so I'm aware these can't be used in the name of the worksheet. I assume they can be changed in the code. It would be ideal if a date of 28/10/18 in cell D2 became...

I currently have a macro that creates and formats a sheet called "Noon" I'd like a macro that can create a new sheet each time (and I will add my formatting code to it) the cmdbutton is pushed and will rename each sheet +1 to the last, i.e. Noon2, Noon3, Noon4, etc. Thanks!

Afternoon All, I know this can be done but no idea how.... I have a worksheet and the tab name need to take the information entered into cells A1, A2, A3 & A4 and rename accordingly. eg. A1 = 1025 A2 = ZUT A3 = 001 A4 = A I'd like the tab to take these values and display them as...

Hello people, I am trying to duplicate sheet every time a user click on a button and it will be rename into a sequence. For example i have sheets ABC, DEF, GHI and the master to duplicate from is 99. Hence the sheet count is 4. When it is being copied from 99, i want the duplicated sheet to...

This macro works for the most part, but what happens is it doesn’t completely rename the entire sheet. If the sheet name is “Sheet1” and you run the macro, it renames it to “Sheet71 1” What am I missing here to get it to just rename the Sheet1 to Sheet71 without leaving the 1 after the rename...

Good Evening All or Good Day depending on your time zone... I have a workbook that I am setting up as a Template, I have 3 Template Sheets in the Workbook. They all have 1 Table located on them. I have a basic VBA Code to Copy the Template, Rename the Template but I cannot get or find a way to...

Hi all, Looking to rename multiple sheets based on a list located in worksheet 'codes' from the range B3:B35... I hope someone can help! Many thanks in advance