Cell References..

  • Thread starter Thread starter anyoneknows
  • Start date Start date
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
 
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?
 
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..
 
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...
 
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
 
Back
Top