Hello,
In a nutshell: I am putting together a database. I created a search
"grid" that allows the user to choose a name from a data validation
list. After selecting a name, the grid (shows 4 locations across, and
the 12 months down) uses Sumproduct to count the number of units the
selected name has for each site, in each month.

The problem: I would like to use this database over a few years. Each
year I will be adding almost a thousand entries. I have been using a
set range, eg D7:D10000, for Sumproduct to search. I have an old
workstation at work, and after each entry it can literally take 2-3
full seconds for the workbook to re-calculate. It has been suggested
that I use a dynamic named range using
=OFFSET(Data!G7,,,CountA(Data!$B:$B),1), instead of the range I
indicated above. This would allow the formulas to only look in the
actual range, instead of a bunch of blank cells.

I haven't been able to put this to a try yet. So my question is---am I
on the right track? Is there a different technique I should be
considerin?

I hope I have explained this clearly enough. Please let me know if I
can supply any other need info.

Thanks,
Don