method of selection

[gavmer]

Hi all,

I have a workbook used to build macinery specs. Column A contain
options and column D contains pricing. I am after a method of selectio
where the content in the pricing column would copy to column B besid
the option. (pricing column is hidden).

What is the best approach to this?? I have considered mayb
checkbox/option button for each option????? IF so, how would i d
this??

Cheers to all!!!!

 

[Frank Kabel]

Hi
not really sure what you're trying to do. Could you give an example?

 

[gavmer]

Hi Frank,

Column A contains options. Column D contains pricing of these option
(hidden column). I need a method of selection where the user select
what options they want by maybe clicking a check box next to the optio
they want. The price of that option will copy into column B beside th
option selected. Also, if deselected, the price will remove from th
column.

I hope this helps frank.....thank you!!!!!

 

[Frank Kabel]

Hi
o.k. lets give this a try:
- link your checkboxes to column C
- enter the following formula in B1
=IF(C1,D1,"")
and copy this formula down

 

[gavmer]

Hi Frank,

That seems to have worked a treat. lll test it in my complete workoo
and see how it goes.

Cheers.....once again :-