Hi Everybody,

Apologies if this is an easy one, but I am not an Excel afficienado in any way. Just know the basics. So where I need help is as follows:

I am trying to put together an excel spreadsheet which will ultimately put a quote together and export it to MS Word - but more on that later.

What I am trying do is have a user select a checkbox from a number of options, and depending on the checkbox selected the part number, quantity, description, price will be populated on the same sheet further down. The part number, price, description etc will be fixed and found on a hidden sheet for admin purposes. In addition I'm wondering if there is a way for a comparison quote to be put together ? So User chooses option 1 from section 1, option 2 from section 2, and then option 1 from section three, could I have a comparison checkbox which takes the unselected options and quotes them as well ?

Once I have solved all of this I would like the quote section to be exported into MS word - but thats for the future.

Does anybody have any help on the problem above ?

Thanks a bunch

Compaqact

If you need further details please let me know