Appendix-Thread-Evaluate-Range-(-Codes-for-other-Threads-HTML-Tables-etc-)

[DocAElstein]

In support of this Thread:
http://www.excelfox.com/forum/showth...Paste-by-a-Vba

If column E of ap.xls matches with column A of leverage.xlsx then copy column E of leverage.xlsx and paste it to column Z of ap.xls

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

Row\Col	B	C	D	E	Z
1	AccountId	EntityName	Exchg-Seg	Symbol
2	WC5758		NSE	TCS
3	WC5758		NSE	SRTRANSFIN
4	WC5758		NSE	MARICO
5	WC5758		NSE	M&MFIN
6	WC5758		NSE	20MICRONS
7	WC5758		NSE	CONCOR
8	WC5758		NSE	COALINDIA
9	WC5758		NSE	BOSCHLTD
10	WC5758		NSE	BERGEPAINT
11	WC5758		NSE	5PAISA
12	WC5758		NSE	TATAELXSI
13	WC5758		NSE	HINDPETRO
14	WC5758		NSE	DISHTV
15

Worksheet: ap-Sheet1

_____ Workbook: LEVERAGE1.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G
1	Stock Name			pro times	ultimate times
2	20MICRONS	EQ	INE144J01027	19	26	36.35
3	TCS	EQ	INE253B01015	19	26	13.5
4	3IINFOTECH	EQ	INE748C01020	29	39	2.05
5	3MINDIA	EQ	INE470A01017	48	64	21299
6	5PAISA	EQ	INE618L01018	31	41	129.5
7	63MOONS	EQ	INE111B01023	30	40	99.15
8	8KMILES	EQ	INE650K01021	27	36	56.5
9

Worksheet: Sheet1

If column E of ap.xls matches with column A of leverage.xlsx then copy column E of leverage.xlsx and paste it to column Z of ap.xls

After
example
cell E2 of ap.xls matches with column A3 of leverage.xlsx then copy E3 of leverage.xlsx and paste it to Z2 of ap.xls


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

Row\Col	B	C	D	E	Z
1	AccountId	EntityName	Exchg-Seg	Symbol
2	WC5758		NSE	TCS	25.823112
3	WC5758		NSE	SRTRANSFIN
4	WC5758		NSE	MARICO
5	WC5758		NSE	M&MFIN
6	WC5758		NSE	20MICRONS	25.823112
7	WC5758		NSE	CONCOR
8	WC5758		NSE	COALINDIA
9	WC5758		NSE	BOSCHLTD
10	WC5758		NSE	BERGEPAINT
11	WC5758		NSE	5PAISA	40.795512
12	WC5758		NSE	TATAELXSI
13	WC5758		NSE	HINDPETRO
14	WC5758		NSE	DISHTV

Worksheet: ap-Sheet1