Current row in one worksheet dictates values in another

[mrall]

I'm sure this is just a simple question but, I have no books on VBA programming in Excel and don't know what it is reffered to, in order to search of it.

1.) Based on the current curser possition in sheet1, I would like sheet2 to display all or some of the row values (in a special form)
2.) As the current curser possition chances in sheet1, the values should be updated in sheet2 (like a database record and form)
3.) If values are changed in sheet2 they should reflect the change on sheet1
4.) From sheet2 I should be able to move the curser up and down in sheet1 reflecting the different values of the rows

I'm sure it has been done
If you know of any examples let me know

As alway thanks soo much for any help

[TMS]

You can probably do the first couple of items using a VBA Sheet Selection Change event.

Then you'd need some code to process the form when changes are made.

Maybe you could post a sample workbook if you want more specific help.

Regards, TMS