name worksheets

Good Afternoon, I'm currently having trouble with my code to name a new sheet (when created) with the value from column A, using the last row used as guidance. The userform adds the data to the list and it should copy a worksheet named "Template" and rename itself to the last info added on...

I have come to the point in my macro where I have many rows of unsorted data. Each row has a person's name. I need to create a worksheet for each person, name the worksheet their name and copy JUST their data to the sheet with their name. Data looks something like this: Date Name1 Location1...

Hi Experts, I need to create new worksheets using the names stored in an Array, however, when I run my code it creates the right amount of sheets, but the names are not been assigned to the new worksheets, so I was wondering if one of you could point my mistake, below is my code: Sub...

Hello, everyone. I am trying to check have VBA check to see if a worksheet name already exists before adding a worksheet. If it does, I want to make an Adjustment to the name and then check the new name (The adjustment adds " - 2" and then " - 3" and so on to the original name each time...