Hi,

Not sure if this is even possible on Excel but though best ask the experts .

I have an excel file with 4 boxes -

Name - Text Box

Number - Text Box

Type - Drop Down

Date - (Calendar selection)

This is a shared document that various people can be in at one time, basically I would like excel to save the information entered into the name, number and type box into another file with the corresponding date.

For example enter Mr Smith, 12346, Blue and select the date 01/05/2015 - This then saves into a file already created called 01/05/2015.

And as more information is added to the day the rows just fill up with the information? Its probably something I need to do on access by looking around online but have no experience of this.

Thank Yu