$$Excel-Macros$$ Conditional Comments

Dear All Can I give conditional conmments.For Eg if In Cell A1 there is "XYZ" then the comments show "Good Work" and If A1 contents "PQR" then comments should show"need Improvement" Is it possible ? if yes please let me know hoe to do it. Waiting for reply -- Shrini -- FORUM RULES (986+ memb

Re: $$Excel-Macros$$ Conditional Comments

Hi, Try it... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$1" Or Target.Cells.Count > 1 Then Exit Sub Target.ClearComments If Target.Value = "XYZ" Then Target.AddComment ("Good Work") End If If Target.Value = "PQR" Then Target.AddCo

RE: $$Excel-Macros$$ Conditional Comments

Option Compare Text Private Sub Worksheet_Change(ByVal Target As Range) With Target .ClearComments If .Cells.Count = 1 Then If Target.Value = "Xyz" Then .AddComment ("Good Work") ElseIf .Value = "PQR" Then .AddComment ("Need Improvement")

RE: $$Excel-Macros$$ Need VBA Book

Excel 2003/2007 Power Programming with VBA Try to Download From Google.. it's a good and free by J-walk From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Wed/2012 10:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Confirmation

Hi, Can you explain how you need to block Formula and headings? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Wed/2012 11:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Confirmation Hi, Try below

$$Excel-Macros$$ Opening for MIS Executive.

Hi All, We have good Opening for MIS Executive. Job Description: Location - Gurgaon (Nr Huda City Centre Metro Station) Work Experience : - Total 2+ Year. Required Skills : - Good Command Over MS Excel.(Vlookup,sumif,Filter,Condition Formatting,Pivot Table) CTC : - 1:80 - 2:10 Lac. Joining

Re: $$Excel-Macros$$ vba code to kill all open workbooks

How about application.quit or Sub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Application.Workbooks w.Close SaveChanges:=false Next w 'Application.Quit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Ori

Re: $$Excel-Macros$$ modification in paste special macro.

no Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Tuesday, March 06, 2012 10:41 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ modification in paste special macro. i used this macro and assigned it a shortcut key for my conven

Re: $$Excel-Macros$$ Need if formula

You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesday, March 06, 2012 10:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need i

$$Excel-Macros$$ Re: modification in paste special macro.

First of all, you should NOT simply change the topic of somone else's discussion thread and ask your own question. That's called "hijacking a thread", and is extremely bad form. Secondly... When you select a range of cells and copy/paste special -Values, Excel does a bunch of stuff behind-the-sc

Re: $$Excel-Macros$$ loop through cell

Many reasons. What are you trying to do? For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ what ?? And InStr(1, ws.Name, "Doc", vbTextCompare) = 0 Then 'you didn’t select the worksheet and you do NOT need to with ws .Columns("C").AutoFit .Columns("E:H

Re: $$Excel-Macros$$ Re: modification in paste special macro.

Paul, As you know I adhere closely to the KISS principle. I assumed ?? that OP wanted to “put the formula back” . Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, March 07, 2012 8:31 AM To: excel-macros@googlegroups.com Subject: $$E

Re: $$Excel-Macros$$ loop through cell

Hi learn excel.. Please send it with attachment.. it will be helpful.Thanks/// On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel wrote: > help with code > > > Dim ws As Worksheet > > can someone tell me why the follwowing code wont work > > > >For Each ws In ThisWorkbook.Worksheets >If

Re: $$Excel-Macros$$ modification in paste special macro.

i think... its not possible... On Wed, Mar 7, 2012 at 10:11 AM, danial mansoor wrote: > i used this macro and assigned it a shortcut key for my conveniance for > paste special values,but i can not undo last actions is that possible to > undo last 2 actions after modification of this posible? > >

$$Excel-Macros$$ formula help

hi all can anyone help me to get the desired result in this sheet i have attached the sheet please see the attachment for better understanding. Regards Avinash -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please H

Re: $$Excel-Macros$$ Re: modification in paste special macro.

Don, Oh, I agree completely! However, depending on the experience level of the person asking the question, it may not be enough to know that you CAN'T do it. Personally, I'd need to know WHY. There's been far too many times that someone has said (to me or others) that something can't be done simp

Re: $$Excel-Macros$$ formula help

Dear Avinash, Please use it.. =B2&"--"&COUNTIF($A$2:A2,A2) or =$B2&"--"&SUMPRODUCT(--($A$2:$A2=$A2)) See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Re: modification in paste special macro.

And I agree with you. I have actually written projects to restore ALL formulas with macros on open because a user was always destroying somehow and insisted on not having them protected.. range(“c2:c22”).formula=”=a2+b2” Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.co

$$Excel-Macros$$ Vlookup basics and help

I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Exces

Re: $$Excel-Macros$$ formula help

Macro solution for summary Sub getuniqueandcount() Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row) _ .AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range("G1"), Unique:=True Range("h2:H" & Cells(Rows.Count, "g").End(xlUp).Row).Formula = _ "=VLOOKUP(G2,A:B,2,0)&""--""&COUNTIF(A:A,G2)" End

