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
Bookmarks