I've attached my spreadsheet so you can view what I've done. Essentially I have a summary page (first sheet in the workbook) that summarizes the activities that occur in a 2 week period. Each activity is performed by an employee and lists how many hours they spent performing that particular activity. What you'll notice is that if a particular activity occurs on multiple highways I need separate results, which I've done already. If possible I'd like to be able to add the employee information to the pivot table so I can expand the service order so it lists how many of the total hours were performed by each employee.
So right now for example, my spreadsheet will say that service order 546 was performed for a total of 40 hours that day. I want a button to expand a list of which employees made up those 40 hours and a breakdown for each. E.g. TOM - 10hrs, JOE 30hrs etc.
Every time I import that info into excel using ALT D + P it crashes the whole document. Any help would be greatly appreciated.
Bookmarks