$$Excel-Macros$$ Invoice rate verification

Hi All, Need your help. I have Item Master (which has effective date of price applicable for a product) and Sales Register (actual date of invoice with item and price charged). I need to check in Sales Register whether the rate applied is as per Item Master. Sample file attached. Please assist.

Re: $$Excel-Macros$$ Excel macro to add VBA password

Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI wrote: > Kiran, > > Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime > under VBE editor. > > On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI > wrote: > >> Dear Kiran, >> >> Please try it.. >

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congratulations Noorain. You are a real asset. Agreed that the certificate is a great idea. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday, September 05, 2012 6:55 AM To: excel-macros@googlegroups.com Subject: R

Re: $$Excel-Macros$$ Excel macro to add VBA password

Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI wrote: > Dear Kiran, > > Please try it.. > > > Sub ProtectFiles() > > Dim MyFile As File > > Dim MyFolder As Folder > > Dim fso As Scripting.File

Re: $$Excel-Macros$$ Excel macro to add VBA password

Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password="abc" Next End Su

$$Excel-Macros$$ Excel macro to add VBA password

Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks & Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BAN

Re: $$Excel-Macros$$ Rank Formula

Rajan I think this is not working,I used it but wrong output in passing formula sheet.Guillett Sir formula VBA for passing is fanstatic On Wed, Sep 5, 2012 at 8:32 PM, Rajan_Verma wrote: > *=IF(ISERROR(MATCH(0,N(F11:L11>$F$10:$L$10),0)),"Passed","Fail")* > > * * > > * * > > *Regards* > > *Rajan v

Re: $$Excel-Macros$$ JAVA Software Engineer in Raleigh, NC

Hi Vinay, This is to inform you that, Job posting is not allowed in this group. Regards, Kuldeep Singh On Thu, Sep 6, 2012 at 2:40 AM, Vinay Kumar wrote: > * * > > *JAVA Software Engineer*** > > *Raleigh, NC*** > > * * > > *Primary Responsibilities * > >- Design, develop, and maintain Def

$$Excel-Macros$$ Multiple JAVA/J2ee Positions

Need JAVA Developers for Chicago, IL/ Bloomington, IL/ Raleigh, NC/ NYC, NY Duration: 12 months Thanks, Vinay Kumar Diverse Lynx LLC. 300 Alexander Park, Suite # 200 Princeton, NJ 08540 Phone: 732-452-1006 ext 208 Fax: 732-452-0684 Email: vi...@diverselynx.com

$$Excel-Macros$$ JAVA Software Engineer in Raleigh, NC

JAVA Software Engineer Raleigh, NC Primary Responsibilities * Design, develop, and maintain Defined Benefit Calculation Engine applications * Take a leadership role in technical design and product implementation discussions. * Participate in establishing and documenting coding best

Re: $$Excel-Macros$$ need tool for automation

On Wednesday, September 5, 2012 11:26:17 AM UTC-4, Rajan_Verma wrote: > > * * > > *Not actually tools , but you can find many useful code to accomplish > that task* > > * * > > *www.ExcelFox.com* > > *www.ExcelPowerUser.Wordpress.com* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 783

RE: $$Excel-Macros$$ need tool for automation

Not actually tools , but you can find many useful code to accomplish that task www.ExcelFox.com www.ExcelPowerUser.Wordpress.com Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of maksood alam Se

Re: $$Excel-Macros$$ need tool for automation

like find duplicate, filter, advance filter, any reporting tool with the vba coding, so i can learn from it. On Wed, Sep 5, 2012 at 8:21 PM, Rajan_Verma wrote: > *What kind of tool* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macr

RE: $$Excel-Macros$$ Rank Formula

=IF(ISERROR(MATCH(0,N(F11:L11>$F$10:$L$10),0)),"Passed","Fail") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 05 September 2012 1:03 To: excel-macros@googlegroups.com Subject: Re:

RE: $$Excel-Macros$$ How to count the items except repetition

=SUM(1/COUNTIF($C$3:$C$39,$C$3:$C$39)) with CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 05 September 2012 10:51 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

RE: $$Excel-Macros$$ need tool for automation

What kind of tool Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of maksood alam Sent: 04 September 2012 11:47 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need tool for automation

Re: $$Excel-Macros$$ Excel Macro

just found that you're defining the fpath only if you select "Yes". also, I suggest you use  Option Explicit at the top of your module. This will ensure that you have all variables declared. If I do that, it says that Quit = True is defining a new variable called "Quit" and setting it to "true".

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Thank you very much to all the Members of the Group who deemed me worthy for this achievement. *Aside to Ayush*: Most helpful Award Certificate is very lovely and nice,it will encourage to our group member to solve query more and more. Thanks brother for this creativity. -- With Regards, Noorai

RE: $$Excel-Macros$$ Excel Macro

Not to worry, Sorted it. Thanks you so much for all your help, you'd saved me HOURS. I will be sure to recommend this site. Many thanks Darren Combellack From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 05 September 2012 12:18 To: e

RE: $$Excel-Macros$$ Excel Macro

