Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto complete?
Never really delved all that much into Excel before - not to this level any
way so Im hopeing someone can hold my hand through this. It should be an easy one for someone: I am trying to design a simple order form. If I enter a product code into column A, I want it to fill in the product description, pack size and price, in columns B, C & D leaving me just to fill in the total quantity in column E. Then at the end, it should just have a list of the products my customer has ordered in a nice printable page for the sales dept to process. (I can probably do the aesthetics and simple calculations) Hope this makes sense. Kind Regards. |
#2
|
|||
|
|||
You will first need a data sheet listing all the products you have:
Code - Desc - Pack - Price Then on your order form sheet use VLookup function for the Desc - Pack - Price columns based on whichever code you type in "MNicholas" wrote in message ... Never really delved all that much into Excel before - not to this level any way so I'm hopeing someone can hold my hand through this. It should be an easy one for someone: I am trying to design a simple order form. If I enter a product code into column A, I want it to fill in the product description, pack size and price, in columns B, C & D leaving me just to fill in the total quantity in column E. Then at the end, it should just have a list of the products my customer has ordered in a nice printable page for the sales dept to process. (I can probably do the aesthetics and simple calculations) Hope this makes sense. Kind Regards. |
#3
|
|||
|
|||
This should get you started...using simple vlookups, referencing a table of all product codes and associated info, you can do this fairly simply. I used the if(isblank()) formulas to keep the page clear if nothing is selected. Let me know if you need more help. +-------------------------------------------------------------------+ |Filename: For_ MNicholas.zip | |Download: http://www.excelforum.com/attachment.php?postid=3704 | +-------------------------------------------------------------------+ -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=396989 |
#4
|
|||
|
|||
Just a quick line to say Thank You! With your very kind help, and the use of
a tutorial randomly found at http://pubs.logicalexpressions.com/P...cle.asp?ID=446 I have done it. Thanks again JethroUK© & Excel_Geek. MN "Excel_Geek" wrote: This should get you started...using simple vlookups, referencing a table of all product codes and associated info, you can do this fairly simply. I used the if(isblank()) formulas to keep the page clear if nothing is selected. Let me know if you need more help. +-------------------------------------------------------------------+ |Filename: For_ MNicholas.zip | |Download: http://www.excelforum.com/attachment.php?postid=3704 | +-------------------------------------------------------------------+ -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=396989 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I attach data to auto complete | Excel Worksheet Functions | |||
How do I get a field in excel to auto complete with a check mark | Excel Discussion (Misc queries) | |||
Auto Complete not completing | Excel Discussion (Misc queries) | |||
How do you auto complete when skipping spaces | Excel Discussion (Misc queries) | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions |