create dynamic vba script for new sheets for each row from main sheet with name

[ganu learner]

res sir I record a micro for 3 new sheets create from main sheet is below.

now I want new sheets create dynamically acording to main sheet. in which row 1:1 is header so in every sheet first row is common after that new sheet for every row according to main sheet and also with name according column A .

recorded micro is below here thanks

Sub Macro1()
Range("A1").Select
Sheets.Add After:=ActiveSheet
Sheets("NiftyBank MW").Select
Rows("1:1").Select
Selection.Copy
Sheets("Sheet1").Select
Rows("1:1").Select
ActiveSheet.Paste
Sheets("NiftyBank MW").Select
Sheets("NiftyBank MW").Name = "NiftyBank MW"
Rows("2:2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "Sheet1"
Rows("2:2").Select
ActiveSheet.Paste
Sheets.Add After:=ActiveSheet
Sheets("NiftyBank MW").Select
Sheets("NiftyBank MW").Name = "NiftyBank MW"
Rows("1:1").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet2").Select
Rows("1:1").Select
ActiveSheet.Paste
ActiveSheet.Paste
Sheets("NiftyBank MW").Select
Rows("3:3").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet2").Select
Rows("2:2").Select
ActiveSheet.Paste
Sheets.Add After:=ActiveSheet
Sheets("Sheet3").Name = "Sheet3"
Sheets("NiftyBank MW").Select
Rows("1:1").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet3").Select
Rows("1:1").Select
ActiveSheet.Paste
Sheets("NiftyBank MW").Select
Rows("4:4").Select
Application.CutCopyMode = False
Selection.Copy
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet3").Select
Rows("2:2").Select
ActiveSheet.Paste
Sheets("NiftyBank MW").Select
Range("A1").Select
End Sub

 

[Fluff]

In what way isn't it working?

 

[ganu learner]

Sir please see on attachment I send you my file after apply script made by you.
I work if I apply in module or run with F8 but not work if I paste it in VBA project folder.

 

[Fluff]

You have not supplied a file & the XL2BB table you have posted does not show how my macro "doesn't work".
You will need to explain what is not working

 

[ganu learner]

Sir please see on this file I tried to given all information about file.
all data receive form rts server.

NiftyBank MW.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Trading symbol	LTP	Bid qty	Bid rate	Ask rate	Ask qty	LTQ	Open	High	Low	Prev close	Volume traded today	Open interest	ATP	Total bid qty	Total ask qty	Exchange	LTT	LUT
2	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
3	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
4	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
5	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
6	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
7	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
8	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
9	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
10	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
11	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
12	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.	N.A.
NiftyBank MW

Cell Formulas
Range	Formula
A2	A2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "TradingSymbol")
B2	B2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Last")
C2	C2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "BidSize")
D2	D2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Bid")
E2	E2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Ask")
F2	F2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "AskSize")
G2	G2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "LTQ")
H2	H2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Open")
I2	I2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "High")
J2	J2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Low")
K2	K2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "PrevClose")
L2	L2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Volume")
M2	M2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "OpenInterest")
N2	N2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "AverageTradePrice")
O2	O2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "TotalBidQty")
P2	P2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "TotalAskQty")
Q2	Q2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Exchange")
R2	R2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "lastTradeTime")
S2	S2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "lastUpdateTime")
A3	A3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "TradingSymbol")
B3	B3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Last")
C3	C3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "BidSize")
D3	D3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Bid")
E3	E3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Ask")
F3	F3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "AskSize")
G3	G3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "LTQ")
H3	H3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Open")
I3	I3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "High")
J3	J3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Low")
K3	K3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "PrevClose")
L3	L3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Volume")
M3	M3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "OpenInterest")
N3	N3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "AverageTradePrice")
O3	O3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "TotalBidQty")
P3	P3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "TotalAskQty")
Q3	Q3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Exchange")
R3	R3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "lastTradeTime")
S3	S3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "lastUpdateTime")
A4	A4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "TradingSymbol")
B4	B4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Last")
C4	C4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "BidSize")
D4	D4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Bid")
E4	E4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Ask")
F4	F4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "AskSize")
G4	G4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "LTQ")
H4	H4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Open")
I4	I4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "High")
J4	J4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Low")
K4	K4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "PrevClose")
L4	L4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Volume")
M4	M4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "OpenInterest")
N4	N4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "AverageTradePrice")
O4	O4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "TotalBidQty")
P4	P4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "TotalAskQty")
Q4	Q4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Exchange")
R4	R4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "lastTradeTime")
S4	S4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "lastUpdateTime")
A5	A5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "TradingSymbol")
B5	B5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Last")
C5	C5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "BidSize")
D5	D5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Bid")
E5	E5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Ask")
F5	F5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "AskSize")
G5	G5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "LTQ")
H5	H5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Open")
I5	I5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "High")
J5	J5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Low")
K5	K5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "PrevClose")
L5	L5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Volume")
M5	M5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "OpenInterest")
N5	N5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "AverageTradePrice")
O5	O5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "TotalBidQty")
P5	P5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "TotalAskQty")
Q5	Q5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Exchange")
R5	R5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "lastTradeTime")
S5	S5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "lastUpdateTime")
A6	A6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "TradingSymbol")
B6	B6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Last")
C6	C6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "BidSize")
D6	D6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Bid")
E6	E6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Ask")
F6	F6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "AskSize")
G6	G6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "LTQ")
H6	H6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Open")
I6	I6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "High")
J6	J6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Low")
K6	K6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "PrevClose")
L6	L6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Volume")
M6	M6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "OpenInterest")
N6	N6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "AverageTradePrice")
O6	O6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "TotalBidQty")
P6	P6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "TotalAskQty")
Q6	Q6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Exchange")
R6	R6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "lastTradeTime")
S6	S6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "lastUpdateTime")
A7	A7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "TradingSymbol")
B7	B7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Last")
C7	C7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "BidSize")
D7	D7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Bid")
E7	E7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Ask")
F7	F7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "AskSize")
G7	G7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "LTQ")
H7	H7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Open")
I7	I7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "High")
J7	J7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Low")
K7	K7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "PrevClose")
L7	L7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Volume")
M7	M7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "OpenInterest")
N7	N7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "AverageTradePrice")
O7	O7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "TotalBidQty")
P7	P7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "TotalAskQty")
Q7	Q7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Exchange")
R7	R7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "lastTradeTime")
S7	S7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "lastUpdateTime")
A8	A8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "TradingSymbol")
B8	B8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Last")
C8	C8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "BidSize")
D8	D8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Bid")
E8	E8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Ask")
F8	F8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "AskSize")
G8	G8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "LTQ")
H8	H8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Open")
I8	I8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "High")
J8	J8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Low")
K8	K8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "PrevClose")
L8	L8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Volume")
M8	M8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "OpenInterest")
N8	N8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "AverageTradePrice")
O8	O8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "TotalBidQty")
P8	P8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "TotalAskQty")
Q8	Q8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Exchange")
R8	R8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "lastTradeTime")
S8	S8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "lastUpdateTime")
A9	A9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "TradingSymbol")
B9	B9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Last")
C9	C9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "BidSize")
D9	D9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Bid")
E9	E9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Ask")
F9	F9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "AskSize")
G9	G9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "LTQ")
H9	H9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Open")
I9	I9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "High")
J9	J9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Low")
K9	K9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "PrevClose")
L9	L9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Volume")
M9	M9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "OpenInterest")
N9	N9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "AverageTradePrice")
O9	O9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "TotalBidQty")
P9	P9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "TotalAskQty")
Q9	Q9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Exchange")
R9	R9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "lastTradeTime")
S9	S9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "lastUpdateTime")
A10	A10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "TradingSymbol")
B10	B10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Last")
C10	C10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "BidSize")
D10	D10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Bid")
E10	E10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Ask")
F10	F10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "AskSize")
G10	G10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "LTQ")
H10	H10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Open")
I10	I10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "High")
J10	J10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Low")
K10	K10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "PrevClose")
L10	L10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Volume")
M10	M10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "OpenInterest")
N10	N10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "AverageTradePrice")
O10	O10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "TotalBidQty")
P10	P10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "TotalAskQty")
Q10	Q10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Exchange")
R10	R10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "lastTradeTime")
S10	S10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "lastUpdateTime")
A11	A11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "TradingSymbol")
B11	B11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Last")
C11	C11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "BidSize")
D11	D11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Bid")
E11	E11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Ask")
F11	F11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "AskSize")
G11	G11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "LTQ")
H11	H11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Open")
I11	I11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "High")
J11	J11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Low")
K11	K11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "PrevClose")
L11	L11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Volume")
M11	M11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "OpenInterest")
N11	N11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "AverageTradePrice")
O11	O11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "TotalBidQty")
P11	P11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "TotalAskQty")
Q11	Q11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Exchange")
R11	R11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "lastTradeTime")
S11	S11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "lastUpdateTime")
A12	A12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "TradingSymbol")
B12	B12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Last")
C12	C12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "BidSize")
D12	D12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Bid")
E12	E12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Ask")
F12	F12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "AskSize")
G12	G12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "LTQ")
H12	H12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Open")
I12	I12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "High")
J12	J12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Low")
K12	K12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "PrevClose")
L12	L12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Volume")
M12	M12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "OpenInterest")
N12	N12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "AverageTradePrice")
O12	O12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "TotalBidQty")
P12	P12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "TotalAskQty")
Q12	Q12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Exchange")
R12	R12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "lastTradeTime")
S12	S12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "lastUpdateTime")

 

[Fluff]

If you are referring to the data from your function, that has nothing to do with the code I supplied.
You will need to find out why the function isn't working

 

[ganu learner]

Res Sir, I tried many times with given code by you but nothing is happened with code please look on it I again send you latest file.

Sub ganulearner()
Dim Hdr As Variant
Dim Cl As Range
With Sheets("NiftyBank MW")
Hdr = .Range("1:1").Value
For Each Cl In .Range("A2", .Range("A" & Rows.Count).End(xlUp))
Sheets.Add(, Sheets(.Index)).Name = Cl.Value
Range("1:1").Value = Hdr
Cl.EntireRow.Copy Range("A2")
Next Cl
End With
End Sub

NiftyBank MW.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	sheet name	Trading symbol	LTP	Bid qty	Bid rate	Ask rate	Ask qty	LTQ	Open	High	Low	Prev close	Volume traded today	Open interest	ATP	Total bid qty	Total ask qty	Exchange	LTT	LUT
2	sheet1	AXISBANK-EQ	568.8	11922	568.8	0	0	50	516.95	585.65	451.1	543.25	25599380	0	541.99	11922	0	NSE	03/13/20 3:59:57 PM	03/13/20 6:20:32 PM
3	sheet2	BANKBARODA-EQ	65.35	25524	65.35	0	0	1	51.05	66.35	46.5	56.65	47239305	0	60.41	25524	0	NSE	03/13/20 3:58:13 PM	03/13/20 6:20:32 PM
4	sheet3	CANBK-EQ	107.4	1877	107.4	0	0	1000	89.2	109.4	82	98.5	18446393	0	98.5	1877	0	NSE	03/13/20 3:59:42 PM	03/13/20 6:20:34 PM
5	sheet4	FEDERALBNK-EQ	68.5	6054	68.5	0	0	600	56.8	69.25	53.65	63.1	22602120	0	63.05	6054	0	NSE	03/13/20 3:55:38 PM	03/13/20 6:20:31 PM
6	sheet5	HDFCBANK-EQ	1069.8	4657	1069.8	0	0	50	980.05	1081.45	919.2	1021.3	33171603	0	1018.29	4657	0	NSE	03/13/20 3:58:42 PM	03/13/20 6:13:17 PM
7	sheet6	ICICIBANK-EQ	447.2	12309	447.2	0	0	100	401	464.75	395.2	425.65	67105024	0	433.74	12309	0	NSE	03/13/20 3:59:37 PM	03/13/20 6:20:32 PM
8	sheet7	INDUSINDBK-EQ	803.75	646	803.75	0	0	1	724	834.7	551.1	784.65	21139779	0	732.16	646	0	NSE	03/13/20 3:53:52 PM	03/13/20 6:20:32 PM
9	sheet8	KOTAKBANK-EQ	1470.05	0	0	1470.05	50	20	1400	1505	1172.05	1465.05	11408950	0	1459.39	0	50	NSE	03/13/20 3:59:30 PM	03/13/20 6:13:18 PM
10	sheet9	PNB-EQ	37.4	22137	37.4	0	0	24	31.2	38.15	28.05	33.75	46283334	0	34.49	22137	0	NSE	03/13/20 3:57:38 PM	03/13/20 6:20:34 PM
11	sheet10	SBIN-EQ	242	40175	242	0	0	100	200	248.8	184.65	212.6	155703140	0	226.86	40175	0	NSE	03/13/20 3:59:45 PM	03/13/20 6:20:31 PM
12	sheet11	YESBANK-EQ	25.55	157779	25.55	0	0	5	22.55	27.7	21.35	25.05	276663954	0	25.42	157779	0	NSE	03/13/20 3:59:59 PM	03/13/20 6:20:35 PM
NiftyBank MW

