Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-22 Thread dguillett1
like my solution. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Wednesday, August 22, 2012 1:37 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list) Hi

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-22 Thread amar takale
Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* amar takale > *Sent:* Wednesday, August 22, 2012 1:37 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Search & Highlight name in list (1000 > name list) >

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-22 Thread dguillett1
My guess is that you didn’t like my solution. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Wednesday, August 22, 2012 1:37 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread SAGAR KASANGOTTUWAR
Dear Mr. Amar, Can you explain me in detail that will help me lot. I am not able understand the logic behind the attached excel THANKS & REGARDS, CA KSAGAR On Tue, Aug 21, 2012 at 4:01 PM, Amresh Maurya wrote: > > Hi CA KSAGAR , > > GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET L

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread dguillett1
ps.com ; NOORAIN ANSARI Subject: $$Excel-Macros$$ Search & Highlight name in list (1000 name list) Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name & I search name then I scroll bar up & down which cell highl

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread Amresh Maurya
Hi CA KSAGAR , GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET LOGIC.. Regards Amresh On Tue, Aug 21, 2012 at 3:42 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Ameresh, > > Kindly tell me how we can put scroll in excel like you have done in > attached work

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread SAGAR KASANGOTTUWAR
Dear Ameresh, Kindly tell me how we can put scroll in excel like you have done in attached worksheet... Thanks & Regards, CA KSAGAR On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली wrote: > Dear Amar > Your formula is right > if you want only the highlighted color then on filter field click o

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread अनिल नारायण गवली
Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks & Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale wrote: > Hi Amresh > I used excel 2003 So I cant see formulas.I also

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread amar takale
Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya wrote: > Hi Amar, > > find the attached file. hope it will help you in search the data. >

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread Amresh Maurya
Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale wrote: > Hi experts, > I know it is Conditional formatting but if I search name then highlight > that cell but if there are 1000 name & I search name then I sc

$$Excel-Macros$$ Search & Highlight name in list (1000 name list)

2012-08-21 Thread amar takale
Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name & I search name then I scroll bar up & down which cell highlight. I want to jump that cell directly with highlight.Is it possible? Thanks Amar -- Join official facebook page of