N
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
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