Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Populate Fields
Hello, I am trying to create a spreadsheet to log in current purchase orders for my company. What I am trying to accomplish is to be able to type in the order number in the first column and have several other fields in the row automatically populate ("account manager" "sales rep" etc.) Perhaps pulling info from another data sheet. Is this possible with excel? Thank you -- tqdinh22 ------------------------------------------------------------------------ tqdinh22's Profile: http://www.excelforum.com/member.php...o&userid=36453 View this thread: http://www.excelforum.com/showthread...hreadid=562142 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Populate Fields
Have you looked into lookup, vlookup or hlookup? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=562142 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Cycling Through Page Fields Automatically | Excel Discussion (Misc queries) | |||
populate fields with macro | Excel Discussion (Misc queries) | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
getting multiple data to populate another worksheet | Excel Worksheet Functions |