I have data which is exported into excel each month. I have been tryin
to write a macro in VBA which will find a certain item then copy th
row with this item on into another worksheet.

Could anyone help me with a generic code to find a certain text, the
copy the row with this text in to a certain row of another spreadsheet
Also is there a way to make it user friendly so you can type in the tex
and the row you want it in, in a user interface box?

Alternatively is there a way in excel or through code you can sort th
rows in a spreadsheet so that they appear in an order which is mor
advanced than ascending/descending. Eg I have rows with details of
apples, pears, oranges and bananas respectively and I want them to b
in the order pears, bananas, apples, oranges or whatever order
choose.

nb. I am using Excel 97.

Any help would be much appreciated!

Thank you in advance

--
fugfu
-----------------------------------------------------------------------
fugfug's Profile: http://www.excelforum.com/member.php...fo&userid=2495
View this thread: http://www.excelforum.com/showthread.php?threadid=38483