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

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