Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months
Hi Sumit, I had called you several times for my previous query regarding outstanding status, but it saying number invalid. I need to speak to you. In this case, I can't use pivot table in this scenario. Because lot of other issues attached with this. I have to use formula here. Thanks Kalyan On Sat, Oct 9, 2010 at 11:08 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear one colum set structure :- month = jan-2008 jan-2009 jan-2010 then use use pivot table On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel kalx...@gmail.com wrote: Hi Worawat, Thanks for your advice. But I can't use pivot table in this scenario. Because lot of other issues attached with this. Thanks Kalyan On Sat, Oct 9, 2010 at 3:43 AM, worawat kh worawat...@gmail.comwrote: Hi Kalyan You can use pivot table to solve this , better than use many excel function Worawat 2010/10/8, Kal xcel kalx...@gmail.com: Dear Experts, I want to extract last 3 months consolidated sale data based on current month. I have attached the file with my query. 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Moo Moo' I have much time for give you -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Losing weight
Hi, Templates are available on Microsoft online. You can download them for free. Hope that helps. Warm regards, Anand Kumar On Oct 8, 6:44 pm, Shimmy morur...@gmail.com wrote: Hi Excellers, I am having a problem, I am trying to lose some weight, it is for tha reason that I would like to request anyone of you to send me a template that I can use to check my weight, either in excel of access format- diet tips could come in handy alongside that template. Preferably the tips should be in either PDF format or on a word processor. Your help in this regard would come in handy. Thank you in advance! -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Rupee symbol HOW ???
Hi, I have done following tricks but not satisfied as : 1) Select the column/cell where you want to have the format with the new ` rupee symbol. 2) Change the format of the cell to Currency. 3) Go to Cell Format - Choose Custom and paste the following: [999]` ##\,##\,##\,##0.00;[9]` ##\,##\,##0.00;`##,##0.00 4) Change the font of the column/cell selected to Rupee Fordian. And thats all you need. but when i am doing this trick in excel it is not working please tell me step by step to get new Rupee Symbol can mentioned in excel platform Regards sajid memon -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Please help
could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hi Excel Guru, Please assist me in this concern . Attached are two sheets Task distribution orginal and other sheet with task distribution My daily activity is to do vlookup and firstly i will copy the pivot table from task distribution sheet orginal and paste special in one new excel sheet then compare it with another sheet which is task distribution sheet. 1) Prepare vlookup to find the batches which are pending . once i perform vlookup it will display the names against the batches. which are pending . Please advise is this possible through vba. Thanks for your help in advance., Raj -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Rupee symbol HOW ???
Check out here: http://bishwajeet.blogspot.com/2010/07/steps-to-include-indian-rupee-symbol.html On Sat, Oct 9, 2010 at 3:17 PM, SAJID MEMON sajidwi...@hotmail.com wrote: -- Hi, I have done following tricks but not satisfied as : 1) Select the column/cell where you want to have the format with the new ` rupee symbol. 2) Change the format of the cell to Currency. 3) Go to Cell Format - Choose Custom and paste the following: [999]` ##\,##\,##\,##0.00;[9]` ##\,##\,##0.00;`##,##0.00 4) Change the font of the column/cell selected to Rupee Fordian. And thats all you need. but when i am doing this trick in excel it is not working please tell me step by step to get new Rupee Symbol can mentioned in excel platform Regards sajid memon -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Simple Excel Macro ??
Hi Guys, I have been banging my head trying to figure out how to do this No luck. I am looking for a simple macro that will go to this webpage http://contests.covers.com/sportscontests/leaders.aspx?sportID=6ID=15070sRec=1eRec=50hiddenSportID=0 Will pick records 1 through 50 and copy it to a spreadsheet. Then it go back to the same page press the next button that will bring you to records 51 through 100 and again copy it to the spreadsheet directly below record 50. IT would then continue on in a loop until it reached the end of the file. Sorry, my limited knowledge with VBA cannot figure this out. Would appreciate any help. Thanks. -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ VLOOKUP function
I am using Excel 2007 and having a strange problem with the VLOOKUP function. I have never used it before, but I have looked at examples on the Internet. However, I cannot figure it out. I placed the following formula in Cell B2: =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE) and then copied it to B3 and B4, which respectively show up as: =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE) =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE) My lookup table is located at D2:E9, with what I am looking up in column D, and the value for the lookup in column E. I placed the second entry in the table in cells A2, A3, and A4. The VLOOKUP functions in cells B2, B3, and B4 show the following results: B2: #VALUE! B3: second entry in the table, same as in A3 B4: the correct lookup value. This does not make any sense to me, based on the examples I have seen. What am I doing wrong? Thanks, Alan -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ VLOOKUP function
Hi Alan, The third part of the formula, where you've put $E:$E has to be replaced by either 1 or 2(since your table array is just D and E column). Thanks, Shreedar On Sun, Oct 10, 2010 at 2:30 AM, Alan jalantho...@verizon.net wrote: I am using Excel 2007 and having a strange problem with the VLOOKUP function. I have never used it before, but I have looked at examples on the Internet. However, I cannot figure it out. I placed the following formula in Cell B2: =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE) and then copied it to B3 and B4, which respectively show up as: =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE) =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE) My lookup table is located at D2:E9, with what I am looking up in column D, and the value for the lookup in column E. I placed the second entry in the table in cells A2, A3, and A4. The VLOOKUP functions in cells B2, B3, and B4 show the following results: B2: #VALUE! B3: second entry in the table, same as in A3 B4: the correct lookup value. This does not make any sense to me, based on the examples I have seen. What am I doing wrong? Thanks, Alan -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts