I need a userform front end to open up when clicking the macro button in worksheet "main"...which is visible to end user..
so when the user clicks the excel 2007 file from their desktop the workbook opens, user clicks macro button to lunch userform - the resource then types in customer account number in first field and the result is displayed in the second field. ..userform to have close button..to close down form
...so spreadsheet "source data" where the user form will be reading the data from is hidden
column A. column B.
Account Number. Organisation Name
4677883. Bank of New York
in total I have 450,000 rows of data....