How to make a macro that copies only the data within a range to another sheet?

Hi all,

This ones seems so simple, but my Excel Marco skills are lacking.

I have a data sheet like so:

A B
Name Grade
Jim 82%
Bob 90%
Kelly 71%
June 95%

And I also have two cells which are designated as the low and high range. (ie C1 = 85% and C2 = 100%).

I need help with the macro for the button that will copy only the rows to a new sheet that fit within the range. So in the example above, pressing the button will create this in a new sheet:

A B
Name Grade
Bob 90%
June 95%

You don't need a macro to do this, but one can be created if this is something you will being on a regular basis.

Take a look at using Advanced Filter with criteria and the option to copy to another location. It will extract only the values that meet the criteria.

See this link for help on Advanced Filter