Re: $$Excel-Macros$$ Vlookup basics and help

Dear Skanda, Plase share sample workbook with group -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 7, 2012 at 10:23 PM, Skanda wrote: > I have two w

Re: $$Excel-Macros$$ Vlookup basics and help

vlookup?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Skanda Sent: Wednesday, March 07, 2012 10:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup basics and help I have two worksheets subset and Maindata. Subset has the following field

Re: $$Excel-Macros$$ Vlookup basics and help

Yes On Wed, Mar 7, 2012 at 11:04 AM, dguillett1 wrote: > vlookup?? > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Skanda > *Sent:* Wednesday, March 07, 2012 10:53 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Vlookup bas

Re: $$Excel-Macros$$ Vlookup basics and help

On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI wrote: > Dear Skanda, > > Plase share sample workbook with group > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

HI Team, I need to put a vlookup for multipal sheet and get result on one sheet. Based on the sheet selection in cell hc6 the formula should get result as shown in the attached sheet. Regards, Vin -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ Need if formula

thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 wrote: > You didn’t show us your situation but, depending on your need you could > use LOOKUP, vLookup > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Ashish Bha

Re: $$Excel-Macros$$ Need if formula

i just used this formula however how can i add iserror formula to this.. On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > thanks one and all for your help.. > > > On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 wrote: > >> You didn’t show us

$$Excel-Macros$$ Exl Adds-in or any software for doing data reconciliations

Hi friends, Please help me if you are using a any excel adds-in or any software for data reconciliation. Warm regards, --- *Pranab A Brahmangaonkar* Pune, India. Mobile + 91 9822445858 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, ac

$$Excel-Macros$$ Search an fill combobox

Hi. Someone help with this: I have a book with aprox 20 sheets, many products are included. Well i need a search a defined product from combobox inside a userform, but when i write the first letter the macro run and don't let me write the others. I tried to put a delay but doesn't work. If you can

$$Excel-Macros$$ Need Help

Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards, karthik.N -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

Re: $$Excel-Macros$$ formula help

Hey! Look at the file, Good luck! 2012/3/7 Avinash > hi all can anyone help me to get the desired result in this sheet > > i have attached the sheet please see the attachment for better > understanding. > > Regards > > Avinash > > -- > FORUM RULES (986+ members already BANNED for violation) >

Re: $$Excel-Macros$$ Need Help

FYI. Regards karthik.N On Wed, Mar 7, 2012 at 1:05 PM, NOORAIN ANSARI wrote: > Dear Kartik, > > Can you share sample workbook. > > On Tue, Mar 6, 2012 at 6:35 PM, karthik N wrote: > >> Kindly help me >> >> To allocate the data in macro branch wise and every branch shouid be >> save in new bo

Re: $$Excel-Macros$$ Vlookup basics and help

Modify to suit =IF(ISNA(VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)),"",VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Skanda Sent: Wednesday, March 07, 2012 11:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vl

Re: $$Excel-Macros$$ Need if formula

You didn’t show us YOUR formula but try looking in the HELP index for ISERR or ISNA Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajasekhar Praharaju Sent: Wednesday, March 07, 2012 1:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ vba code to kill all open workbooks

