I need to insert 10 new sheets in a workbook, base on the value in Column B. I want to get it in a way that whenever the value of Column B change, it insert the new sheet and rename the Sheet Tilte same as Value in Column B. I dont want selection technique and only want to use loop as some of the values in Column B are duplicate.
Thanks for the help.
Thanks for the help.