Creating a database within my template


L

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
 
Ad

Advertisements

M

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.
 
Ad

Advertisements

L

Logan

Thanks Mark

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top