Excel exporting of worksheets in workbooks

[Chaza]

Hi there

I have to work on exporting multiple excel worksheets into multiple workbooks, I don't think it is possible but I am also not too familiar with macros and how they work- I am still learning

Wondering if this is possible and if somebody could advise me on how and where to start looking to get me started

I have tried googling it but to no avail

Thanks

 

[Chaza]

ok I'll try explaining again...hopefully this makes sense
forget about everything else mentioned before

I have an excel sheet it groups data by hotel names so each worksheet has a new record for example worksheet 1 hotel capricon, worksheet 2 rydges etc

The data comes from column "B". Column B is where hotel names are displayed in the worksheet

I don't want the worksheet labelled as worksheet 1 worksheet 2 instead I want it to be labelled as the column B data i.e Hotel Capricon, Hotel Rydges etc

Hope this clarifies things

 

[Chaza]

Found it but if anyone finds a way I can use all contents from Column B instead of just B3 please paste it here

Sub RenameTabs()

' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If cell A1 has no content, then that tab is not renamed.
For i = 1 To ActiveWorkbook.Worksheets.Count
If Worksheets(i).Range("B3").Value <> "" Then
Sheets(i).Name = Worksheets(i).Range("B3").Value
End If
Next
End Sub