Creating a form where you enter the data you know and the rest will automatically populate

Hi,

I have a spreadsheet containing lots of data pertaining to people on secondment, including name, home and host location details, start and end dates etc.

The built in 'Forms' function in Excel 2003 is limited, not least because of the maximum number of fields in can show. I'd therefore like to design a form where I can enter the data I know, i.e. a person's name, and the rest of the form will automatically populate from the data in the main sheet. If I then update or amend the details shown, I want it to update the main spreadsheet data too.

Is this possible? Can anyone help?

Thanks in advance.

catmadjulie

Thanks for the example RoyUK.

On my database sheet I have perhaps 40 columns shared between two sheets (one populates the other with the shared data). These have records (rows) relating to 100 or so secondments. It would be great to be able to pull up the details of one secondee in a printable page area just by entering their name (or other info) in a form and seeing their status or missing actions required etc.

The link you sent me previously will enable a new record to be added, so that sorts that part of the problem out. Thanks again.

catmadjulie

Many thanks RoyUK,

I'll check it out and see how I get on.

catmadjulie