PDA

View Full Version : Compare two sheet , i.e import sheet and htmlcopy sheet and give result in third she



aligahk06
08-24-2019, 04:48 AM
Dear All,

I have a three sheet in excel file ,import , htmocopy and check sheet.
for employee 14088 in check sheet . all data from date 16-7-2019 to 15-08-19 match with two sheets import sheet and htmlcopy sheet then result in check sheet gives true for each date cell else false in corresponding cell.
same for employee 19770 and so on...

Attached sheet.

mana
08-24-2019, 05:11 AM
C4: =import!C5=htmlcopy!C4