Hi there,

At the company i work for we use time sheets to keep track of the hours & jobs which our painters work at each week. They put on the job they worked at on each day and the number of hours.

We also have a spreadsheet where each tab represents a job and then on each job the hours are the amount for labour each week is then inputted for each person that worked on that job. This process takes a lot of time to process the time sheet into the spreadsheet.

I want a way to be able to have a front tab to our costings spreadsheet where we can enter what the time sheets show. Basically an exact copy of what the time sheet looks like but on computer. We then take the paper copy and enter the information in, once completed we somehow press submit and it distributes the information to the relevant job tabs??

Any ideas, all i have though of at the moment is drop menus so that the correct job can be chosen and easy sum functions to calculate the hours by the painters rate??

A big task i would guess but please can anyone help,

kind regards

brandon