MACRO for creating multiple sheets with templet

[harishb63]

sir i am into stock market where i need to caculate stock price to analiyse more

i have a work book which i am uploading in this thread

if you go thru my workbook you will see a "DATA" sheet in this i have a in 9 th row all stock symbol

below with prices of the stock

1) now i want a MACRO to create sheets with my templet which i have crated

2) ie with first symbol should be constant with all other symbol with there combined name as sheet name
(ie in "data" sheet the first symbol is " banknifty" which is in "C" column along with symbol "SBIN" which is in "D" column
and sheet name should be "BANKNIFTY-SBIN" open with my templet which i have created and saved as templet

3) and in new sheet which have been created by name "BANKNIFTY-SBIN"
in "A11 date to taken from "DATA"sheet date column with formula "

=DATA!A11

and contined till last row of data sheet

4) and in new sheet which have been created by name "BANKNIFTY-SBIN"
in "C11 data to taken from "DATA"sheet same symbol column below data with formula
below the "BANKNIFTY" symbol
"

=DATA!C11

and contined till last row of data sheet

5) and in new sheet which have been created by name "BANKNIFTY-SBIN"
in "E11 data to taken from "DATA"sheet same symbol column below data with formula
below the "BANKNIFTY" symbol
"

=DATA!E11

and contined till last row of data sheet

this one i am doing because data will be added every day and if i drag the formula cells it will be updated

like this with with first variable to with all other variable

BANKNIFTY SBIN
BANKNIFTY AXISBANK
BANKNIFTY ICICIBANK
BANKNIFTY HDFCBANK
BANKNIFTY ALBK
BANKNIFTY ANDHRABANK
BANKNIFTY BANKBARODA
BANKNIFTY BANKINDIA
BANKNIFTY CANBK
BANKNIFTY DENABANK
BANKNIFTY FEDERALBNK
BANKNIFTY IDBI
BANKNIFTY INDUSINDBK
BANKNIFTY IOB
BANKNIFTY KOTAKBANK
BANKNIFTY KTKBANK

any dout please reply

thank you in advance

harish