Re: $$Excel-Macros$$ Help Required

hello rakesh, Only for this attached sheet do you have query or Prior chain mails as well, then i think u can just use this formula for the attached sheet replacing date =A2+30 By adding 30days u are getting the answer...Please let me know if this resolves your query or not. Thanks, R

Fwd: $$Excel-Macros$$ Vlookup

Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. -- Forwarded message -- From: muralidhar e Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members,

Re: $$Excel-Macros$$ Vlookup

Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote: > Dear all group members, > > I want

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

All, Thanks alot for your help, formula are working. Hugs & Love ... On Wed, Nov 10, 2010 at 2:30 PM, saggi wrote: > > .e. In cell C4: > > > =text(B4,"mmm") > > > > After this use > > =SUMIF($C$3:$C$25,I8,$A$3:$A$25) > > On Nov 10, 1:45 pm, ashish koul wrote: > > chekc the attachment se

$$Excel-Macros$$ Vlookup

Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- ---

$$Excel-Macros$$ Help Required

Dear All, Can i replace the date as per my requirement. if yes plz suggest me how it possible. Thanks in advance plz do the needful ASAP. -- Regards Rakesh Sharma -- -- Some important links for excel users: 1. F

$$Excel-Macros$$ Re: Fwd: Hide & Protect Sheet from other User

Hi Hemant You can use these VBA methods to solve your problem: Sheets(1).Visible = xlSheetHidden 'Hide the worksheet Sheets(1).Visible = xlSheetVeryHidden 'Hide the worksheet and won't be displayed in Unhide Worksheet dialog list Sheets(1).Protect("Password")'Replace password with yo

$$Excel-Macros$$ Re: Using Web Services with Excel 2010

Hi David, There is good walkthrough available on MSDN http://msdn.microsoft.com/en-us/library/ms519100.aspx You can also refer this article on MSDN: http://msdn.microsoft.com/en-us/library/ms546696.aspx Thanks & Regards Ashish Jain McKinsey India Knowl

$$Excel-Macros$$ Use in vlookup isna and isblank iserror

Hi Praveen, Do you want to learn functions? If yes, follow the Microsoft help by pressing F1(Functional Key near Esc). it contains very good examples. Just search and practice these formulas from there. Do, come up with questions, queries - we'll help you out here. ___

$$Excel-Macros$$ Re: Excel Encyclopedia ppt

Thanks Raj for sharing these tips. Great. Keep it up :) Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com __

$$Excel-Macros$$ How to use imcro application

Hi Friends, Any knw how to use imcro we all of u need to discuss about that, please share your Knowlege -- With Best Regards, - Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 996

$$Excel-Macros$$ Re: How to change multiple values

What if you do " * 0.4 " or " * 40% " in next column and then copy it and use Paste special > Values on the column??? Will this solution work? Regards, Anand On Nov 9, 11:12 am, Vaaibhav wrote: > Hello saggi > > I think you must have given this reply considering that I have only 4 > rows to be

$$Excel-Macros$$ Re: VBA code required for Copy a specific folder.

Hi Mari, You can use CopyFolder method of File System Object as follows: Sub CopyFolder() Dim fso Dim sfol As String, dfol As String sfol = "c:\MyFolder" ' change to match the source folder path dfol = "e:\MyFolder" ' change to match the destination folder path Set fso = CreateObje

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

.e. In cell C4: =text(B4,"mmm") After this use =SUMIF($C$3:$C$25,I8,$A$3:$A$25) On Nov 10, 1:45 pm, ashish koul wrote: > chekc the attachment see if it helps > > > > > > On Wed, Nov 10, 2010 at 8:03 AM, wrote: > > Hi, > > > Write following formula beside date column, i.e. In cell C4: > >

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

chekc the attachment see if it helps On Wed, Nov 10, 2010 at 8:03 AM, wrote: > Hi, > > Write following formula beside date column, i.e. In cell C4: > > =text(B4,"mmm") > > Now copy this formula in all rows of coloumn C, You will get Month name > like Aug in cell C4. > > Now you can use sum if. >

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Ayush, Thanks for the book.. It looks like a very handy resource to keep and refer to. Regards, Aindril On Tue, Nov 9, 2010 at 7:50 PM, ayush jain wrote: > Hi Andy, > > Attached is the book for your reference. *Please do not forward to our > Google group and let them download from the URL.