Greetings!
I've been searching all over the net for what initially seemed a simple piece of code to find however, I've found nothing that helps on this subject. I have a a very simple form that users use to input data into Sheet 2. I want to build in the ability for them to use a Previous/Next button to scroll through the records they have typed in and make changes to the records if they so desire. It would also be nice to include a mssg box once the user has reached the very first or last record statting "first/last record has been reached". The spreadsheet is built in such a way that once the user is done and submits the form it closes out, sends a copy of the spreadsheet via email, and deletes the data and goes back to a blank template. Any help on this would be VERY much appreciated as like I've stated I've been searching for days with no answers. Thank you in advance!!
I've been searching all over the net for what initially seemed a simple piece of code to find however, I've found nothing that helps on this subject. I have a a very simple form that users use to input data into Sheet 2. I want to build in the ability for them to use a Previous/Next button to scroll through the records they have typed in and make changes to the records if they so desire. It would also be nice to include a mssg box once the user has reached the very first or last record statting "first/last record has been reached". The spreadsheet is built in such a way that once the user is done and submits the form it closes out, sends a copy of the spreadsheet via email, and deletes the data and goes back to a blank template. Any help on this would be VERY much appreciated as like I've stated I've been searching for days with no answers. Thank you in advance!!