Database Question

[Uncle Chips]

I'm sure this is rather simple but I would be very appreciative if someone could help me with the following issue. I have a large database in Excel that contains a dozen or so fields such as Name, Address, Email, Organization, etc. All I want to do is be able to pull and separate the database into different tabs based upon a specific criteria in the database. I know I can autofilter and or sort and cut/paste, but I would just like to know if there is a set of formulas/macro that would do the same thing. For example, if I wanted a separate tab distinguishing the Oraganization field, how could I pull that ?

Sorry for such a noob question and thanks in advance for any help.

 

[Smitty]

Welcome to the Board!

AutoFilter is probably one of the most efficient means.

Depending on the size of your dataset formulas might not be the best way to go, but you might want to have a look at VLOOKUP..

You can record a macro performing the AutoFilter, Cut/Paste. Then that can be modified for all of your categories. Just post back the code that you get and someone can help with that.

HTH,