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?
Bookmarks