Dear all
I show you what I want in my attach file please help me on it and show me in the file your solution.
thanks in advanced
Dear all
I show you what I want in my attach file please help me on it and show me in the file your solution.
thanks in advanced
Hi pedjvak,
If you do a Pivot Table and Chart and then FILTER them by the dates, I think that is what you want..??
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
thanks for your answering to my question
but I dont want use pivot table
I want my user insert date in 2 cells by himself like that I show you in my file
Hi pedjvak,
I'm sorry but I don't know how to do that. I've tried to use Dynamic Named Ranges but don't know how to limit the X axis range using two input cells.
I'll study and see if I can find a better answer. There might be a way using VBA Code. Do you want me to follow that or will you allow VBA code to be used?
Last edited by MarvinP; 02-03-2015 at 02:27 AM.
Hi pedjvak,
try
![]()
Please Login or Register to view this content.
Dear nilem
when I copy your code to my original file it is not working
I update all of your address to what that it to be in my file
problem is here that the name("nom" &"qnt") will not create by your code in my file
what can I do ?
Last edited by pedjvak; 02-03-2015 at 06:34 AM.
try to create these named ranges manually (this should be done once)
see also attached file
Thanks and hope you will safe & success
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks