how to have cells automatically fill when entering value in ref

[Matt]

How do you automatically fill in values down a spreadsheet. I have a formula
in cell A1 that references the value in B1 (ie ="text"& B1) When I enter a
number in b1 (ie 55) cell a1 then reads "text55".......here is my
question.....I want to add a value to B2 and have A2 fill in the value from
above without having to copy afterwards. I have a workbook that functions
like this but cannot figure out how it is done. No values appear in A2 until
i hit enter after filling a value in cell B2 and hitting enter.

 

[Basta1980]

Hi Matt,

Perhaps there's some VBA in that particular workbook with a change event.
You can check that by pressing ALT + F11. Anyway I reckon that VBA works best
with wath you like to do. In the Programming forum you can find all sorts of
inof on programming.

Regards,

Basta

 

[Daryl S]

Matt -

Try this formula - if there is nothing in B1, then you won't get the stray
"text".

=IF(len(B1)>0,"text"& B1,"")

Look at the forumulas in the other spreadsheets you use to see what they
test for.