rename sheet

Hi 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...

Hi, 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: Sub Chopper() ' '...

Hi guys, 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? Thanks...

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> <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...

Is it possible to create a macro to rename and save a file based on a cells content? For example, if the name in cell C2 is "John Doe" and D3 has the word "April", I want to rename the current file to John Doe and the current worksheet to April. Can you do this? Thanks in advance, Paul

Hi I would like to know the code to rename default sheet name (Sheet1, Sheet2, Sheet3, ect..) to Invoice1, Invoice2, Invoice3, up to Invoice50. Thanks & Happy New Year!

I'm creating a workbook for colleagues that are not Excel savvy and I'm trying to work within my comfort level (without Macros). I'm trying to copy data from an Input sheet to other sheets. One of the things I would like is to be able to rename 8 of the next 16 sheets by typing a new name in a...