Cell Formulas
Range	Formula
B2	B2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "TradingSymbol")
C2	C2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Last")
D2	D2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "BidSize")
E2	E2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Bid")
F2	F2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Ask")
G2	G2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "AskSize")
H2	H2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "LTQ")
I2	I2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Open")
J2	J2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "High")
K2	K2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Low")
L2	L2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "PrevClose")
M2	M2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Volume")
N2	N2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "OpenInterest")
O2	O2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "AverageTradePrice")
P2	P2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "TotalBidQty")
Q2	Q2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "TotalAskQty")
R2	R2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "Exchange")
S2	S2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "lastTradeTime")
T2	T2	=RTD("pi.rtdserver", ,"NSE_AXISBANK-EQ", "lastUpdateTime")
B3	B3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "TradingSymbol")
C3	C3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Last")
D3	D3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "BidSize")
E3	E3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Bid")
F3	F3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Ask")
G3	G3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "AskSize")
H3	H3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "LTQ")
I3	I3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Open")
J3	J3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "High")
K3	K3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Low")
L3	L3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "PrevClose")
M3	M3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Volume")
N3	N3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "OpenInterest")
O3	O3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "AverageTradePrice")
P3	P3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "TotalBidQty")
Q3	Q3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "TotalAskQty")
R3	R3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "Exchange")
S3	S3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "lastTradeTime")
T3	T3	=RTD("pi.rtdserver", ,"NSE_BANKBARODA-EQ", "lastUpdateTime")
B4	B4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "TradingSymbol")
C4	C4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Last")
D4	D4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "BidSize")
E4	E4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Bid")
F4	F4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Ask")
G4	G4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "AskSize")
H4	H4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "LTQ")
I4	I4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Open")
J4	J4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "High")
K4	K4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Low")
L4	L4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "PrevClose")
M4	M4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Volume")
N4	N4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "OpenInterest")
O4	O4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "AverageTradePrice")
P4	P4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "TotalBidQty")
Q4	Q4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "TotalAskQty")
R4	R4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "Exchange")
S4	S4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "lastTradeTime")
T4	T4	=RTD("pi.rtdserver", ,"NSE_CANBK-EQ", "lastUpdateTime")
B5	B5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "TradingSymbol")
C5	C5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Last")
D5	D5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "BidSize")
E5	E5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Bid")
F5	F5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Ask")
G5	G5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "AskSize")
H5	H5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "LTQ")
I5	I5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Open")
J5	J5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "High")
K5	K5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Low")
L5	L5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "PrevClose")
M5	M5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Volume")
N5	N5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "OpenInterest")
O5	O5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "AverageTradePrice")
P5	P5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "TotalBidQty")
Q5	Q5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "TotalAskQty")
R5	R5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "Exchange")
S5	S5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "lastTradeTime")
T5	T5	=RTD("pi.rtdserver", ,"NSE_FEDERALBNK-EQ", "lastUpdateTime")
B6	B6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "TradingSymbol")
C6	C6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Last")
D6	D6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "BidSize")
E6	E6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Bid")
F6	F6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Ask")
G6	G6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "AskSize")
H6	H6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "LTQ")
I6	I6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Open")
J6	J6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "High")
K6	K6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Low")
L6	L6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "PrevClose")
M6	M6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Volume")
N6	N6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "OpenInterest")
O6	O6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "AverageTradePrice")
P6	P6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "TotalBidQty")
Q6	Q6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "TotalAskQty")
R6	R6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "Exchange")
S6	S6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "lastTradeTime")
T6	T6	=RTD("pi.rtdserver", ,"NSE_HDFCBANK-EQ", "lastUpdateTime")
B7	B7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "TradingSymbol")
C7	C7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Last")
D7	D7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "BidSize")
E7	E7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Bid")
F7	F7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Ask")
G7	G7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "AskSize")
H7	H7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "LTQ")
I7	I7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Open")
J7	J7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "High")
K7	K7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Low")
L7	L7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "PrevClose")
M7	M7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Volume")
N7	N7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "OpenInterest")
O7	O7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "AverageTradePrice")
P7	P7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "TotalBidQty")
Q7	Q7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "TotalAskQty")
R7	R7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "Exchange")
S7	S7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "lastTradeTime")
T7	T7	=RTD("pi.rtdserver", ,"NSE_ICICIBANK-EQ", "lastUpdateTime")
B8	B8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "TradingSymbol")
C8	C8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Last")
D8	D8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "BidSize")
E8	E8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Bid")
F8	F8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Ask")
G8	G8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "AskSize")
H8	H8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "LTQ")
I8	I8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Open")
J8	J8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "High")
K8	K8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Low")
L8	L8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "PrevClose")
M8	M8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Volume")
N8	N8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "OpenInterest")
O8	O8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "AverageTradePrice")
P8	P8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "TotalBidQty")
Q8	Q8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "TotalAskQty")
R8	R8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "Exchange")
S8	S8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "lastTradeTime")
T8	T8	=RTD("pi.rtdserver", ,"NSE_INDUSINDBK-EQ", "lastUpdateTime")
B9	B9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "TradingSymbol")
C9	C9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Last")
D9	D9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "BidSize")
E9	E9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Bid")
F9	F9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Ask")
G9	G9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "AskSize")
H9	H9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "LTQ")
I9	I9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Open")
J9	J9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "High")
K9	K9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Low")
L9	L9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "PrevClose")
M9	M9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Volume")
N9	N9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "OpenInterest")
O9	O9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "AverageTradePrice")
P9	P9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "TotalBidQty")
Q9	Q9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "TotalAskQty")
R9	R9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "Exchange")
S9	S9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "lastTradeTime")
T9	T9	=RTD("pi.rtdserver", ,"NSE_KOTAKBANK-EQ", "lastUpdateTime")
B10	B10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "TradingSymbol")
C10	C10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Last")
D10	D10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "BidSize")
E10	E10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Bid")
F10	F10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Ask")
G10	G10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "AskSize")
H10	H10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "LTQ")
I10	I10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Open")
J10	J10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "High")
K10	K10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Low")
L10	L10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "PrevClose")
M10	M10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Volume")
N10	N10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "OpenInterest")
O10	O10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "AverageTradePrice")
P10	P10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "TotalBidQty")
Q10	Q10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "TotalAskQty")
R10	R10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "Exchange")
S10	S10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "lastTradeTime")
T10	T10	=RTD("pi.rtdserver", ,"NSE_PNB-EQ", "lastUpdateTime")
B11	B11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "TradingSymbol")
C11	C11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Last")
D11	D11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "BidSize")
E11	E11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Bid")
F11	F11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Ask")
G11	G11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "AskSize")
H11	H11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "LTQ")
I11	I11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Open")
J11	J11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "High")
K11	K11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Low")
L11	L11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "PrevClose")
M11	M11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Volume")
N11	N11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "OpenInterest")
O11	O11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "AverageTradePrice")
P11	P11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "TotalBidQty")
Q11	Q11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "TotalAskQty")
R11	R11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "Exchange")
S11	S11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "lastTradeTime")
T11	T11	=RTD("pi.rtdserver", ,"NSE_SBIN-EQ", "lastUpdateTime")
B12	B12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "TradingSymbol")
C12	C12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Last")
D12	D12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "BidSize")
E12	E12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Bid")
F12	F12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Ask")
G12	G12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "AskSize")
H12	H12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "LTQ")
I12	I12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Open")
J12	J12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "High")
K12	K12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Low")
L12	L12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "PrevClose")
M12	M12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Volume")
N12	N12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "OpenInterest")
O12	O12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "AverageTradePrice")
P12	P12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "TotalBidQty")
Q12	Q12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "TotalAskQty")
R12	R12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "Exchange")
S12	S12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "lastTradeTime")
T12	T12	=RTD("pi.rtdserver", ,"NSE_YESBANK-EQ", "lastUpdateTime")

 

