Sorting Info from a WS to multiple Worksheets..

[MikeyJ110]

So, I use to be a lot better with Excel, but it's been quite some time, and I'm in Dire need of help.

Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing I want to do is organize it. I want to sort the Master sheet into other worksheets, and I would like to do this Industry.

Is there a way to make excel register when a contact is in a certain industry, and then subsequently move that contact into a sheet? I tried playing around with If/Then functions, but I think this is a job for a macro/VB expert.

Your help would be greatly appreciated. mjulian@bowdoin.edu

In addition, any other tips to better organize a workbook of this size would be welcomed, and appreciated!

-Mike

 

[Norie]

Why do you want to have separate sheets?

It might not look pretty but it would be much easier to work with/analysis/whatever if all the data was on one worksheet.

 

[MikeyJ110]

Jon!

Thank you so much! You are the man! It worked! Bravo! You are a genius!