+ Reply to Thread
Results 1 to 6 of 6

Copy and paste data based on 2 conditions in same column

  1. #1
    Forum Contributor
    Join Date
    03-12-2022
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    109

    Copy and paste data based on 2 conditions in same column

    I am looking for a code that Clears data in column I & J of Destination table, Copies/Paste data from Source only if Support Coordinator is either "Dominque Mitchell" or "Kimberly Sullivan".

    Orange table is my desired outcome....thank you
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,951

    Re: Copy and paste data based on 2 conditions in same column

    There will be more efficient ways of doing this, but the below is written so it's easy to follow.
    Let us know if you need any of it explaining.

    Please Login or Register  to view this content.
    BSB

  3. #3
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Copy and paste data based on 2 conditions in same column

    Another Option...
    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  4. #4
    Forum Contributor
    Join Date
    03-12-2022
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    109

    Re: Copy and paste data based on 2 conditions in same column

    This worked great but didn't want table to resize. How to modify code?

  5. #5
    Forum Contributor
    Join Date
    03-12-2022
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    109

    Re: Copy and paste data based on 2 conditions in same column

    This also worked great but didn't want table to resize.

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Copy and paste data based on 2 conditions in same column

    This also worked great but didn't want table to resize.
    Why would you want blank unused rows in a Table...?
    What happens if Table 1 has more rows than Table 2...?

    Please Login or Register  to view this content.
    Last edited by Sintek; 08-26-2024 at 11:13 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy, paste and transpose selected data to new worksheet based on conditions
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2019, 12:59 PM
  2. [SOLVED] VB Code to copy paste data from column to another column based on content of cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2019, 08:50 PM
  3. Copy data and paste based on next Column
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2018, 01:22 PM
  4. Copy and Paste to New Tab based on Conditions
    By mattman123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2014, 12:59 PM
  5. [SOLVED] Copy and Paste Based on Conditions
    By Hazarrd in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 10-14-2013, 05:44 PM
  6. Replies: 2
    Last Post: 06-15-2012, 04:40 PM
  7. Copy and Paste based on conditions
    By K17TROJAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2008, 01:15 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1