golf4
09-27-2004, 10:01 PM
Hi, everyone -
I think some have seen my Timesheet tool (developed with the expert help from people here and on mrexcel.com), but I've run into a brick wall. One of our federal housing programs is changing drastically, and I've found I need to really change around our tool. UUUGGGG.... these programs are turning my hair even greyer than it is now!!! :p
Our current Timesheet has the user manually enter their hours per day (reguklar hours, OT, various leaves, etc.). When the Timesheet is printed, the total hours are broken down, %-wise, between our various housing programs. The MAJOR change is that, now, HUD is requiring hours (employee costs) to be broken down by development (building) in addition to %-wise as above. The easiest way to do this would be through our work order system, i.e. 2 hours working in Building A, 3 hours working in Building B, etc. The wall I've run into is how to transpose these types of hours into our Timesheet tool.
I've created a data entry sheet where the user would enter work order numbers, the applicable date of the work order, and the hours spent in each building. Column A is work order numbers, Column B is the date of the work order, Column C through Column W are the columns related to each building.
The question I have is what would be the best way to transpose the hours entered in the data entry sheet into the Timesheet tool. CLEAR AS MUD, HEH??? :dunno
If it would make it easier to see what I'm talking about, I could zip the tool up and post it or e-mail it out to those interested in taking a look at my problem. I would appreciate any assistance on this one.
Thanks for the help,
Golf
I think some have seen my Timesheet tool (developed with the expert help from people here and on mrexcel.com), but I've run into a brick wall. One of our federal housing programs is changing drastically, and I've found I need to really change around our tool. UUUGGGG.... these programs are turning my hair even greyer than it is now!!! :p
Our current Timesheet has the user manually enter their hours per day (reguklar hours, OT, various leaves, etc.). When the Timesheet is printed, the total hours are broken down, %-wise, between our various housing programs. The MAJOR change is that, now, HUD is requiring hours (employee costs) to be broken down by development (building) in addition to %-wise as above. The easiest way to do this would be through our work order system, i.e. 2 hours working in Building A, 3 hours working in Building B, etc. The wall I've run into is how to transpose these types of hours into our Timesheet tool.
I've created a data entry sheet where the user would enter work order numbers, the applicable date of the work order, and the hours spent in each building. Column A is work order numbers, Column B is the date of the work order, Column C through Column W are the columns related to each building.
The question I have is what would be the best way to transpose the hours entered in the data entry sheet into the Timesheet tool. CLEAR AS MUD, HEH??? :dunno
If it would make it easier to see what I'm talking about, I could zip the tool up and post it or e-mail it out to those interested in taking a look at my problem. I would appreciate any assistance on this one.
Thanks for the help,
Golf