Need help please

[treetopflyn]

I am trying to find a way to populate the Tab labels with Data entered into the first sheet in a workbook. Is this possible?

Thanks
K

 

[MrKowz]

Welcome to the forums!

Are you needing to rename existing worksheets based off of a list in your first worksheet, or are you needing to create worksheets and name them based on that list?

 

[treetopflyn]

I have a worksheet that has a table on the first sheet where I insert data. When the data is input it populates the sheets rest of the sheets with the data entered. I would like for the data to also populate the Tabs. The reason is, once I have the sheets populated I have to break out each sheet separately. If the tabs were already labeled it would speed up the process.

 

[MrKowz]

I'm not sure I understand. Can you please give me a direct example of your input and desired output?

 

[treetopflyn]

Company name is input into Cells 2a 2b 2c 2d 2e 2f then info then populates into sheets 2 in the corresponding cell. The same is done for each company
(3a 3b 3c 3d 3e 3f, 4a 4b 4c 4d 4e 4f etc)

I would also like to have some of the data populated in the the sheet tab.