linking spreadsheet nightmare
 

Here is another look at what I am trying to do may be some one can se
my error
It returns #NAME? error

You link a cell something like this =D17 which will bring back th
value in Row 17 Column D

You can bring back a row number like this =ROW(D17) which returns th
value 17

You can also bring back a ROW number with addition example I want RO
17 but I am on ROW 1 so =(ROW(D1)+16) would return 17

So here I am... Lets skip 60 at a time starting on row 2. I want to b
able to keep the Column D

=((ROW(D2)-1)*60) = ((2)-1)*60) = 60

How can I say this =D((ROW(D2)-1)*60) (where D is the Column and th
ROW formula is the row number) which is bacially =D60 from above.

Why do I need this. Now all I need to do is copy the code to the nex
line and it will automatically copy D120 then D180 then D24
......etc.

Thanks for any idea's I will keep working on the macro study

--
newbie_hel
-----------------------------------------------------------------------
newbie_help's Profile: http://www.excelforum.com/member.php...fo&userid=1507
View this thread: http://www.excelforum.com/showthread.php?threadid=26708

linking spreadsheet nightmare
 

If I understand your problem right, you coud try to change to R1C1 reference
style.


newbie_help skrev:


Here is another look at what I am trying to do may be some one can see
my error
It returns #NAME? error

You link a cell something like this =D17 which will bring back the
value in Row 17 Column D

You can bring back a row number like this =ROW(D17) which returns the
value 17

You can also bring back a ROW number with addition example I want ROW
17 but I am on ROW 1 so =(ROW(D1)+16) would return 17

So here I am... Lets skip 60 at a time starting on row 2. I want to be
able to keep the Column D

=((ROW(D2)-1)*60) = ((2)-1)*60) = 60

How can I say this =D((ROW(D2)-1)*60) (where D is the Column and the
ROW formula is the row number) which is bacially =D60 from above.

Why do I need this. Now all I need to do is copy the code to the next
line and it will automatically copy D120 then D180 then D240
......etc.

Thanks for any idea's I will keep working on the macro study.


--
newbie_help
------------------------------------------------------------------------
newbie_help's Profile: http://www.excelforum.com/member.php...o&userid=15076
View this thread: http://www.excelforum.com/showthread...hreadid=267087

linking spreadsheet nightmare
 

I think you want:

=INDIRECT("R"&(ROW(D2)-1)*60&"C4",FALSE)
or
=INDIRECT("d"&((ROW(D2)-1)*60))

The first one uses =indirect() in R1C1 style and the second use A1 reference
style.

(This is a formula entry difference--it won't matter if you're in R1C1 or A1
reference style (via tools|options|General Tab).)






newbie_help wrote:

Here is another look at what I am trying to do may be some one can see
my error
It returns #NAME? error

You link a cell something like this =D17 which will bring back the
value in Row 17 Column D

You can bring back a row number like this =ROW(D17) which returns the
value 17

You can also bring back a ROW number with addition example I want ROW
17 but I am on ROW 1 so =(ROW(D1)+16) would return 17

So here I am... Lets skip 60 at a time starting on row 2. I want to be
able to keep the Column D

=((ROW(D2)-1)*60) = ((2)-1)*60) = 60

How can I say this =D((ROW(D2)-1)*60) (where D is the Column and the
ROW formula is the row number) which is bacially =D60 from above.

Why do I need this. Now all I need to do is copy the code to the next
line and it will automatically copy D120 then D180 then D240
.....etc.

Thanks for any idea's I will keep working on the macro study.

--
newbie_help
------------------------------------------------------------------------
newbie_help's Profile: http://www.excelforum.com/member.php...o&userid=15076
View this thread: http://www.excelforum.com/showthread...hreadid=267087

--

Dave Peterson