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