Appendix Thread. ( Codes for other Threads, ( Avinash ).)

[DocAElstein]

Notes in support of this Thread
https://excelfox.com/forum/showthrea...between-sheets

We are using the code line like
Index(Cells, Rws(), Clms)

This requires the array of required row numbers from the original worksheet, held in Rws()

These show the Row numbers concerned

Original range. ( First Worksheet Before )
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Rows in Original	Original	A	B	C	D	E	F	G	H	I	J	K
R1	1	Exchange	Symbol	Series/Expiry	Open	High	Low	Prev Close	LTP
R2	2	NSE	ACC	EQ	1265	1265	1246.5	1275.3	1247	22	BUY	1167.6105
R3	3	NSE	ADANIENT	EQ	151.85	165.45	151.4	151.85	152.35	25	BUY	141.0465
R4	4	NSE	HDFC	EQ	1805	1826	1805	1809.3	1786.05	1330	BUY	1624.0295
R5	5	NSE	HDFCBANK	EQ	985	988.4	970	991.85	971.85	1333	BUY	854.6115
R6	6	NSE	HEROMOTOCO	EQ	2316	2345	2300	2292.25	2311.8	1348	SHORT	2024.154
R7	7	NSE	HINDALCO	EQ	145.9	147.45	142.45	146.95	143.6	1363	BUY	119.9375

Worksheet: 1-Sheet1 Output 17-21 July


First worksheet After:

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Rows in Original

First Worksheet After

A

B

C

D

E

F

G

H

I

J

K

R1

1

Exchange

Symbol

Series/Expiry

Open

High

Low

Prev Close

LTP

R2

2

NSE

ACC

EQ

1265

1265

1246.5

1275.3

1247

22

BUY

1167.6105

R4

3

NSE

HDFC

EQ

1805

1826

1805

1809.3

1786.05

1330

BUY

1624.0295

Worksheet: 1-Sheet1 Output 17-21 July


New worksheet after
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Rows in Original	New Sheet		B	C	D	E	F	G	H	I	J	K
R1	1	Exchange	Symbol	Series/Expiry	Open	High	Low	Prev Close	LTP
R3	2	NSE	ADANIENT	EQ	151.85	165.45	151.4	151.85	152.35	25	BUY	141.0465
R5	3	NSE	HDFCBANK	EQ	985	988.4	970	991.85	971.85	1333	BUY	854.6115
R6	4	NSE	HEROMOTOCO	EQ	2316	2345	2300	2292.25	2311.8	1348	SHORT	2024.154
R7	5	NSE	HINDALCO	EQ	145.9	147.45	142.45	146.95	143.6	1363	BUY	119.9375

Worksheet: 1-Sheet1 Output 17-21 July