Hi,

Is it possible to have a set of values on one worksheet and have them come up as tab names on following worksheets. For example, on worksheet 1, I have a list of countries viz. UK, France, Germany, Spain and Italy on cells A1:A5. Once I run the macro (I guess it has to be a macro), I need it to check that there are no tabs by that name and then create a blank worksheet with a tab name for the said country (if the country tab already exists, then ignore).
In the above example, I will then end up with 6 tabs with tab names 1, UK, France, Germany, Spain, Italy.

Appreciate your help.

Rgds

Krishna