I need a formula that will complete the data on a sheet 2 after being entered
on sheet 1. The data to be entered is the amount in columns "Red & Blue" and
the rows are are from a validation list which includes nuts, bolts, screws,
and hammers.

Sheet 1
Red Blue Type
$5.00 $3.00 nuts
$3.00 $7.00 nuts
$5.00 $1.00 bolts
$6.00 hammers
$4.00 bolts
$8.00 screws
______________________________

Sheet 2
Red Blue
nuts
bolts
screws
hammers
TOTAL $ $