Re: $$Excel-Macros$$ Re: Macro on daily task

Thanks Pascaal, Apology for delay response and thanks for working on the macro. As i was busy with kids first birthday, i did not reply to ur email. on the query raised. Current, i apply filter and search anything which start as "Win" & group them under "Brokerage win". Like wise "TCAP" under "

Re: $$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C

Hi BTW, you said there is only two products. So how Z comes in the list ? Anyway, try =IF(COUNTIFS($A$1:$A$6,"x",$B$1:$B$6,B1)*COUNTIFS($A$1:$A$6,"y",$B$1:$B$6,B1),"Closed","Open") Kris ExcelFox -- FORUM RULES (986+ members already BANNED for violati

Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command

The most likely cause is that you have a macro assigned to Ctrl-A either in an open workbook, an addin, or in your personal macros workbook. This last is a hidden workbook which opens up when you open excel. You can see its macros in the VBE so press Alt-F11 and have a look. There may be a macro

Re: $$Excel-Macros$$ A24 workbook will be prepared based on A23

Just see the attached sheet FY Ref Regards Anil Gawli On Thu, May 24, 2012 at 3:06 PM, Anirban Roy wrote: > Dear Group, > > A24 will be prepared based on A23. Who will get highest score in every > sheet of A24, will win and his name will be declared by the authority. Data > entry will be in

Re: $$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C

Hi It doesn't work properly, if i add Z 45 at the end it would show closed but its should be open. Regards, Deepak Rawat On Thu, May 24, 2012 at 8:54 PM, NOORAIN ANSARI wrote: > Dear Sreenivas, > > Please try it and see attached sheet.. > > *=IF(COUNTIF($B$1:$B$6,B1)>1,"Closed","Open")* > > or

Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command

Dear All, This error is coming in all the sheets whenever I open any excel sheet and Press Crl.+A then error 1004 is showing on the screen. Thanks & Regards, K Sagar On Thu, May 24, 2012 at 6:05 PM, dguillett1 wrote: > Provide an excel file. > > Don Guillett > Microsoft MVP Excel > SalesAid

Re: $$Excel-Macros$$ Urgent Client Position ::: Java Flex Developer - Work Location: Palo Alto, CA

STOP ALREADY !! sai girish wrote: > *Hi,* > > *This is Thomas Fedrick, - Recruitment and Resources from SancroSoft USA > Inc.* > > We have an urgent requirement as follows: > > Please reply to this email with the latest copy of your resume in MS-Word > Format with the following details

Re: $$Excel-Macros$$ Urgent Client Position ::: Senior Websphere Systems Administrator - Work Location : Eldorado Hill , CA

Hi Thomas/Sai, Please do not post job vacancy in this group. Moderator: please delete this thread. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: sai girish Sender: excel-macros@googlegroups.com Date: Thu, 24 May 2012 01:45:42 Reply-To: excel-macros@googl

Re: $$Excel-Macros$$ Re: Macro on daily task

what about the content of your first file... can you say something about the code? it seems to open exploit On Thursday, May 24, 2012 10:53:03 PM UTC+1, Don Guillett wrote: > > Must have replied to another post with a request for a file. > ??? > > Don Guillett > Microsoft

Re: $$Excel-Macros$$ Re: Macro on daily task

Must have replied to another post with a request for a file. ??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: bpascal123 Sent: Thursday, May 24, 2012 4:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Macro on daily

Re: $$Excel-Macros$$ Re: Macro on daily task

Dunno. Didn’t' realize I replied. Been hectic today. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: bpascal123 Sent: Thursday, May 24, 2012 7:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Macro on daily task Don, What is this post abou

Re: $$Excel-Macros$$ Re: Macro on daily task

btw don, i'm running a 64-bit machine and your yahoo-host spreadsheet shell code seems not able to run, but why the heck do you send such files in this discussion??? On Thursday, May 24, 2012 1:04:05 PM UTC+1, Don Guillett wrote: > > > > Don Guillett > Microsoft MVP Excel > SalesAid Softwa

Re: $$Excel-Macros$$ Re: Macro on daily task

Don Guillett, is there anything wrong? First you come in discussion with nothing then you post files vba password locked if anybody can look at it closely, that to me seem to open a shell exploit On Thursday, May 24, 2012 1:04:05 PM UTC+1, Don Guillett wrote: > > > > Don Guillett > Microso

Re: $$Excel-Macros$$ Oralce Connection

thanks Paul, the issue is resolved. On 24 May 2012 07:50, Paul Schreiner wrote: > If you'd like for me to help you... > > I.need.the.entry.from.the.tnsnames.file > > I cannot guess. > > I tried to give you an idea what to look for, but have no idea what you > found, because you didn't tell me.

Re: $$Excel-Macros$$ queary

Hi Anil Assuming cell A1 = 901+k then in cell B1 try below formula =LOOKUP(MID(A1,FIND("+",A1,1)+1,1),{"a","i","k","l","p";"b","d","a","e","c"}) HTH Mahesh On Thu, May 24, 2012 at 8:58 PM, NOORAIN ANSARI wrote: > Dear Anil, > > Please try it and see attached sheet. > > * > =IF(COUNTIF($B$3:B

Re: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA

Just Curious but wasn't a rule made just a few days back regarding the blocking of people sending Job Postings ? Thanks Ashish Pradhan On 24-05-2012 22:42, resp...@gmail.com wrote: Why do you keep sending this ad over and over again. Sent from my BlackBerryŽ smartphone from Airtel Ghana --

Re: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA

Sai Girish is banned Regards Ayush Jain On Thursday, 24 May 2012 22:42:55 UTC+5:30, hilary lomotey wrote: > Why do you keep sending this ad over and over again. > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: *sai girish > *Sender: *excel-macr

Re: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA

Why do you keep sending this ad over and over again. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: sai girish Sender: excel-macros@googlegroups.com Date: Thu, 24 May 2012 22:42:19 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent C

Re: $$Excel-Macros$$ User Form

Thanks Chilexcel On Thu, May 24, 2012 at 10:23 PM, ChilExcel wrote: > Good Job Noorain Ansari !!! > > > Chilexcel > > 2012/5/24 NOORAIN ANSARI : > > Dear Deba, > > > > Please see attached Userform, hope it will help you. > > > > > > -- > > Thanks & regards, > > Noorain Ansari > > www.noorai

Re: $$Excel-Macros$$ User Form

Good Job Noorain Ansari !!! Chilexcel 2012/5/24 NOORAIN ANSARI : > Dear Deba, > > Please see attached Userform, hope it will help you. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Tue, May 22, 2012 at 6:01 PM, Deba Ranjan w

Re: $$Excel-Macros$$ queary

Dear Anil, Please try it and see attached sheet. * =IF(COUNTIF($B$3:B3,LEFT(B3,3)&"*")>1,VLOOKUP(LEFT(B3,3)&"*",$B$2:C3,2,0),CHAR(96+COUNTA($B$3:B3))) * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote

Re: $$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C

Dear Sreenivas, Please try it and see attached sheet.. *=IF(COUNTIF($B$1:$B$6,B1)>1,"Closed","Open")* or *=IF(SUMPRODUCT(--($B$1:$B$6=B1))>1,"Closed","Open")* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 24, 2012 at 6:48 PM, sreenivas

$$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C

Hi, Please see the attached example and please help out with Macro. I have ONLY two Products say X and Y in column "A" and if the amounts match for both the products in Column "B" write as Closed in Column "C". Please see the example attached in excel. note : Check the two products in rows in alt

$$Excel-Macros$$ A24 workbook will be prepared based on A23 workbook

Dear Experts, A24 will be prepared based on A23. Who will get highest score in every sheet of A24, will win and his name will be declared by the authority. Data entry will be in every sheet of A23 – And each sheet of A24 will be prepared whenever the macro will run. Waiting for your respon

Re: $$Excel-Macros$$ queary

Dear Anil, Please try it.. *=CHAR(96+ROW(A1)) * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote: > Hello friends, > > I have a queary plz find attahcment. > > > Thanks & Regards > Anil > > -- > FORUM

Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command

Provide an excel file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: SAGAR KASANGOTTUWAR Sent: Wednesday, May 23, 2012 2:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command Dear all, I am facing the prob

Re: $$Excel-Macros$$ Vlookup is not working

please see the attachment On Thu, May 24, 2012 at 6:01 PM, Amit Gandhi wrote: > thanks sir > > On Wed, May 23, 2012 at 6:00 PM, dguillett1 wrote: > >> Also, please do not use entire columns. Restrict to only area needed. >> >> =VLOOKUP(E3,Sheet1!E1:G100,3,FALSE) >> >> Don Guillett >> Microsof

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

thanks On Thu, May 24, 2012 at 5:50 PM, sreenivas kammari wrote: > use this formula: > > =VLOOKUP(E3,Sheet1!E:G,3,0). > > On Thu, May 24, 2012 at 4:09 PM, vijayajith VA > wrote: > > Hi > > Try ths > > =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) > > > > > > On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi >

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

thanks On Thu, May 24, 2012 at 4:09 PM, vijayajith VA wrote: > Hi > Try ths > =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) > > > On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi wrote: > >> Hi Experts >>> >>> >>> VLOOKUP is not working in attached file, can anyone help me why its not >>> working and what will

Re: $$Excel-Macros$$ queary

If you want help you need to: Use a meaningful subject line in your post give before/after examples and fully explain the logic. or... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: anil kumar Sent: Thursday, May 24, 2012 5:48 AM To: exc

Re: $$Excel-Macros$$ queary

sorry sir, lack of time i could not explen. I gat data in 901+k 903+a 901+p 905+i 902+l I have to change 901+k=a, 901+a=b, k=a a=b p=c i=d l=e -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

Re: $$Excel-Macros$$ Vlookup is not working

thanks sir On Wed, May 23, 2012 at 6:00 PM, dguillett1 wrote: > Also, please do not use entire columns. Restrict to only area needed. > > =VLOOKUP(E3,Sheet1!E1:G100,3,FALSE) > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Paul Schreiner > *Sent:*

Re: $$Excel-Macros$$ Re: Macro on daily task

Don, What is this post about? It has a reply I have deleted and files not related to the discussion. On Thursday, May 24, 2012 1:04:05 PM UTC+1, Don Guillett wrote: > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* bpascal123 > *Sent:*

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

use this formula: =VLOOKUP(E3,Sheet1!E:G,3,0). On Thu, May 24, 2012 at 4:09 PM, vijayajith VA wrote: > Hi > Try ths > =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) > > > On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi wrote: >>> >>> Hi Experts >>> >>> >>> VLOOKUP is not working in attached file, can anyone h

Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command

