Quote from a Price List using macro

Hi,

I would like to use check boxes on a sheet to display tasks (and corresponding price) from a price list in a different sheet.
Check boxes would be used to select a "department", a "Process", and other sorting options to generate a list of all the possibilities and their prices. Checking and unchecking the boxes would update automatically the list (see attach file).

I already asked for help previously (see post: "Check Boxes to generate quote from price list" posted 05-28-2018 - can't add the link as I have not posted enough on the forum ) and a macro that fit my needs was generated. However, I tried to update that macro in a larger price list but I was rapidly stuck as I am not a great specialist in VBA.

Additionally, I would like to select tasks that will be performed among the list of the possibilities obtains after checking boxes in order to generate the total price.

Could you please help me to update the macro to fit the new file ?

Thank you,

Arno

Hi,

Had someone the opportunity to have a look to my request?
It would be great if the community can help me to solve this as I am using this file quite often.

Please let me know if you have any question on that request.

Thanks,
Have a nice day,
Best,

Arno

Hello,

I am still looking forward some help on this issue. Would someone had a chance to have a look into the document sent?
Let met know if additional information is needed.

Thanks.
Arno

Hi,

Indeed since the first post, some check boxes were removed and other added to fit the "Price list" sheet that has now more columns and more choices.
I struggled a while to update the macro that was generated after my first post but I was stuck as I have not enough VBA knowledges...

Let me know if you have any question.
Thanks for your help.
Best,

Arnaud