Thanks a ton for your response,... I am very very nocive as to my experience
of excel, it took me a week to create what I have created thus far, I don't
know what a worksheet_calculate is ... I am going to send to you the excel
spread sheet that I am working on maybe that could give you a better idea of
what I am doing...

thanks

I am sending it to you under the email of

I am a series 7 trader at a propfirm.

"Don Guillett" wrote:

It would depend on HOW the cell becomes "buy".. If you type it in a simple
worksheet_change event would do where it copies the symbol and inserts
before the 1st available cell on the destination page. More detail perhaps
or a workbook sent directly to me at the address below.A worksheet_calculate
could take ALL buys to the destination page. I once had a series 7 license.

--
Don Guillett
SalesAid Software

"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!