Auto Populating/ formating Fields
 

I have a project at work I am trying to finish. I need to be able to
auto populate/format fields on a spreadsheet. I attached a copy of the
sheet I am working on. I emulated what I want on the first sheet and
the second sheet contains what I have. As information is populated on
column F, I would like columns N, O, & P to auto populate as well as
format using pre-defined criteria foubdin rows 2, 3 , & 4 Column B. I
may need an additional table in the mix. Any help would be greatly
appreciated.


+-------------------------------------------------------------------+
|Filename: Excel Project.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4057 |
+-------------------------------------------------------------------+

--
tsjonesosu
------------------------------------------------------------------------
tsjonesosu's Profile: http://www.excelforum.com/member.php...o&userid=29019
View this thread: http://www.excelforum.com/showthread...hreadid=487512