Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

IT WORKS ... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If WorksheetFunction.CountIf(Range("A3:G3"), "XYZ") > 0 Then Rows("25:30").Hidden = False End If End Sub THANKS FOR SHARING On Saturday, 2 April 2016 11:21:18 UTC-7, NIJ wrote: > > Thanks alot.

Re: $$Excel-Macros$$ Comine Text

Dear Mr. Pankaj, Thanks, Just in addition to this can you send me revised code attached file. Thanks in advance On Sunday, April 3, 2016 at 5:40:52 AM UTC+5:30, Pankaj Sharma wrote: > > chk > > > > *PJ * > > *MIS Analyst*

Re: $$Excel-Macros$$ Comine Text

chk *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook** www.facebook.com/dude.pj * *We meet for a reason, either you're a ble

Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

Thanks alot. one more query IF I WANT TO UNHIDE CERTAIN ROWS SAY ROW 25 TO 30 ( ALREADY HIDDEN) IF TEXT CONTAIN "XYZ" IN ANY OF CELL A3 TO G3, PLEASE GIVE MACRO FOR THAT. On Saturday, 2 April 2016 06:53:26 UTC-7, Sam Mathai Chacko wrote: > > > Private Sub Worksheet_SelectionChange(ByVal Target

$$Excel-Macros$$ Comine Text

Hi, Please help me out to solve this problem, I have following table. Now what I want to have result as third column "Combine". Srn Name Combine 1 A A, B, C B C 2 D D, E E 3 F F, G, H, I, J G H I J 4 K K 5 O O, P P -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Please check the below formula will work for you, this will count and return a value above zero if existed in the list. =COUNTIF(mylist,RIGHT(A1,5)) Regards Faisal PK On Sat, Apr 2, 2016 at 6:38 PM, Ganesh N wrote: > Dear Team, > > Any one can help me out ? > > Thanks & Regards, > Ganesh N > >

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Dear Team, Any one can help me out ? Thanks & Regards, Ganesh N On Sun, Mar 27, 2016 at 9:15 PM, Ganesh N wrote: > Dear Team, > > Any update on my request ? > > Thanks & Regards, > Ganesh N > > On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N wrote: > >> Dear Team, >> >> Kindly request to help me wi

$$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote: > > I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT > POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH > CELL VALUE. > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > > I

Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Rows("12:18").Hidden = Worksheetfunction.countif(Range("A1:G2"),"ABC") > 0 End Sub On Apr 2, 2016 19:18, "NIJ" wrote: > > > On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote: >> >> I want to aply below macro to cells A1 to

$$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote: > > I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT > POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH > CELL VALUE. > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > > I

Re: $$Excel-Macros$$ SAME MACRO FOR MANY CELLS

You want to check whether each cell from A1 to G2 has the text "ABC" in it or not? And if yes, hide the same rows? On Sat, Apr 2, 2016 at 7:00 PM, NIJ wrote: > I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT > POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO F

$$Excel-Macros$$ SAME MACRO FOR MANY CELLS

I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH CELL VALUE. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value = "ABC" Then Rows("12:18").Hidden = True

$$Excel-Macros$$ Re: EXCEL ADD-IN for reconciling two Data Tables

Thank you sir for that, i appreciate and am using it at my workplace. On Thursday, September 13, 2012 at 9:28:34 PM UTC+3, aju wrote: > > Dear Friends, > Please the attached Excel add-in Reconciliation > Tool made by me.This Add-in can be used to reconcile two numerical f