Hey all, I submit a time sheet each week for the different jobs I
have worked on. I am trying to make a spreadsheet to totalize how
many hours I have spent on a single job over the course of a year. I
have all my time sheets in one Excel file on multiple sheets. How can
I do this? Any help is appreciated.

A typical time sheet looks somewhat like this:
Job name Job # M T W Th F Sa Su Total

I envision the totalization to look something like this:
Job # Total time spent Total $$ spent

Thx.

you need to add an additional worksheet for a summary sheet.
all your worksheets need to be set up with the same format.

then, on the summary sheet, you can tell that cell to sum through all
52 worksheets & give you the total for each job.
=SUM(Sheet1:Sheet12!B6)
you can do this with formulas, you don't need a macro.
hth
susan



On Feb 23, 11:32 am, "Apollo55" wrote:
Hey all, I submit a time sheet each week for the different jobs I
have worked on. I am trying to make a spreadsheet to totalize how
many hours I have spent on a single job over the course of a year. I
have all my time sheets in one Excel file on multiple sheets. How can
I do this? Any help is appreciated.

A typical time sheet looks somewhat like this:
Job name Job # M T W Th F Sa Su Total

I envision the totalization to look something like this:
Job # Total time spent Total $$ spent

Thx.

That's good, but as you said all worksheets need to have the same
format. For your example, the formula sums all of the B6 cells
regardless if they have the same job number. One week, cell B6 could
be job 01, the next week it could be 12. So I need to do some more in
depth programming.

Right now on my summary worksheet I have an If(CountIf)) statement to
bring all the job #'s onto the new worksheet. I then filter out the
duplicates and spaces to give me a list of all the job #'s. I am
working on writing a VLOOKUP function to totalize the hours per job.
The one problem (if I can get it to work) is that it's not very
friendly to add additional worksheets to, as each week a new worksheet
gets added.

There's got to be an easier way!

Thx.