I hope you are doing great,
I would like to create a VBA code to compare the columns in two workbooks and populate the required/correct status in Column D of Employees amount sheet
There are the description of the statuses in Column E
I have the attached two files for references Emplyoyess amount sheet.xlsxEmployees BS.xlsx
Could you please help me with this?
Thank you in advance