Macro to sort results by placing them into individual worksheets

[gr8rck]

Hi all,

Looking for macro help. I need to have a downloaded csv/excel file sorted by "column X" and then have that row placed into individual worksheet tabs.

An example would be:

Column X
Table for Member
Table for Guest
Table for Visitor
Table for Member
Table for Member
Table for Guest


Results:

Worksheet B
Table for Member
Table for Member
Table for Member

Worksheet C
Table for Guest
Table for Guest

Worksheet D
Table for Visitor


Thanks,
Ryan.