You've got it correct so far. Currently, I have one button at the top of the
form that when clicked, it will insert the current row to the top of Section
1, because that's the cell it is designated to move to (A4) (under the header
rows) on the Tracking tab. It works fine if you are trying to move a row
from Section 1 of the Western Tab, to Section 1 of the Tracking Tab.
However, if your current row is in Section 2, and you click the button, it
will move it to Section 1 on the Tracking Tab.

The code I have behind the button right now is:

Private Sub MoveRow_Click()
ActiveCell.EntireRow.Copy
Worksheets("Tracking").Activate 'the other sheet
ActiveSheet.Range("A4").Select
Selection.Insert Shift:=xlDown
Worksheets("Western").Activate 'back to the original
ActiveCell.EntireRow.Delete Shift:=xlShiftUp
End Sub

Any help you can provide is greatly appreciated.

Thanks so much!
Stacie



"Chip" wrote:

> 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?
>
>