Results 1 to 2 of 2

Thread: VBA Code to Extract data

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    VBA Code to Extract data

    I would like a macro to open up a source workbook and to copy the data into the destination workbook as follows:


    1) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Zero Rate" appears, to be copied into col N, in the same row where the names matches the source workbook
    2) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Exempt" appears, to be copied into col M, in the same row where the names matches the source workbook


    I have attached sample data from the source workbook as well as the destination workbook


    Your assistance in this regard is most appreciated
    Attached Files Attached Files

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Note: I moved your posting to the Excel Help forum where it will receive a wider audience of volunteers who can respond to it.

Similar Threads

  1. Replies: 8
    Last Post: 06-08-2013, 01:24 PM
  2. Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  3. VBA Code to extract subtotals
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 12-02-2012, 01:15 PM
  4. VBA Code to Open Workbook and copy data
    By Howardc in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 06:58 PM
  5. VBA code to copy data from source workbook
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 07-30-2012, 09:28 AM

Posting Permissions

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