Good Morning MREXCEL.
I have a Master list of Job#'s that tracks our internal Job#s, customers, due dates, purchase order numbers etc.
We receive PO's and enter them as internal Job#s on this list. I am trying to create a user form activated by a command button called "Add PO."
My first question: Is there a way to allow the user to select the rownumber of the worksheet and then insert the user form data above the user selected row?
Our default for new entry's is to insert data at the top of the list which keeps most recent info at the top, we like this method versus a sort because often we add PO's to Job numbers that come in across a few weeks or months so we need the user to have the ability to input the desired rownumber of the sheet via input box (textbox) and then have that PO line be inserted above the selected row.
Thanks, I can provide some current examples of the spreadsheet if needed.
I have a Master list of Job#'s that tracks our internal Job#s, customers, due dates, purchase order numbers etc.
We receive PO's and enter them as internal Job#s on this list. I am trying to create a user form activated by a command button called "Add PO."
My first question: Is there a way to allow the user to select the rownumber of the worksheet and then insert the user form data above the user selected row?
Our default for new entry's is to insert data at the top of the list which keeps most recent info at the top, we like this method versus a sort because often we add PO's to Job numbers that come in across a few weeks or months so we need the user to have the ability to input the desired rownumber of the sheet via input box (textbox) and then have that PO line be inserted above the selected row.
Thanks, I can provide some current examples of the spreadsheet if needed.