Price List Template

It's definitely possible, roprice806, but it will take a pretty good knowledge of Excel to do it.

If I were doing it, my initial central focus would be on turning your Pricing sheet into a single database, on the basis of which you could create queries using the various Database functions in Excel. These are the several functions that begin with D_____, such as DSUM, DGET, DAVERAGE .... and these could be used to populate a Bid based on the selections made in your initial template.

Are you comfortable enough with Excel to take that suggestion and run with it?  It's entirely possible somebody else would approach it differently. One of the great things about Excel is that there often are multiple routes to the same destination. Anyway, given a bit more time I could put together a simple sample.....