+ Reply to Thread
Results 1 to 3 of 3

How to copy non-adjacent cells from a row when it's updated with a required criteria

  1. #1
    Registered User
    Join Date
    01-15-2018
    Location
    Southend-on-Sea, England
    MS-Off Ver
    2016
    Posts
    6

    How to copy non-adjacent cells from a row when it's updated with a required criteria

    I need to copy single row values from columns A, F and R on worksheet "RD activity review log" when column P has a value of "On hold" and the column R date value is changed. I need the values from these three cells to be pasted onto the next empty row of worksheet "Paused Log" after each time the criteria is met.

    I have the following code as a worksheet change event, but would like to change it so that I only copy the values from columns A, F and R rather than the values from the entire row. Can anyone help please?

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: How to copy non-adjacent cells from a row when it's updated with a required criteria

    Change this line of code
    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Look at this link to undestand the Union functionality https://msdn.microsoft.com/en-us/vba...n-method-excel
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-15-2018
    Location
    Southend-on-Sea, England
    MS-Off Ver
    2016
    Posts
    6

    Re: How to copy non-adjacent cells from a row when it's updated with a required criteria

    Fantastic. Thank you so much!!!

+ 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. Copy values from adjacent cells to groups of adjacent cells with gaps
    By Kneigum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2017, 04:50 PM
  2. Replies: 6
    Last Post: 11-11-2016, 09:07 PM
  3. [SOLVED] Formula to copy adjacent cell if criteria is found
    By no_Fate in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2015, 09:31 PM
  4. Replies: 4
    Last Post: 01-12-2015, 11:41 AM
  5. Geomean last 5 cells where adjacent cells meet certain criteria
    By thomasart23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2014, 05:03 PM
  6. [SOLVED] Copy adjacent cells based on matched cell criteria
    By asdfwqefwe3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2013, 02:26 AM
  7. [SOLVED] Add date to cell when adjacent cells are updated
    By lilvictorians in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2013, 07:47 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1