Hi All
I am comfortable in Excel but not an advanced user so what I want to do is exceeding my knowledge base:
I am working on a spreadsheet - 200 rows
Each row = 1 product
Each product has local and overseas manufacturers with the local manufacturers not being a problem. The spreadsheet already has some formulas.
The overseas manufacturers (4):
For each manufacturer is a base price which is determined by a tick box (calculated on a different spreadsheet)
price calculation for the product is generally based on the minimum price but at times it might have to be overwritten to select a certain manufacturer
The rule is: minimum price which results in the manufacturer and the price to be copied in the relevant columns going forward.
Exception: User selects manufacturer over price.
I thought about using option buttons. 1 button for each row as default = minimum and one for each manufacturer as selector. Which meant 1,000 option buttons with 5 in each group. Having played around with it a bit I quickly realised that this is a ludicrous undertaking and am hoping someone has a better solution to this. I have no knowledge of VBA but am great at cutting & pasting code and stitching it together.
I have a sample file attached and hope it makes sense.
Hope even more that one of you smart people can help. Thank you in advance
Bookmarks