Automating Spreadsheet Formulas

Hello all,

This question is basically in reference and extension to an original question I had posted many, many years ago (8 years ago). Post #5001478

With the help of this forum, it got me over my hurdle and through reading & experimenting I was able to tinker & fine tune my worksheet to my needs. Times have changed and I am looking for help & suggestions on how to modify my original costing spreadsheet to reflect my current needs. FDibbins, suggested I create a new post regarding my updated questions.

As well as doing phone sales/orders, I am finding myself bidding on more and more bid tenders for my products. While I have find tuned the original look up solution provided by ConneXionLost, to auto round up the next highest Customs value, I have a few other ideas I would like to implement on this sheet to better serve my needs.

Basically,

1) The "Our Costs" tab - Is it possible to have the sheet ask me whether I want Brokerage pricing on individual or multiple items and automatically insert the correct formula in the cell? Some of my bid tenders are awarded individually and some are awarded on a whole.

2) The "Mark Up" tab - Is it possible to again have a pre-defined drop down box with pre-filled in percentages instead of scrolling across the entire page(s)?

I have deleted a few of the non-necessary tabs (trailer space, local/national taxes) in this worksheet.

I also have another question regarding multiple column matches, but will plug away at that one on my own or ask in a separate thread.

Please find attached a copy of my current costing sheet in it's present state (names/products have been altered to protect their identity).

Any help or guidance in how/if this is possible is much appreciated.

Thanks again for the abundance of info on here.

jeeperv6

Hi FlameRetired,

Thank you for your suggestion. I do have a basic understanding of the drop down box/list concept. But I would need my formulas entered in as a wild card, would I not? For an individual item, I could just use a partial absolute reference in broker column (ie $J6) and Excel should pick up which cell I'm in (ie $J18) automatically and use that cell reference? Would that work if I needed to use multiple items for brokerage as I do in J4?

Thanks again!