Where does the information come from. You will need to enter it at least
once. You could use Define Name, or AutoCorrect to do this. Help covers
both.

wrote:

i want to be able to enter a code for example s1 into a cell and have the
information i need be put in that particular cell .