Re: $$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul

2011-01-20 Thread hanumant shinde
Thank a lot Ashish and Vijay. From: ashish koul To: excel-macros@googlegroups.com Sent: Thu, 20 January, 2011 4:09:38 PM Subject: Re: $$Excel-Macros$$ Re: Sumproduct Query ** Ashish Koul hi not much difference between using (-- and , ) and using *

$$Excel-Macros$$ Re: Help req

2011-01-20 Thread saggi
not getting any idea after seeing ur data, plz elaborate ur issue On Jan 21, 4:21 am, Prakash Gusain wrote: > What are you looking for Rakesh?  Kindly explain it little bit more. > > Prakash Singh Gusainhttp://prakashgusain.blogspot.com > > On Jan 20, 6:01 pm, Rakesh Sharma wrote: > > > > > > >

Re: $$Excel-Macros$$ Urgent Requirement of VBA Developer

2011-01-20 Thread hanumant shinde
There are lots of openings. just upload your profile on naukri and monster and you will be tortured by consultancies. i have kept my resume inactive coz i just shift to another comp but still i am getting calls and mails. just ur resume should have lots of VBA VBA and Macro macro.

$$Excel-Macros$$ NEEDHELP

2011-01-20 Thread Prathima R
hi experts, i have one access database where i upload the data from outlook sentmails.all the fields in database are consistent and mail format is also default .but there are around 18-22 fields in the access database template i need to input data from the mail.like these i will be inputting aroun

$$Excel-Macros$$ Re: Help req

2011-01-20 Thread Prakash Gusain
What are you looking for Rakesh? Kindly explain it little bit more. Prakash Singh Gusain http://prakashgusain.blogspot.com On Jan 20, 6:01 pm, Rakesh Sharma wrote: > *Hi ,* > * > * > * > * > *Please help me to make simple dashboard to modified .* > * > * > *for reference see attachment,* > * >

Re: $$Excel-Macros$$ How to turn on the auto list for Excel Function?

2011-01-20 Thread Aamir Shahzad
use excel 2007 or 2010, your requirement fulfill by these versions only. Aamir Shahzad On Thu, Jan 20, 2011 at 8:54 PM, santosh bahuguna wrote: > its an excel 2007 feature > > > On Fri, Jan 14, 2011 at 3:00 AM, Mao wrote: > >> Hi, >> >> I have a very stupid question here. I am using Excel 2003

Re: $$Excel-Macros$$ Query

2011-01-20 Thread Aamir Shahzad
thank you On Wed, Jan 19, 2011 at 9:55 AM, Dave Bonallack wrote: > Hi Aamir, > Have a look at the attached. > Regards - Dave. > > -- > Date: Tue, 18 Jan 2011 23:28:27 +0500 > Subject: Re: $$Excel-Macros$$ Query > > From: aamirshahza...@gmail.com > To: excel-macros@go

Re: $$Excel-Macros$$ Re: Requesting help to generate progress reports in Excel ...

2011-01-20 Thread Greg Mouning
Hi Ayush, Awesome job! The pie chart displays the contents I requested. However, I question the win/loss percentage. It should total 100% and currently it totals 155%... I believe the total loss percentage = 55% is accurate as we had a losing session. That would mean the total win percentage shou

Re: $$Excel-Macros$$ How to turn on the auto list for Excel Function?

2011-01-20 Thread santosh bahuguna
its an excel 2007 feature On Fri, Jan 14, 2011 at 3:00 AM, Mao wrote: > Hi, > > I have a very stupid question here. I am using Excel 2003. I don't > know why when I am trying to enter a function in the spreadsheet, the > remaining part will not show up. > > For example, when I am trying to enter

Re: $$Excel-Macros$$ Unique records

2011-01-20 Thread Umesh Dev
Hi Ashish Thank you ... You made it very simple. I was finding it difficult to loop. Thanks Omar for the input. Thanks and Regards Umesh Dev On Sat, Jan 15, 2011 at 9:53 PM, ashish koul wrote: > check the attachement see if it helps > > > On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev wrote: > >

Re: $$Excel-Macros$$ Sales Dashboard

2011-01-20 Thread Jorge Marques
I agree with Shahina, you should show more number informations, but in a esthetic way i prefer the second one, but brighten a little the colors! Regards, Jorge 2011/1/20 shannu shannu > not good, u r showcasing more data in charts and diagrams an dnot in > numbers. > > Regards, > Shahina > > -

$$Excel-Macros$$ Help req

2011-01-20 Thread Rakesh Sharma
*Hi ,* * * * * *Please help me to make simple dashboard to modified .* * * *for reference see attachment,* * * * * *thanks in adv..* -- Regards Rakesh Sharma -- -- Some important links for excel users: 1. Follow us o

Re: $$Excel-Macros$$ Sales Dashboard

2011-01-20 Thread SUMIT VYAS
Very Nice Mr. Kalyan On Wed, Jan 19, 2011 at 1:43 PM, Kal xcel wrote: > Dear All, > > > I am sharing two types of outlook of a Sales Dashboard which I am preparing > for my company. I need your honest comment that looks wise which one is > better. > > > > Thanks in advance > > Kalyan > > -- > >

Re: $$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul

2011-01-20 Thread ashish koul
hi not much difference between using (-- and , ) and using * attached sample u can check for one of the differences go through the link *http://www.xldynamic.com/source/xld.SUMPRODUCT.html* it will complete information . On Thu, Jan 20, 2011 at 12:25 PM, saggi wrote: > > Kindly go thr

$$Excel-Macros$$ Re: UDF as trigger

2011-01-20 Thread The Frog
Can you post your code for the UDF so we can see what you are trying to do. I have had no issue changing multiple cells / worksheets / workbooks from a single UDF. But maybe we are not talking the same thing. Can you share with us what you are doing? The Frog -- -

$$Excel-Macros$$ Re: Sales Dashboard

2011-01-20 Thread saggi
Dashboard 1 Looking better On Jan 19, 1:13 pm, Kal xcel wrote: > Dear All, > > I am sharing two types of outlook of a Sales Dashboard which I am preparing > for my company. I need your honest comment that looks wise which one is > better. > > Thanks in advance > > Kalyan > >  Dashboard.xlsx > 50K

$$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul

2011-01-20 Thread saggi
Kindly go through below given link, Surely u will get all answer of your query http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ Regards Vijay -- -- Some important links for excel users: 1. Follow us on TW

Re: $$Excel-Macros$$ Sumifs and date formatting

2011-01-20 Thread saggi
Kindly attach the XL On Jan 20, 10:53 am, Manoj kumar wrote: > please send us an attachment.. > > Regards, > Manoj Kumar > > > > > > > > On Thu, Jan 20, 2011 at 9:51 AM, solsbee wrote: > > I am doing a data dump into and excel spreadsheet and the date format > > that I get is MMDD.  I am try

Re: $$Excel-Macros$$ Sales Dashboard

2011-01-20 Thread shannu shannu
not good, u r showcasing more data in charts and diagrams an dnot in numbers.   Regards, Shahina --- On Wed, 1/19/11, Kal xcel wrote: From: Kal xcel Subject: $$Excel-Macros$$ Sales Dashboard To: excel-macros@googlegroups.com Cc: "NOORAIN ANSARI" , "Dilip Pandey" , "koul.ashish" , "ayush jain"