Please take a look at the file I have attached.
I have been working on a time card systems where Employees enter there time on their respective tab "Employee 1". I have a worksheet called "Weekly hours". My thought on this was to use a Sumif on the Week and day to look up on "Employee 1" sheet and put that data in it respective spot. I thought I made the formulas correct but can't seem to get it to work.
Dave
The problem I see with this is you would need a whole sheet dedicated to each individual entry. Some place to store all of data that the "Weekly Hours" is to use. Because as soon as you shifted to week 2, then week 1 would not have any data to draw on.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks