Excel template populating from a worksheet
 

Good morning,
I have an excel worksheet containing customer names, addresses, phone
numbers, machine, serial number, type of service, last service date, next
service date, and comments.

I would like to have this information to populate onto another worksheet
template when a user enters a customer name from the other worksheet. I need
the information for one customer to be displayed on this template as to
simplfy the users search and as well as for "presentation".

Any ideas as to a template or functions would be greatfully appreciated.

Thank you

Excel template populating from a worksheet
 

You would normally use VLOOKUP to do this - detailed explanation
available in XL Help, or you could have a look at Debra Dalgleish's
notes he

http://www.contextures.com/xlFunctions02.html

Hope this helps.

Pete

On Apr 29, 5:20*pm, Brandy wrote:
Good morning,
I have an excel worksheet containing *customer names, addresses, phone
numbers, machine, serial number, type of service, last service date, next
service date, and comments.

I would like to have this information to populate onto another worksheet
template when a user enters a customer name from the other worksheet. *I need
the information for one customer to be displayed on this template as to
simplfy the users search and as well as for "presentation".

Any ideas as to a template or functions would be greatfully appreciated.

Thank you