[Fluff]

Do you get any error messages?

 

[ganu learner]

Do you get any error messages?

No sir If I go with F8 then its work one by one but when i paste code in VBA Project then nothing happen.
other vba script working fine one of script I send to you which is working

Private Sub Worksheet_Calculate()
Dim capturerow As Long, currow As Long, col As String
On Error GoTo handerror

Application.EnableEvents = False
capturerow = 2
currow = Range("A65536").End(xlUp).Row
If currow < 5 Then currow = 5

Cells(currow + 1, 1) = Cells(capturerow, 1)
Cells(currow + 1, 2) = Cells(capturerow, 2)
Cells(currow + 1, 3) = Cells(capturerow, 3)
Cells(currow + 1, 4) = Cells(capturerow, 4)
If currow > 5 Then
If Cells(currow, "B") > Cells(currow + 1, "B") Then
col = "E"
ElseIf Cells(currow, "B") < Cells(currow + 1, "B") Then
col = "F"
Else
col = "G"
End If
Cells(currow, col) = Cells(currow + 1, "C") - Cells(currow, "C")
End If
Range("E4").Value = WorksheetFunction.Sum(Range("E5:E" & currow))
Range("F4").Value = WorksheetFunction.Sum(Range("F5:F" & currow))
Range("G4").Value = WorksheetFunction.Sum(Range("G5:G" & currow))
handerror:
Application.EnableEvents = True
End Sub

 

[Fluff]

The macro is not automatic, you need to run it manually.

 

[ganu learner]

Res Sir please modify for automatic.