RE: $$Excel-Macros$$ unable to open file of 2007 in 2003

Dear Sanjib, Please check http://update.microsoft.com for updates. If there are any updates for Office, install them. If there are any high priority updates for Windows, install them. Then reboot and see if fixed. You can also test if you can open the Excel 2007 file(s) by double-clicking

Re: $$Excel-Macros$$ unable to open file of 2007 in 2003

Dear Sir, The installation completed sucessfully, there is no error during installation, but while trying to open the file it is showing that the file is not recognize by excel 2003. regards, Sanjib On Wed, Feb 8, 2012 at 12:04 PM, Asa Rossoff wrote: > Hello Sanjib! > > Did installation

$$Excel-Macros$$ Custom Excel Functions

Could anybody explain how to create Custom Excel Function for converting Numbers to Words i.e. 1250 (One thousand two hundred and fifty) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

RE: $$Excel-Macros$$ Target.cell issues

I said there could be errors, and I spotted one immediately :) -- I forgot some parenthesis. Here it is corrected: Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range ' Handle Column 8 Changes for each rng in Application.Intersect(Target, Me.Columns(8)).areas

RE: $$Excel-Macros$$ Target.cell issues

Hello Chandra, I recommend using Application.Intersect to detect if a cell or range of interest is in the Target range. This is because multiple cells can be changed at one time (for example, by copy/paste, search/replace, or fill down), and your If/Then, depending on how you write it precisely,

Re: $$Excel-Macros$$ Target.cell issues

Thanks Noorain Ansari ,its works fine Regards chandru On Wed, Feb 8, 2012 at 11:59 AM, NOORAIN ANSARI wrote: > Dear Chandra Sekaran, > > Please try it.. > > Private Sub Worksheet_Change(ByVal Target As Range) > If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then > Tar

RE: $$Excel-Macros$$ unable to open file of 2007 in 2003

Hello Sanjib! Did installation of "the patch" fail, or did opening of an xlsx/xlsm file fail? What error did you get? When you say "the patch", do you mean the Compatibility Pack for Office? The latest Compatability Pack is at http://www.microsoft.com/download/en/details.aspx?displaylang=en

Re: $$Excel-Macros$$ Target.cell issues

Dear Chandra Sekaran, Please try it.. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then Target.Offset(0, -2).Value = "Booked" End If If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then Target.Offset(0, 2).Val

Re: $$Excel-Macros$$ Target.cell issues

sorry one Contion only worked On Wed, Feb 8, 2012 at 11:44 AM, wrote: > ** > Copy this code.. > > Private Sub Worksheet_Change(ByVal Target As Range) > If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells = > "BILLED" Then > Target.Offset(0, -2).Value = "Booked" > If Tar

Re: $$Excel-Macros$$ Target.cell issues

Copy this code.. Private Sub Worksheet_Change(ByVal Target As Range)   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells = "BILLED" Then Target.Offset(0, -2).Value = "Booked"   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN" Then Target.Offset(0, 2)

$$Excel-Macros$$ Target.cell issues

Dear all i have wrriten this code for worksheet change module My contion is workingbut second contion is not working any one help me Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells = "BILLED" Then Target.Of

Re: $$Excel-Macros$$ unable to open file of 2007 in 2003

Send the file. Sent from BlackBerry® on Airtel -Original Message- From: Sanjib Chatterjee Sender: excel-macros@googlegroups.com Date: Wed, 8 Feb 2012 11:37:09 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ unable to open file of 2007 in 2003 Dear Sir,

Re: $$Excel-Macros$$ Learn Macros and Basics VBA

Excellent Effort Amresh, Keep it up On Wed, Feb 8, 2012 at 10:18 AM, Amresh Maurya wrote: > Hi All My Friends, > > Please find the attached file. > > I have made PPT for Learn Macros and Basics VBA. Might be helping someone > to learn. > > > Cheers!! > Amresh Kumar > 9958418578 > > -- > FORUM RUL

Re: $$Excel-Macros$$ Plz, suggest can we do like this for the macro's. (for better explanation if u need plz check the attached file (Grm Details here) and Grm is the main file with two command button

attachment missing On Tue, Feb 7, 2012 at 7:33 PM, Mohammed Muneer wrote: >1. This is original macro. > > Sub fill() > > ** ** > > ** ** > > ** ** > > ' > > ** ** > > ** ** > > ** ** > > ' fill Macro > > ** ** > > ** ** > > ' Macro recorded 2/7/2012 by mmuneer > > ' >

Re: $$Excel-Macros$$ INDEX FUNCTION & MATCH FUNCTION

Thanks to all Excel group Members, On Mon, Feb 6, 2012 at 11:46 PM, Sam Mathai Chacko wrote: > I would actually explain the use of MATCH in a little more detail. You > have omitted the use of the greater than / lesser than arguments. > > Regards, > > Sam Mathai Chacko > > > On Mon, Feb 6, 2012 at

Re: $$Excel-Macros$$ Solution required plz

OK. Just add some text to the rest of the rows in col A on sheet2 so the “activites”name works Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, February 07, 2012 1:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Solution required

Re: $$Excel-Macros$$ Solution required plz

Just checked it Don. Couldn't figure out what you were referring to. Could you please let me know. Sam On Wed, Feb 8, 2012 at 12:43 AM, Sam Mathai Chacko wrote: > OKAY > > > On Wed, Feb 8, 2012 at 12:41 AM, dguillett1 wrote: > >> Sam, pls go back and test your MATCH >> >> Don Guillett >> Sale

Re: $$Excel-Macros$$ Solution required plz

OKAY On Wed, Feb 8, 2012 at 12:41 AM, dguillett1 wrote: > Sam, pls go back and test your MATCH > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sam Mathai Chacko > *Sent:* Tuesday, February 07, 2012 11:28 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Exce

Re: $$Excel-Macros$$ Solution required plz

Sam, pls go back and test your MATCH Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, February 07, 2012 11:28 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Solution required plz I have added two named ranges for activities and the

Re: $$Excel-Macros$$ Fwd: Solution required plz

Don Guillett SalesAid Software dguille...@gmail.com From: dguillett1 Sent: Tuesday, February 07, 2012 1:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Solution required plz You should give a MEANINGFUL subject line. Explain in the body of the email what you want.

Re: $$Excel-Macros$$ Fwd: Solution required plz

You should give a MEANINGFUL subject line. Explain in the body of the email what you want. Give examples. See attached for formulas in sheet 2 and then formulas in sheet1 to fetch the result. Can be combined into a more complex Don Guillett SalesAid Software dguille...@gmail.com From: Steven

Re: $$Excel-Macros$$ Solution required plz

The basic premise of a solution oriented approach is that it requires some element of dynamic adjustment or a self corrective modus operandus that will ensure proximity to correctness within a set of expected variations. 1. Your suggestion of having each column hard coded will (may) not suffice th

Re: $$Excel-Macros$$ Add to this group

Use this link and send an invite to your friend https://groups.google.com/group/excel-macros/members_invite?hl=en Regards, Sam On Tue, Feb 7, 2012 at 11:00 PM, Sam Mathai Chacko wrote: > I have sent you an invite just now. Please check the link > > Regards, > > Sam Mathai Chacko > > > On Tue,

Re: $$Excel-Macros$$ Add to this group

I have sent you an invite just now. Please check the link Regards, Sam Mathai Chacko On Tue, Feb 7, 2012 at 10:26 PM, Krishna madolli wrote: > Hi my friend want to add his ID to this group, please let us know the > procedure > -- > Krishnaraddi V Madolli. > > -- > FORUM RULES (986+ members alr

Re: $$Excel-Macros$$ Solution required plz

I have added two named ranges for activities and the states. The formula for percentage will then be =COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities) and for the status will be =IF(C2>=1,"Complete","Incomplete") OR =IF(C2<1,"Incomplete","Complete") Regards Sam Mat

Re: $$Excel-Macros$$ Regarding Vlookup and Hlookup function

Dear Sanjib, Please find the Attached Sheet Let me know for any other Assistance. Regards, Anoop On Tue, Feb 7, 2012 at 12:08 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > > Dear Sir / Madam, > > Would you provide me more example for Vlookup and Hlookup function > > Thankin

$$Excel-Macros$$ Fwd: Solution required plz

-- Forwarded message -- From: Steven Dsouza Date: Tue, Feb 7, 2012 at 10:59 AM Subject: Solution required plz To: excel-macros@googlegroups.com Hi, Iam an ardent follower of this group. I was just wondering if someone can help me find a solution. I have mentioned the issue in th

$$Excel-Macros$$ Solution required plz

