I am unable to write range for the If function under for each attendance logs, as the filter data table does not work (because ‘Day’ would not be = Day from DT_filteredem to DT_filteredem_day) due to the excel file being corrupted midway?, hence it is unable to write range.
For this i also have an empty employee folder to create and store all the employees individual raw data files.
Another question that i have is that if excel file is macro-enabled worksheet would it affect anything?
Hoping to get help. Thank you in advance!!