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