Results 1 to 1 of 1
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts

    VBA Code to copy specific data drom Source Workbook to Destination Workbook

    I need the following to be copied from the Pivot Table on the source workbook (BR1 Vat report.sample) to on the destination workbook (Vat Sample Data):

    1) I need the value in Col B next to the text V.A.T. On Sales (BR1 vat report) to be copied to column H (Vat Sample), in the same row where the name in Col B (Vat Sample)matches the name in the source workbook on the Sheet “Pivotable” in B1

    2) I need the value in Col B next to the text V.A.T. On Purchases ((BR1 vat report) to be copied to column G (Vat Sample), in the same row where the name in Col B (Vat Sample) matches the name in the source workbook on the Sheet “Pivotable” in B1

    3) I need the value in Col B next to the text Sales To Internal (BR1 vat report) to be copied to column M (Vat Sample) , in the same row where the name in Col B (Vat Sample) matches the name in the source workbook on the Sheet “Pivotable” in B1 (BR1 vat report)



    Your assistance in this regard is most appreciated
    Attached Files Attached Files
    Last edited by HowardC; 2012-07-29 at 23:38.

Posting Permissions

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