Many thanks JOHN H. DAVIS... your code worked a treat.... and I've customised it to my activity.
Just 1 more additional cry for help, how do I amend the code to first check if the sheet with the same name exists and if so skip the addition and move to the next. This is my code which is copying and renaming a master template:
Oh. I could also do with code to reverse this and batch search and delete sheets. I know I ask for too much but I'm a newbie to vba it may take me 3 hours to work out how to doe it when experts take 3-5 so your help is greatly appreciated.
Thanks in Advance..
Bookmarks