Re: $$Excel-Macros$$ Rank Formula

Thanks rajan First time I put only formula Now it working.It is array formula. On Thu, Sep 6, 2012 at 6:39 PM, Rajan_Verma wrote: > *Its an array formula , confirm it as array by pressing Shit+Ctrl+Enter* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > >

Re: $$Excel-Macros$$ Question chart

Dear Pravesh, See i have changed the dropdown working . pls do the color , as i'm busy with other work. On Fri, Sep 7, 2012 at 9:48 AM, PRAVESH KUMAR <> wrote: > HI Team, > > > please help me to solve this queston it's very urgent. > > solve asap. > > > > -- > > Thanks & Regards > > Pravesh Kuma

Re: $$Excel-Macros$$ Please Help

thx brother On Fri, Sep 7, 2012 at 10:42 AM, Karan Singh wrote: > Hi Jeet, > > I think you're not able to explain your problem. As all expert said at > least you should explain your queries in Subject & then in your > workbook. Anyways I'v done something (with recording), hope you need this.

$$Excel-Macros$$ pls help urgent- need data in the format as required

example attached. i have multiple columns and rows. Please advise a formula to get the data in the attached format. -- 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 tit

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

Hi Don, Thanks for your macro. In my case I need a macro to add Password, Not remove password. Thanks, Krian On Thu, Sep 6, 2012 at 11:50 PM, dguillett1 wrote: > Put in a workbook module to find another file to unlock vba > > Option Explicit > 'Your password goes here > Const gszProjPasswor

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

Put in a workbook module to find another file to unlock vba Option Explicit 'Your password goes here Const gszProjPassword As String = "hello" Public Sub UnlockMe() Dim wbName As Variant Dim wbBook As Workbook Dim vbaProj As Object Dim oWin As Object Dim X As Integer On Error GoTo ErrorHand

Re: $$Excel-Macros$$ Re: UDF for all worksheets

Excellent description, we salute you Paul all group members are lucky because you, Asa and Don are with us. Sent from BlackBerry® on Airtel -Original Message- From: Paul Schreiner Sender: excel-macros@googlegroups.com Date: Thu, 6 Sep 2012 10:35:40 To: Reply-To: excel-macros@googl

Re: $$Excel-Macros$$ Re: UDF for all worksheets

Is your function in a "Standard" module? or a "Sheet" module? Perhaps we need a discussion about "scope". --- First, let's talk about Declaring variables and Modules: There are several different types of Modules: -ThisWo

Re: $$Excel-Macros$$ Re: UDF for all worksheets

Thanks Prince. I have made it public. Though I don't know the basic difference between the scope to be private or pubic. So will send you the work sheet. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Prince Dubey Sender: excel-macros@googlegroups.com Da

$$Excel-Macros$$ Re: Please Help

Hi Jeet, I did'nt get your query or the selection criteria for the desire solution.So pls explain little more about the problem. regards prince regards prince On Thursday, September 6, 2012 10:28:42 AM UTC+5:30, jeet singh wrote: > > > > Dear All, > > plz find the attachment and help > >

$$Excel-Macros$$ Re: Sun IDM Developer in NY

Dear vinay this is not the place where job posting can be done so pls follow the rules of forum. On Thursday, September 6, 2012 7:29:03 PM UTC+5:30, Vinay Kumar wrote: > > > > *Req: Sun IDM Developer* > > *Location: NY* > > *Duration 12 months* > > > > *Required Skills Include

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

Hi Rajan, I m agree with you. On Thursday, September 6, 2012 8:11:31 PM UTC+5:30, Rajan_Verma wrote: > > Although you can know VBA Project is lock or unlock but you can not lock > or > unlock VBProject by Code > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > > -Original Messa

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

Vinay pls follow forum rule Sent from BlackBerry® on Airtel -Original Message- From: Vinay Kumar Sender: excel-macros@googlegroups.com Date: Thu, 6 Sep 2012 14:31:24 To: Vinay Kumar Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multiple JAVA /J2ee Positions Need JAV

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

Although you can know VBA Project is lock or unlock but you can not lock or unlock VBProject by Code Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancharla Sent: 06 Septembe

