Filling in a cell automatically when a new record is entered

[Sarah]

Is it possible for a cell to automatically populate when a
new record is entered. Example, Info is entered into A1
and C1 has a value of Frank. When info is entered into A2
can C2 automatically pop in Frank? Thanks for any help you
can give me!

 

[Bernard Liengme]

You have not explained if Frank is the only possible entry in C2 but here
are some suggestions for formula in C2 (copied down the column as far as
needed)

=IF(ISBLANK(A2),"","Frank"
=IF(ISBLANK(A2),"",A1 you get the same value as in A1

Tell us more and we will try to help

 

[Don]

Try...

In C1

=IF(A1="","",C1)

Cheers,

Don

 

[Don]

oooops........sorry.

Enter that in C2

Too early here......