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!
