Hi..
I have 2 sheets called Master and Child.
Master sheet contains 3 columns A11:EMPNO,A12:EMPNAME,A13:DESIGNATION. The values are coming under this.
Child sheet also contains 3 columns with the same column names in the same location.
Is it possible to compare those 3 values in the Master sheet with the values in Child sheet??
If the all the 3 values are not matched with each other sheet, then just read those 3 values from Child sheet and append into Master sheet's end of the record.
Regards
venki.
I have 2 sheets called Master and Child.
Master sheet contains 3 columns A11:EMPNO,A12:EMPNAME,A13:DESIGNATION. The values are coming under this.
Child sheet also contains 3 columns with the same column names in the same location.
Is it possible to compare those 3 values in the Master sheet with the values in Child sheet??
If the all the 3 values are not matched with each other sheet, then just read those 3 values from Child sheet and append into Master sheet's end of the record.
Regards
venki.