Thread
:
Referencing the same cells
View Single Post
#
3
Posted to microsoft.public.excel.misc
galimi
external usenet poster
Posts: 210
Referencing the same cells
Kenton,
You can use the indirect formula to indicate a range that will never change,
even when the rows or columns shift.
--
http://www.ExcelHelp.us
888-MY-ETHER ext. 01781474
"Kenton" wrote:
I need some help changing the following formula to reference the same cells
once the reference sheet is updated (additional rows are added). The formula
is as follows...
=INDEX('J:\KENTON\INTERMODAL\[DRAYMAN FUEL SURCHARGE
CHARTS.xls]COVER'!$K$7:$BB$48,MATCH(X25,'J:\KENTON\INTERMODAL \[DRAYMAN FUEL
SURCHARGE
CHARTS.xls]COVER'!$A$7:$A$48,0),MATCH(AH10,'J:\KENTON\INTERMO DAL\[DRAYMAN
FUEL SURCHARGE CHARTS.xls]COVER'!$K$6:$BB$6,0))
... and I need the following cells to stay the same when additional rows are
added to the reference sheet. $K$7:$BB$48 and $A$7:$A$48. Thanks.
Reply With Quote
galimi
View Public Profile
Find all posts by galimi