Thanks again Paul, Sorry to be simple, I can't seem to get it to work? Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim PO As Long PO = MsgBox("Is the Purchase Order complete?", vbYesNoCancel) If PO = vbYes Then Me.Saved = True Dim fName As String, fPath As String fName = Rang

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Dear Noorain, Congratulations Regards, CA KSAGAR On Tue, Sep 4, 2012 at 3:42 PM, Kal xcel wrote: > Brother, > > I think, beside your achievement I also achieved something……….that is.. > > I got a really nice person called “NOORAIN ANSARI”. > > Till date whenever I faced any problem in

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Thanks very much for short formula On Wed, Sep 5, 2012 at 5:04 PM, Ms-Exl-Learner . wrote: > Or in one shot... > > =IF(SUMPRODUCT(--((F11:L11)<($F$10:$L$10))),"Failed","Passed") > > Refer the attached sheet for detail. > . > <><><><><><> > *Ms.Exl.Learner* > <><><><><><> > > > -- > > <><><><><><

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Or in one shot... =IF(SUMPRODUCT(--((F11:L11)<($F$10:$L$10))),"Failed","Passed") Refer the attached sheet for detail. . <><><><><><> *Ms.Exl.Learner* <><><><><><> -- <><><><><><> *Ms.Exl.Learner* <><><><><><> On Wed, Sep 5, 2012 at 1:24 PM, Manoj Kumar wrote: > Dear Amar, > > Please Use it

Re: $$Excel-Macros$$ Excel Macro

the Filename is a fully "delineated" name. That is to say, it is intended to be the full path and file name. If not path is specified, the default path is used. If fPath is defined, then you can use: ActiveWorkbook.SaveAs Filename:= fPath & "Incomplete" & " - " & Range("G4").Value & ".xlsm", Fil

Re: $$Excel-Macros$$ Learn Array formula's

hi, Expecting examples excel file, reg. Array formula functions. On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI wrote: > Sure Murlidhar, > > i will provide you shortly. > > > On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E wrote: > >> Hi, >> Thanks alot. If u give any files with examples in e

Re: $$Excel-Macros$$ Count when po is greater than zero

Thanks it was working. On Tue, Sep 4, 2012 at 7:04 PM, Rajan_Verma wrote: > * * > > * * > > *=SUMPRODUCT(N($B$2:$B$10=B2),N($D$2:$D$10<>""))* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Wow.Manoj. This will be grt help to me Thanks very much... On Wed, Sep 5, 2012 at 2:26 PM, Manoj Kumar wrote: > Dear Amar, > > Please find the attachment.. hope it will help you.. > > > Regard > Manoj > > > On Wed, Sep 5, 2012 at 1:43 PM, amar taka

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Dear Amar, Please find the attachment.. hope it will help you.. Regard Manoj On Wed, Sep 5, 2012 at 1:43 PM, amar takale wrote: > Hi Manoj, > Now I attached sheet.See it > > > On Wed, Sep 5, 2012 at 1:42 PM, amar takale wrote: > >> Hi Manoj, >> This is valuable formula for me,Thanks for it.B

Re: $$Excel-Macros$$ Excel Macro

Thanks Paul, That make sense, and works perfect. Where should I add the 'fPath' within that line, currently its saving to my document, but I would like it to save to Dropbox. fPath = "\\SBS1\dropbox\Purchase Order" On Tuesday, 4 September 2012 14:36:43 UTC+1, Paul Schreiner wrote: > > I think

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Hi Manoj, Now I attached sheet.See it On Wed, Sep 5, 2012 at 1:42 PM, amar takale wrote: > Hi Manoj, > This is valuable formula for me,Thanks for it.But I think it is also show > in short formula but now I forget it how to use it.I attached sheet with > your formula. Can you solved little more s

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Hi Manoj, This is valuable formula for me,Thanks for it.But I think it is also show in short formula but now I forget it how to use it.I attached sheet with your formula. Can you solved little more solution for Grade, I show Grade table in sheet. Thanks for your valuable time. Pls see it Thank yo

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Dear Amar, Please Use it... =IF(OR(F11<$F$10,G11<$G$10,H11<$H$10,I11<$I$10,J11<$J$10,K11<$K$10,L11<$L$10),"Failed","Pass") you can use conditional formatting to change color. Regard On Wed, Sep 5, 2012 at 1:20 PM, amar takale wrote: > Hi manoj, > If failed minmum one subject then show fail

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Hi manoj, If failed minmum one subject then show failed (required output in yellow) (looking Minmum marks on Row numbers 10) F10:L10. If anyone got marks less than minimum marks then show failed. On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote: > Dear amar, > > Please tell what is passing mark

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Dear Amar, Please Use it... =IF(OR(F11<$F$10,G11<$G$10,H11<$H$10,I11<$I$10,J11<$J$10,K11<$K$10,L11<$L$10),"Failed","Pass") Regard Manoj On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote: > Dear amar, > > Please tell what is passing marks... > > Regard > Manoj > > On Wed, Sep 5, 2012 at 1:06 P

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Dear amar, Please tell what is passing marks... Regard Manoj On Wed, Sep 5, 2012 at 1:06 PM, amar takale wrote: > Hi All Experts, > Pl solved challenging formula for passing. > > Appreciate the help very much > > -- > Join official facebook page of this forum @ > https://www.facebook.com/disc

$$Excel-Macros$$ Required Passing formula (More confusing)

Hi All Experts, Pl solved challenging formula for passing. Appreciate the help very much -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, li

Re: $$Excel-Macros$$ Rank Formula

Dear Guillett Sir That amazing formula,I never thought sum product formula useable Thanks very very much If you have time one another problem I faced ,This is confusing formula bcos more than three criteria for passing Can you help me? Pls Pls . Appreciate the help On Tue, Sep 4, 2012