Please see the attached example.
On Sheet 2 is a form created to amend data on sheet 1. The bottom right box on the form titled "Copy All Original Coding" needs to search column A on Sheet 1 when a number is entered into the box and the button pressed. I know the number will exist in column A because I will have already verified this, so when the button is pressed I need it to copy the data from cells H,I,J,K on that row to cells L,M,N,O on the same row.
Screen shot.PNGScreen Shot 2.PNG
Hope you can help me out.