Sir,'Excel'lent efforts and useful ideas. Please provide vba code as well as working Excel file.
Dear Sir,Please help me.I have 2 excel files A and B. I am using file A for Data Entry and B for making report.file B cell reference are in file A.when I entered data into file A and save and close then after I open file B for making report.After update if File B cell data change then i want to run vba code.ThanksAmitae.ramgarh@gmail.comExample:In File ACell Address = A1I Entered data = Computersave and close file AWhen I Open File Bask for update "I click on Update"Cell Address = B1 (reference : File A / cell A1)Now Cell B1 Value = ComputerIf Cell B1 value Change then run vba code.Note: I just want to know that how to realize the excel that cell value (File B / CEll B1) is changed.I tried Worksheet_change event but its work only when I change in worksheet(File B).
Please do not enter any spam message in comment box
Sir,
ReplyDelete'Excel'lent efforts and useful ideas. Please provide vba code as well as working Excel file.
Dear Sir,
ReplyDeletePlease help me.
I have 2 excel files A and B.
I am using file A for Data Entry and B for making report.
file B cell reference are in file A.
when I entered data into file A and save and close then after I open file B for making report.
After update if File B cell data change then i want to run vba code.
Thanks
Amit
ae.ramgarh@gmail.com
Example:
In File A
Cell Address = A1
I Entered data = Computer
save and close file A
When I Open File B
ask for update "I click on Update"
Cell Address = B1 (reference : File A / cell A1)
Now Cell B1 Value = Computer
If Cell B1 value Change then run vba code.
Note: I just want to know that how to realize the excel that cell value (File B / CEll B1) is changed.
I tried Worksheet_change event but its work only when I change in worksheet(File B).