LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How can I break up a worksheet into weeks?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
page break settings for excel worksheet Roger Setting up and Configuration of Excel 1 July 11th 07 10:26 PM
Break cell into multiple lines by line break Chia Excel Discussion (Misc queries) 1 August 20th 06 06:37 AM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
calculate weeks from a start date ( not yr weeks) Todd F. Excel Worksheet Functions 6 November 27th 04 05:53 PM
Copy worksheet with Pivot Table and break link to original workshe setter-lover Excel Worksheet Functions 0 November 18th 04 09:29 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"