I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria and without clearing previous content. I am tracking subscriptions on a master file and would like to create sheets based on the type of subscriptions. I will enter new subscriptions often (maybe daily or weekly) and I want to keep a running list. I do not want to filter. I need coding that will copy data to a new sheet.
Suppose I have the following data:
Subscription Type Record Amount Start Date End Date
New York Times Online 1 $100.00 1/1/2017 12/31/2017
New England Courier Newspaper 2 $200.00 2/1/2017 1/31/2018
Washington Post Online 9 $300.00 4/15/2016 4/14/2017
Financial Times Newspaper 5 $400.00 1/1/2017 12/31/2017
I want all Online subscriptions to copy to sheet two and all Newspaper subscriptions to copy to sheet three. And lets supposed I don't need the record number to copy over. Just the other columns. What coding can be used to transfer the data automatically every time a new subscription is entered?