Put this in the cell of your master sheet where you want the references to
start and copy it down
=OFFSET(Sheet2!$A$1,0,ROW(A1)-1)
"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
|