Thank you very much that works great.

Now how do I make the sheet hidden? Also, is there a way to write a macro
or something to create a button to toggle between hiding this sheet and
letting it be visible.

Thanks,
Kyle

"Jim Jackson" wrote:

If I understand what you are asking for, drop-down lists should do the trick.
On the hidden sheet, insert the list of choices for a particular column on
the visible sheet. Place a title at the top, highlight all the cells except
for the title. In the address box (upper left of screen) type the title you
have chosen.
Click on "Data/List/Create List". Your chosen cells will be represented on
the dialog box that appears. Click OK.

On the sheet to be updated highlight the range of cells in a column that
fits the list you created. Click on "Data/Validation". Choose "List" from
the choices. Type "=(your title)" in the Source box and close the dialog.

You should see a drop-down arrow which, when clicked, will display the
choices.

Jim

"kyle" wrote:

I have a program with quite a few macros, so the formatting of the names used
in the program must be identical. I thought I could remedy this by adding a
database of some sort so that they would be forced to pick the name from a
list. I am quite in the dark about all of this and actually got the idea
from someone else on the discussion group. If someone could briefly explain
how that would work or a way to write the macro I'm looking for that would be
great. I would need the list to be updated by other people if that helps and
the person I got the idea from used a hidden sheet.

ps. if you need more information about something just let me know, I
understand if it's a little confusing since I'm quite confused.

thanks,
Kyle