hypuk
04-04-2012, 06:45 AM
Hi there
I was wondering how I'd be able to search another spreadsheet which has a account number, first name and surname in there, by entering a account number on my excel userform and clicking a search button on the form to return matched data and populate it in to my first name and surname field.
Below is a link to a screenshot of my userform
http://imageshack.us/photo/my-images/851/formg.gif/ (http://imageshack.us/photo/my-images/851/formg.gif/)
Any help would be muched appreciated.
Mark
I was wondering how I'd be able to search another spreadsheet which has a account number, first name and surname in there, by entering a account number on my excel userform and clicking a search button on the form to return matched data and populate it in to my first name and surname field.
Below is a link to a screenshot of my userform
http://imageshack.us/photo/my-images/851/formg.gif/ (http://imageshack.us/photo/my-images/851/formg.gif/)
Any help would be muched appreciated.
Mark