It seems that this could be done using a formula. What is the contents of
cell B1 if it is not "Y"? If it is blank, then you could try this formula.

In Cell B1:
=IF(A1="AA","Y","")

In Cell B2:
=IF(A1="AB","Y","")

HTH,
Paul

"RemySS" wrote in message
...
Hey all,

Does anyone know the code to auto-populate cell B1 with a "Y" if cell A1
has
"AA" in it, and cell B2 with a "Y" if cell A1 has "AB" in it? The cells in
column A could have anyhting between AA and AZ, but the corresponding
column
B will always have a "Y" depending on which letters are in column A. Make
sense?! Sorry if its rather ambiguous, I'm crap at VBA and could use the
help!