search and update

[UniversalJOC]

how would I create a button that basically allows a search to be made.
activates the find action. asks for a user name (initials for example) and then number to be found in a column. then takes you to the requested row, and also updates the corresponding columns (eg Columns E - the word 'Active',F- current date,I - initials,J-the word 'customer')

 

[Corni]

Open the Forms toolbar (View|Toolbars) and place the button control on the worksheet. Then assign a macro to the button that is going to perform all tasks you need. You have to be familiar with VBA.