Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
[newbie] copy unhidden cells | Excel Discussion (Misc queries) | |||
[newbie] Macro for "copy and paste" | Excel Discussion (Misc queries) | |||
Macro newbie - simple copy/paste function | Excel Programming | |||
Copy cells and paste to an address given in another cell (VBA Newbie) | Excel Programming | |||
newbie trying to workout copy | Excel Programming |