I wish to search a column for a particular value.

If the value is found, I want to be able to copy all the information in
that particular row to a new worksheet. The original worksheet is then
searched again for any more occurrences of the value and if found, that
row is copied to row 2 of the new worksheet, and so on until the
orginal worksheet has been completely searched.

Can I write a macro to do that?

If so, the next step would be to search a number of columns in the
orginal worksheet for various values. If all values are found, the row
is copied to the new worksheet, and so on as above.

Any ideas would be greatly appreciated

Thanks
Matthew


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