Looking for help with a list in 2003 Excel

[Bren312]

Hello, I'm trying to do something in Excel 2003 and I can't figure it out (if it's even possible). I have created a menu planning spreadsheet with a list of all of the things I can eat (on a special diet). I want to be able to copy and paste words from this list in a different part of the spreadsheet (the copied words will not be in the same order as the original list) and have a message pop up in the cell next to the food in the original list so that I know I've already used it. Hopefully that makes sense. I don't know what this would be called so I didn't do a search for it. Thanks!

Bren

[Miraun]

Hey Bren;

What you're looking for is called Data Validation. Basically, drop down lists. You can program Data Validation drop down menus to reference named ranged that you've identified elsewhere in the workbook. I could go into a long explanation on the topic, but instead, I'll reference a pretty good website that breaks down how you can use data validation...

http://www.contextures.com/xldataval01.html

However, you don't need to protect the sheets like it's recommending.

[Bren312]

Thanks, Miraun! I appreciate your help, and the link. Haven't had a chance to check it out yet but I'm sure it'll do the trick.

Bren