Forum Discussion
Complex Formula/Lookup and total
I need assistance. I need to calculate the total number of man hours spent on multiple jobs from my file for the entire year to see which project(s) had the most hours sent. So I have multiple projec...
Patrick2788 Thanks for the assistance. I am attaching my live file here. I have several tabs at the bottom I need to create the 'pivot table' for. I need one for SD's, DD's, CD's, and PR #s. I have never created a pivot table, so I don't know how to set that up based on the document you send. I don't know if I am linking this correctly, first time using this board. Thanks for your assistance!
U:\~Studio Architects Info\Accounting\R&D\2024\2024-01-28-Data to KLF\Employee Hours 2023-EDIT.xlsx
It appears you may have linked to a network share that I don't have access to view. You could host the file on OneDrive or send it to me via private message (if you're missing the attachment option when composing).
- I sent via message as an attachment. It did not allow me to attach/upload a file through here. Thanks!