I'm new here and would like to know if you can help me with this.
I"ve created an excel form which feeds an excel sheet with data. This userform has several textboxes.
Every time I create a new entry the userform will populate a new row with the values specified.
I want to create a command button (RETRIEVE) to find a value that has been previously entered in a textbox in the sheet and then auto populate the rest of textboxes with the values of that row.
Once that's been done I want to be able to update (replace) that information with another command button (UPDATE).
Any help would be very appreciated.