Suppose the numbers in my excel sheet is coming from another excel sheet within the same workbook, then the numbers are linked with another sheet numbers. It has a link as "='Hyperion - Jan'!$Z$54" in formula bar which has a value of 32.8%.
Now I need to change this $Z$54 cell reference n number of times in various cells, so i was trying to insert this $Z$54 in my formula through the formula if Z & 54 is written in my excel in other cells for the reference. But i was stuck & not able to come up with the formula i want.
Hi Bhavesh,
So what is it you actually want to do, you haven't really explained? Change $Z$54 to some other cell reference?
Please supply the workbook so we might better understand the question.
Regards
Phil
Are you referring to the INDIRECT function?
E.g. in cell A1 you have the text $Z$54. You can use INDIRECT($A$1) in all your formulas to reference the cell $Z$54.
If you decide to change the reference in A1 to $X$10 (for example) then the INDIRECT($A$1) will now reference cell $X$10.
