Put the data into a List (Excel 2003) or a Table (Excel 2007). When data is
added just below a list or table, the list or table expands to include the
added data. Formulas that refer to whole columns in lists and tables keep
referring to the entire column even as the column changes its number of
rows.

Alternatively, put a blank row below the tabulated data, color it yellow or
gray so it looks different than a data row, but include the blank row in
formulas that analyze the column. Train the lab monkeys to insert one or
more rows above this shaded row and put their data into the inserted rows.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"John" wrote in message
...
I want to write macros that will automatically update the spreadsheet when
I
add further data. For example I have 10 columns x 8 rows of dat and write
a
macro to generate average and standard error of the mean in the cells
below
each column. Later, when I get the results from the next set of
experiments
I insert a further 8 rows of data giving me 16 rows in all. Is it
possible
to construct a macro that will handle this or do I just have to insert the
formula again this time for 16 rows?

This may sound trivial but we have lots of data accross many different
experiments and it would be more elegant and efficient if I could produce
a
spreadsheet that our students could just paste their results into that
would
do the necessary calculations for them.
--
medjpb