Scott

You will need to copy the formula down column F

There are several ways to do this

goto the last row that has your parts listed in it

select the cell for that last row in column F

press the Ctrl & Up Arrow keys - this should selct all cells up to F
(based on your example)

Press Ctrl D

or

Edit Menu Fill Fill Dow

--
Message posted from http://www.ExcelForum.com