Filling in a cell automatically when a new record is entered

  • Thread starter Thread starter Sarah
  • Start date Start date
S

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!
 
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
 
Back
Top