The most straightforward way of doing what you ask is with a formula in
column c. For instance, you could enter this formula into C1 and copy it
down:
=IF(A1="Keyword", B1,"")
Then, if in the corresponding row in column A you type Keyword, the cell in
column C will display what is in column B's cell. If not, it will display
nothing (which is signified by "")

--
Kevin Vaughn


"Leo Edwards" wrote:

Hi there,

I'm not sure whether this is possible, but is there a way in which typing in
a specific word would result in information being copied from one cell into
another?

In simpler form: 'Keyword' typed into cell A (after verification) causes
data to duplicate from cell B into cell C.

Sorry to ask such a simple question, but any help would be greatly
appreciated!

Thanks

Leo