Help with a simple form

[Guest]

I need help with a very simple form. I have a glossary for my team defined
in Excel. I want to set up a form that will let them key in the first few
letters of either the acronym or the term itself and show all items in the
worksheet that start with those letters. As you key more letters, it refines
more. Kind of like the index function in Help.

Secondly, I want to set up an input form that a user would fill out that
would then save that information into a second spreadsheet (behind the look
up one). Then an administrator would review those entries regularly and add
the entries to the main glossary as appropriate.

Any help would be appreciated.

 

[STEVE BELL]

You can try to use Conditional Formating.

Set a cell for user input.
Select all the cells in the glossary.
Go to
Format >> Conditional Format

Set 'Condition 1' to "Formula Is"
(Using R1C1 notation - change to this in Options)
=Find(R1C1,RC,1)=1
and set the format.

R1C1 is the cell for user input.

Now if any of the cells starts with whatever is in R1C1 ($A$1) it will take
on the format.

The input form is a little trickier. Send me a sample copy with details and
I'll try to do this for you.
(Beware - I am working on another project my response may be a little slow).

(e-mail address removed)
Remove "AYN" from email to respond