Hi

Would someone be able to assist or point me in the right direction?

I have a worksheet ("Sheet1") which contains data in range(A3:P50). The Header Rows are A1:P2.

I want to search data in column A to find the record I want to amend (say this is in cell A25) and select data in cells D25 and J25 to change them. Finally in cell Q25 (in this example) I want to put todays date to record when this record was changed.

I want to do this using a userform and to scroll up or down a txtbox (txtPONumber). I wanted to create two commandbuttons (cmdScrollUp and cmdScrollDown to do this scrolling. The items of data that need to be changed will be populated in txtCost and txtNumber respectively.

This sounds very easy to do, but I just can't seem to get my head around how to do this.

Any thoughts?

Many thanks.