Report

VBA Coding to copy data from one worksheet to another worksheet

Ask a question tippy99001 1Posts Wednesday April 12, 2017Registration date April 12, 2017 Last seen - Last answered on Apr 19, 2017 at 03:32 PM by ac3mark
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!!
Helpful
+0
plus moins
HOw familiar are you with VBA? Do you have your Developer riibon open and unlocked?

Perhaps you should visit:
http://ccm.net/faq/53497-manipulating-entries-in-excel-via-vba
Tippy99001- Apr 12, 2017 at 10:24 PM
Hi, I know the basics of vba. Yes, I have the developer ribbon open and unlocked.

Thanks!
Reply
ac3mark 8034Posts Monday June 3, 2013Registration date ModeratorStatus October 23, 2017 Last seen - Apr 19, 2017 at 03:32 PM
So post some code where you are stuck, and we can help!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!