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 response

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