+ Reply to Thread
Results 1 to 2 of 2

Macro to copy values on a sheet based on a condition

  1. #1
    Registered User
    Join Date
    06-05-2017
    Location
    Sydney, Australia
    MS-Off Ver
    2016
    Posts
    4

    Macro to copy values on a sheet based on a condition

    Hi People!
    Sorry i'm very basic with macros, I have a vague idea but to be honest the last time I've done one was 8 years ago.
    I think this might be simple, but I can't do it, so it would be really helpful if you guys can help me
    I have a file with 2 sheets, one called "Recommendation Table" and the other "Close Out Plan"
    So, I need to populate all the information from the "Recommendation Table" sheet into the "Close Out Plan" based on the value of the D Column of the "Recommendation Table" (if Column D=Critical or Essential, then I'd need to copy all the row, otherwise I need to check the next row).

    Thanks in advance to everyone.
    Miguel.

  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,885

    Re: Macro to copy values on a sheet based on a condition

    Try this;
    Please Login or Register  to view this content.
    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

+ 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. Replies: 5
    Last Post: 11-07-2016, 07:49 AM
  2. Replies: 0
    Last Post: 03-10-2014, 03:15 PM
  3. [SOLVED] Copy and paste (values) to another sheet based on condition
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-09-2013, 10:25 PM
  4. Need a macro to copy data from one sheet to another based on condition.
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2013, 01:56 AM
  5. Replies: 1
    Last Post: 05-11-2013, 02:58 AM
  6. macro to copy values on one sheet based on the values of another sheet.
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 09:09 AM
  7. macro to copy rows to another sheet based on condition mentioned in another workbook
    By sona_tejas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 06:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1