Returning multiple row based on criteria

[MartyB99]

Hi,

New on here and I'm looking for help if possible please. I have two worksheets and I want to insert multiple rows from one worksheet to another if criteria are met.

Example below. I have 8 columns in worksheets 'RATINGS' and I only want to return the rows to worksheet 'SUMMARY' where the 'RatingTotal' is greater than 70.

Date Product1 Product2 Product3 Rating1 Rating2 Rating3 RatingTotal
30/09/2013 Ball Bell Belt 10.00 10.00 5.00 25.00
01/10/2013 Ball2 Bell2 Belt2 10.00 15.00 10.00 35.00
02/10/2013 Ball3 Bell3 Belt3 35.00 20.00 10.00 65.00
03/10/2013 Ball4 Bell4 Belt4 25.00 25.00 25.00 75.00
03/10/2013 Ball5 Bell5 Belt5 20.00 30.00 35.00 85.00

I need a formula that will work over a range but I should know if the no. of rows in worksheet 'RATINGS' if this helps. It's nearly like cut & paste but I want it automated so in the above example the only rows that should be returned to worksheet 'SUMMARY' are:

03/10/2013 Ball4 Bell4 Belt4 25.00 25.00 25.00 75.00
03/10/2013 Ball5 Bell5 Belt5 20.00 30.00 35.00 85.00

Hope this makes sense and if there is anybody out there that can suggest a solution I'd be grateful.

Thanks

Marty

[JBeaucaire]

This is what the Autofilter is for.

1) Click on the header row
2) Select Data > Filter to turn on the filter arrows
3) Select the RatingTotal drop arrow and apply a CUSTOM filter for values greater than or equal to 70.
4) Copy all visible rows to Summary
5) Turn off the filter.

This will work quickly with dataset of any size.

[MartyB99]

Thanks, I know the Data Filter will do this but i am looking for an autmated solution so I can scale up as I will be adding multiple worksheets in the book. So I want it to do the job of essential a manual cut and paste but I want it automated.

[JBeaucaire]

Ah, then perhaps you posted in the wrong part of the forum if you're looking for automation, then the VBA Programming forum would be more appropriate? Shall I move this for you?