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?

Copy Formula with Pattern
 

Enter your "formulas" as text, e.g., xA4, xA53, etc. Do a drag down and
then do a Find/Replace of "x" by "="

--
Jim
"marmor516" wrote in message
...
|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?

Copy Formula with Pattern
 

I would use the indirect function
=indirect("A"&4+49*(row()-4))
This assumes that the first time the equation is entered is row 4...
--
Wag more, bark less


"marmor516" wrote:

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?

Copy Formula with Pattern
 

Neat trick
--
Wag more, bark less


"Jim Rech" wrote:

Enter your "formulas" as text, e.g., xA4, xA53, etc. Do a drag down and
then do a Find/Replace of "x" by "="

--
Jim
"marmor516" wrote in message
...
|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?

Copy Formula with Pattern
 

Thank you both for your help. I love both the traditional solution and the
back door solution. How do I rate your entries?

"Brad" wrote:

Neat trick
--
Wag more, bark less


"Jim Rech" wrote:

Enter your "formulas" as text, e.g., xA4, xA53, etc. Do a drag down and
then do a Find/Replace of "x" by "="

--
Jim
"marmor516" wrote in message
...
|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?

Hi,

What about if the data is in different columns but in the same row?

For example:

A3= A1
B3= E1
C3=I1, .....

Thanks a lot!