Hi

Please could you help me with the following.
I would like to rename each tab with the list of names in sheet 1.
For Example, In sheet 1, I have the following list, Trade 1, Trade 2...Trade 5 ranging from cell A1:A5.
I would like to have each tab after Sheet 1 to be renamed as per the list in sheet 1.
The number of trades may vary from time to time, for instance 5, 10, 15 trades and would like the coding to cater for this.

Is this a possibility in VBA coding?

Thank you for reading my thread.

2Quick2Fast