Hi,
its my first post

I am transfering sheets to new workbook .Each sheet name has one identifier say Manufactures. I have 3 Workbook each having 50 sheets that have various manufactures.For example, sales,units,visits workbook each having 50 sheets for manufactures.I want to create Workbook for each manufacture having sales,units,visits for that manufacture only and have same name as manufacture
Problem :
Manufacture name contains ":" and file name cant have colon. and also file name cant be NUll
my loop stop if null is there and :
i am removing colon using right function
how to deal with Null values.