a VBA Code that will copy and paste a Row upon selection of an item in a Listbox

I am currently improving one of my workbooks. On “sheet2” a “userform1” populates data on the sheet over one row, along columns “A” to “BG” (and the next blank row, post clearing data). I then utilise a second “userform2” with single item Listboxes, (the Listboxes are successfully populated from column “A” on” sheet2”) I want to be able to copy and paste the row corresponding to the Listbox selection from “sheet2” to another data sheet, “sheet3” using a VBA code, But I do not know where to start.

This pasted data is then used to populate forms on other sheets using formulae. The form filling aspect is all successfully in place on the workbook. The forms populate when I manually enter data into Sheet 3, as I pushed past the problem I was having hoping my knowledge would have improved sufficiently to “combat” the issue, but as I have stated I don’t know where to start. I have tried searching the forum as well as googling the issue, I am just getting more confused and agitated, which is a shame because I have enjoyed my progress this far.

Hi taffboyo and welcome to the forum.

It would probably help if we could see a (desensitized) version of your workbook as it will give a greater feel for the issue in hand.

BSB

Hi BSB,

Thank you.

As requested, PFA a desensitized version of my workbook.