Re: $$Excel-Macros$$ 12 secret shortcuts of Excel

Hi All, It was great to see that the group has completed 3 yrs and my heartful thanx to all those guys who shared their thoughts and ideas about excel here. Infact, i learnt a lot of things abt excel after joining this group and KUDOS TO EVERYONE[?] Many Thanks, Pavithra On Sat, Apr 3, 201

Re: $$Excel-Macros$$ 12 secret shortcuts of Excel

Thanks Ayush for providing this great book and congrats on completing three years by the great group that is created by you and now it becomes a important part of my daily life I must say this. The solutions provided by the groups are so accurate and easy to use. Keep up good work and great going a

$$Excel-Macros$$ Re: 12 secret shortcuts of Excel

Ayush, Congratulations! for completing three years of helpful service. This is the only one group i have seen in GoogleGroups that is so much active. I must say its a tremendous effort of the Group Moderators. No doubt, the help this group has provided and the learning it gives us, is simply imm

$$Excel-Macros$$ Find and Replace with an entire line from a another worksheet

Need help with a find and replace type macro. I've tried VLOOKUP but I don't think it will provide what I'm looking for. I have a column of numbers in Sheet A that I correspond with a row of data in Sheet B. Sheet B has thousands of lines of data that I do not need, I only need the several dozen

Re: $$Excel-Macros$$ Need urgent Help.

Hi, PFA file for solution Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Apr 2, 2010 at 3:45 PM, Baby Patel wrote: > Hi All, > > Can anyone help me providing the quick guide on excel formulas. > > I know muchbut want to prepre for an interview. > > Also can you ple

Re: $$Excel-Macros$$ 12 secret shortcuts of Excel

Congrats everyone for completing 3 years. I know all of us would like to thank the Creators of this group Ayush ans Ashish for making our life easier. Ayush, the Ebook is simply awesome. Finally, thanks to all the members for keeping this group alive. Now, lets make it imortal ;) Thanks & Rega

Re: $$Excel-Macros$$ Assistance required

Hi All, I`m doing an anlysis for a stock where i need to identify the excess stock purchased despite availability of stock (stock lying without any consumption) in the sucessive months. Attached is the sample file (actual file line items are more 1 lac). Please help me out on the same. Thanks &

$$Excel-Macros$$ qx() enhanced database function

http://www.douglaswilliamsmith.net/Excel_Functions/ Frequent use of database functions in Excel over my career prompted me to start making an enhanced ‘user defined’ function in Excel for retrieving data from Excel databases in the mid 90’s. In the meantime, functionality has been continually adde

$$Excel-Macros$$ convert variant() to string

Hi All, I am writing a VBA macro in Microsoft Excel 2007 and run into the following problem Due to back-compatibility reasons, I have to do define a named range from C1 to E12 called "data_area". I need to refer to this named range in my code C1 to E1 are column names, e.g., Column1, Column2, Co

$$Excel-Macros$$ Need urgent Help.

Hi All, Can anyone help me providing the quick guide on excel formulas. I know muchbut want to prepre for an interview. Also can you please help me with below problem there are three columns as follows post code value 1 value2Value3 WQ1 2GX 2000 3000 WQ15sx5

$$Excel-Macros$$ Assistance required

Hi All, I`m doing an anlysis for a stock where i need to identify the excess stock purchased despite availability of stock (stock lying without any consumption) in the sucessive months. Attached is the sample file (actual file line items are more 1 lac). Please help me out on the same. Thanks &

RE: $$Excel-Macros$$ Sum Product use in Macro

Hi, It seems that Sumproduct doesn't work as expected in VBA. I have found that I need to use 'Evaluate' So, if your worksheet formula was, for example: SUMPRODUCT((A2:A200="Yes")*(B2:B200)) Then the VBA equivalent would be: YourVariable = Evaluate("SUMPRODUCT((A2:A20=""Yes"")*(B2:B20))") Note th

$$Excel-Macros$$ Need advise

Hi All, Myself rajasekher just require your valuable suggestion in this concern, please advise the excel formular where in i can use and the words for the value specified in excel. for example if the value in excel is 80 (numerical) ... i need this 80(numerical) towords as eighty,..