Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread Vaibhav Joshi
What is criteria for false condition? On Oct 1, 2014 9:07 PM, "SUDHIR VERMA" wrote: > Dear Vaibhav, > > Thanx for new intellectual property of coding. But there is all conditions > are "true".This file is containing true criteria. Please run this macro > for false condition. Once again you are r

Re: $$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread Vaibhav Joshi
its super one.. + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 7:37 PM, Rajan Verma wrote: > in J1 > > =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 > > Regards > Rajan. > > On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: >> >> Dear

Re: $$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread SUDHIR VERMA
thanking you so much On 1 October 2014 19:37, Rajan Verma wrote: > in J1 > > =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 > > Regards > Rajan. > > On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: >> >> Dear Experts, >> >> Kindly resolve my problem. >> >> Explanation in attached workb

Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread SUDHIR VERMA
Dear Vaibhav, Thanx for new intellectual property of coding. But there is all conditions are "true".This file is containing true criteria. Please run this macro for false condition. Once again you are requested to give your precious time. Thanking You On 1 October 2014 12:10, Vaibhav Joshi wro

$$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread Rajan Verma
in J1 =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 Regards Rajan. On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: > > Dear Experts, > > Kindly resolve my problem. > > Explanation in attached workbook. > > Thanking You > > Regards > Sudhir > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Need help to mail userform on outlook body

2014-10-01 Thread Paul Schreiner
It sounds like you're trying to create a userform in Excel, copy the userform to an email in Outlook, Send the email, have the recipient change something and click a button and have the userform respond to your Excel workbook? I don't think you're going to have any luck with that approach. Even

Re: $$Excel-Macros$$ Conditional formatting help - file attached

2014-10-01 Thread Vaibhav Joshi
check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 4:25 PM, Pravin Gunjal wrote: > Hello Friends, > > I have attached an excel file, in which Column D, M and Y are very > important in this file. > > *I need the following :*

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Vaibhav Joshi
welc0me..Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 4:42 PM, Hilary Lomotey wrote: > thanks Boss > > On Wed, Oct 1, 2014 at 11:59 AM, Vaibhav Joshi wrote: > >> chk this.. >> >> Cheers!! >> >> + >> *I did not do this for you. G

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Hilary Lomotey
thanks Boss On Wed, Oct 1, 2014 at 11:59 AM, Vaibhav Joshi wrote: > chk this.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Wed, Oct 1, 2014 at 4:21 PM, Hilary Lomotey wrote: > >> wow, exactly what i needed, yes i wish the data be cleared

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Vaibhav Joshi
chk this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 4:21 PM, Hilary Lomotey wrote: > wow, exactly what i needed, yes i wish the data be cleared , will be > grateful for that bit of code. thanks but its excellent code, thanks All

$$Excel-Macros$$ Conditional formatting help - file attached

2014-10-01 Thread Pravin Gunjal
Hello Friends, I have attached an excel file, in which Column D, M and Y are very important in this file. *I need the following :* If a Division (Col D) has crossed 30 days (Col Y) and still not received an acknowledgement copy (Col M) then the entire row (from Column A to Y) must be highlighted

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Hilary Lomotey
wow, exactly what i needed, yes i wish the data be cleared , will be grateful for that bit of code. thanks but its excellent code, thanks All On Wed, Oct 1, 2014 at 11:39 AM, Vaibhav Joshi wrote: > chk this... > > also do you want data to be cleared from list 2 post data transfer to > excel... >

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Vaibhav Joshi
chk this... also do you want data to be cleared from list 2 post data transfer to excel... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 3:45 PM, Hilary Lomotey wrote: > Solid boss execllent, its what i wanted, can you assist with t

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Hilary Lomotey
Solid boss execllent, its what i wanted, can you assist with the last piece of code to post it to column G? On Wed, Oct 1, 2014 at 11:09 AM, Anil Gawli wrote: > Dear Hilary, > > Pl find attached as required by you > > Warm Regards, > Gawli Anil :) > > On Wed, Oct 1, 2014 at 3:10 PM, Hilary Lomo

Re: $$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Anil Gawli
Dear Hilary, Pl find attached as required by you Warm Regards, Gawli Anil :) On Wed, Oct 1, 2014 at 3:10 PM, Hilary Lomotey wrote: > Hello experts, > > kindly assist with code in the form attached. > what i need to do is that when i open the userform, i want to select names > on the left listb

$$Excel-Macros$$ Move Selected Names to Listbox

2014-10-01 Thread Hilary Lomotey
Hello experts, kindly assist with code in the form attached. what i need to do is that when i open the userform, i want to select names on the left listbox and click on the arrow button () to populate it in the listbox on the right so i will be able to post it in the sheet (Home) column G unde