Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread SG
Thankyou so much Vabz On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG sona...@gmail.com javascript: wrote: yeah got it...one more thing..in reports, we can't say customer to select * for All because it's not user

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread Vaibhav Joshi
Cheers!! On Thu, Jun 19, 2014 at 4:03 PM, SG sonal...@gmail.com wrote: Thankyou so much Vabz On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG sona...@gmail.com wrote: yeah got it...one more thing..in reports, we can't

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
Hi In cell C2 put * (only asterik) instead of ALL. Cheers!! On Wed, Jun 18, 2014 at 6:10 PM, SG sonal...@gmail.com wrote: Hi Experts, I'm looking for a solution to summarise the data based on multiple criterias in drop downs. My data has 3 dropdowns.I have tried it using advance filter

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
Amazing Vabz...thanksss..Can you please explain the idea behind this??? On Wednesday, June 18, 2014 6:30:28 PM UTC+5:30, Vabz wrote: Hi In cell C2 put * (only asterik) instead of ALL. Cheers!! On Wed, Jun 18, 2014 at 6:10 PM, SG sona...@gmail.com javascript: wrote: Hi Experts, I'm

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
when you say ALL, for excel / computer it is * (asterik), remember old days when DOS were used where command was Dir *.* Cheers!! On Wed, Jun 18, 2014 at 6:48 PM, SG sonal...@gmail.com wrote: Amazing Vabz...thanksss..Can you please explain the idea behind this??? On Wednesday, June 18,

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
yeah got it...one more thing..in reports, we can't say customer to select * for All because it's not user friendly. What to do in that case?? On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote: when you say ALL, for excel / computer it is * (asterik), remember old days when DOS were

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG sonal...@gmail.com wrote: yeah got it...one more thing..in reports, we can't say customer to select * for All because it's not user friendly. What to do in that case?? On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote: when you