Test

[Molly Brennholz]

Screenshots I need to help answer the post that is just here:
http://www.excelfox.com/forum/showth...-to-put-remark

If column I is sell then see the value of column K & if column K is Greater than sheet2 of column E then put the remark in sheet3 in the stock name from column B
If column I is buy then see the value of column K & if column K is lower than sheet2 of column F then put the remark in sheet3 in the stock name from column B
remark will be in series like 1,2,3,4,5,6 and so on
vba is palced in a separate file
all files are located in same place
and after putting the remark clear sheet 1 and sheet 2

If column I is sell then see the value of column K &

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L
1	Exchange	Symbol	Series/Expiry	Open	High	Low	Prev Close	LTP
2	NSE	ACC	EQ	10	11	12	13	8	SELL	11.247	1100.947
3	NSE	ADANIENT	EQ	8	7	6	5	4	BUY	1.334	130.734
4

Worksheet: Sheet1


if column K is Greater than sheet2 of column E

Row\Col	A	B	C	D	E	F	G	H	I
1	Exchange	Symbol	Series/Expiry	Open	High	Low	Prev Close	LTP
2	NSE	ACC	EQ	1	1102	18	4	2
3	NSE	ADANIENT	EQ	5	6	129	8	4
4

Worksheet: Sheet2

E then put the remark in sheet3 in the stock name from column B

Row\Col	A	B	C	D	E	F	G
1	Symbol
2	ACC	1	2	3
3	ADANIENT	1
4
5
6
7		remark I have puuted 1 bcoz series start with 1
8		and next time when I will run the macro
9		then it will start with 2
10		and again when I will ran the macro then it will start with 3

Worksheet: Sheet3

If column I is buy then see the value of column K & if column K is lower than sheet2 of column F then put the remark in sheet3 in the stock name from column B
remark will be in series like 1,2,3,4,5,6 and so on
vba is palced in a separate file
all files are located in same place
and after putting the remark clear sheet 1 and sheet 2

arrS1()

Exchange	Symbol	Series/Expiry	Open	High	Low	Prev Close	LTP
NSE	ACC	EQ	10	11	12	13	8	SELL	11.247	1100.947
NSE	ADANIENT	EQ	8	7	6	5	4	BUY	1.334	130.734

arrS2()

Exchange	Symbol	Series/Expiry	Open	High	Low	Prev Close	LTP
NSE	ACC	EQ	1	1102	18	4	2
NSE	ADANIENT	EQ	5	6	129	8	4

arrS3()

Symbol
ACC	1	2	3
ADANIENT	1

Symbol
ACC	1	2	3
ADANIENT	1

---

Your data ?????
SELL is K=1100.947 , sheet 2 column E is 1102 … so K is NOT > column E ---- so no output – no remark
BUY is K = 130.734 , sheet 2 column E is 129 … so K is NOT < column E ----- so no output – no remark



_.....see next post............._