Creating a database within my template

[Logan]

I would like to start to build a database of persons
details within my workbook template.
My idea is that each time Sheet1 is filled out, the persons
details (ie Surname, Given, DOB, Address, etc.) populates
to a database sheet that is hidden sheet in the workbook.
When the person is done filling out this sheet it gets
saved as an xls in another folder. This done with a macro.
I would like the database sheet, with this persons details
to stay in the template and each time the template is used
it stores the persons details, thereby building the
database within the template.
In the future I would like to be able to query the database
prior to filling out the sheet to see if the person is in
the database. If the person is there I would like to import
their details in the sheet.

Is this possible. If so can anyone point me in the right
direction.

Thanks

 

[Mark Rosenkrantz]

Logan;

Maybe a tip on my website : www.rosenkrantz.nl might help.

Point to : Excellent Files | Tips | Books & Sheets | Dynamic Database.

This could be a handy example.
Mark.

 

[Logan]

Thanks Mark

That gets me moving in the right direction. Just have work
out how to work into my Save As macro.