Hi JHB,
Further to your code given a few days back, I have added my code in between to export data while creating multi sheet in Excel.
Initially sheet1 shall be filled up with employee punch-in n out data and if data continues for next employee, it shall add new sheet in Excel file and and export data that relevant to new employee. - Pls see my attached file.
I think I am close to target.
After a long try, I am stuck up. Bcz my export code is generating few date after completion of month. Means if suppose September should end up with date 30 but it is still generating 3 additional dates.
Likewize at last sheet it is not reaching to 30 Sept. It is generating till 29th Sept.
Can you please help to sort out this issue.
Thanks,