Hey all,
I have an Excel (2007) file that does pay calculations for delivery truck drivers for the company I work for.

There are 3 sheets--the first is where drivers input information, which has a whole slew of dropdown menus, etc., the second is data (text = value), and the third is the sheet where everything is added up and calculated (intended for management). It works GREAT locally.

I'd like to have this go online.

Here's what I need: the first sheet to be interactive, including the dropdown boxes. A submit button that would SOMEHOW (e-mail, creating a PDF of sheet 3 and saving it to the server, saving a new XLSX to the server with a diff name) get the results to me.


The question is simple. The answer probably isn't.

How do I do it?