Solved: Move to Next Record

[Hoopsah]

Hi

I have written a workbook, where, when details are input into cell H2 then all of the other cells are populated, taking data from another worksheet.

I have set up some amend data and error checking functions along the way.

What I would like to finish this off is a button (Already Created) than when clicked will go to the next record on the list.

I have attached a copy of my workbook and although I think it is quite self explanatory please feel free to ask anything to try and get to the right answer,

Thanks for any help given

Hoopsah

[Bob Phillips]

Gerry, try this.

I have added formulae to get the data relating to the CDRef, you need to check I have got the correct column reference for them, some I have not even tried as I had no inkling of which it should be.

[Hoopsah]

Once again - That is fantastic Bob.

I was hoping that once I saw how to go to the next record I could possibly work out how to go to the previous record, but as usual you have surpassed yourself.

All I can say is thanks Bob, this is exactly what I was looking for,

Cheers

Gerry