I have a report that comes out weekly. It lists a lot of data for each
employee. I need to see how to write a macro that will look on this one
sheet find an employees name and paste that entire row onto the sheet with
the empoyee's name on it. Example D1 Steve Smith A1-C1 bunch of misc data,
E1-Q1 more data, I need to take this whole row and paste it on to a sheet
with the tab label Steve.

Hi gatorcc

Start here
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"gatorcc" <(E-Mail Removed)> wrote in message news:2D6F3706-B28F-4936-BE54-(E-Mail Removed)...
>I have a report that comes out weekly. It lists a lot of data for each
> employee. I need to see how to write a macro that will look on this one
> sheet find an employees name and paste that entire row onto the sheet with
> the empoyee's name on it. Example D1 Steve Smith A1-C1 bunch of misc data,
> E1-Q1 more data, I need to take this whole row and paste it on to a sheet
> with the tab label Steve.