thanks works great...if you want the current workbook to remain open where you're running the code what needs to be changed? ie: Master file book1 book2 book3 ect close everything expect master file On Mar 7, 8:32 am, "dguillett1" wrote: > How about  application.quit or > > Sub CLOSE_ALL()

Re: $$Excel-Macros$$ loop through cell

Don work Great thanks For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ what ?? And InStr(1, ws.Name, "Doc", vbTextCompare) = 0 Then i use this code to not look at the "doc" sheet, is there a better way? i have 10 sheets that i want the the code to run o

Re: $$Excel-Macros$$ copy range

hey Don sorry to trouble you but for some reason i couldnt get this to work... i dont know how to attatch a file On Mar 6, 8:57 am, "dguillett1" wrote: > Try this. BTW you have NO "Bob" in field 7 > > Sub filterandcopyusedrange() > Dim ds As Worksheet > Set ds = Sheets("Sheet10") > Cells.Find(

RE: $$Excel-Macros$$ modification in paste special macro.

? Sure it is, It's just a bit of trouble. Actually, IsItPossible is almost always = True. Even if drastic measuers are required or no one knows exactly how it's possible. But most requests that come up are possible in some relatively understood way. 1. Any macro can be undo-able,

Re: $$Excel-Macros$$ loop through cell

Send direct to dguillett1 @gmail.com Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:33 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ loop through cell Don work Great thanks

Re: $$Excel-Macros$$ vba code to kill all open workbooks

Sub CLOSE_ALLbut() myname = ActiveWorkbook.Name Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Application.Workbooks If w.Name <> myname Then w.Close SaveChanges:=False End If Next w 'Application.Quit End Sub Don Guillett Microsoft MVP Excel Sales

Re: $$Excel-Macros$$ copy range

send to dguillett1 @gmail.com Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:37 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ copy range hey Don sorry to trouble you but for

Re: $$Excel-Macros$$ : How to use IF Function more than 8 times ?

0 100 126 200 131 300 136 400 141 500 146 600 151 700 156 800 161 900 166 1000 171 1100 =VLOOKUP(A3,B8:C18,2) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rushiraj Patel Sent: Wednesday

Re: $$Excel-Macros$$ Vlookup basics and help

Don, It did not return any values On Wed, Mar 7, 2012 at 4:56 PM, dguillett1 wrote: > Modify to suit > > =IF(ISNA(VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)),"",VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)) > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Skand

Re: $$Excel-Macros$$ Need Help

Dear Kartik please use below codeand Change red color path Sub Sheet_Creater_Deptwise() Dim rng As Range Dim rng1 As Range Set rng = Sheet1.Range("G1:G" & Sheet1.Range("G65536").End(xlUp).Row) rng.Copy Sheet1.Range("H1") Set rng1 = Sheet1.Range("H1:H" & Sheet1.Range("H65536").End(xlUp).Row) rng1.S

Re: $$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

Dear Vinod, Please use.. =VLOOKUP($F15,INDIRECT($K$15&"!F:I"),3,0) and see attached sheet.. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 7, 2012 at 11:42 PM, vinod rao wrote: > HI T

Re: $$Excel-Macros$$ Vlookup basics and help

Dear Skanda, Please try it.. =IFERROR(VLOOKUP($A3,Maindata!$A$1:$I$25,MATCH(C$1,Maindata!$A$1:$I$1,0),0),"--") See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 7, 2012

Re: $$Excel-Macros$$ Need if formula

Dear Rajasekhar, You can use the IsError function as follows: =IF(ISERROR(B4/C4),0,B4/C4) On Thu, Mar 8, 2012 at 12:31 AM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > i just used this formula however how can i add iserror formula to this.. > > > > > On Thu, Mar 8, 2012 at

Re: $$Excel-Macros$$ Need Help

see attached sheet.. On Wed, Mar 7, 2012 at 3:12 PM, karthik N wrote: > Kindly help me > > To allocate the data in macro branch wise and every branch shouid be > save in new book , > > > Regards, > karthik.N > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise

$$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

Friends plz, formula through conditional formatting can be applicable. Now I am doing it manually everytime the date change. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge

Re: $$Excel-Macros$$ : How to use IF Function more than 8 times ?

