Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-09 Thread sudheer lolla
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, s

Re: $$Excel-Macros$$ VLOOKUP function

2010-10-09 Thread Shreedar Pandurangaiah
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.

$$Excel-Macros$$ VLOOKUP function

2010-10-09 Thread Alan
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 B

$$Excel-Macros$$ Simple Excel Macro ??

2010-10-09 Thread Bill Q
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

Re: $$Excel-Macros$$ Rupee symbol HOW ???

2010-10-09 Thread krishna mummina
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

Re: $$Excel-Macros$$ Please help

2010-10-09 Thread rajasekhar praharaju
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. >

$$Excel-Macros$$ Rupee symbol HOW ???

2010-10-09 Thread SAJID MEMON
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;[

$$Excel-Macros$$ Re: Losing weight

2010-10-09 Thread anandydr
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

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-09 Thread Kal xcel
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