I have a large workbook with employee attendance and I would like to pull the attendance data for each employee by date.
Is there a macro that can do this?
I have a large workbook with employee attendance and I would like to pull the attendance data for each employee by date.
Is there a macro that can do this?
Without seeing the workbook, I can only offer suggestions.
If the data are organized in a "normalized" fashion, then a pivot table will work.
The SUMIFS (or SUMPRODUCT) can get sums based on multiple criteria.
If you are trying to extract non-numeric data then using a composite ([Employee ID] & ":" & [Date]) along with INDEX / MATCH might help.
The chances are good that you do not need a macro to do this. Regular formulas should handle it.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks