Results 1 to 10 of 29

Thread: copy and paste by VBA based on criteria

Threaded View

fixer copy and paste by VBA based... 03-02-2020, 10:25 PM
DocAElstein Hi, To copy all columns... 03-03-2020, 02:07 AM
fixer Sub STEP4() Dim w1 As... 03-03-2020, 06:58 AM
DocAElstein Your macro is good Your... 03-03-2020, 01:04 PM
fixer Thnx Doc Sir for ur great... 03-03-2020, 01:13 PM
DocAElstein Hi, Some extra info: For... 03-03-2020, 03:34 PM
fixer Thnx Doc Sir for providing... 03-03-2020, 03:44 PM
fixer Doc Sir i have a similar... 03-17-2020, 05:29 PM
DocAElstein Hello Worksheets.Item(1)... 03-17-2020, 06:51 PM
fixer Thnx Alot Doc Sir i changed... 03-17-2020, 07:31 PM
fixer copy and paste by vba 03-29-2020, 07:04 PM
DocAElstein Before: _____ Workbook:... 03-30-2020, 12:37 AM
fixer Sorry Doc Sir i made a... 03-31-2020, 05:34 PM
DocAElstein :confused: I do not... 03-31-2020, 11:39 PM
fixer vba is placed in sample2.xlsm... 04-01-2020, 12:33 AM
DocAElstein What is the problem with the... 04-01-2020, 12:59 AM
fixer Sub STEP6d() Dim Wb1 As... 04-01-2020, 08:37 AM
DocAElstein Do you understand anything... 04-01-2020, 12:10 PM
DocAElstein I try again to explain.. ... 04-01-2020, 01:17 PM
fixer No Doubt Doc Sir u gave me... 04-01-2020, 08:31 PM
fixer Thnx Alan Elston Sir (Doc Sir) 04-02-2020, 10:45 PM
fixer copy and paste by vba 04-16-2020, 10:13 AM
DocAElstein Hi There are very many... 04-16-2020, 01:55 PM
fixer Thnx Alot Doc Sir for helping... 04-17-2020, 11:25 AM
fixer Copy and paste the data if... 04-22-2020, 06:37 PM
DocAElstein I think you have not... 04-23-2020, 04:04 PM
fixer Minor changes are there in... 04-27-2020, 06:38 PM
DocAElstein If the only change is to... 04-28-2020, 01:47 AM
fixer Problem Solved Thnx Doc Sir... 04-28-2020, 11:58 AM
Previous Post Previous Post   Next Post Next Post
  1. 03-02-2020, 10:25 PM #1
    fixer is offline
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    copy and paste by VBA based on criteria

    all files are located same place

    vba is placed in a seperate file sample1.xlsm

    copy all the data from column A TO COLUMN H complete data from sample2.xls and paste it to sample3.xlsb in same columns

    save and close the sample2.xls and sample3.xlsb

    i need to do the same by vba so plz help me in slving this problem sir

    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
    Last edited by DocAElstein; 10-24-2023 at 02:23 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy and Paste based on comparisons/Match and calculations of cells in two workbooks
    By fixer in forum Test Area
    Replies: 48
    Last Post: 09-23-2020, 02:03 AM
  2. Copy Paste based on comparisons calculations in 2 XL files, 1 might be .csv file .Opened in XL=Fail/Chaos
    By fixer in forum Test Area
    Replies: 85
    Last Post: 06-09-2020, 05:58 PM
  3. Copy paste data based on criteria
    By analyst in forum Excel Help
    Replies: 7
    Last Post: 01-13-2014, 12:46 PM
  4. VBA code to copy and paste row based on certain criteria
    By T0NT0 in forum Excel Help
    Replies: 8
    Last Post: 10-31-2013, 12:38 AM
  5. Copy data from 1 excel workbook to another based on certain criteria
    By Matt_M in forum Excel Help
    Replies: 2
    Last Post: 09-18-2013, 12:30 AM

Tags for this Thread

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