F
fugfug
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
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