Solved Excel VBA to copy/paste upon condition met

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

snoozee

Thread Starter
It's My Birthday!
Joined
Apr 10, 2006
Messages
264
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.
 

Attachments

OBP

Joined
Mar 8, 2005
Messages
19,895
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.
 

Attachments

snoozee

Thread Starter
It's My Birthday!
Joined
Apr 10, 2006
Messages
264
Thanks heaps i really appreciate your help with this :)
 

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
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 :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Members online

Top