selective display

[Rishi jaipuria]

Hi,I have a long list of share prices extending to 500
lines. Can i select the stock prices which meet a certain
critieria and copy this selective data to a different
range in a seperate worksheet

thanx

Rishi

 

[Anders S]

Have you tried Advanced Filter (Data menu)?

Anders Silvén