# Excel's drag and fill function, help.

1. ## Excel's drag and fill function, help.

I have this little problem here:
I have, in a column (in the first six boxes vertically)
='STAGE CALCULATIONS'!D9
='STAGE CALCULATIONS'!D15
='STAGE CALCULATIONS'!D21
='STAGE CALCULATIONS'!D27
='STAGE CALCULATIONS'!D33
='STAGE CALCULATIONS'!D39

When I use the drag and fill function, I drag it and the listing would become:
='STAGE CALCULATIONS'!D9
='STAGE CALCULATIONS'!D15
='STAGE CALCULATIONS'!D21
='STAGE CALCULATIONS'!D27
='STAGE CALCULATIONS'!D33
='STAGE CALCULATIONS'!D39
='STAGE CALCULATIONS'!D15
='STAGE CALCULATIONS'!D21
='STAGE CALCULATIONS'!D27
='STAGE CALCULATIONS'!D33
='STAGE CALCULATIONS'!D39
='STAGE CALCULATIONS'!D45

And to make things even annoying, I tried using the first two:
='STAGE CALCULATIONS'!D9
='STAGE CALCULATIONS'!D15

and it ended up as
='STAGE CALCULATIONS'!D9
='STAGE CALCULATIONS'!D15
='STAGE CALCULATIONS'!D11
='STAGE CALCULATIONS'!D17
='STAGE CALCULATIONS'!D13
='STAGE CALCULATIONS'!D19
....

Is there a way for me to end it up as a multiple of six? I mean what I really want is
='STAGE CALCULATIONS'!D9
='STAGE CALCULATIONS'!D15
='STAGE CALCULATIONS'!D21
='STAGE CALCULATIONS'!D27
='STAGE CALCULATIONS'!D33
='STAGE CALCULATIONS'!D39
='STAGE CALCULATIONS'!D45
='STAGE CALCULATIONS'!D51
='STAGE CALCULATIONS'!D57
='STAGE CALCULATIONS'!D63
='STAGE CALCULATIONS'!D69
.... which I can't understand why it won't happen. Help anyone?

2. ## Re: Excel's drag and fill function, help.

This works, in A1
=INDIRECT("'STAGE CALCULATIONS'!"&"D"&(ROW()-1)*6+9)
and copy down the column

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1