Pulling Values from Another Tab based on certain conditions

[OleMiss2010]

Let's say I have three columns (Account, Balance, and Risk) and want to pull a list of all accounts where the risk is > 5 into a new tab. Obviously there are a half dozen ways to do this fairly easily, but I was wondering the most direct method to do this for VBA purposes.


I'm mostly doing this to experiment around with Excel for hypothetical future situations.

 

[Hui]

OleMiss2010


Firstly, Welcome to the Chandoo.org Forums


Have you looked at Using an Advanced Filter?


I'd have a read of Debra Dalgleish posts at Contextures.com

http://www.contextures.com/xladvfilter01.html


The problem could also be done with formulas,

I'll drag some out later

 

[OleMiss2010]

Actualy did not even consider that. Thanks.


Also, thanks for the welcome.