Hi,
Below query is to extract data records from multiple worksheets to a single worksheet
The macro able to extract the value of each 'Summary' sheet A1 and B1
But it couldn't identify the value of 'total day(s)' of work/leave/unpaid leave.
This is because the location (rownumber) of 'total day(s)' rows is not same for each worksheet.
(depending the number of staff)
I would really appreciate your help.
Actual Result:
department: laundry
department: marketing
department: security
Expected Result:
department: laundry 53 6 1
department: marketing 60 14 6
department: security 28 7 5
Bookmarks