RE: $$Excel-Macros$$ Sun IDM Developer in NY

Need to be ban.. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vinay Kumar Sent: 06 September 2012 7:29 To: Vinay Kumar Subject: $$Excel-Macros$$ Sun IDM Developer in NY Req: Sun IDM Develope

$$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

RE: $$Excel-Macros$$ Please Help

Same as don Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 06 September 2012 6:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help I did NOT look at y

RE: $$Excel-Macros$$ Require values from other cell references

Showing #N/A Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 06 September 2012 2:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Require values from other cell r

RE: $$Excel-Macros$$ Segregation of short term, long term capital gain and average rate of share

Would be useful Just follow the steps http://www.mudraa.com/trading/81631/0/learn-to-use-excel-to-get-real-time-da ta-from-nse-site.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAGAR KAS

RE: $$Excel-Macros$$ Required a correct VB code for search option

Try this Private Sub Worksheet_Change(ByVal Target As Range) Sheet1.AutoFilterMode = False If Target.Address <> Sheet1.Range("a2").Address Then Exit Sub Sheet1.Range("A4").AutoFilter 1, "*" & Target.Value & "*" End Sub Regards Rajan verma +91 7838100659 [

RE: $$Excel-Macros$$ Invoice rate verification

=INDEX($C$13:$C$24,MATCH(1,N((N($A$13:$A$24=A3)*ROW($A$13:$A$24)*N($B$13:$B$ 24>=$B3))>0),0)) With CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vikas Agarwal Sent: 06 September 2012 12:2

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

4. vba protecion password On 9/6/12, Rajan_Verma wrote: > Where you want to apply Password. > > 1) File Open ? > 2) Worksheet Password ? > 3) Workbook Password ? > 4) VBA project Password ? > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > -Original Message- > From: excel-macros

Re: $$Excel-Macros$$ Sun IDM Developer in NY

6) Jobs posting is not allowed, Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Vinay Kumar Sent: Thursday, September 06, 2012 8:58 AM To: Vinay Kumar Subject: $$Excel-Macros$$ Sun IDM Developer in NY Req: Sun IDM Developer Location: NY Duration 12 mon

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

Where you want to apply Password. 1) File Open ? 2) Worksheet Password ? 3) Workbook Password ? 4) VBA project Password ? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancha

RE: $$Excel-Macros$$ Require values from other cell references

=INDEX($B$3:$CP$3,,MATCH($B10,DAY($B$1:$CP$1),0)+COLUMNS($C$9:C9)-1) with CSE in C10 Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 06 September 2012 12:49 To: excel-macros@

$$Excel-Macros$$ Sun IDM Developer in NY

Req: Sun IDM Developer Location: NY Duration 12 months Required Skills Include: - Experienced in Sun Identity Manager 8.X (Oracle Waveset) and ability to work on workflow Customizations in PWC framework. - Experience on developing identity management entities like WorkFlow, WorkFlow Subproces

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

hi noorain, yes i want to protect VBA Thanks, kiran On 9/6/12, NOORAIN ANSARI wrote: > Means, You want to protect VBA Coding instead of Opening File. > Kindly confirm. > > On Thu, Sep 6, 2012 at 6:32 PM, Kiran Kancharla > wrote: > >> Hi, >> >> with the above macro I am able to add pasword to o

Re: $$Excel-Macros$$ Please Help

well said. Hopefully these messages will do some good?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, September 06, 2012 7:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help Don, I did (look) H

Re: $$Excel-Macros$$ Re: Please Help

