Cell References..

A

anyoneknows

I have a 12 month rolling report with a seperate worksheet within th
workbook which refers to the column containing current month's Numbers
When I "Cut" Column C (which contains the oldest Month) and "insert
column C between N & O it shifts my cells left and all I need to do i
input all of the current Month Data into Column N. The formulas al
remain intact and everything is peachy. Until I goto the Workshee
that refers to the Current Month on the 12 month rolling report.

My problem is that when I shift the columns on the "Report" workshee
it chages the cell reference formulas on the "Eval" worksheet.


Changing
=(Report!$N$4)

to

=(Report!$M$4)

Is there a reference formula that I can use in the "Eval" workshee
that will always go to the "N Column" of the Report worksheet for it'
data even when the data shifts left
 
R

RagDyer

Try:

=INDIRECT("Report!$N$4")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a 12 month rolling report with a seperate worksheet within the
workbook which refers to the column containing current month's Numbers.
When I "Cut" Column C (which contains the oldest Month) and "insert"
column C between N & O it shifts my cells left and all I need to do is
input all of the current Month Data into Column N. The formulas all
remain intact and everything is peachy. Until I goto the Worksheet
that refers to the Current Month on the 12 month rolling report.

My problem is that when I shift the columns on the "Report" worksheet
it chages the cell reference formulas on the "Eval" worksheet.


Changing
=(Report!$N$4)

to

=(Report!$M$4)

Is there a reference formula that I can use in the "Eval" worksheet
that will always go to the "N Column" of the Report worksheet for it's
data even when the data shifts left?
 
A

anyoneknows

Hello Again,

I am now having difficulting with the graphs for the 12 month rollin
report. I am having the same problem that "INDIRECT" fixxed for me o
the report worksheet. But =INDIRECT("Report!$N$12") will not work o
the Graphs.

Currently This is the formula.

=Report!$C$8:$N$8

When I shift the cells left and insert the current month it changes th
formula on the Graphs 'Source Data' to this...

=Report!$C$8:$L$8

And when I use....

=INDIRECT(Report!$C$8:$N$8)


I get the error Message "Function is not Valid"



"Help me Obi Wan Kinobi, You're my only hope."


Thanks..
 
R

RagDyer

I don't think that I've ever made a chart in XL, so don't know if I can be
much help on this subject,
BUT ...
I did notice that either there's a typo, or ... did you really leave out the
quotes in the formula you posted?
=INDIRECT(Report!$C$8:$N$8)

So, maybe try:
=INDIRECT("Report!$C$8:$N$8")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hello Again,

I am now having difficulting with the graphs for the 12 month rolling
report. I am having the same problem that "INDIRECT" fixxed for me on
the report worksheet. But =INDIRECT("Report!$N$12") will not work on
the Graphs.

Currently This is the formula.

=Report!$C$8:$N$8

When I shift the cells left and insert the current month it changes the
formula on the Graphs 'Source Data' to this...

=Report!$C$8:$L$8

And when I use....

=INDIRECT(Report!$C$8:$N$8)


I get the error Message "Function is not Valid"



"Help me Obi Wan Kinobi, You're my only hope."


Thanks...
 
A

anyoneknows

Ive tried with the quotes, without the quotes, "INDIRECT" is what's
being highlighted after I get the Error Message.

Thanks for your input though
 
Top