VBA Copy and Paster into another Workbook
Results 1 to 3 of 3

Thread: VBA Copy and Paster into another Workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA Copy and Paster into another Workbook

    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

  2. #2
    New Member
    Join Date
    Aug 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Copy and Paster into another Workbook

    Bump

  3. #3
    New Member
    Join Date
    Aug 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Copy and Paster into another Workbook

    Any help is much appreciated

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •