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 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 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 wrote: >> >>> Hi Kalyan >>> >>> You can use pivot table to solve this , >>> better than use many excel function >>> >>> >>> Worawat >>> >>> 2010/10/8, Kal xcel : >>> > 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=wall&ref=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=wall&ref=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=wall&ref=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=wall&ref=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=wall&ref=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 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=wall&ref=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=wall&ref=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 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=wall&ref=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=wall&ref=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=wall&ref=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 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=wall&ref=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=wall&ref=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=6&ID=15070&sRec=1&eRec=50&hiddenSportID=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=wall&ref=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: , 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=wall&ref=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 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: , 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=wall&ref=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=wall&ref=ts
Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET
How to do that progamatically using VBA... On 10/8/10, krishna mummina wrote: > > Hey Dude, > > > Do this, > > > Select the Cell which you want to delete and Ctrl+Select Every Sheet, then > press Delete. > > > I hope it will helpful. > > > Regards, > Krrish > > > On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla wrote: > >> Hi guys >> >> >> I Have a column "xyz" which is there in every sheet of the workbook >> and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1 >> >> >> If i delete a value from that column "xyz" in sheet A,the deleted cell has >> to be deleted from these B,C sheets >> But the vice-versa should not happen i.e Delete of a cell in column "xyz" >> of sheet B or C should not delete from A >> For me sheet A is a base sheet >> >> >> >> >> "DELETE REFLECTS ALL SHEETS IS WHAT I NEEDED" >> >> >> I will be very thankful to this community if i get some answer. >> >> >> Thanks >> sudheer.L >> >> >> -- >> >> -- >> 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=wall&ref=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=wall&ref=ts > -- sudheer.L -- -- 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=wall&ref=ts
