Stacie let me make sure I understand what is going...so Well Type 1,
Well Type 2 and Well Type 3 data sections are all on the same sheet?
and the number of rows in each section varies i am assuming? and you
want it so that when the active cell is in some range vba will act on
the corresponding well type, and then initiate your macro, correct?
can you give me your code thus far?