I use excel 2003 to enter labor hours for my employees. Column A is date,
Column B is job #, Column C is job name, Column D is job address, Column E is
lunch break, Column F is start time, Column G is stop time, and Column H is
total hours for the day. I have several tabs down at the bottom which is
each employees work times and history, ie I have a tab for scott, eric, rod,
etc. What I would like to do is be able to EASILY print a report by column B
(job number) that would automatically tell me how many job labor hours we
have accumulated for that particular job. I would also like the report to
break down each employee (or tab) with how many hours each has towards that
particular job. All the while without messing up the order of my cells, etc.
Is there anyone out there that would know how to do this sort of thing?