Hi all,

I use this function to set up the same raneg on multiple tabs is the same
work sheet
=OFFSET(INDIRECT(Report!C$1&"!a1"),0,0,1000,100)

It works great Report!C$1 is the place where I woul just type the sheet I
want the lookup the value on. This works great in the active file..

Does anyone know how to modify the function, or another function that I can
use to do the samething but to another seperate file.

Thanks
--
Helping Is always a good thing