This has to be done with programming. You might be better off posting in the
Programming group.

You need an event macro that inserts a timestamp in another cell when the
target cell changes to "buy". Then you can extract all the "buys" in
descending order based on the timestamp.

Biff

"Happy Skunk Love" <Happy Skunk wrote in
message ...
Howdy,

I sure would love some help. I have a list of 400 stocks on one page of
an
excel spreadsheet. I have one cell for each symbol set to say "Buy" when
it
meets certain criteria.

In another spread sheet, one that would appear blank at first, I would
like
to have it make a moving list of the symbols when they say "Buy".
Example:
Symbol IBM meets my criteria, in cell A1 on page 1 it says "Buy".. then on
page 2 the symbol IBM pops up.

Ten minutes later cell CC meets my criteria and says "Buy", I would like
the
symbol to appear before IBM on page 2 and push IBM from spot A1 to spot
A2....

After half and hour I have 35 symbols that have met my criteria with the
latest one that met my criteria in position A1 with the rest fo the
symbols
following that symbol..A2, A3,A4 and so forth...

Would really help if I could figure this out...Thanks!