Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Date Ranges in Pivot Table

  Asked By: Harley    Date: Aug 15    Category: MS Office    Views: 1164
  

I am using an excel workbook as a means of scheduling staff. I can
enter their first name, week ending date, project number, and number
of hours scheduled via a userform I made. I have a couple of pivot
tables already set up, one sorts the hours by project, then by name,
the 2nd pivot table sorts name first, then project number. So far, so
good.

Now I have someone that wants me to make the pivot tables so that they
can see various date ranges, such as all the time worked in a given
month, or in the last 2 weeks, or from January to April.

Having taken only 1 VBA class, I know just enough to be dangerous.
Anyone have any ideas on how I can do this? Any help would be most
greatly appreciated!

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Date Ranges in Pivot Table Or get search suggestion and latest updates.




Tagged: