Hi
That may take a bit of explaining, so I will link in my previous thread that this is relating to.
I have a Workbook with a Log Sheet and a Form. With the click of a button, the contents of my form are transferred to the log sheet, and save this information in the next available row. This works well, and my thread on this can be seen here: VBA to submit contents of one page to another
On the Log Sheet, in the A Column, there is a code that generates a reference ID for each issue that is logged through the form. This also works, and on another form I am able to click the reference from a drop down, and populate the cells with the information in the log. Again, this works well.
My question is in regards to this second form. When I populate the information, there are some cells which are blank as they don't have information in. Form 2 is intended to put that information in place.
Where would I start with the VBA code to transfer the information from Form 2 into the log, but taking into account the row it needs to populate is determined by the unique code in the A column?
In my head, it is a case of VLookup to find the unique code, that identifies the row, then enter the text into the relevant cells on that row.
But I have no idea how this is done in VBA.
I assume it is simply amending the code that finds the "next empty line" with one that finds the correct line based on the contents of A.
Any pointers on where I should start?
That may take a bit of explaining, so I will link in my previous thread that this is relating to.
I have a Workbook with a Log Sheet and a Form. With the click of a button, the contents of my form are transferred to the log sheet, and save this information in the next available row. This works well, and my thread on this can be seen here: VBA to submit contents of one page to another
On the Log Sheet, in the A Column, there is a code that generates a reference ID for each issue that is logged through the form. This also works, and on another form I am able to click the reference from a drop down, and populate the cells with the information in the log. Again, this works well.
My question is in regards to this second form. When I populate the information, there are some cells which are blank as they don't have information in. Form 2 is intended to put that information in place.
Where would I start with the VBA code to transfer the information from Form 2 into the log, but taking into account the row it needs to populate is determined by the unique code in the A column?
In my head, it is a case of VLookup to find the unique code, that identifies the row, then enter the text into the relevant cells on that row.
But I have no idea how this is done in VBA.
I assume it is simply amending the code that finds the "next empty line" with one that finds the correct line based on the contents of A.
Any pointers on where I should start?