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 |
#2
|
|||
|
|||
Chandra,
the only way I know of is to use a Worksheet_Change Event procedure. Using your example the following worked for me Private Sub Worksheet_Change(ByVal Target As Range) Sheets(2).Range("A6").Formula = ActiveSheet.Range("A6").Formula End Sub I put this Sub into the Sheet 1 module. It only works one way. The formula on Sheet 2 changes when you change the formula on sheet 1, but not the other way around. Hope this helps Ken Johnson |
Reply |
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 |