A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Limit Pivot Table by date



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 09:46 PM posted to microsoft.public.excel.charting
Catherine
external usenet poster
 
Posts: 144
Default Limit Pivot Table by date

I have a workbook with two worksheets, one in which people enter their data
and the other that summarizes the data with pivot tables. The 2nd worksheet
is protected. I created a macro that updates all three pivot tables
automatically. Now I need to create a macro that asks staff to enter the date
they started recruitment so that one table only shows the months and year
when recruitment started. Right now, I have to select the month/year
manually. What I would like is for staff to get one text box that asks them
when they started recruitment (month/year). Ideally they would be asked only
once. (They're going to be pretty upset with me otherwise). I looked on the
web and this site for an answer, but I'm not getting anywhere. Can someone
help me? I'm using Excel 2003 and have very! limited knowledge of VBE. An
example of the table I want to limit is below. With this example, I would
like the table to show data starting in Feb-10, excluding all monthly data
prior to Feb-10 (in this case only Jan-10). Thank you so much for your help!

Screening Date
Jan-10 Feb-10 Mar-10 Apr-10 Grand Total
Sum of Eligible 21 18 3 1 46
Sum of Enrolled 0 4 8 1 13
Sum of Consented 0 2 8 1 11


--
Catherine
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.