Check Boxes to generate quote from price list

Hello,

This is my first post on the forum and I need your help to solve my issue.

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 am stuck on whether I should use a VLOOKUP fonction and several tables or if it is possible to use a macro.
Could you please help me to solve this question ?

Thank you,

Arno

Try This:-
To Run Code change CheckBox Selection in "Price List" CheckBoxes

Awesome, this is exactly what I wanted !

As my table "pricelist" should be update with my data and that column should be added, I will have to update the macro accordingly. I guess that I will need your help if I am stuck with these modifications .

Thank you very much for your help

You're welcome