So...I have had some time to think this one through a bit.
Currently, when a user adds data (using the Add Line Item button), the rows will populate with an auto-generated LINE number along with the information from the form. I've attached a sample form with LINE 1 filled in.
Is there a method of making that LINE number a "hyperlink" to open a form (pre-populated with that rows information) - and on that form have Cancel, Delete, and Save buttons?
Then, if I change data in the form and select Save. I want the new data to overwrite the current data for this particular row.
If I select the Delete button, this row will be deleted from the spreadsheet and any row below the deleted row will move up?
If I select Cancel, the form will close and nothing will happen.
I should note: I do not know how to code. I've been able to create this form by asking lots of questions and getting great answers on these Forums. If you have the time and desire to spell things out clearly for me...or even just put the code in there for me.....well...you know how much frustration you'd be saving me!
F-0068 04OCT2015_H.xlsm
Bookmarks