Wookbook Automation Copy/Paste a range based on a name

[TXJM]

Hi

I have a question how I can automate a wookbook I have.

I need to search in column R on sheet1 for a specific name, if found then need to copy that specific row ranging from column D to I onto sheet2 starting at column F5 to K5.
With every new entry going on the next row below.
Each name will be going onto a new sheet ( there will be 20 different names = 20 sheets).

I am looking for not having to copy and paste each specific range from sheet1 onto the sheet for that name.

Thank you for looking into this!!!!

[Leith Ross]

Hello TJXM,

Welcome to the Forum!

What data will be on these new sheets?
Will each sheet be named using the search name?

[TXJM]

The data to be copied will be:

date out, time out, Description, date in , time in.

The cell formatting on the original sheet and the destination sheet ( the sheet for that name ) will be set before hand, so does not need to be changed.

The Name sheet will be in place before hand, so does not to be created each time an new entry is made.

Thank you for your interest in this project of mine!!!