linking spreadsheet nightmare

[newbie_help]

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

 

[Guest]

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


newbie_help skrev:

 

[Dave Peterson]

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).)