I need advice to develop an application using excel to develop a "shopping
Cart" procedure.

I have a excel database with product codes and specifications as a table :
headings are in columns and data is in rows. I have many (12) worksheets
where customers can choose (single option botton..True for selected False for
non selected) from diferents segments and products. In each worksheet
customers select or no the right product for them.

The problem:

The database is used to extract references like product name and other
specifications (using funtions like index and vlookup) so if i change the
secuence (order) the specfications will change or get a data error.


The issues here a

1) How to develop the procedure to extract only selected items from database
when the customers click on an "add to cart" button or something like this?

2) How to develop a procedure to put the selected items (extrated above)
into a pre formated customer invoice?

Considerations:

I will also appreciatte If somebody tell me where i can found an example
for this.

Thank for your support.

regards,


alex
madrid-spain


This application will run for only one customer per session.