M
mark
Hi
I have a sales order form with the equipment on the second sheet as "PartNo"
"Description" "Cost" selected each column of data then clicked in the
cellname box and called them "PartNo" "Description" "Cost"
On the sales order form I have the columns "Qty" PartNo" "Description"
"Serial No" "QtyDes" "Price" Total"
I have set up data validation for the description as a list with
=Description what I want it to do is display the part no in the part number
Column and the cost in the price column. Also the list only shows the first
eight items with scroll bars is it possible to show more of the list I.e. 20
lines
Thanks in advance
Mark
I have a sales order form with the equipment on the second sheet as "PartNo"
"Description" "Cost" selected each column of data then clicked in the
cellname box and called them "PartNo" "Description" "Cost"
On the sales order form I have the columns "Qty" PartNo" "Description"
"Serial No" "QtyDes" "Price" Total"
I have set up data validation for the description as a list with
=Description what I want it to do is display the part no in the part number
Column and the cost in the price column. Also the list only shows the first
eight items with scroll bars is it possible to show more of the list I.e. 20
lines
Thanks in advance
Mark