rvfowler2
asked on
Excel Macro and Pivot Table, Part II
My boss asked the following for a macro that creates a pivot table in Excel. "Is it possible to get 1st login and last log out of each day on the line to the right of totals for each day?" What adds complexity is that there might not be the same # of rows each time for the pivot table, depending on how many employees actually worked that day. See attachments: one is the pivot table and one has the macro within it. Thanks.
P.S. - And why is the first file so big? Is it the Pivot table?
LogonReport.xls
LogonReportStarter2.xls
P.S. - And why is the first file so big? Is it the Pivot table?
LogonReport.xls
LogonReportStarter2.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER