I would like to retrieve the active row Number of sheet1 in sheet2 and place some of the values of that row into different cells in sheet2. If the user changes to sheet1 and moves the active row then changes back to sheet2 than the values of the cells in sheet2 should change with that row change. (I assume I can place the code in the on_activate for sheet2)

I would like to be able to change the active row number from sheet2 by increasing it or decreasing it by one or by going to the first row or last row.

I am not sure what command is use to reference an active row in another sheet or to change it.

The best way to describe what I am referring to is to say each row in sheet1 is a record an each column is a field (kind of like a database) in sheet2 I want to be able to view and edit the fields in an easier format. I have a menu (next, previous, first, last, save)

If you know of any examples or a list of commands that may apply to this let me know.

As always, Thanks so much