create a form to find next
 

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

create a form to find next
 

Autofilter the data, then loop through the visible cells.

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

--
Regards,
Tom Ogilvy


"Michael" wrote in message
...
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