Retrieve data from excel database

[Vanya Noble]

Using the Template Wizard Add-in, I have created a form/template and have successfully sent inputs to an excel database. Is it possible to retrieve data from the database back into the template? The purpose of this would be to provide a copy of the details to each client.

 

[BrianB]

I have not used the Wizard. It looks like, in my ignorance, that it will not do what you want because you need to have a way of finding & reading an existing record. Seems to be an oversimplification.

menu Data/Form may be of use - but you still need a way of finding an existing record.

It is possible to have a separate worksheet "form" that will display single records. Could add code to update the database. Similar principle to my code below.

In the absence of another reply, you may prefer to use a UserForm method which will read and write records, and a button can be added to Find.

This is so commonly required, and simple, that it is amazing why MS has not done it as standard.

http://www.mrexcel.com/board2/viewtopic.php?t=272831