PDA

View Full Version : Copy Rows based on Name Condition



gatorcc
12-15-2008, 12:25 PM
I have a report that comes out with all employees on the report. Right now I have to copy and paste each employee into there own personal sheet in the workbook. I figure there has to be some way using a macro to automate this task. I am attaching a sample of my spreadsheet.
I have spent hours on this forum and google trying to find the right macro to do this. :banghead:

Any help would be greatly appreciated.

lucas
12-15-2008, 12:40 PM
See if this gets you started:
http://vbaexpress.com/forum/showthread.php?t=24148

georgiboy
12-15-2008, 01:00 PM
Heres something i have used in the past...

Hope it helps