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

2014-10-01 Thread Vaibhav Joshi
this was not your requirement earlier!! chek this..When you run macro, 1st you ask fro whole range containing data, in this example you need to select range D2 to H23, after that you will be asked for destination column where you need result, here you need to select whole column like column J.

$$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 under

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 resp...@gmail.com 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

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 gawlianil8...@gmail.com wrote: Dear Hilary, Pl find attached as required by you Warm Regards, Gawli Anil :) On Wed, Oct 1, 2014 at 3:10

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 resp...@gmail.com wrote: Solid boss execllent, its what i wanted, can

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 v...@vabs.in wrote: chk this... also do you want data to be cleared from list 2 post data transfer to

$$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 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 resp...@gmail.com 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

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 v...@vabs.in 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 resp...@gmail.com wrote: wow, exactly what i needed, yes i wish

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 resp...@gmail.com wrote: thanks Boss On Wed, Oct 1, 2014 at 11:59 AM, Vaibhav Joshi v...@vabs.in wrote: chk this.. Cheers!! + *I did not do

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 isk1...@gmail.com 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

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

$$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)) in Excel?

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

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 rajanverma1...@gmail.com 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

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 rajanverma1...@gmail.com 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

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 newinex...@gmail.com 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