Hi,

I have received some excellent help from this site, and have now finished the work I needed to do.
I'm just wondering if i could make life easier when updating my database.

I currently have 14,654 rows and will be adding about 200 or so each month next year..
I am using 12 formulas which pulls data from all rows, but am wondering if instead of say A2:A14654,
I could instead say A2: the bottom row. (I use A1 for titles) is there a way to do something like this?

also, My formulas vary in format Eg..

=SUMPRODUCT(($J$2:$J$14654=$AB2)*(V2:V14654=2),--(W2:W14654=0))

=MAX(IF(J2:J14654=AB2,IF(Y2:Y14654>1.9,IF(M2:M14654<=100,D2:D14654))))

=SUMPRODUCT(--(V2:V14654=2),--(W2:W14654=1)) etc..

some have $ signs, and some are of different formats... will this have an effect when i add more rows?

I just want to make as easy as possible to update my database, and not have to worry if my results are accurate or not.

Thanks all..