Copy row Macro Help for VBA Newbie
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. |
Copy row Macro Help for VBA Newbie
Hi gatorcc Start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gatorcc" wrote in message ... 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. |
All times are GMT +1. The time now is 08:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com