try in the first cell:
=INDIRECT("'" & TEXT(DATE(2004,COLUMN(A:A),1),"MMMYY") & "'!C7")
and copy to the right
"Box 666" <email@example.com> schrieb im Newsbeitrag
> I have a worksheet for each month with a summary sheet at the front.
> On the summary sheet I have columns headed Jan, Feb etc and say cell
> ='Jan04'C7 and so on down that worksheet, all in all I pull about 20
> from Jan onto the Summary sheet.
> When I move to the Feb column then B1 = 'Feb04'C7 and so on. At the
> have to set up each individual "lookup"cell to theSummary sheet. Is
> way that you can "drag" the Jan column to the right and have the
> duplicate for Feb and then so on across the worksheet for each month.
> Alternativly any suggeustions of aneasier way to do this??