I am creating a web site which is currnetly in HTML code exclusiveley.
I need it to have 2 things which i don't know how to make

1. I have an Excel Spreadsheet that processes data using a series of formulae and a simple macro
I would like people to be able to log onto the site, put in data and then for them to be given the result.

2. I would like people to be able to input data in a seperate form and then i would like this data to be logged in a database or submitted to me in some way. (I can create a macro to convert this data)

If anyone can help me that would be great.

I haven't yet purchased web hosting but the one i am looking at supports/contains all the following:

MS SQL 2000 databases
MySQL databases
Shared SSL
Webmail
Frontpage Support
ASP.NET, ASP, PHP, Perl
SMTP server

Please help me someone!

well looking at your list you don't need all of those things.

If you decide to get webspace then the likelihood is that a corporation will probably either be running a Windows OS (Windows Server 2003 etc) or some build of BSD (Although Linux is not ruled out)

Depending on the OS you pick will then decide which you are more likely to deal with. For instance ASP.NET and ASP will only really be found on the Windows servers, since it's native to them. (I personally stay clear of them however thats entirely down to your preference in which Script language you want to program in to be the gutts of what you are doing).

Personally I would vouch for either PHP or Perl, PHP is seen as easier to most, although I'm fond of Perl. Again both of these are scripting languages that will do the work you want, you can have any or some of these languages, however just remember the more languages you toy with the more time it will take to learn any particular one.

Most BSD servers will come with an Internal SMTP server as standard, or if you are dealing with a shared hosting package you'll have the capacity to hook to an SMTP server to send outgoing messages via e-mail.

As for Databases, SQL has a particular language and the MS SQL and MySQL databases are just their own different flavours which are meant to be better equipment for certain language usage. (For the most part ASP, Perl and PHP can hook to any of the Databases without problems) Again you only need one, I personally used MySQL with a BSD system however if you pick a Win server you'll probably use MS SQL.

Depending on your SQL server and the people that supply you with access to one will decide if you can access the database externally or have access only through scripts run in your webspace. (With the most recent iteration of OpenOffice it's possible to access SQL databases to move spreadsheet data to the database, but only if you have the ability to access the server externally)

As for Webmail, thats usually handled by who ever deals with your webspace providing. It is possible to create a script to handle your own webmail if you are running a dedicated server with it's own mail server, however looking at what you are after this isn't something you need to worry about.

Frontpage Support I'm not too familiar with since I don't use Frontpage, I'm guessing it relates to the usage of an MS product for quick HTML/Script insertion through a WYSIWYG GUI but I could be wrong.

The Shared SSL is just a way of saving money, SSL servers that allow the "Secure Socket Layer" method of web access usually require "Signing" with a "Certificate of Authentication", which just means the server is vouched for by someone reputable as being authentically what it claims to be. Since you aren't running your own dedicated server there is no need to worry about "Snakeoil" (Self authentication certificates)

You should only worry about SSL if you intend to write programs that will require secure connections like Credit or Data transfers. (Just remember if you do write scripts in the future to innitiate SSL before asking for passwords not the other way around)

I hope this gives you a brief look into what you are looking at and for, just try to keep it simple, stick to one language if you can. (PHP/Perl recommended on BSD/Linux systems, potentially ASP on Microsoft ones although both PHP and Perl can function on them too, just differently with the use of Binary files)