View Single Post
 
Old 12-19-2016, 06:33 AM
mrettler mrettler is offline Windows 10 Office 2007
Novice
 
Join Date: Nov 2016
Location: central, WI
Posts: 11
mrettler is on a distinguished road
Default

Yes the table would always include either "1" to identify the intersecting row of the tractor and the parts available or it would be left blank.

The other question was in reference to the formula's working on one sheet but the actual tractors and parts on a different sheet or tab. I would like there to be two and maybe three tabs (or worksheets) in the file. The shop mechanics would use sheet 1(possibly labeled parts lookup, and would only see the popup box and the parts available. Sheet two would be used by the shop foreman and would be the actual table with all the tractors and parts. This table will end up very large as we have close to 100 pieces of equipment and hundreds of parts.

Matt
Reply With Quote