Help with Macro (VBA) copy range if..

**Umair Ikram** · 12-03-2009, 05:34 AM

Dear members,

say i have a worksheet named "sheet1" and a worksheet named "sheet2".

In sheet 1 i have a buch of data, e.g it looks something like this:

1 TRUE
2 FALSE
3 FALSE
4 TRUE
5 FALSE
6 FALSE

whats the macro code for it to only copy the "TRUE" number to "sheet2"? so it will only copy 1 & 4 to sheet2, thanks in advance

**Umair Ikram** · 12-03-2009, 05:34 AM

i basically only want it to copy the number if it's true if its false dont copy.

**Umair Ikram** · 12-03-2009, 05:48 AM

Bump, still need help :/

**DonkeyOte** · 12-03-2009, 05:52 AM

Umair.

Bumping your post after 14 minutes is not acceptable.

PM'ing members to look at your posts is not acceptable.

Regards your question - check out either Auto Filter / Advanced Filtering... if you need a Macro use the Recorder to record your Filtering actions.

**DonkeyOte** · 12-03-2009, 06:03 AM

And in addition...

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Please read the Forum Rules before posting any further.

**Umair Ikram** · 12-03-2009, 08:22 AM

Originally Posted by DonkeyOte

Umair.

Bumping your post after 14 minutes is not acceptable.

PM'ing members to look at your posts is not acceptable.

Regards your question - check out either Auto Filter / Advanced Filtering... if you need a Macro use the Recorder to record your Filtering actions.

Sorry about that, by any chance can you explain how i can use auto filter or advanced filtering, this is actually for a school project and it needs to have VB code resolved around it, isnt there like a certain code i can use for the macro?
i know it may sound dumb, but i never use excel etc, its for a school project so im new to all of this :/
Thanks and sorry