Prev: IF Statements
Next: How do I insert a photo into a specific cell?
From: John McKeon on 13 May 2010 16:14
I could really use your help.

I have a worksheet with multiple tabs (sheets). I have one sheet with all
the data in it. Each row of data is defined by an identifier in the cells in
column C. There are only 4 options of identifiers. I would like to have
data, when entered into the data sheet copy and past each row into a
corresponding sheet without empty rows in-between on the new sheets.

In other words, each row assigned to identifier = John Doe will have a copy
of that row placed in a sheet named John Doe. I can do this with sorting,
copy / paste. I would like to see if Excel will do this with a macro or if
there is a function that will auto copy & paste without leaveing empty rows
on John Doe Sheet. I have not done a successful macro and am looking for
another option.

I would really appreciate your help with this. It is a large bit of data
that needs to be updated often and the sort - C/P is getting real old.
Thanks in advance.
From: Ron de Bruin on 13 May 2010 17:09
Maybe
http://www.rondebruin.nl/copy5.htm


--

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



"John McKeon" <JohnMcKeon(a)discussions.microsoft.com> wrote in message news:671C0F0F-B5A5-473F-BAE6-CE5300E8CA01(a)microsoft.com...
> I could really use your help.
>
> I have a worksheet with multiple tabs (sheets). I have one sheet with all
> the data in it. Each row of data is defined by an identifier in the cells in
> column C. There are only 4 options of identifiers. I would like to have
> data, when entered into the data sheet copy and past each row into a
> corresponding sheet without empty rows in-between on the new sheets.
>
> In other words, each row assigned to identifier = John Doe will have a copy
> of that row placed in a sheet named John Doe. I can do this with sorting,
> copy / paste. I would like to see if Excel will do this with a macro or if
> there is a function that will auto copy & paste without leaveing empty rows
> on John Doe Sheet. I have not done a successful macro and am looking for
> another option.
>
> I would really appreciate your help with this. It is a large bit of data
> that needs to be updated often and the sort - C/P is getting real old.
> Thanks in advance.
 | 
Pages: 1
Prev: IF Statements
Next: How do I insert a photo into a specific cell?