Hi there,

I want to sort data using column Q by name order. Once these have
been sorted I want a macro to copy all the rows where the cell in Q
matches a first name string which should be able to be programmed into
the macro. I then want it cut and pasted to the end of the
spreadsheet i.e 5 rows after the end row.

One this has been done I would like the SUM formula entered into both
sections but to SUM the data in column S.

I know you guys would find this easy to complete however.

The reason I need the above to be completed is because the macro below
stops working when there is no names at all for my string below,

Sheets("Customer Orders").Select
Range("Q1").Select
Do While ActiveCell.Value < "John Smith"
ActiveCell.Offset(1, 0).Select
Loop

If there is no John Smith it stops working.........and doesnt move on
to the next part.

If someone could help with a macro as per my above request it will be
very dynamic and will help me a great deal.

THanks

Andrea