I want a collumn of a table to be only to accept certain values.

[alexcjames.87]

Sorry if this is in the wrong area of the forum.

I'm making a budget with excel, and I have a table set up, and I want it to only accept certain values like "Housing - Rent", "Utilities - Water", etch. for what the category of the expense will be. I've seen other excel workbooks set up to where you enter in one table a set of values, then in another table you are only allowed to enter those values into said column or else it won't let you input any values.

I'm trying to figure out how to do that, but can't find any good tutorials online, and I can't figure it out by viewing an excel workbook that does what I'm trying to do.

If someone can help me I'd greatly appreciate it!

Thanks in advance!
~alexcjames.87

[etaf]

you use data validation
and choose the list
http://www.contextures.com/xlDataVal02.html
OR
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[alexcjames.87]

That will work wonderfully!

Thank you so much!

[etaf]

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here