create a form to find next

[Guest]

I have a spreadsheet containing multiple entries for the same account and
want to create a form which will scroll through all entries for a selected
account, any ideas how to achieve this would be greatly appreciated

Thanks

 

[Tom Ogilvy]

Autofilter the data, then loop through the visible cells.

or look at the visual basic help example in the VBE for the FindNext method.