Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a second worksheet | Excel Discussion (Misc queries) | |||
Populating a calendar from another worksheet | Excel Worksheet Functions | |||
Populating Cells from One Worksheet to Another... | Excel Worksheet Functions | |||
Populating one worksheet from another | Excel Worksheet Functions | |||
populating a worksheet | Excel Worksheet Functions |