VBA Coding to copy data from one worksheet to another worksheet

Closed
tippy99001 Posts 1 Registration date Wednesday April 12, 2017 Status Member Last seen April 12, 2017 - Apr 12, 2017 at 04:11 PM
 Blocked Profile - Apr 19, 2017 at 03:32 PM
Hello,
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

Blocked Profile
Apr 12, 2017 at 08:27 PM
HOw familiar are you with VBA? Do you have your Developer riibon open and unlocked?

Perhaps you should visit:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
0
Hi, I know the basics of vba. Yes, I have the developer ribbon open and unlocked.

Thanks!
0
Blocked Profile
Apr 19, 2017 at 03:32 PM
So post some code where you are stuck, and we can help!
0