Macros To name Worksheets

Originally Posted by davesexcel

The first column meaning A1?
Or do you want to loop through column A and create new sheets based on the the names in column A?

I would like to loop through column A because while column A has only one name in it Column A's length is dependent on the number of rows in column B, so your second option sounds alot like what I am trying to do, is it possible

Originally Posted by davesexcel

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

sample.xlsx

see attchaed

Originally Posted by davesexcel

You don't have anything in column A

Hi there, I was for my example purposes to answer your question but yes my actual column is B

Sorry meant "A" not I

Originally Posted by Mordred

Hi cheil, I'm curious, in your first post you wanted to rename the sheets according to student names. In the workbook that you uploaded, you have sheets with hotel bookings and not student names, or anything to do with them.

Hi Mordred
My first post was a scenario, after Dave asked for an illustration, it made more sense to just upload what i was working on rather going and recreating something, I just changed the values in some fields so that you don't see actual data
I didn't mean to confuse everyone
I really just want to know how to get the data provided in column B as the name of the worksheet and eventually name of the new workbook after running my macros.
Would you guys be able to help me?

Originally Posted by davesexcel

Do you mean to rename a sheet in column B or rename a sheet in a specific cell in Column B?

my column b is how the data is grouped by hotel name, I want the data displayed in column be to be reflected as the name of the worksheet. for example worksheet 1 has has column b with hotel name as capricorn then worksheet 1 to be renamed to capricorn

I tried to put this as a macro but it didn't work, should this go inside one of my already existing macros?
I have two macros one for auto cells adjustment and then other for the exporting of the worksheets into individual workbooks