I appreciate the replies. However, I still need additional guidance.
now know I might not have been as clear as I could have been i
describing what I wanted.

The VLOOKUP sounds like what I need for this. I had used it elsewher
in the workbook and it never crossed my mind to use it there for som
reason. The sheet with the list of codes has 3 columns on it.
Column A -- the various letter codes (i.e. A, B, C, D etc.)
Column B -- the number of cells I need the value in Column C to b
entered (i.e. 1,2,3,4 etc.)
Column C -- the value to be entered (i.e. 5,000,000)

So, after I enter the letter code, I need VLOOKUP to reference column
for that particular code to determine how many cells it needs to plac
the value from Column C in. I hope that made sense. Is this possible
Perhaps with a tweak to what was posted before? Thanks again for you
help so far.

Tro

--
Message posted from http://www.ExcelForum.com