I need to set up a form to help in adding data to a worksheet.

How would I go about setting up a form for the following Worksheet:

Reciept | Date | Details | Amount | Security | Entertainment | Gambling
| Groceries | Misc

The form I require Should have a text box entry for Reciept Number,
Date, Details & Amount, Then it should have a drop down box for the
type i.e Secuity, Entertainment, Gambling, Groceries and Misc.

The amount should be displayed on the worksheet in both the amount
column and also under the selected type.

The entry needs to be able to press tab to got to each field and then
enter to add it to the row before moving onto the next row. It should
insert a new row for each set

At the botom of each of the amount to Misc will be a row of total cells
and below that will be a cell that displays the total of the totals
row.

Any help with this would be much appreciated thanks as im well out of
my depth.


--
rochdalemark
------------------------------------------------------------------------
rochdalemark's Profile: http://www.excelforum.com/member.php...o&userid=10792
View this thread: http://www.excelforum.com/showthread...hreadid=545552