I have a Worksheet "Audit" filled with many Rows of data.

Not all cells contain text (Some cells are empty) but Column C wil
always have text in it.

I want to select and paste all rows (running A to J) to a WorkShee
"Temp" that have a string of text "John Miles".
The WorkSheet "Temp" will already have previous data in it so i want t
copy the Rows to the next empty Row.

Then on WorkSheet "Temp" i want to count how many Rows there ar
containing the name "John Miles". Then i also want to count how man
Rows have an empty cell in Column A.

Please can someone advise me of how to do this.

Thanks in advance

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