Copy rows of data to new worksheet based on cell value in another

[Carlab49]

Hi All,

I've been reading through previous threads, but just cant get my head round the code required to do the above.
I would like to auto (Copy) populate the row data to another worksheet based on certain criteria entered into a column on another.

I have attached a copy for reference.
On sheet 1 (AFQ) i am using columns A - J. I would like to copy the row data of the same columns on sheet 2 (PAWEL), if that name has been entered in column H of sheet 1 (AFQ). Then to do the same for sheet 3 (PAUL).

Then i would like to do the same for Sheet 4 (Complete), but this will be based on "Complete" being selected in column F of sheet 1

Can some provide some guidance on this please, would be very much appreciated.

[Mumps1]

Do you want to do this one row at a time as the name is entered in column H and "Complete" is selected in column F? What about the name "Carla" in column H? Do the sheets for PAWEL, PAUL and possibly Carla already exist?

[Carlab49]

I dont mind if its automatically or with a button. Just Pawel and Paul then the complete one. Yes those sheets are already set up in the document.

[Mumps1]

Try the attached file. Click the "Copy Data" button to copy to the Pawel and Paul sheets. When you click on "Complete" in column F, that row will be copied to the "Complete" sheet.

[Carlab49]

Try the attached file. Click the "Copy Data" button to copy to the Pawel and Paul sheets. When you click on "Complete" in column F, that row will be copied to the "Complete" sheet.

You are a blooming star!! - works perfectly. thank you so much.

[Mumps1]

You are very welcome.