refer to cells by cells(0,1) etc rather than "A1"
 

I have numerous references from 1 sheet(report) to another sheet(photos).
Currently i use a simple but time consuming:
=IF(Report!C28="","",Report!C28) method.

I would like to code this as somehting like:
=if(Report!(3, 28)<"",Report!(3,28).

I have found due to an added delete row code i have put to the Report page
the cells being referenced to in the Photo's page then
change to Ref#(being not valid)
I am thinking that if i refernce the cells by code with the cells (x,y)
would auto fix the deleting of the rows in sheet 1??

Am i correct in saying this?
Can anyone assist me?

Corey....

refer to cells by cells(0,1) etc rather than "A1"
 

This kind of linking is gonna cause you heartache later on--if it hasn't
already.

If you can find a nice unique key in both worksheets, maybe you can put those
keys in the second and use =vlookup() or =index(match()) to retrieve values from
that other sheet.

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

=========
But a formula like this:
=IF(INDIRECT("report!a1")="","",INDIRECT("report!a 1"))

Will always point to A1 of the Report sheet--no matter what you insert/delete.

Corey wrote:

I have numerous references from 1 sheet(report) to another sheet(photos).
Currently i use a simple but time consuming:
=IF(Report!C28="","",Report!C28) method.

I would like to code this as somehting like:
=if(Report!(3, 28)<"",Report!(3,28).

I have found due to an added delete row code i have put to the Report page
the cells being referenced to in the Photo's page then
change to Ref#(being not valid)
I am thinking that if i refernce the cells by code with the cells (x,y)
would auto fix the deleting of the rows in sheet 1??

Am i correct in saying this?
Can anyone assist me?

Corey....

--

Dave Peterson

refer to cells by cells(0,1) etc rather than "A1"
 

Thanks Dave.
You are true gentleman.
Went with the :
=IF(INDIRECT("report!a1")="","",INDIRECT("report!a 1"))
suggestion.
Perfect once again.

Cheers

Corey....
"Dave Peterson" wrote in message
...
This kind of linking is gonna cause you heartache later on--if it hasn't
already.

If you can find a nice unique key in both worksheets, maybe you can put
those
keys in the second and use =vlookup() or =index(match()) to retrieve
values from
that other sheet.

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

=========
But a formula like this:
=IF(INDIRECT("report!a1")="","",INDIRECT("report!a 1"))

Will always point to A1 of the Report sheet--no matter what you
insert/delete.

Corey wrote:

I have numerous references from 1 sheet(report) to another sheet(photos).
Currently i use a simple but time consuming:
=IF(Report!C28="","",Report!C28) method.

I would like to code this as somehting like:
=if(Report!(3, 28)<"",Report!(3,28).

I have found due to an added delete row code i have put to the Report
page
the cells being referenced to in the Photo's page then
change to Ref#(being not valid)
I am thinking that if i refernce the cells by code with the cells (x,y)
would auto fix the deleting of the rows in sheet 1??

Am i correct in saying this?
Can anyone assist me?

Corey....

--

Dave Peterson