Data Export from excel file

[Micheal_P]

Hello Ladies and Gentlemen,
I have an excel file that contains information about my clients as you see bellow

[/IMG]_{^{<strike>
</strike>}}
This is actually a sample, my real file has 1018 rows and 6 columns.
What I want to do is to categorize my list by Type(column4), and they way I wish to be able to do it is by writing the word in a cell and every row that has that word in it to go to a new Sheet, I’ ll post another sample image bellow.

[/IMG]_{^{<strike>
</strike>}}
I searched online for a solutions but nothing seems to dothe job as I wanted, also some things I found I just couldn’t implement.
I hope I made myself clear.

Thank you all in advance!!

 

[hiker95]

Micheal_P,

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.

 

[Macropod]

For a formula-based approach, see: http://windowssecrets.com/forums/sh...es-from-a-list?p=734296&viewfull=1#post734296
& http://www.techsupportforum.com/forums/f57/excel-formula-issues-375768.html#post2567119

 

[Micheal_P]

Thank you all for the help, the answer was more simple than i thought, a simple filter did the job.