Duke,
Thanks for your answer. I need to alter the formula so that I can take a
range from sub document rows and pull them into master doc rows. From your
response I understand how to fill down in such a case, but how do I fill
across? (sorry...beginner here).

To be more specific...I need to take range A1:E1 from subs, and take it into
master doc range A1:E1. The subs will be updated every week.

Thanks in advance.
Brett

"Gnomie" wrote:

I need to extend a fill series using ref's from sheet 2.

Sheet 1 info needs to fill "down" the rows.. and the info it's referencing
is "across the columns"

How do I extend the fill series to run : A1
B1
C1 etc.. ??
Losing all my hair over this and wha'ts left of it is going Grey!!..

If it was only 1 worksheet I wouldn't bother to fill.. yet sheet 1 will be a
master of info for 120 indiviual sheets...

Any help would be appreciated

Thanks