Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers | Excel Worksheet Functions | |||
Excel Stock List | Excel Discussion (Misc queries) | |||
how to use short cuts when making stock list | New Users to Excel | |||
Summarize Out of Stock List | Excel Worksheet Functions | |||
how to copy old price data onto new stock list if match exists? | Excel Discussion (Misc queries) |