"HELP URGET" Macro to create worksheet from dropdown list on master template table

[Shehana]

Hi all ,

please i do need help Urgently

i have a "master template" sheet- table dropdown list with "sumif" formula populated via "Data" sheet data values by looking up dropdown list name in "data" sheet,

i need to create sheet by each name on dropdown list , copy template table sheet populated,looking up for that name...

I`m such new to VBA, dropdown list is 98 names and its growing .

please if any one of you could help me, so that i dont need to copy past master template 98 times and copy past same name for 98 sheets .every week twice..


Shehana