I wish to create a simple excel sheet / form that will enable us to add a list of customers whether manually or in bulk.

When the customer name is inserted into the first cell of the row, the remainder of the row will become visible and have 7 input parameters on the subsequent columns. Two of the columns are simple radio / option buttons and the other 5 columns will be simple pull down lists.

They key is the conditional non visibility of the cells until the customer name has been input.

This should take all of 5 minutes for someone really familiar with Excel.

Also, we are using excel 2000 so compatibility of a file made on a later version is probably not going to work!!