Copy rows of data based on alpha condition

[Closed]
Report
-
Posts
5
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
-
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

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