Copy rows of data based on alpha condition

Closed
bgb92 - Feb 11, 2009 at 12:16 AM
solene77
Posts
5
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
- Feb 11, 2009 at 02:37 AM
Hello,
I have a summary worksheet that houses all records. I'd like to break that summary worksheet into in multiple worksheets grouped by last name, but still maintain my summary sheet for updating. I'd like to update one worksheet but have those updates transfer to the other worksheets.

I have a summary worksheet that stores information like lastname, first name, birthdate, email address & contact information. I'd like to take that information and pull it into another worksheet grouped by last name (worksheet 2 A-H, worksheet 3 I-P, worksheet 4 Q-Z)

1 reply

solene77
Posts
5
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
1
Feb 11, 2009 at 02:37 AM
hi,
try this link:
www.duepoint.com/1863/julias_study_guide.xlsx
this should help you to solve your problem.
good luck.
0