Excel Numpty newb needs help

[Fanum]

I can do a basic spreadsheet but I've never really played with Excel and this is beyond me...Ive googled and keep on getting descriptions of macros and complicated check sums that I don't understand....so I'm hoping some excel guru here might be able to help me knock up what I'm after or point me ast some idiot proof instructions or templates

This is to go on a website.......it's very simple (I hope)....all i want is a list of 8 options, a tick box to select one or more than one, and a total of the items selected

I need to be able to tart up the table but I can do that.....once i've got a basic working example

Could anyone help please?


The principle;

 

[Clive]

This is to go on a website.......it's very simple (I hope)....all i want is a list of 8 options, a tick box to select one or more than one, and a total of the items selected

Do you mean this table is to appear in a Web page, in which case Excel doesn't come into it, or do you mean you are providing a downloadable Excel spreadsheet with that table in it ?

 

[Fanum]

It needs to appear on a web page.......I presumed I could embed an excel sheet

Hmmm.....if I can't, I guess I've been googling the wrong thing.....I'm using Dreamweaver 8 .....I'll have a look for form templates in Dreamweaver

 

[Clive]

It needs to appear on a web page.......I presumed I could embed an excel sheet

Only if all your customers will have Excel installed - take a look at http://www.mredkj.com/javascript/orderform.html for simple examples

 

[brassmonkey001]

I don't want item 4.

 

[Fanum]

I don't want item 4.

You haven't seen her yet

 

[Fanum]

You know how you find something online and wish you'd found it months ago???


SOME REALLY NICE DREAMWEAVER TUTORIALS

Still not sure how to do this adding up price list thing, but I'll get there

 

[snoopy]

It depends what you are doing with the output. If you are storing it then you need to use Perl/php to check which items are checked and sum them up, otherwise use Javascript.

Either way you need to use a form: code is like:

<@form>

<@input type="checkbox" name="wheels" id="wheels" checked>
<@label for="wheels">I need wheels @ £120</label>

<@/form>

Try copying that into Dreamweaver and get the form the way you want it. I'll then help you on the Javascript if you just want to show the total. Remove the @'s btw.

 

[Loiq]

would it not be easier to build a database in droople (open source stuff) and then you can create a shopping cart style tool...

or am i benig fick.

 

[Taff]

You know how you find something online and wish you'd found it months ago??? Still not sure how to do this adding up price list thing, but I'll get there

I won't be able to help you with inserting anything into a web page Bill, but if you just need help with creating some Excel formulae & adding up a total (it looks very straighforward) let me know.