VBA Coding to copy data from one worksheet to another worksheet

[Closed]
Report
Posts
1
Registration date
Wednesday April 12, 2017
Status
Member
Last seen
April 12, 2017
-
 Blocked Profile -
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


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
Hi, I know the basics of vba. Yes, I have the developer ribbon open and unlocked.

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