vba Copy Paste Conditional to put remark 1 2 3 .. etc

[Molly Brennholz]

Hello

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 here: http://www.excelfox.com/forum/showth...ll=1#post12837

---

So Try this data : http://www.excelfox.com/forum/showth...ll=1#post12838



( You also need Function CL( ) )


To explain the solution to you:
If your data is
_____ Workbook: Merge2.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E
1	Symbol
2	ACC	1	2	3
3	ADANIENT	1
4

Worksheet: Sheet3

arrS3() =

arrS3(1)

arrS3(2)

arrS3(3)

arrS3(1) =

Symbol

arrS3(2)=

ACC

1

2

3

arrS3(3)=

ADANIENT

1

Let arrS3(cnt)(1, UBound(arrS3(cnt), 2)) =

File here: http://www.excelfox.com/forum/showth...ll=1#post12840
(You also need Function CL( ) )



Molly