rohitbisani
New Member
- Joined
- Oct 30, 2009
- Messages
- 6
Hello This is Rohit...
I have a project in my college in which i need to do the following. Please help
I have a task in which I need to communicate between the sheets.. I have a unique ID in each worksheet through which I can identify which record to be edited in the other worksheet... So I have a number x with unique ID 5000 (for example)in sheet1... I have a number y with unique ID 5000 in sheet 2.... when I change x in sheet 1, the number y in worksheet 2 must change to (y-x) ...
I want these cells to be related... basically a macro which will subtract the value x from corresponding cell automatically whenever x is changed...
Please Help.
Thank You
I have a project in my college in which i need to do the following. Please help
I have a task in which I need to communicate between the sheets.. I have a unique ID in each worksheet through which I can identify which record to be edited in the other worksheet... So I have a number x with unique ID 5000 (for example)in sheet1... I have a number y with unique ID 5000 in sheet 2.... when I change x in sheet 1, the number y in worksheet 2 must change to (y-x) ...
I want these cells to be related... basically a macro which will subtract the value x from corresponding cell automatically whenever x is changed...
Please Help.
Thank You