Hi adey,
You are probably using the fill handle to copy rows down including
formulas. If not you should first become familiar with it.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
But if you have a total at the bottom of your rows or want to insert and
delete rows it can be more complicated so suggest you read
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
The formulas and constants are generated the same as with the fill
handle, the the macro will also remove the constants from the
inserted rows.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"adey v." wrote in message ...
Is it possible to make ongoing entries one one worksheet ,automatically fill
to the next available line (row) on a linked spreadsheet? I'm so tired of
making huge , and largely blank, worksheets just to accomidate for every
poosibilty of where info could show up. Thanks everybody out there for your
help - you've been super!
adey v.