Re: $$Excel-Macros$$ Sales Dashboard
not good, u r showcasing more data in charts and diagrams an dnot in numbers. Regards, Shahina --- On Wed, 1/19/11, Kal xcel kalx...@gmail.com wrote: From: Kal xcel kalx...@gmail.com Subject: $$Excel-Macros$$ Sales Dashboard To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI noorain.ans...@gmail.com, Dilip Pandey dilipan...@gmail.com, koul.ashish koul.ash...@gmail.com, ayush jain jainayus...@gmail.com, anandydr anand...@gmail.com, davebonall...@hotmail.com, C.G.Kumar kumar.bemlmum...@gmail.com Date: Wednesday, January 19, 2011, 1:43 PM 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Sumifs and date formatting
Kindly attach the XL On Jan 20, 10:53 am, Manoj kumar manoj.vishwakarma...@gmail.com wrote: please send us an attachment.. Regards, Manoj Kumar On Thu, Jan 20, 2011 at 9:51 AM, solsbee joesolsbe...@gmail.com wrote: I am doing a data dump into and excel spreadsheet and the date format that I get is MMDD. I am trying to sum the data by two criteria using the sumifs function, but I keep getting an answer of zero, when I know that is not the correct total. I changed the date format, but still get the same answer of zero. When I click on the insert function on my toolbar to look at my formula, the cell with a date of 1/3/10 shows a result of 40181. I know this is the excel date function starting from 1900, but I don't know how to fix it. Someone please help, it will save me so much time if I can sum all of the data by two criteria. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul
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 TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Sales Dashboard
Dashboard 1 Looking better On Jan 19, 1:13 pm, Kal xcel kalx...@gmail.com 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 50KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: UDF as trigger
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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Sumproduct Query ********** 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 realsa...@gmail.com wrote: 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 TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel abc.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sales Dashboard
Very Nice Mr. Kalyan On Wed, Jan 19, 2011 at 1:43 PM, Kal xcel kalx...@gmail.com 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help req
*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 on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Help Required..xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sales Dashboard
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 shannur...@yahoo.com not good, u r showcasing more data in charts and diagrams an dnot in numbers. Regards, Shahina --- On *Wed, 1/19/11, Kal xcel kalx...@gmail.com* wrote: From: Kal xcel kalx...@gmail.com Subject: $$Excel-Macros$$ Sales Dashboard To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI noorain.ans...@gmail.com, Dilip Pandey dilipan...@gmail.com, koul.ashish koul.ash...@gmail.com, ayush jain jainayus...@gmail.com, anandydr anand...@gmail.com, davebonall...@hotmail.com, C.G.Kumar kumar.bemlmum...@gmail.com Date: Wednesday, January 19, 2011, 1:43 PM 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Unique records
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 koul.ash...@gmail.com wrote: check the attachement see if it helps On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi All, Can anyone help me with the code in *VBA *to find unique values and pasting it separately in Excel. Regards Umesh Dev -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to turn on the auto list for Excel Function?
its an excel 2007 feature On Fri, Jan 14, 2011 at 3:00 AM, Mao yanjiemao...@gmail.com 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 the function: concatenate. I will write =conca And the remaining part will pop up. The only thing I need do is to hit tab instead of filling the characters one by one. Which step can bring this auto filling back alive to my Excel? Thanks in advance! Mao -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Requesting help to generate progress reports in Excel ...
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 should calculate to 45%. This would means the win percentage for each player should be smaller as well. Can you verify this? Regards, Greg On Thu, Jan 20, 2011 at 12:03 PM, Ayush Jain jainayus...@gmail.com wrote: Hi Greg, I have modified the Pie chart as required by you. Please see attached file and let me know for any further assistance required. Best Regards, Ayush Jain Group Manager and Microsoft MVP On Wed, Jan 12, 2011 at 12:02 PM, ayush jain jainayus...@gmail.comwrote: Hi Greg, Due to some office work, i have not responded you on this...I hope to get back to you by this weekend on this... BR, Ayush Jain On Wed, Jan 12, 2011 at 7:09 AM, Greg Mouning gamoun...@gmail.comwrote: Dear Ayush, Thank you the graphs you generated look awesome! I love the bar chart particularly as it demonstrates our team progress over 16 weeks. As for the pie chart, I am not sure that it represents what I am looking to report. I guess first, I want a pie chart that shows 9 slices. Because there are 16 weeks of data and I can only play 5 out of 8 players each week; the total number of weeks (16) multiplied by (5) matches equal 80 total matches. I think it needs to use all 80 games and create a percentage of each persons wins which demonstrates their individual contribution. This percentage, should should make up 8 slices of the pie, one for each player. Finally, there needs to be (1) remaining slice to represent the remainder of the pie which is the total matches loss. If there is a way to add the win/loss records of individual players, that would be perfect. For example, in my case I played 11 matches, so it needs to display the following data inside of my slice of the pie: G Mouning 8% (3-8) I don't know if this explanation is any more helpful but I thought I should try to explain what I want differently. Thanks again for your additional assistance. Best regards, Greg On Sun, Jan 9, 2011 at 9:52 AM, ayush jain jainayus...@gmail.comwrote: Hi Greg, Please see if the charts created in attached Excel workbook helps you. Feel free to write back if you need any further assistance. Thanks. Best Regards, Ayush Jain Group Manager Microsoft MVP. On Sun, Jan 9, 2011 at 9:53 AM, Greg gamoun...@gmail.com wrote: Hello, Happy New Year! It has been a couple of months and I have not received an answer to a request I made. I would like to know how to generate Pie Charts and Bar Graphs based on data in an Excel spreadsheet. If it is helpful, I have made my Excel Spreadsheet called, Fall_Session_Data.xls available at the following weblink: http://db.tt/Ynfa44I Thanks in advance for your assistance. -Greg On Nov 12 2010, 3:38 pm, Greg gamoun...@gmail.com wrote: Hi, I am a newbie to Excel and think I have a simple request but do not know how to get started. I would like to request help in generating progress reports for team mates on my in house league 8-ball pool team. I have been keeping a tally for the past 9 weeks of each persons wins and losses. I want a pie chart to illustrate their contribution to the team for the past 9 weeks. For example, I would like to see a percentage based on the total number of wins for each person. This percentage is displayed as percent/piece of the pie. Next, I would like to show a bar graph or line chart (like the stock market charts) for each individual illustrating their win/loss records from week 1 up through week 9. BTW, please include instructions on how best to enter my data in the Excel spreadsheet. I'm told this may need a pivot table but I know nothing about how to create them. Thanks in advance for any assistance you can provide. Kind regards, Greg -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Best regards, Ayush Jain -- Best regards, Ayush Jain -- Best regards, Ayush Jain -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on
Re: $$Excel-Macros$$ Query
thank you On Wed, Jan 19, 2011 at 9:55 AM, Dave Bonallack davebonall...@hotmail.comwrote: 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@googlegroups.com Thanks for reply, now attached sheet is very clear. Aamir Shahzad On Tue, Jan 18, 2011 at 10:10 AM, ashish koul koul.ash...@gmail.comwrote: check the attachment see if it helps you On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack davebonall...@hotmail.com wrote: Sorry Aamir, Can't understand the question. If your worksheet had a cell with the desired answer in it (entered manually) this may help me understand your request. Regards - Dave. -- From: aamirshahza...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Date: Mon, 17 Jan 2011 23:31:49 +0500 Dear experts, How to resolved attached query, can anybody tell formula not macro. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email
Re: $$Excel-Macros$$ How to turn on the auto list for Excel Function?
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 santoshbahug...@gmail.com wrote: its an excel 2007 feature On Fri, Jan 14, 2011 at 3:00 AM, Mao yanjiemao...@gmail.com 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 the function: concatenate. I will write =conca And the remaining part will pop up. The only thing I need do is to hit tab instead of filling the characters one by one. Which step can bring this auto filling back alive to my Excel? Thanks in advance! Mao -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Help req
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 rksharma...@gmail.com wrote: *Hi ,* * * * * *Please help me to make simple dashboard to modified .* * * *for reference see attachment,* * * * * *thanks in adv..* -- Regards Rakesh Sharma Help Required..xls 36KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ NEEDHELP
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 around 40-50 mails. could any one please assist me in suggesting the macro code to perform this activity. i will attach the letters and database . please advise is this possible to update through vba access or excel macro. i could be very much thankful for your help. Regards, Prathima - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent Requirement of VBA Developer
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. From: Jitendra Verma jitendra.kumarve...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, 20 January, 2011 4:08:06 PM Subject: $$Excel-Macros$$ Urgent Requirement of VBA Developer Hi All, I have 6+ year of IT experience in Excel, VBA, Addin, SQL Server 2008. I want Urgent job and i can join within 15 days. If anybody have requirement please let me know. Thanks in advance! please find attached my latest profile. Thanks and Regards,Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Help req
not getting any idea after seeing ur data, plz elaborate ur issue On Jan 21, 4:21 am, Prakash Gusain gusainprak...@gmail.com 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 rksharma...@gmail.com wrote: *Hi ,* * * * * *Please help me to make simple dashboard to modified .* * * *for reference see attachment,* * * * * *thanks in adv..* -- Regards Rakesh Sharma Help Required..xls 36KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul
Thank a lot Ashish and Vijay. From: ashish koul koul.ash...@gmail.com 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 * 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 realsa...@gmail.com wrote: 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 TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel