Hello all. I am creating a bid sheet and would like to have on my header column a cell that is titled "%Profit". I would like to be able to click on that header cell and have drop down options which allow me to choose between varying percentages (%50,60%,65%), click on desired percentage, and have my choice applied to all of the amounts in the column directly below. There are several places I would like to apply this type of function on my sheet, but for this example, the details are as follows: The header "%Profit" cell is G1. This column continues down to G19. The previous column, "Cost" Is F1-F19. My goal is to apply which ever percentage I choose in my drop down category of G1 to the cost given in the "F" column. I hope this is clear and that what I would like to achieve is even a possibility. Thank you to anyone who may be able to provide some insight. -WFK