Hi Guys,

I am stuck on a problem.

I want to have a Textbox on the userform where a user can input a row# or "UCI#" and by pressing a button, that row moves under whatever "UCI"(F) is selected on the ComboBox(highlighted on the picture) on the userform.

Client Data is scattered randomly on the sheet because of timing and sometimes we need to have family members grouped together so in order for us to group them together, I need to move their row under the principle applicant data(PA) or "E"


For example, I want to move A7 under A1's family.

Thank you


userform.JPG

sheet.JPG