Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link Formulae
Friends
Is there any way in excel in which i could link the formula and not copy them. Meaning I want to link the formulae in such a way that the formula of the linked cell changes if there is a modification of the formula of the parent cell. I have elaborated by giving an example Say I have a formula sum(A1:A5) in the cell A6 in worksheet1. I copy the similar formula in worksheet2 at A6 Now I want the formula in worksheet2 to change if I have changed the formula in worksheet1. For example If the formula in Worksheet1 A6 is changed to sum(A1:A4) , I want the formula in Worksheet2 A6 to change automatically to sum(A1:A4) Any Ideas how to do this in Excel. -- Regards Chandra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change to formulae | Excel Worksheet Functions | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
Link from webpage to excel sheet | Excel Discussion (Misc queries) | |||
assemble link from different cells and return value | Excel Worksheet Functions | |||
Breaking the link | New Users to Excel |