Hi Guys,
I need some help creating a Macro.
I'm trying to copy and paste rows of data that contain my criteria column A but not if column B is blank.
I want to be able to enter a team code in cell B2 in the "Summary" tab and have the Macro pull all the non-blank rows of data and paste into the "Summary" tab.
If that doesn't make sense, please let me know.
Here is my code:
Please Login or Register to view this content.
Last edited by amasulli; 05-11-2012 at 01:53 PM.
Why are you performing the actions on the worksheet activate event? How about having the copy paste triggered by a button instead?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Re: Need VBA Code to copy paste rows from worksheet to another
My code isn't working properly...I don't know what I'm doing wrong. Sure I can add a button for the copy/paste but I'd like to see how this Macro would work set up my way.
Last edited by amasulli; 05-11-2012 at 02:59 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks