macro to move data from one sheet to another by month

Hello, on the attached worksheet i'm trying to get the data from "Closed Business" to The "Executive" Sheet by month, when the Month is entered into cell J2, (I entered the first row in as an example) This would then save as "Closed Business for Distribution - October, 2016" , or whatever month is entered in J2, in a file to my desktop.

Also this would be going to upper management so if you have any ideas on a way to make it more appealing to look at that would be great also. This is not important, was just looking for ideas if you have any.

Thank you for any and all help.

Hi Jaslake, Thanks for your help again. It would be throughout the current year. then 2017 would be a new sheet.

Hello Jaslake, Any luck? I have a sheet that does something similar, but have no idea of how to tweak the code to work for this sheet? Thank you.

Thank you!, I will check it out in a little bit! Really appreciate your help!

Hello, I'm getting an error code when selecting in J2 - " run-time error '1004': Auto filter method of range class failed " ???

Got it! Thanks so very much for this, It works great! Have a great weekend!!

Hello Again, If you have a Minute, can you explain how the "auto filter" works in this code? Thanks.

.Range("A3:W" & srcLR).AutoFilter Field:=17, Operator:= _
xlFilterValues, Criteria2:=Array(1, myDate)

Hello Jaslake, Don't worry about that last question, I looked it up and found some examples, and how they work. Have a good weekend.

Hi Jaslake, How would i modify your code to border the cells when they move to the "executive tab"?? I cant figure it out. Thank you.

I tried changing .cells.borders.linestyle, taking out .borders. Also the .range (a8:j) .clear taking out .clear. Both to no good. Not sure where to go from here! Thank you for your time!

Please Login or Register  to view this content.

I think i got it working on another sheet i have been playing with - This does not delete the borders when selecting a new month, but it does not resize it to the number of rows when the month changes. What do you think?

Yes it was originally from Leo, I have tried to modify Yours but don't even know where to begin. I tried on the below part of the code taking out .clear, which did not work. I like the way the drop down selects the month and then imports the data on yours. So much to learn!

Please Login or Register  to view this content.

Ahhh, got it working. Thanks again, Was looking at that line that was replaced with the above "with tgtws" code, would never have came up with that!