How can I break up a worksheet into weeks?

[MinConst]

This might be hard to explain but here goes.
I have this worksheet that I keep tract of Time and Materials projects. I
am a contractor. It works fine. My issue is that I have running totals for
the complete project and I bill clients weekly. So I have to figure some
things out each week. How many men worked, what was purchased that week etc.
I also share this sheet with the client so they can see what has gone on
during the project. I create a .pdf of a selected area so they don't see some
parts of the sheet. (Print Selected area).
My thought is to break the sheet into tabs. A tab for each week but I
would like one tab to show the complete worksheet. I can't think of a way to
do this. I can create tabs and copy them but am at a loss on how to make it
usable.
I hope this makes sense. I'd be happy to upload the sheet so someone can
see this better.
Thank you.

 

[ward376]

Maybe you can add a column that identifies the week - then you can use
dynamic subtotals and filters to see what's happening for a week or
group of weeks.

Cliff Edwards

 

[MinConst]

Thanks Cliff,
I'm not sure how to do what your suggesting. I will look into it and see
if I can figure it out. Sounds like a plan though.

 

[ward376]

You can send an example to my email if you'd like. It's never as
simple as I think it is, but if it is as you described, I should be
able to send you something workable back this evening.

Cliff Edwards