5 Replies Latest reply on Feb 14, 2019 6:55 PM by Prasanna R

    How to select next record by clicking "Next" button through actions?

    Linda Dawson

      Hi,

       

      In the attached workbook. When I click a customer name in sheet 1, it will filter sheet 2 through filter action. There is another sheet, which is a floating Next Button.

       

       

      My question is: Is it possible to select next record in sheet 1 to filter sheet 2 by clicking Next button? For example, Now it filter customer name Erin Ashbrook from sheet 1 to sheet 2. When I click next, I hope it will show Harry Marie in sheet 2. Click again, it will show Heather Kirkland in sheet 2, etc. I don't care if it will select next customer name in sheet 1.

       

      Is it possible?

       

      Thanks,

       

       

      Linda