Dayhole,

You should try using VLOOKUP formulas in the columns that you want t
automatically fill with information. You can input the name into on
cell and have subsequent cells fill automatically.

VLOOKUPS have the following arguments:
Lookup_value - in your case, the company name (although I woul
recommend creating a primary key for this)
Table-array - a table you will create that has all the information yo
require
Col_index_num - indicates which column that data you are pulling int
the particular cell is located
Range_lookup - usually set to FALSE

Hope this help

--
cparask
-----------------------------------------------------------------------
cparaske's Profile: http://www.excelforum.com/member.php...nfo&userid=379
View this thread: http://www.excelforum.com/showthread.php?threadid=37776