Hi, Iam an ardent follower of this group. I was just wondering if someone can help me find a solution. I have mentioned the issue in the attached file. thanks in advance for the Patience in going through my email. Regards Steve -- FORUM RULES (986+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ Add to this group

Hi my friend want to add his ID to this group, please let us know the procedure -- Krishnaraddi V Madolli. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ vlookup and index/match functions help required

thanks kris sir and sam sir . On Tue, Feb 7, 2012 at 10:30 PM, Sam Mathai Chacko wrote: > I would also go with the LOOKUP suggested by Kris as it is direct, and > simple. But if you do not want to make any change to your layout, you could > also use a CSE formula > > =INDEX($H$3:$H$9,MATCH(B2,--T

Re: $$Excel-Macros$$ vlookup and index/match functions help required

I would also go with the LOOKUP suggested by Kris as it is direct, and simple. But if you do not want to make any change to your layout, you could also use a CSE formula =INDEX($H$3:$H$9,MATCH(B2,--TRIM(RIGHT(SUBSTITUTE($G$3:$G$9,"-",REPT(" ",20)),10)),-1)) Regards, Sam Mathai Chacko On Tue, Fe

Re: $$Excel-Macros$$ Excel test file Basic & Advance

Hi Maries, Thanks..Excellent Tools.. Regards Nikhil Shah On Tue, Feb 7, 2012 at 4:08 PM, Maries wrote: > *Find the attached Excel File > * > On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI > wrote: > >> PFA >> >> >> On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) < >> amit.de...@meruc

Re: $$Excel-Macros$$ Re: IF FUNCTION PROBLEM

Thanks Kris, wow, this index formula makes my work really easy, thanks boss, u r great, On Tue, Feb 7, 2012 at 4:27 PM, Kris wrote: > Hi > > You are welcome !! > > BTW, you could replace the P7 formula with > > =INDEX(I4:I26,A1) > > Kris > > -- > FORUM RULES (986+ members already BANNED for viol

Re: $$Excel-Macros$$ Re: IF FUNCTION PROBLEM

Hi You are welcome !! BTW, you could replace the P7 formula with =INDEX(I4:I26,A1) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ vlookup and index/match functions help required

Hi, In C2 and copied down, =LOOKUP(B2,$I$3:$J$11) and arrange your table like RANGE GRADE 0 No Grade 3.2 D 4.1 C2 5.1 C1 6.1 B2 7.1 B1 8.1 A2 9.1 A1 10.1 No Grade Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ IF FUNCTION PROBLEM

You don't format the value using TEXT function in this case. Use format cells to format. Check the attachment. Regards, Sam Mathai Chacko On Tue, Feb 7, 2012 at 8:49 PM, hilary lomotey wrote: > Hello Experts, > > i have a data, i want the data to read " decrease" when the % change for > the se

Re: $$Excel-Macros$$ Re: IF FUNCTION PROBLEM

Thanks Kris, very helpful On Tue, Feb 7, 2012 at 4:13 PM, Kris wrote: > Hi, > > Replace your Col I formula. In I4 and copied down, > > =IFERROR(C4/C3-1,"N/A") > > custom format the cell as *0.00%;(0.00%)* > * > * > Kris > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use

$$Excel-Macros$$ Re: IF FUNCTION PROBLEM

Hi, Replace your Col I formula. In I4 and copied down, =IFERROR(C4/C3-1,"N/A") custom format the cell as *0.00%;(0.00%)* * * Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

Re: $$Excel-Macros$$ Header and Footer Based on Cell Value

Dear John, Please try through below link.. http://www.cpearson.com/excel/headfoot.htm http://www.exceltip.com/st/Insert_headers_and_footers_using_VBA_in_Microsoft_Excel/454.html Hope it will help to you. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.bl

Re: $$Excel-Macros$$ vlookup and index/match functions help required

thanx for help but its giving #na on entering 3.2 in any cell in bucket 3.2 to 4 range 4.1 to 5 range 5.1 to 6 range 6.1 to 7 range On Tue, Feb 7, 2012 at 8:39 PM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Sort the data and use it.. > > =LOOKUP(B3&"*",$G$3:$G$9,$H$3:$H$9) > > See attached s

$$Excel-Macros$$ IF FUNCTION PROBLEM

Hello Experts, i have a data, i want the data to read " decrease" when the % change for the selected year is -ve eg (7.9%) otherwise to read "positive", i have used the formula ="This represents a % "&IF(P7<0,"decrease","increase"), but it doesnt change when the sign changes. kindly assist. thank

Re: $$Excel-Macros$$ vlookup and index/match functions help required

Dear Sourabh, Sort the data and use it.. =LOOKUP(B3&"*",$G$3:$G$9,$H$3:$H$9) See attached sheet.. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Feb 7, 2012 at 8:05 PM, Sourabh Salgotra wrot

Re: $$Excel-Macros$$ vlookup and index/match functions help required

Hi Sourabh, Find the attached file. I have used only VLOOKUP to achieve your requirement. I hope this clarify clear. Regards, MARIES. On Tue, Feb 7, 2012 at 6:35 PM, Sourabh Salgotra wrote: > > dear sir, > plz help me in attached file. > > > Thanks & Regards > Sourabh > Contact Numb

Re: $$Excel-Macros$$ Sorry Muneer's file attachment - Grm!

The answer would be Yes, you can combine multiple sub-routines in to one. However, you need to know what exactly you want to achieve before putting them together. In your case, you have three routines, but all of them do not actually produce an output, although they are performing some (similar) ac

Re: $$Excel-Macros$$ Hi friends, now its clear.....

Just a thought. Are you trying to say that if there is a common word in all the lines, you need to know that word? Example I let you go Let me in Who let the dogs out To let and you need the value in your first column to be '*let*'? I'd say caramba! if that's the case And Excel_Lover, you nee

$$Excel-Macros$$ Plz, suggest can we do like this for the macro's. (for better explanation if u need plz check the attached file (Grm Details here) and Grm is the main file with two command buttons (F

1. This is original macro. Sub fill() ' ' fill Macro ' Macro recorded 2/7/2012 by mmuneer ' ' Keyboard Shortcut: Ctrl+Shift+N ' ActiveCell.FormulaR1C1 = "aa" Selection.AutoFilter Field:=2, Criteria1:="aa" End Sub 1. C

Re: $$Excel-Macros$$ vlookup in Text Box

No dispute Asa, just a careful examination. Yes, the lines of code are more or less the same. Sam On Tue, Feb 7, 2012 at 9:20 AM, Asa Rossoff wrote: > Sam, I think we have the same number of lines of code, by the way I have > On Error, plus two lines of code. You have two lines of code plus a

Re: $$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

Or a simple macro ‘= Option Explicit Option Compare Text Sub getword() Dim c As Range For Each c In Range("e13:e21") If InStr(c, "Cell") > 0 Then c.Offset(, 1) = "cell" Next c End Sub ‘ Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Tuesday, February 07

RE: $$Excel-Macros$$ paste special problem

You can try Application.calculation = xlMannual , if calculation is not required everytime From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Feb/Fri/2012 11:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ paste sp

Re: $$Excel-Macros$$ Excel test file Basic & Advance

Thanks Maries for useful attachment. On Tue, Feb 7, 2012 at 4:08 PM, Maries wrote: > *Find the attached Excel File > * > On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI > wrote: > >> PFA >> >> >> On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) < >> amit.de...@merucabs.com> wrote: >> >>>

Re: $$Excel-Macros$$ Index and Match

Dear Darwin, Actually, It was query of one of our group member Mr. Pravesh kashyap, He wanted to extract all vertical data in horizontal way as per provided heading. In this case.Heading is repeating again by again in column "A" below function was used to extract column "B" data in ho

Re: $$Excel-Macros$$ Index and Match

Dear Darwin, Please try it without using helping coloun. =INDEX($A$2:$A$14,MATCH(SMALL($B$2:$B$14,ROW(A1)),$B$2:$B$14,0)) See attached sheet.. On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan wrote: > Hi group, > > Currently I m reviewing the use of Index and match. However, anyone can > point out w

Re: $$Excel-Macros$$ Excel 2007 not opening the sheet

Dear Idhrees, Please check below link.. http://www.mrexcel.com/forum/showthread.php?t=289850 On Mon, Feb 6, 2012 at 4:15 PM, Idhrees Mohamed wrote: > Dear Friends, > > I am using excel 2007 and my files are not opening in the first attempt if > i minimize the window and maximize or right click i

Re: $$Excel-Macros$$ Index and Match

ear Darwin Kindly find the attached file On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan wrote: > Hi group, > > Currently I m reviewing the use of Index and match. However, anyone can > point out what is missing in my forumla? > > -- > Darwin Chan > darwin.chankaw...@gmail.com > kw42c...@yahoo.com.h

$$Excel-Macros$$ Index and Match

Hi group, Currently I m reviewing the use of Index and match. However, anyone can point out what is missing in my forumla? -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t