Results 1 to 10 of 29

Thread: copy and paste by VBA based on criteria

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 03-17-2020, 06:51 PM #1
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Hello

    Worksheets.Item(1) is first worksheet
    Worksheets.Item(2) is second worksheet
    Worksheets.Item(3) is Third worksheet
    Workshe    …….etc.

    First4Worksheets.JPG : https://imgur.com/v0h9CaU
    Attachment 2793

    Try
    w2.Worksheets.Item(2).Columns("A:H").Past……………
    Attached Images Attached Images
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!
    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