I am using MS Query to import external data. The number of rows imported
changes (inceases/decreases) based on user defined criteria. I import into
columns A-D but have a many columns linking to the data using formulas

In excel 97-2003 there was a useful little piece of functionality that
allowed you to fill adjacent formulas so as the extrnal data range
expanded/contracted the adjacent formuals and hence named rnages would also
do the same.

Does the same functionality exist in Excel 2007. I can't find it anywhere.