Good Day Everyone
I have a workbook with a "Master" sheet and a "Data" Sheet, what i need is a macro that will create new sheets copied from the master sheet(duplicated) based on the values in column E2:E of the "Data" sheet and each new sheet named for said values.
i.e. if "Data" sheet column E2 is abc123, then a new sheet identical to the "Master" sheet named abc123 needs to be created and if E3 in data sheet is 123abc, then a new sheet identical to the "Master" sheet named 123abc needs to be created etc.
then the values in the newly created sheet needs to match the rest of the row where the name of the sheet was derived from.
i.e. sheet abc123 range C6 value must be equal to "DATA"A2
sheet abc123 range C7 value must be equal to "DATA"C2
sheet abc123 range C8 value must be equal to "DATA"B2
sheet abc123 range C6 value must be equal to "DATA"A2
.....and
sheet 123abc range C6 value must be equal to "DATA"A3
sheet 123abc range C7 value must be equal to "DATA"C3
sheet 123abc range C8 value must be equal to "DATA"B3
sheet 123abc range C6 value must be equal to "DATA"A3
The rest of the data pre entered into the "Master" sheet must also be duplicated to all new sheets.
i.e. if i put "test a 1 " into range A18 of the master sheet, then all the new sheets must have the same in A18.
Any help here will be greatly appreciated.
Thanks in advance.
see attached my sample workbook.....
Bookmarks