Here is a more "wordy" explanation of what I am trying to do:
After I run the sort by decending order in my first workbook, I need t
select the worst half of ticker symbols in a column. Then, I need t
open another workbook (the one with the previous code). Then, one b
one, run each ticker symbol through my second workbook. Let me explai
more what this second workbook does: If I type a ticker symbol into
cell and hit enter -- underneath it spits out all client names tha
have it. Then, if I type in another ticker into the same cell, it wil
erase and give me new output. So, somehow I need to copy and past
inbetween inputs the ticker and the output. This would be the report.
Thank

--
Message posted from http://www.ExcelForum.com