Fill Down Formula Pattern

[no shoe]

I need to continue filling down the data on the right by day of the week, however the fill handle is not adjusting the formulas the way that I would like. Any help?

******** ******************** ************************************************************************>

Microsoft Excel - Book2 ___Running: 11.0 : OS = Windows Windows 2000

(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout

D2J2K2L2M2D3G3H3I3J3K3L3M3D4G4D5G5D6D7D8D9D10D11D12D13 =

A

B

C

D

E

F

G

H

I

J

K

L

M

1

*

OBC

cc

*

*

*

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

2

Wed*01/01

696

794

87.7%

*

*

*

*

*

87.7%

74.3%

70.7%

76.0%

3

Thu*01/02

1538

2,071

74.3%

*

*

85.9%

78.3%

66.9%

70.5%

74.8%

74.9%

90.7%

4

Fri*01/03

1332

1,883

70.7%

*

*

86.6%

*

*

*

*

*

*

5

Sat*01/04

713

938

76.0%

*

*

90.2%

*

*

*

*

*

*

6

Sun*01/05

633

737

85.9%

*

*

*

*

*

*

*

*

*

7

Mon*01/06

1570

2,006

78.3%

*

*

*

*

*

*

*

*

*

8

Tue*01/07

1309

1,957

66.9%

*

*

*

*

*

*

*

*

*

9

Wed*01/08

1255

1,781

70.5%

*

*

*

*

*

*

*

*

*

10

Thu*01/09

1362

1,822

74.8%

*

*

*

*

*

*

*

*

*

11

Fri*01/10

1245

1,663

74.9%

*

*

*

*

*

*

*

*

*

12

Sat*01/11

732

807

90.7%

*

*

*

*

*

*

*

*

*

13

Sun*01/12

562

649

86.6%

*

*

*

*

*

*

*

*

*

Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[Davers]

Hey no shoe...do you mean the formula's in Range"D:D" are not filling down correctly? What would you like them to do? Or do you mean when you drag the formula over from say G3:M3, it didn't do it how you wanted...

Dave

[DRJ]

Try

=INDIRECT("D" & 6 + ROW()-3)

[no shoe]

I have the percentages in D, and I will like them to be sorted in 'calendar' format on the right side of the shown spreadsheet. Most likely I will need to do each day of the week individually which is fine. Something along the lines of adding 7 to the formula when I drag it down.

Thanks

[no shoe]

I suppose the easiest way to word it is:

I want to add 7 to the row portion of a formula, and be able to fill down with it.

A1
A1+7
A8+7
etc.

[DRJ]

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: xl2002 XP : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
E3F3G3H3I3J3K3E4F4G4H4I4J4K4E5F5G5H5I5J5K5E6F6G6H6I6J6K6 =
	A	B	C	D	E	F	G	H	I	J	K
1	*	OBC	cc	*	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
2	Wed*01/01	696	794		*	*	*	*	*	*	*
3	Thu*01/02	1538	2071		5.00%	6.00%	7.00%	8.00%	9.00%	10.00%	11.00%
4	Fri*01/03	1332	1883		12.00%	13.00%	14.00%	15.00%	16.00%	17.00%	18.00%
5	Sat*01/04	713	938		19.00%	20.00%	21.00%	22.00%	23.00%	24.00%	25.00%
6	Sun*01/05	633	737		26.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
7	Mon*01/06	1570	2006		*	*	*	*	*	*	*
8	Tue*01/07	1309	1957		*	*	*	*	*	*	*
9	Wed*01/08	1255	1781		*	*	*	*	*	*	*
10	Thu*01/09	1362	1822		*	*	*	*	*	*	*
11	Fri*01/10	1245	1663		*	*	*	*	*	*	*
12	Sat*01/11	732	807		*	*	*	*	*	*	*
13	Sun*01/12	562	649		*	*	*	*	*	*	*
14	Mon*01/06	1570	2006		*	*	*	*	*	*	*
15	Tue*01/07	1309	1957		*	*	*	*	*	*	*
16	Wed*01/08	1255	1781		*	*	*	*	*	*	*
17	Thu*01/09	1362	1822		*	*	*	*	*	*	*
Sheet1 Hyper Lynks Address is here ...

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[DRJ]

The numbers in column D didnt post for some reason, but it was working for me.