drag a value from 1 cell to multiple cells

[kltxdot]

in a cell I have: =day1!night1 I want the day1 to incrment up and the night1 to stay the same. Is there a symbol that I can place in front of the night1 to make it stay, but allows day1 to increment. Office XP

 

[Mudface]

Take a look at the formulae below, the first

=INDIRECT("Day"&ROW()&"!Night1")

can be used if you start in the first row. The second: -

=INDIRECT("Day"&ROW()-4&"!Night1")

can be used if you're starting in a different row using an offset. Replace the 4 with row number of where you're starting minus one.

Book1
	A	B	C	D
1	1
2	2
3	3
4
5	1
6	2
7	3
Sheet4

 

[Mark W.]

Book1
	A	B	C	D	E	F	G	H	I	J
1	=day1	=day1!night1
2	=day2	=day2!night1
3	=day3	=day3!night1
4	=day4	=day4!night1
5	=day5	=day5!night1
6	=day6	=day6!night1
7	=day7	=day7!night1
8	=day8	=day8!night1
9	=day9	=day9!night1
10
11
12
Sheet2