Delete all the rows and columns and try again. On Wed, May 23, 2012 at 1:00 PM, SAGAR KASANGOTTUWAR wrote: > Dear all, > > I am facing the problem in MS excel command Crl + A. Whenever I run command > Crl+A 1004 error in EXECL file. > > Kindly help me for resolve this error. > > Thanks & Regards,

Re: $$Excel-Macros$$ How to create running time in excel sheet

What do you mean by running time. please share more examples. On Wed, May 23, 2012 at 9:17 AM, PRAVESH KUMAR wrote: > Hi Group, > > please tell How to create running time in excel sheet?? > -- > > > *Thanks & Regards* > > *Pravesh Kumar* > > -- > FORUM RULES (986+ members already BANNED for viola

Re: $$Excel-Macros$$ queary

Dear Anil, Please explain..what you want as output. On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote: > Hello friends, > > I have a queary plz find attahcment. > > > Thanks & Regards > Anil > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread tit

Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command

Dear Mr. Rajan, I have removed all the add ins but still that error is showing in the screen. Thanks & Regards, K SAGAR On Wed, May 23, 2012 at 1:42 PM, Rajan_Verma wrote: > Remove add ins if you have installed > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]

Re: $$Excel-Macros$$ queary

what query u have , from the attachment i didn't understand . On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote: > Hello friends, > > I have a queary plz find attahcment. > > > Thanks & Regards > Anil > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accura

$$Excel-Macros$$ queary

Hello friends, I have a queary plz find attahcment. Thanks & Regards Anil -- 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, Code Problem, and Need Advice will not get q

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hi Try ths =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi wrote: > Hi Experts >> >> >> VLOOKUP is not working in attached file, can anyone help me why its not >> working and what will be right formula? >> >> Pls help me here. >> >> Regards >> >> Amit >> >> -- >>

$$Excel-Macros$$ A24 workbook will be prepared based on A23

Dear Group, A24 will be prepared based on A23. Who will get highest score in every sheet of A24, will win and his name will be declared by the authority. Data entry will be in every sheet of A23 – And each sheet of A24 will be prepared whenever the macro will run. Waiting for your response