Ok please read the following message I have sent out to many. I need to find out how to accomplish this. My IT guy was no help my payroll company was no help so now I am asking here. Message below explains what I sent to my IT guy-
Hey man how good are you with excel. I have a very tricky thing I want to accomplish. I attached something here. I have (3) mock up time cards along with an input sheet that I would like to pull data from the time cards. Then there is a payroll report sheet that would refine the input sheet. What I am trying to achieve is having 1 sheet that would have the employee’s ID #, name and hours he worked in specific dept’s.
I completed it how it should be but I don't know what formulas to make it happen. So the page titled Payroll Report is what I want to achieve from numerous time cards numbered 001-12, 003-12, 004-12 etc. The Input Sheet is there to help filter the time cards then the payroll report sheet would be the refined page. If you feel this is something we can do over the phone rather than coming to my office like we planned then that would be great. I need it done ASAP though. I have tried basic macro’s and pivot tables but they were unsuccessful. I want to do this with you not just have it done. I need to learn this because it would change a lot. Please let me know if you can accomplish what I want to achieve here. Sorry for the novel. (see attached)
Bookmarks