I have this program created with the help of many smart people in the user
group & many thanks to all that help.
I have a bolt list sheet and a summary sheet with "sumproduct" formulas that
retreive from the "bolt list" sheet, quantities of different bolt diameter
and length.
But in order for the summary sheet to work, I must input: diameter & length
in the appropreate cell for a specific grade of bolt.
In other word the, "summary" sheet retreives from the "bolt list" sheet and
I would like the in formation from "bolt list" sheet send to the "summary"
sheet without any input from the user.
Is this request logicaly possible? If so, would someone guide me in
acheiving this method please.
Many Thanks
Serge