Results 1 to 1 of 1

Thread: Macro to copy data in specific Columns

  1. 04-19-2013, 10:42 AM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Macro to copy data in specific Columns

    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) Replace & in Col C in destination workbook with "AND"
    3) Copy Col C in source workbook(Browse Assets.xlsx) from row 2 onwards to Col A from row 2 in destination workbook
    4) 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
    5) Copy Col H in source workbook(Browse Assets.xlsx) from row 2 onwards to Col L from row 2 in destination workbook
    6) Copy Col J in source workbook(Browse Assets.xlsx) from row 2 onwards to Col N from row 2 in destination workbook

    Your assistance in this tregard is most appreciated

    PLEASE HELP !!

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=SIDLFRkUEIo&lc=UgzTF5vvB67Zbfs9qvx4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg
    https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugx12mI-a39T41NaZ8F4AaABAg.9iDQqIP56NV9iFD0AkeeJG
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
    https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzFkoI0n_BxwnwVMcZ4AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9htG01cKBzX
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htJ6TpIOXR
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htOKs4jh3M
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 10-24-2023 at 02:19 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro To Browse Select File And Import Specific Data
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 06-10-2013, 06:12 PM
  2. Macro to copy data where name matches destination workbook
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-20-2013, 10:07 AM
  3. Macro Copy Columns and Paste in rows.
    By TommyKris in forum Excel Help
    Replies: 3
    Last Post: 03-06-2013, 02:36 PM
  4. Macro to copy data from a set of excel files
    By Sreejesh Menon in forum Excel Help
    Replies: 5
    Last Post: 11-15-2012, 11:17 AM
  5. Macro to copy data from multiple workbooks and sheets
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 11-08-2012, 01:15 PM

Bookmarks

Posting Permissions

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

Forum Rules