I am trying to set up a spreadsheet that scheduling people can use to schedule the amount of time they want staff to spend on a project. I have already set up pivot tables that show the total information broken down by project, and broken down by staff person. Now they want me to make it so they can see time scheduled for a specific period - i.e. all time scheduled between the dates of 1/02/07 to 1/21/07. None of these people are smart enough to know how to manipulate the data to accomplish this - they would just like to enter 2 dates, and have Excel just re-create the pivot tables. Does anybody have any idea how I can accomplish this? Any assistance would be most greatly appreciated. Thanks!
2007-01-29 08:20:44 · 2 answers · asked by Michael P 1 in Computers & Internet ➔ Programming & Design
Try posting your question with some basic examples at mrexcel.com and you can get a very cogent explanation of what to do
2007-01-29 08:25:28 · answer #1 · answered by Mictlan_KISS 6 · 0⤊ 0⤋
You'll need to learn to generate pivotables using vba. Record the whole session and see the code vba generates. Tweak here and there, soon you'll get an ideal how to customize it.
Using Excel for that is an overkill. Perhaps there are other simpler solutions you haven't considered.
2007-02-01 00:35:06 · answer #2 · answered by unnga 6 · 0⤊ 0⤋