Creating an interactive price list in Excel

I will outsource the creation of an interactive price list template in Excel, which, when generated to PDF, will be ready to be sent to the client (so also preparation in terms of visuals)

Functionalities:

- drop-down menu of products (product ABC)

- packaging type of product ABC

- 4 product categories

- fresh/frozen product (not all packaging types are available for fresh and frozen product)

- currency EUR/PLN/GBP

- automatic price calculation based on the base price of the product + margin + packaging price

- automatic price conversion in GBP and EUR on the basis of the base price in PLN

- possibility to generate the whole list/price list as well as several/several selected products

- optional possibility of product images (so that it generates in PDF)

examples:

Wants to send customer #1 a quote for ABC products in ABC packaging configuration with prices in EUR, using the same file wants to be able to quickly generate a quote for customer #2 BC product in C packaging configuration in GBP.

Product A in the base version costs 20PLN, in packaging A + 2PLN, B+1PLN etc.

Attached is a list of products (partial) which is at the moment) and I will send graphic materials for insertion (logo and background, font)

If you have any questions, please contact me.