I have a workbook having 2 sheets. The first contains of customer database and the 2nd sheet displays certain fields from the first sheet to the user just like user form .

The 2nd sheet will display the first record from the 1st sheet, I have apply following formula to display the record from sheet 1,

I want to add arrow shape (=> ) button to click next record in second sheet. pls guide.

formula :

Sheet1 contains data in the range A1:F20

Sheet2 will display the contents of A1:F1 in the cells A1:F1.

A1: =OFFSET(Sheet1!$A$1,$H$1,0)
B1: =OFFSET(Sheet1!$A$1,$H$1,1)
C1: =OFFSET(Sheet1!$A$1,$H$1,2)
D1: =OFFSET(Sheet1!$A$1,$H$1,3)
E1: =OFFSET(Sheet1!$A$1,$H$1,4)
F1: =OFFSET(Sheet1!$A$1,$H$1,5)

H1: =0