copying cell links with fixed number in between

In a column someone wants a reference to another cell. They want this for a
large nr. of cells, with 15 in between

=D15
=D30
=D45
=D60
and so on

I can build a simple VBA module to get this done, but the whole in itself is
variable (for some purposes 15, others 18, in another sheet it'll be a
different column) and the user who needs to do this won't be able to change
anything in the VBA stuff. They will also need this in more worksheets. I've
checked 'paste special' but it doesn't seem to have any functionality for
this.

Any ideas?

demechanik
Fri Mar 14 03:27:01 CDT 2008

One way is to use in say, E15, copied down:
=OFFSET(D$15,ROWS($1:1)*15-15,)
to return the required:
> =D15
> =D30
> =D45
> =D60

Or, if say, E14 will house the "fixed number", ie: 15
In E15, copied down: =OFFSET(D$15,ROWS($1:1)*E$14-E$14,)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"OverlookingSimpleClue" wrote:
> In a column someone wants a reference to another cell. They want this for a
> large nr. of cells, with 15 in between
>
> =D15
> =D30
> =D45
> =D60
> and so on
>
> I can build a simple VBA module to get this done, but the whole in itself is
> variable (for some purposes 15, others 18, in another sheet it'll be a
> different column) and the user who needs to do this won't be able to change
> anything in the VBA stuff. They will also need this in more worksheets. I've
> checked 'paste special' but it doesn't seem to have any functionality for
> this.
>
> Any ideas?

OverlookingSimpleClue
Mon Mar 17 01:59:00 CDT 2008

Thank you. This is what I was looking for

"Max" wrote:

> One way is to use in say, E15, copied down:
> =OFFSET(D$15,ROWS($1:1)*15-15,)
> to return the required:
> > =D15
> > =D30
> > =D45
> > =D60
>
> Or, if say, E14 will house the "fixed number", ie: 15
> In E15, copied down: =OFFSET(D$15,ROWS($1:1)*E$14-E$14,)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "OverlookingSimpleClue" wrote:
> > In a column someone wants a reference to another cell. They want this for a
> > large nr. of cells, with 15 in between
> >
> > =D15
> > =D30
> > =D45
> > =D60
> > and so on
> >
> > I can build a simple VBA module to get this done, but the whole in itself is
> > variable (for some purposes 15, others 18, in another sheet it'll be a
> > different column) and the user who needs to do this won't be able to change
> > anything in the VBA stuff. They will also need this in more worksheets. I've
> > checked 'paste special' but it doesn't seem to have any functionality for
> > this.
> >
> > Any ideas?

Max
Mon Mar 17 05:00:18 CDT 2008

Welcome, glad it was, and thanks for feeding back here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"OverlookingSimpleClue" <OverlookingSimpleClue@discussions.microsoft.com>
wrote in message news:2C8557A1-4469-41A1-B63E-17E617D89F7F@microsoft.com...
> Thank you. This is what I was looking for