Hi Experts,

This is my first post - I've been reading and getting lots of help on my own.

What i'm trying to do is build a form for my end users. for a certain field i want them to enter text. i'd like a macro that takes that text and compares it to a set table on another sheet that i've Named.

Example.

Cell D19 = spot users will enter data

Sheet Other A20 - A256 (A20:A256) is the list, i have it named Ext_Mat_Group

If a users enters a Ext_Mat_Group that is in the list do nothing.
Else "(What they entered) - NEW"

Thanks,

Dex