Looking for way to: Copy/Paste range of cells to another worksheet based on matching crite

I've looked at similar posts but have to post this as a new question as they didn't solve my issue:

I have a file with names down column B in sheet 1 and want to transfer all cells C to AA in the row associated with specific names in column B of this sheet to worksheet 2 which is set up with all the same headings and just a limited selection of names from sheet 1. I can write a macro to copy the data but need to get the macro to look for the name in the cell in sheet 2 where I have the name I want the data transferred for. How do I get it to do this for each new cell I go to for which I want to extract the data from sheet 1 - can anyone help please?

I can't see how to attach my file (Can't see paper clip?? or "manage attachments" button.... )

I created this macro but need to replace "Andrew Dibby" with the name in the cell I'm in:

Please Login or Register  to view this content.

I've attached file with 2nd sheet open and now want to copy the data for - say - "David Bell" from sheet 1, where I have the second row duplicated by the above macro for "Andrew Dibby". Hope someone can please help! Thanks, Mary

Thanks, Holger but when I copied and pasted that over my existing macro and ran it, it copied all the names and their data to the new sheet. I need to enter the names in manually and run the macro to look in sheet one and carry it over to sheet 2. I need to get the macro to look for the name in column B in the second worksheet cell I've just typed the name into and get it to bring the data for that name into sheet B. Any more suggestions would be welcome. Thanks! Mary