I am having two workbook. Source.xlsm and Destination.xlsx.
In both the work book I am having customer name, Plant model and plant S.No details.
Once i press's Write Value button from source workbook, I want it should write "Calibration done" on Destination workbook Sheet 2 column K where my customer name, Plant model and plant S.No matching. And this "Calibration Done "
For example, If customer name, Plant model and plant S.No is matching on row 13 and K13 is blank then K13 it should print "Calibration done"
Can any one help me for solve this
I am attaching my file here for your reference.