1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved Excel VBA to copy/paste upon condition met

Discussion in 'Business Applications' started by snoozee, Dec 4, 2018.

Advertisement
  1. snoozee

    snoozee Thread Starter

    Joined:
    Apr 10, 2006
    Messages:
    263
    Hi

    I'm trying to work out how to copy a data range to another worksheet when a condition is met and i'm failing as i'm a bit rusty on the whole VBA thing :)

    When a user enters "Y" in column U i need the relevant rows data from cell range A:C copied to another worksheet.

    I've attached an example of what I'm working with and how it's laid out.

    I'd really appreciate some help with this.
     

    Attached Files:

  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    The code in sheet 1 will do what you want.
    However I have only transferred the value from column "a", I will let you work out b & c.
    You also need to format column a as a date, as I have.
     

    Attached Files:

  3. snoozee

    snoozee Thread Starter

    Joined:
    Apr 10, 2006
    Messages:
    263
    Thanks heaps i really appreciate your help with this :)
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,552
    First Name:
    Hans
    Hi Sue,
    Didn't OBP's answer put you on the right track? Keep in mind that the check for Y or y is case sensitive.
    I don't know if the file you sent me contains data that cannot be shared so I haven't attached it here.
    I wish all at TSG a great and helpful 2019 :)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...

Short URL to this thread: https://techguy.org/1220046

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice