Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

copying cell links with fixed number in between

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
OverlookingSimpleClue - 14 Mar 2008 08:51 GMT
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 - 14 Mar 2008 09:27 GMT
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,)
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> In a column someone wants a reference to another cell. They want this for a
> large nr. of cells, with 15 in between
[quoted text clipped - 13 lines]
>
> Any ideas?
OverlookingSimpleClue - 17 Mar 2008 07:59 GMT
Thank you. This is what I was looking for

> One way is to use in say, E15, copied down:
> =OFFSET(D$15,ROWS($1:1)*15-15,)
[quoted text clipped - 23 lines]
> >
> > Any ideas?
Max - 17 Mar 2008 11:00 GMT
Welcome, glad it was, and thanks for feeding back here.
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thank you. This is what I was looking for
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.