hi crisp,
thanks for the swift reply. I'm afraid I can't use the
method you method.. Basically the info is taken from other souces thru
cut & paste and I put in the date & company. I was think for example if
row 11 have the stock code I want, the programming will display the
whole row data to for example worksheet 2.

I hope I can get more advise on this or programming etc.


Thanks


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