Hello Matt,

do you have Excel 2007?

If so, just convert the range into "smart table" (Home/Format as table)

Then any update to the table (adding new rows) will automatically copy the
same formula.

Milan

--
Milan Bortel

MCAS, MCTS
GOPAS Computer Training Center
Brno, Czech Republic


"Matt" wrote:

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.