Hi,

I would like help to copy rows of data to a new sheet within the active
workbook. I have data in columns A thru Q, row 1 being the header row. In
column H I have the reps last name followed by a space and first name. I
would like an input box asking for the last name of the rep to sort by.
After sorting on his name I would like to have all data copied to a new sheet
which has today's date in column J or has today's date in column K. These
dates appear as 25-Jun-08. I would like to copy the headers as well to the
new sheet along with the same format as on the active sheet.

I someone could assist I would greatly appreciate it.
--
By persisting in your path, though you forfeit the little, you gain the
great.

Use data>filter>filter by the date and the name and then copy. Record a
macro and modify.
If all else fails, send a workbook to my address below along with clear
explanation, snippets of this email and before/after example(s)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"DavidH56" <(E-Mail Removed)> wrote in message
news4E77A82-DC62-4E7F-B34E-(E-Mail Removed)...
> Hi,
>
> I would like help to copy rows of data to a new sheet within the active
> workbook. I have data in columns A thru Q, row 1 being the header row.
> In
> column H I have the reps last name followed by a space and first name. I
> would like an input box asking for the last name of the rep to sort by.
> After sorting on his name I would like to have all data copied to a new
> sheet
> which has today's date in column J or has today's date in column K. These
> dates appear as 25-Jun-08. I would like to copy the headers as well to the
> new sheet along with the same format as on the active sheet.
>
> I someone could assist I would greatly appreciate it.
> --
> By persisting in your path, though you forfeit the little, you gain the
> great.
>