Saving userform data into specific row

[Weasley0307]

Hi everyone. The userform below is the second entry data form that I will be using to keyin the Date, PO NO and Project name for column B, A, and J respectively. All the other columns are were first filled in in the first entry form. In order for me to set which row that i want my second entry form's data to be stored in, I have decided to use the column C as a reference (as shown in the OC/SC No. combobox). If i chose 12345,, i would like for the 3 new data to be stored in the same row as that OCSC. No. The first row of the data is an example (*since it has been filled, it wont show up in the combobox anymore)

Secondly, I would like to display all the existing data (booking date, LME and etc in this userform as well for my own reference, based on the OC/SC No. that i picked in the combobox as well. If I chose 333, the booking date txtbox in the userform would display 25/01/2024 and so on.

Would appreciate if someone could guide me to write the code on how to save my data in specific row and display data in that row as well based on what my OC/SC No. value is.

 

[dmt32]

Hi
the way most deal with this is to add a hidden column to your combobox which holds the filtered record row number which you use to return a record to your form & post back to the range.

If not sure how to do this this then suggest post the code (using code tags) behind the form & provide copy of your worksheet using MrExcel Addin

XL2BB - Excel Range to BBCode

Convert selected range to BBCode to include as a snapshot in your question.

www.mrexcel.com

Plenty here to offer guidance

Dave