Hi.

I have an excel worksheet that I would like automated, so that it can be used as a price calculator. First of it would be nice if someone could point me in the right direction for the questions later in the post, and to answer if what I want to have the excel sheet do is possible.

So first thing first. The excel sheet is a multi page sheet with lots of different products, all with the same formating. What I want to do is add a button besides each different product so that you can click the button, and then the product is added in another sheet, one after another, with a total sum and transport cost at the bottom.

I also need it to work so that when I am in the category selecting page (this is already working) I can click a button, and it removes all the products added so that I can start over.

When the right products are selected, and an amount for each is chosen (default 1) I want to be able to export it to a word document that also contains a logo and some default text.

Is this something that can be achieved with Excel, with macros or some clever programing?

Thanks in advance for any help and directions.

-Voffel