View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
marmor516 marmor516 is offline
external usenet poster
 
Posts: 2
Default Copy Formula with Pattern

I am having problems dragging down a formula. What I have is =A04, =A53,
=A102, the formal changes by 49 rows each time. When I attempt to drage the
formula through the next 3 lines I get =A05, A=54, and =A103. What I want is
=A152, =A201, =A250.. If I drop the = sign I can get it to work fine, but
that wont help me. Does anyone have a recommendation?