Data navigation macro
 

I am trying to create a macro that can sort through data and based on
the values carry out a function on a specific range. I am having a
rough go at it though. In short this is what I am trying to
accomplish:

In column F, find the range of values between 1 and 2. Based off this
range of data, look at the corresponding range in Column G and find the
range of values between 10.0 and 30.0. Take this range and the
corresponding range in H and find the slope of the data set.

easy enough right? not for me. Any tips on a macro that will do this,
example of a find, and select a relative range and repeating the process
to navigate through some data.

Thanks.


--
retro88
------------------------------------------------------------------------
retro88's Profile: http://www.excelforum.com/member.php...o&userid=29039
View this thread: http://www.excelforum.com/showthread...hreadid=487805