ditto Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, September 06, 2012 6:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Please Help Have you read the "Forum Rules"? (Well, SOME are more of a "guide

Re: $$Excel-Macros$$ Fwd: Please Help

I did NOT look at your attachment because you did not provide a meaningful subject line in your post and you did not explain your problem in the body of the email. I hope you explained, with examples, in the file. But, I didn’t look Don Guillett Microsoft Excel Developer SalesAid Software dguill

RE: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: 06 September 2012 12:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP

RE: $$Excel-Macros$$ Need VBA code for Formatting chart

Download code from here http://www.excelfox.com/forum/f12/color-chart-series-vba-58/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 06 September 2012 10:45 To: excel-macros@googleg

RE: $$Excel-Macros$$ Rank Formula

Its an array formula , confirm it as array by pressing Shit+Ctrl+Enter Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 06 September 2012 10:26 To: excel-macros@googlegroups.com Subj

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

Hi, with the above macro I am able to add pasword to open the file. In my case i need a maco to add pssword for VBA, not for opening the file. plase help... On 9/6/12, SAGAR KASANGOTTUWAR wrote: > *Thanks a lot Noorain Bhai* > > ** > Have you any programme for protecting the same files in that

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

HOME OFFICE? 2012/9/5 Vinay Kumar > * * > > *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 0

Re: $$Excel-Macros$$ Please Help

Don, I did (look) He didn't (explain) He has 5 columns of data and looks like he wants to do a bunch of sumifs, but there's some "selection criteria" he has listed, but doesn't explain what it is or why. I decided that it would take too much effort to ASK for the answers to questions he shou

Re: $$Excel-Macros$$ Please Help

I did NOT look at your attachment because you did not provide a meaningful subject line in your post and you did not explain your problem in the body of the email. I hope you explained, with examples, in the file. But, I didn’t look. Don Guillett Microsoft Excel Developer SalesAid Software dgui

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

*Thanks a lot Noorain Bhai* ** Have you any programme for protecting the same files in that folder...? Thanks & Regards, SAGAR On Thu, Sep 6, 2012 at 2:41 PM, NOORAIN ANSARI wrote: > Dear Sagar, > > Please use it. > > Change Folder path as per your need. > > Sub Protect_filesofFolder() > > D

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

Thanks Asa, I have learned a lots of new thing from you. Your description, your logic, your Concept and your solution always guide me. I think you are milestone of our group..please keep continue to post your valuable solution..We are missing you last one or two month. On Thu, Sep

Re: $$Excel-Macros$$ Invoice rate verification

It looks like your "Item Master" rates are based on a Date. However, the dates in the Sales Register don't match up with the dates in the Master. Is this simply because it's sample data? What is the relationship between the Product Code, Date, and Rate? Is the Rate established on a date and appl

Re: $$Excel-Macros$$ Re: Please Help

Have you read the "Forum Rules"? (Well, SOME are more of a "guideline".)   1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. As an example: My Excel-

$$Excel-Macros$$ Re: UDF for all worksheets

Hi sandeep, i hope scope of ur function or sub is private, so please make it public. If it does not work then pls share the ur workbook with us. regards Prince On Thursday, September 6, 2012 4:15:13 PM UTC+5:30, sandeep chhajer wrote: > Dear all, > > I have made a UDF (formula) in personal.

$$Excel-Macros$$ Re: Please Help

ANY UPDATE On Thu, Sep 6, 2012 at 10:28 AM, jeet singh wrote: > > > Dear All, > > plz find the attachment and help > > Regards > Jeet > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ UDF for all worksheets

Dear Sandeep, Please change scope Public instead of Private. else share your UDF with group. On Thu, Sep 6, 2012 at 4:14 PM, wrote: > Dear all, > > I have made a UDF (formula) in personal.xls file. Though it is working > when I am working @ personal file but when ever I am trying to use it in m

$$Excel-Macros$$ UDF for all worksheets

Dear all, I have made a UDF (formula) in personal.xls file. Though it is working when I am working @ personal file but when ever I am trying to use it in my other worksheet the formula is not working. Please help. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook

Re: $$Excel-Macros$$ automatic update totals in cumulative colums

Hai Noorin Sir Thanks for your quick response. Small correction.Just read file1.xls is april and file2.xls is may up to march. In the month of april monthly and cumulative figures in male,female total is same. But in the month of may i enter the monthly figures in male female . *IN THE SAME MONTH

Re: $$Excel-Macros$$ automatic update totals in cumulative colums

Dear Excel Learner, Please try it for cumulative sum =SUM($E$4:E4,$F$4:F4) in cell G4 File 1 On Thu, Sep 6, 2012 at 2:58 PM, excel lerner wrote: > Hello sir > > In my attached files file1.xls is one month reports. file2.xls is next > month reports. > > I want to cumulative values in cumul

$$Excel-Macros$$ automatic update totals in cumulative colums

Hello sir In my attached files file1.xls is one month reports. file2.xls is next month reports. I want to cumulative values in cumulative columns automatically when i enterd present month values in monthly columns. Please help me. Thanks in advance -- Join official facebook page of this foru

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

Dear Sagar, Please use it. Change Folder path as per your need. Sub Protect_filesofFolder() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder("D:\VBA_Class\Extra\") For Each MyFile In MyF

Re: $$Excel-Macros$$ Require values from other cell references

Hi Pravin, Try this. =INDEX($B$3:$CP$3,MATCH($B10,$B$1:$CP$1),MATCH(C$8,$B$2:$D$2)) Regards, Kuldeep Singh On Thu, Sep 6, 2012 at 12:48 PM, Pravin Gunjal wrote: > Dear Friends, > > Request to please help me on this issue. > > I have attached an excel file for your reference. > > I want the da

Re: $$Excel-Macros$$ Segregation of short term, long term capital gain and average rate of share

Dear Noorain, I want to manage share stock and there prices at the time of sale. Purchase average prices should come automatically. Kindly help me about this. Thanks & Regards, KSAGAR On Tue, Jul 31, 2012 at 11:54 PM, NOORAIN ANSARI wrote: > Dear Sagar, > > Please share a sample workbook for

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

Wht error is showing, Please send screenshot. On Thu, Sep 6, 2012 at 1:49 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Noorain, > > I have the same but it is not working. > > Thanks & Regards, > > KSAGAR > > > On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI > wrote: > >>

Re: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

Dear Sundar, You can use single Vlookup for both required Column *=VLOOKUP(K2,CHOOSE({1,2,3},$D$2:$D$20,$B$2:$B$20,$C$2:$C$20),{2,3},0) * with ctrl+shift+enter See attached sheet for more clarity. On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote: > Dear Friends, > > Help me to find the

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

Dear Noorain, I have the same but it is not working. Thanks & Regards, KSAGAR On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI wrote: > Dear Sagar, > > First of all you have add library in VBE Area > > Step:- Tools-Reference-Microsoft Scrinpting Runtime. > > Brother check once again, if does',t

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

Dear Sagar, First of all you have add library in VBE Area Step:- Tools-Reference-Microsoft Scrinpting Runtime. Brother check once again, if does',t work revert me. On Thu, Sep 6, 2012 at 1:22 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Noorain, > > I am not able to ru

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

Dear Noorain, I am not able to run the programme and showing compile error (Method or data not found) after running. Thanks & Regards, KSAGAR On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla wrote: > Hi, > > thanks a lot your quick responce.. > > thanks, > kiran > > On 9/6/12, NOORAIN ANSARI

$$Excel-Macros$$ Required a correct VB code for search option

Hello, I have attached an excel file which is having search option in it. The VB code is gathering the data only from 1st column and it is not applied for second column of the file. I need to search some record which may have in any of the columns (display name or e-mail id). Kindly help me out o

Re: $$Excel-Macros$$ Invoice rate verification

Hi Vikas, You can use Lookup formula. Regards, Kuldeep Singh On Thu, Sep 6, 2012 at 12:21 PM, Vikas Agarwal wrote: > 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

$$Excel-Macros$$ Require values from other cell references

Dear Friends, Request to please help me on this issue. I have attached an excel file for your reference. I want the data to be filled in rows which has given in above columns of the attached file. Please help. Thanks Pravin Gunjal -- Join official facebook page of this forum @ https://www.f

Re: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

PFA On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote: > Dear Friends, > > Help me to find the circle and area. Please find the attached file for > your reference. > Thanks > N.Sundarvelan > 9600160150 > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexc

$$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

Dear Friends, Help me to find the circle and area. Please find the attached file for your reference. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, ac

$$Excel-Macros$$ Invitation to use Google Talk

--- You've been invited by jeet singh to use Google Talk. If you already have a Google account, login to Gmail and accept this chat invitation: http://mail.google.com/mail/b-c937b1f53f-08548356f2-pLu-ioOM7CH0jtP62c_RBhXcwkc To s