Transferring like data

[npignetti]

Hello,
Here is an example of what I am trying to accomplish:

I have a running list of client ID numbers, the client name, the date of
service, and charges associated for that service in random order similar to
this:

123456 mary frank 5/9/2008 121.00
143235 john smith 10/15/2006 3,612.00
763876 john doe 12/6/2007 1,969.00
137543 bob jones 4/8/2003 165.00
123456 mark frank 6/17/2008 352.00
763876 john doe 9/19/2007 4,524.00
143235 john smith 10/28/2004 3,456.00
123456 mark frank 6/17/2008 352.00
763876 john doe 9/19/2007 4,524.00
143235 john smith 10/28/2004 3,456.00

What i need to do is take every client in that list using the id number and
group them on a seperate sheet- take all the john doe's and paste them into a
set bank of rows. Is there a function to have excel search for like id
numbers and paste all the associated information into specific rows on a
seperate sheet in aecending order?

Thank you in advance.

Nick

 

[Gary''s Student]

You can use AutoFilter to display only rows with a given id number. Then you
can copy/paste the rows elsewhere.

 

[npignetti]

It is several hundred rows of data, and I was trying to automate this
process. That is the way I am currently doing it, and it is taking several
hours of copy/pasting.

Thank you.

 

[Max]

How about a simple, fast, non-array formulas driven model which automates the
desired copying of lines from a parent/master sheet to individual child
sheets named as the key col values. All copied lines will appear neatly
bunched at the top in the child sheets.

Take away this illustrative sample from my free archives:
http://savefile.com/files/1813664
Parent to Child AutoCopy via Key Col Values.xls
(full construct details, nicely rendered, easy to adapt)

In your instance, as the key col value is in col A in the parent sheet
you probably just need to change this point formula in K2 (in the parent):
=IF($B2="","",IF($B2=K$1+0,ROW(),""))
to
=IF($A2="","",IF($A2=K$1+0,ROW(),""))
Then fill K2 across/down. Adapt the listings in K1 across to suit your
unique client id numbers, name the child sheets as the same client ids, and
you should be good to go, up and about in 10-15 mins flat?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik

 

[Herbert Seidenberg]

Completely automated.
Not a single formula.
Some code.
Excel 2007
http://www.savefile.com/files/1849992