Fix a Reference

[watzmann]

Hi All,

I have excel file containes

1- one summery sheet
2- day1 to day 100 sheets

i was trying to get data from each sheet " day1 : day 100 " and copy this data to the summery sheet ,

ex. = 'Day1'!O4

when i tried to drag the cell to the entire column i got the following

= 'Day1'!O5 then i found the soloution of using the $ sign

='Day1'!O$4

which is nice but the problem now is i need chnages to occures in days

ex. = 'Day1'!O$4
= 'Day2'!O$4
= 'Day3'!O$4

so please tell me how to do that because 100 day is too much and i cannot do it maually

thanks in advnace

[windknife]

Try this,
A1
=INDIRECT("Day" & ROW() & "!O4",1)

copied down.

HTH,
windknife