Hi Rushiraj, you can also you lookup function please find the attachment.. On Wed, Mar 7, 2012 at 11:42 AM, Rushiraj Patel < rushiraj.pa...@in.aegisglobal.com> wrote: > Dear Experts, > > ** ** > > I am using Excel 2003. > > ** ** > > I have a file in which I need to bifurcate the figur

Re: $$Excel-Macros$$ Pivot Issue

Hello, Please let me know is there any soultion for this kind of issues. Regards, Chandra Shekar B On Tue, Mar 6, 2012 at 1:58 PM, Chandra Shekar wrote: > Hello Rajan, > > Yes Pivot name is correct. > > Regards, > > Chandra Shekar B > > On Tue, Mar 6, 2012 at 1:48 PM, Rajan_Verma wrote: > >>

Re: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

A few rows on the top has a logic that is different from the logic in a few rows below. Either that, or I am not able to understand your conditional format rule. Please let us know what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer wrote: > ** > Friends plz, fo

RE: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

Dear Sam, Thanx for reply, Conditional formatting to change the color. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, March 08, 2012 9:48 AM To: exce

Re: $$Excel-Macros$$ : How to use IF Function more than 8 times ?

I'd go with recommended solution of having helper columns. In case you need a non-helper column solution, use =LOOKUP(C16,{0,126,131,136,141,146,151,161,171,201},{"125 and Below","126 to 130","131 to 135","136 to 140","141 to 145","146 to 150","151 to 160","160 to 170","171 to 200","200 and above"

Re: $$Excel-Macros$$ Search an fill combobox

The ComboBox1_Change event is designed to work that way. Stop using the change event for this. Each time you type a letter, there is an event triggered. If you do not want to search to be triggered, why don't you use a button click for this. Type in the name in the combobox, and then click the butt

Re: $$Excel-Macros$$ Error in condition of particular data receive from another sheet

=IFERROR(INDEX(Sheet2!$C$2:$C$15,SMALL(IF(IFERROR(SEARCH(Report!$B$32,Sheet2!$A$2:$A$15,1),0)>0,ROW(Sheet2!$C$2:$C$15)-1,""),ROW()-33)),"") Regards, Sam Mathai Chacko On Wed, Mar 7, 2012 at 9:49 AM, Ashish Bhalara wrote: > > > -- Forwarded message -- > From: Ashish Bhalara > Dat

Re: $$Excel-Macros$$ Exl Adds-in or any software for doing data reconciliations

When you say data reconciliation, do you mean data comparison across sheets? Or is that consolidation? For the former, there's a sheet comparer add-in available on the net, if you search for it. Sam On Wed, Mar 7, 2012 at 5:24 PM, Pranab Brahmangaonkar wrote: > Hi friends, > > Please help me if

RE: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

Dear Sam, I want to know on this particular date how many people took the medicines and what's their badge no's. (only to differentiate them from other dates). Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups

Re: $$Excel-Macros$$ need help to make compare sheet plz

please send the sheet with example On Tue, Mar 6, 2012 at 6:14 AM, sherif azat wrote: > what i want in the sheet > > -- > 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

$$Excel-Macros$$ Excel Macro Code Request for List files and Move specified directory

Dear all, Please find below is my request to create macro code: Step1: Browse Directory. Step2: List files in above selected directory. Step3: Create directory based on the file Step4: Move files based on its named directory. Please help us to get this process solution. Please let me know if y

Re: $$Excel-Macros$$ Need Help

Thank You Regards karthik.N On Thu, Mar 8, 2012 at 9:56 AM, NOORAIN ANSARI wrote: > see attached sheet.. > > > On Wed, Mar 7, 2012 at 3:12 PM, karthik N wrote: > >> Kindly help me >> >> To allocate the data in macro branch wise and every branch shouid be >> save in new book , >> >> >> Regar

Re: $$Excel-Macros$$ Unlist - Table to be constant for every macro to run

*osh.ListObjects(1).UnList* Regards Sam Mathai Chacko On Wed, Mar 7, 2012 at 12:34 AM, dguillett1 wrote: > try > Sub removetableSAS() > dim i as integer > for i = 1 to 3 >activesheet. osh.listobjects("Table" & i ).unlist > next i > End sub > > Don Guillett > Microsoft MVP Excel > Sales