Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Macro to copy data from specfic Cols in Source workbook

    I have two workbooks and would like a macro to copy data from the source work to the destination workbook as follows (macro to be in destination workbook)

    1) Source workbook (Browse Assets.xlsx) copy Col A & B from row two onwards to Row 2 onwards in Col C & D in Destination workbook
    2) Copy Col C in source workbook(Browse Assets.xlsx) from row 2 onwards to Col A from row 2 in destination workbook
    3) Copy Col D to F in source workbook(Browse Assets.xlsx) from row 2 onwards to Col G to Col I from row 2 in destination workbook
    4) Copy Col H in source workbook(Browse Assets.xlsx) from row 2 onwards to Col L from row 2 in destination workbook
    5) Copy Col J in source workbook(Browse Assets.xlsx) from row 2 onwards to Col N from row 2 in destination workbook


    http://www.mrexcel.com/forum/excel-q...ange-sign.html

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

  2. #2
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Maudibe

    Thanks for the help, much appreciated

    Regards

    Howard

Posting Permissions

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