This is my first time posting on here, and I'm very new to Excel VBA code, so I would appreciate some help. I have an Excel workbook with 7 sheets. The 1st one is a reference sheet titled Allocation, where I type in names of accounts into cells A3:A5. For the purpose of this...
I write next code to copy active sheet, is working but:
- i need to: - switch it in ActiveSh, new created copy;
- counting cell A14 start from 1. to 999. on each copy;
- counting cell D16 start from 001 to 999 on each copy;
- counting of sheet is not...
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 know how to rename a sheet when I already know what the sheet name is going to be. For example I geta weekly file from an external source and I rename it as follows.
'Rename sheet in Study Summary
Workbooks.Open Filename:= _
"G:\Database\Database files\Study Summary.xlsx"...
I am new to vba. Trying to write code to generate copies from a template worksheet and name the copies from a range in primary worksheet. The ws tabs should be in a date format. So far I was able to generate the copies from the template and it makes the amount of copies in the range, but instead...
I want to rename my worksheet with today's date preceded by the letters LB (space).
I've been tinkering with the syntax of this statement for a while and I can't get it to work.
ActiveSheet.Name = "=""LB ""&TEXT(TODAY(),""YYYY-MM-DD"")"
If I place the above formula in a cell...
Below code gives me out of memory error.
ActiveSheet.Name = "ABC"
I have added below lines to my code in order to free memory
Application.DisplayAlerts = False
Application.CutCopyMode = False
I have a workbook full of order sheets, I am attempting to figure out a code that will automatically generate the name of sheet based on one cells' value (ex. W9). However; if they cell should be empty, I would like it to keep the name as Sheet1 or Sheet2, etc. Attempted to find sources...
I am trying to create a macro that will rename all tabs that have been named with a date mm-dd-yyyy. I would like a dialog box to pop up and ask for a starting date and then have the macro find the tab names with the lowest date and then rename them to the next years dates
For example current...
Hi! I am am looking for some much needed help but please bear with me as I am a complete novice and only joined Mrexcel today!
Using windows 7 with Excel 2013 but would like this to run on previous versions also.
The following is what I would ideally like:
I have a workbook with 2 worksheets...
Gaaah! Working on a macro to copy in a sheet from a daily report, into my "processing" workbook. The daily report worksheet to-be-copied will always be called "orange", so I figured when I copy it, I'll rename it "orange" + the number of sheets in the workbook (orange5 when sheets.count=5...
I have a workbook with a over 100 sheets and at the end I have a template where I have a macro that copies the template and does some work with pivot tables and it is working well. What I would like have happen is for the new sheet (Template(2)) to be named in mmddyy form one business day after...
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...
In this code, if the cell value is having some special characters like "/" etc, it showing error.
I need to exclude that error and remove the special character in the particular cell and rename as it is.
Example : B1 cell is having " ABC/ DCF"
While renaming the sheet, it should come as " ABC...
I am a VBA greenhorn and need assistance in renaming (11) select worksheets in an excel workbook that containd based upon a cell value in each sheet.
This forum does have several posts relating to this same problem; however, no posts address naming specific sheets as well as where...
I'm trying to feed information from a MSProject file to an excel workbook. I want that for every uncompleted task that is a non-summary task, that I duplicate a sheet in the excel workbook and rename it to the Text1 field value of the task.
The template sheet is the 2nd sheet and is named...
The code posted by texaslynn in the link below works perfectly for the beginning of what I'm trying to do. However, I already have a tab with a name that matches one of the data names in the column that is being broken out. When the macro runs, the already created tab is overwritten with...
I'm learning VBA slowly but this has me stumped!
I have a worksheet which I need to filter by Column E for every criteria listed and copy the results to a new sheet - named after the value in Column E. Then delete the data from the original sheet.
I attempted this:
I have the below code,renaming each tab as A2 & "Transactions" but on sheet 2 it is still trying to use cell A2 from the sheet 1, I need to pick up A2 from each sheet while active, any suggestions please?
Also do you know how I can start from just the second sheet please?
I've tried to figure this out on my own and I keep getting the same error.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I'm trying to copy a template sheet I've made and rename it to a date that is displayed in the new sheet. I keep getting...