VBA Coding to copy data from one worksheet to another worksheet

Registration date
Wednesday April 12, 2017
Last seen
April 12, 2017
 Blocked Profile -
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?

Thank you!!

1 reply

HOw familiar are you with VBA? Do you have your Developer riibon open and unlocked?

Perhaps you should visit:
Hi, I know the basics of vba. Yes, I have the developer ribbon open and unlocked.

Blocked Profile
So post some code where you are stuck, and we can help!