How can I add "monthly" tabs that summarize a yearly report?
 

I have created a worksheet to track work orders. How can I utilize tabs to
view the report by broken out by month, while maintaining entry of data on
the master worksheet?

How can I add "monthly" tabs that summarize a yearly report?
 

While this is possible, it may not be the easiest thing to accomplish
and manage. However, filtering is a great way to see only a portion of
your data; the Data/Filter/Autofilter command adds very flexible
filtering of your data that occurs "in place" that can be customized,
and be turned off whenever you wish.

On May 16, 2:53 pm, eg2008 wrote:
I have created a worksheet to track work orders. How can I utilize tabs to
view the report by broken out by month, while maintaining entry of data on
the master worksheet?

How can I add "monthly" tabs that summarize a yearly report?
 

If your data is arranged appropriately, you may be able to accomplish
what you want with a pivot table. Create a pivot table, put month as
the page field and then select the show pages option for you pivot
table, you will get a page for each month. If you can create a pivot
table that displays the data you want you may find the Show Pages
option is a pretty slick way to get where you want.

Ken


On May 16, 2:53*pm, eg2008 wrote:
I have created a worksheet to track work orders. *How can I utilize tabs to
view the report by *broken out by month, while maintaining entry of data on
the master worksheet?

How can I add "monthly" tabs that summarize a yearly report?
 

The real question is why you want to use "tabs" to hold monthly data. Excel
works much better when you put all your data on one sheet, and use pivot
tables to summarize the data.

However, if you really want to use separate "tabs" (they're called
worksheets), you can summarize using something like:

=sum(Jan:Dec!a1:a100)

Regards,
Fred.

"eg2008" wrote in message
...
I have created a worksheet to track work orders. How can I utilize tabs to
view the report by broken out by month, while maintaining entry of data
on
the master worksheet?