I m trying to use the same formula for the next column over but when i copy
and paste the formula i get the same answer.
so for Nov, 1) -2.70 is the result i get from the underline formula of
='Hedge Fund'!$E29. I want Dec's column to be the same formula but ='Hedge
Fund'!$E30 instead.
how can i Find/Replace a part of a formula to replace something back to the
formula? i want the result to come from line 30 instead of line 29, but when
i Find=*29 and Replace with=*30, i don't get the results from 'hedge Fund'
page, but i get *30

A % Nov % Dec
1 -2.70 -2.70
2 -1.65 -1.65
3 -1.61 -1.61
4 -0.75 -0.75
5 -5.04 -5.04

When you copy this ='Hedge Fund'!$E29 to another column the $ in front of
the E tells Excel not to alter the column in the cell reference
SO if you use ='Hedge Fund'!E29 all should be wee
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JessieB" wrote in message
...
I m trying to use the same formula for the next column over but when i copy
and paste the formula i get the same answer.
so for Nov, 1) -2.70 is the result i get from the underline formula of
='Hedge Fund'!$E29. I want Dec's column to be the same formula but ='Hedge
Fund'!$E30 instead.
how can i Find/Replace a part of a formula to replace something back to
the
formula? i want the result to come from line 30 instead of line 29, but
when
i Find=*29 and Replace with=*30, i don't get the results from 'hedge Fund'
page, but i get *30

A % Nov % Dec
1 -2.70 -2.70
2 -1.65 -1.65
3 -1.61 -1.61
4 -0.75 -0.75
5 -5.04 -5.04

When i remove $ in front of E, it automatically goes to F which is what i
don't want. i want the column to still reference E , but move down a row to
30 instead of 20. what can i do?

"Bernard Liengme" wrote:

When you copy this ='Hedge Fund'!$E29 to another column the $ in front of
the E tells Excel not to alter the column in the cell reference
SO if you use ='Hedge Fund'!E29 all should be wee
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JessieB" wrote in message
...
I m trying to use the same formula for the next column over but when i copy
and paste the formula i get the same answer.
so for Nov, 1) -2.70 is the result i get from the underline formula of
='Hedge Fund'!$E29. I want Dec's column to be the same formula but ='Hedge
Fund'!$E30 instead.
how can i Find/Replace a part of a formula to replace something back to
the
formula? i want the result to come from line 30 instead of line 29, but
when
i Find=*29 and Replace with=*30, i don't get the results from 'hedge Fund'
page, but i get *30

A % Nov % Dec
1 -2.70 -2.70
2 -1.65 -1.65
3 -1.61 -1.61
4 -0.75 -0.75
5 -5.04 -5.04

If I understand you, you're looking to copy a link formula across columns,
along a row, and have the formula reference a single column, down the rows.

If I'm right, enter this *anywhere*, and copy across as needed:

=INDEX('Hedge Fund'!$E:$E,COLUMNS($A:AC))

This *starts* with Row 29, and increments from there.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JessieB" wrote in message
...
When i remove $ in front of E, it automatically goes to F which is what i
don't want. i want the column to still reference E , but move down a row
to
30 instead of 20. what can i do?

"Bernard Liengme" wrote:

When you copy this ='Hedge Fund'!$E29 to another column the $ in front of
the E tells Excel not to alter the column in the cell reference
SO if you use ='Hedge Fund'!E29 all should be wee
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JessieB" wrote in message
...
I m trying to use the same formula for the next column over but when i
copy
and paste the formula i get the same answer.
so for Nov, 1) -2.70 is the result i get from the underline formula of
='Hedge Fund'!$E29. I want Dec's column to be the same formula but
='Hedge
Fund'!$E30 instead.
how can i Find/Replace a part of a formula to replace something back to
the
formula? i want the result to come from line 30 instead of line 29, but
when
i Find=*29 and Replace with=*30, i don't get the results from 'hedge
Fund'
page, but i get *30

A % Nov % Dec
1 -2.70 -2.70
2 -1.65 -1.65
3 -1.61 -1.61
4 -0.75 -0.75
5 -5.04 -5.04