hi

this is my first post so the question may seem naive but I only recently
started dabbling in VBA. Ill try to be as clear as possible.

I have the following type of data

heading 1 heading 2 heading 3
456 43575 aaa
5854 65777 aaa
567 123 bbb
5678 3467 bbb
347 3657 bbb
3567 347 ccc

I need to copy headings and all rows with heading3 aaa to different
worksheet then copy headings with all rows with heading3 bbb to different
worksheet etc.
data is already sorted by heading 3

thanks in advance