VBA Copy and Paster into another Workbook

[Slowsupratt]

First, I appreciate any help I can get and thank you in advance for any help you guys/gals can provide. Here is my scenario

I will have a page (worksheet 2) on a workbook with a Marco button and then A3 is the input field. The input is based upon data from the same workbook but different worksheet (worksheet 1).

The input in A3 on worksheet 2 is associated with Column K on a worksheet 1, i.e. customer. I want to copy and paste all rows associated with the customer input on A3 worksheet 2 but only select columns.

The columns would be M:BP and then pasted into a new workbook O:Techsvc\Global Materials\A_New Parts Addition\Part Set-up Request Sheet.xlsm --> worksheet "SAP Entry" --> paste in B2


Thanks again,
Tom

 

[Slowsupratt]

Bump

 

[Slowsupratt]

Any help is much appreciated