- Nov 16, 2005
I want to make a sheet and a check sheet. I would like it to work like this (becuase i don't know how to describe it anyother way). On the first sheet is blank. The second spread sheet has these animals listed fish, frog, turkey, cow, pig. Now what i want to happen is that when i'm typing in the first sheet if i type the letter f Fish will show up in the cell i was typing in. If i then type a r (making it fr) frog will fill the cell. Is there anyway i could do this. Any help would be appreciated.