Forms and Databases

[lcoughlin]

Hello there,
I want to create a form in excel for gathering client information, and spitting out quotes using unique contract numbers AND then collecting that data in a spreadsheet. I would like the form to open up blank with the next contract number in sequence, but then if I click the record from the collection - that all the information be filled in automagically into the form.
I've read most of the posts and found nothing similar, although if there is one already posted, perhaps someone could link it for me.
Thanks

 

[gavinkelly]

Using microsoft access would probably be more suitable for this. forms are easier to create.

 

[Kenneth Hobson]

See http://www.j-walk.com/ss/excel/tips/tip92.htm