we have a number of electronic forms in word. but is there a way to use excel
as a database so you quickly pull up the form which you need

Another job for Excel's handy =Form-That-I-Want() function.

"johne" wrote:

we have a number of electronic forms in word. but is there a way to use excel
as a database so you quickly pull up the form which you need

but seriously, yes, you can make a table with information about the form to
search or sort on, and in one cell you could Insert/Hyperlink to the form and
clicking on it would bring it up.

"johne" wrote:

we have a number of electronic forms in word. but is there a way to use excel
as a database so you quickly pull up the form which you need

if using a checkBox, is there a ID for that checkBox?
So that if that if it is been checked, it will capture that data.
Some thing like:

male [ ] female [ ]
if i checked male [/]
the male data is collected inside a new worksheet.



"dlw" wrote:

but seriously, yes, you can make a table with information about the form to
search or sort on, and in one cell you could Insert/Hyperlink to the form and
clicking on it would bring it up.

"johne" wrote:

we have a number of electronic forms in word. but is there a way to use excel
as a database so you quickly pull up the form which you need