That can be done but why not just use
datafilterautofiltercustomless than 0.
Record a macro if desired.

--
Don Guillett
SalesAid Software

"Sam" wrote in message
om...
hello

in column A i have dates
in column B i have stock name
in column C i have NASDAQ index values

data starts from cell A2, B2 , C2 resp.
the length of data can vary as i can change the stock name or i can
change the index say SP500 index or so...

now i want to write a macro that will check the values in column C and
if it is negative, it will copy that date , stock price and the index
value and paste all this in column F, G and H.

so i want this macro to identify all the dates, stock prices and index
values on the condition that the index was negative.

so if index was -ve say 11 times in the last 30 days , i want in
column F , G , H .....to be able to see corr dates , stock prices and
index values using this macro ...

can any1 plssssssss help......
thanks

sam