Quote:
Originally Posted by Claus Busch
Hi,
Am Tue, 4 Mar 2014 22:38:28 +0000 schrieb taimysho0:
the last question is, in your date
modify code above, how would i modify it so that the results displayed
are always within the last 90 days? so for example anything older than
90 days gets deleted. thanks so much!
you can filter your date for the last 90 days. The chart shows only the
values in the visible cells. So you can keep all your data.
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
ahh i see. thanks for that suggestion, however this would be a manual filter every time i want to filter this. my goal is to include all these manual steps in a macros so that when a user clicks a button, the raw data will be transformed to dates, and displaying only the last 90 days, and then from here, count the number of dates with same dates, and then create a graph from this data. everything else should be deleted and only graph appearing. thats the goal of the macros. im trying to include your code into the macros but having a hard time writing the code for the = last 90 days filter. thanks agian for any help!! :)