software

I have sheets N1-N23. The final sheet i have created is a summary sheet
where i would like to compile info from N1-N23. I would like to have the
info from cell F15 from each sheet displayed in a column on my summary sheet.
In my summary sheet i have ='N1'!F15. I would like to drag and copy this
formula down my column and have F15 remain constant and N1 to change to N2 to
N3 etc until N23. I can't seem to get it to work?

Any advice or source for advice would be helpful.
thanks

JA

=INDIRECT(quot;Nquot; amp; ROW() amp; quot;!F15quot;) entered in A1 of summary sheet.

Drag/copy down.Gord Dibben MS Excel MVPOn Tue, 10 Jan 2006 15:38:04 -0800, quot;JAquot; gt; wrote:

gt;I have sheets N1-N23. The final sheet i have created is a summary sheet
gt;where i would like to compile info from N1-N23. I would like to have the
gt;info from cell F15 from each sheet displayed in a column on my summary sheet.
gt; In my summary sheet i have ='N1'!F15. I would like to drag and copy this
gt;formula down my column and have F15 remain constant and N1 to change to N2 to
gt;N3 etc until N23. I can't seem to get it to work?
gt;
gt;Any advice or source for advice would be helpful.
gt;thanks