Excel Filter/Macro [Solved/Closed]

Ask a question LSKM - Last answered on Jan 15, 2016 at 05:19 PM by vcoolio
Thank you in advance for any time/help you can offer!

I'm working on a contact list in Excel and I need to be able to filter my contacts in a few different ways. Each contact is in a row and each column includes information (name, media type, etc). I've never done programming before so I'm not sure where to start.

The workbook is made up of a few different parts:
- "MASTER" sheet (includes everyone)
- "TV" sheet (for those contacts marked as "TV" in column B ("MEDIA TYPE") on "MASTER" sheet)
- "RADIO" sheet (for contacts marked as "Radio" in column B ("MEDIA TYPE") on "MASTER" sheet)
- etc.

I need to be able to filter (automatically copy/paste if possible) those people on the "MASTER" sheet to their respective "TV"/"RADIO" sheets. The reason for the automatic is because the document will be updated fairly frequently.

Is there a macro/how-to where I can learn to do this? Thanks again!

- Loren
plus moins
Hello Loren,

Perhaps a look at the following link to a similar thread back in early December may give you a guide to a possible solution. I believe that your query is similar. The Poster did not bother to reply so we cannot be totally sure if it worked for him.

In the above-mentioned thread, my post #2 has a code which should work for you also although you need to ignore lines 14 - 21 of that code (this part creates new named sheets which you won't need to do).

There is a DropBox link in the same post which shows how the code works.

Have a look and let us know what you think. If it suits, we should be able to sort something out for you.

Was this answer helpful?  
LSKM- Jan 15, 2016 at 10:00 AM
Hi vcoolio,

Thanks for the links! While I didn't use your code, your response helped shed some light and point the way to another idea: I saved my excel workbook as macro compatible, then recorded a macro as a key command that I can use in the future to copy the necessary contacts from the MASTER worksheet to their designated worksheet. It keeps all the contacts up to date and it's relatively easy to maintain since all the editing still takes place in the MASTER worksheet.

Much appreciated!
- Loren
plus moins
If you have data that is being updated, a spreadsheet is not the platform for that. You need a database to make these record changes. Then run a report based on what value you wish to query!
plus moins
Hello Loren,

That's great! It's called using your initiative!

I'm glad that I was able to help out in a small way. If you ever get stuck, just call back and we'll see what we can do for you.

Good luck!


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!