RE: $$Excel-Macros$$Extract information

2013-03-05 Thread Manjunath Narayanappa
Can some one help me on the below From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 05 March 2013 11:20 To: 'xlstime' Cc: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$Extract information Yes

RE: $$Excel-Macros$$Extract information

2013-03-05 Thread Manjunath Narayanappa
Yes From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 05 March 2013 11:18 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$Extract information Yes From: excel-macros@googlegroups.com [mailto:ex

RE: $$Excel-Macros$$Extract information

2013-03-05 Thread Manjunath Narayanappa
Yes From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 05 March 2013 11:18 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$Extract information you mean to say sheet1 data every day or every click consolidate in sheet2 Enjoy Team

RE: $$Excel-Macros$$Extract information

2013-03-05 Thread Manjunath Narayanappa
anjunath From: Prince [mailto:prince141...@gmail.com] Sent: 05 March 2013 11:04 To: excel-macros@googlegroups.com Cc: 'Prince'; Manjunath Narayanappa Subject: Re: $$Excel-Macros$$Extract information So how calculation on sheet2 has done please explain. With an example. Regards Prince O

Re: $$Excel-Macros$$Extract information

2013-03-05 Thread xlstime
e [mailto:prince141...@gmail.com] > *Sent:* 05 March 2013 10:39 > *To:* excel-macros@googlegroups.com > *Cc:* Manjunath Narayanappa > *Subject:* Re: $$Excel-Macros$$Extract information > > > > Hi Manjunath, > > > > Do you want to get the same information to be p

Re: $$Excel-Macros$$Extract information

2013-03-05 Thread Prince
[mailto:prince...@gmail.com ] > *Sent:* 05 March 2013 10:39 > *To:* excel-...@googlegroups.com > *Cc:* Manjunath Narayanappa > *Subject:* Re: $$Excel-Macros$$Extract information > > > > Hi Manjunath, > > > > Do you want to get the same information to be pasted on t

RE: $$Excel-Macros$$Extract information

2013-03-05 Thread Manjunath Narayanappa
: Prince [mailto:prince141...@gmail.com] Sent: 05 March 2013 10:39 To: excel-macros@googlegroups.com Cc: Manjunath Narayanappa Subject: Re: $$Excel-Macros$$Extract information Hi Manjunath, Do you want to get the same information to be pasted on the sheet2 with same information as it is on sheet1 or

Re: $$Excel-Macros$$Extract information

2013-03-05 Thread Prince
Hi Manjunath, Do you want to get the same information to be pasted on the sheet2 with same information as it is on sheet1 or somthing else is required. Please explain bit more. Regards Prince On Tuesday, 5 March 2013 14:19:02 UTC+5:30, Manjunath Narayanappa wrote: > > Dear Experts, > > > >

$$Excel-Macros$$Extract information

2013-03-05 Thread Manjunath Narayanappa
Dear Experts, In the above attachment, I have a data in Sheet1 in which we update on daily basis. With the help of macros, can I extract same information in sheet2 with one click Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL

RE: $$Excel-Macros$$ Extract information from excel

2013-01-30 Thread Manjunath Narayanappa
s case can we give if function and extract looking information to D column Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 28 January 2013 15:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extrac

Re: $$Excel-Macros$$ Extract information from excel

2013-01-30 Thread Paul Schreiner
At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Manjunath Narayanappa To: "excel-macros@googlegroups.com" Sent: Mon, January 28, 2013 10:12:20 AM Subject: $$Exce

Re: $$Excel-Macros$$ Extract information from excel

2013-01-30 Thread अनिल नारायण गवली
Dear Manjunath, see the attached sheet. Warm Regards, Gawli Anil On Wed, Jan 30, 2013 at 4:21 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Experts > > > > Thanks to all, > > > > Please find the attachment, please advise in case if we have K508 ,F508, > E508, A50

$$Excel-Macros$$ Extract information from excel

2013-01-30 Thread Manjunath Narayanappa
Dear Experts Thanks to all, Please find the attachment, please advise in case if we have K508 ,F508, E508, A508 in rows but in same column B I have highlighted in red. Regards Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
r Anil, >>>> >> Yes,I am not used countifs formula.pls suggest Excel 2003 formula >>>> >> Thanks in Advance >>>> >> >>>> >> On Tue, Jan 29, 2013 at 3:45 PM, Manjunath Narayanappa >>>> >> wrote: >>&g

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread NOORAIN ANSARI
; From: excel-macros@googlegroups.com > >> > [mailto:excel-macros@googlegroups.com] > >> > On Behalf Of Manjunath Narayanappa > >> > Sent: 29 January 2013 10:14 > >> > To: 'excel-macros@googlegroups.com' > >> > Subjec

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
groups.com >> > [mailto:excel-macros@googlegroups.com] >> > On Behalf Of Manjunath Narayanappa >> > Sent: 29 January 2013 10:14 >> > To: 'excel-macros@googlegroups.com' >> > Subject: RE: $$Excel-Macros$$ Extract information from e

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
ehalf Of Manjunath Narayanappa > Sent: 29 January 2013 10:14 > To: 'excel-macros@googlegroups.com' > Subject: RE: $$Excel-Macros$$ Extract information from excel > > > > Dear Gawli Ali, > > > > I'm unable to copy the formula & paste i

RE: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread Manjunath Narayanappa
sorry to miss spell your name From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 29 January 2013 10:14 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Extract information from excel Dear Gawli Ali, I&#

RE: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread Manjunath Narayanappa
Dear Gawli Ali, I'm unable to copy the formula & paste in another sheet Thank Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?? Sent: 29 January 2013 04:53 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
l-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >> On Behalf Of ashish koul >> Sent: 28 January 2013 15:28 >> To: excel-macros@googlegroups.com >> Subject: Re: $$Excel-Macros$$ Extract information from excel >> >> >> >> try t

RE: $$Excel-Macros$$ Extract information from excel

2013-01-28 Thread Manjunath Narayanappa
Thank you very much Ashish, its working fine From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 28 January 2013 15:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extract information from excel try this see if it helps

Re: $$Excel-Macros$$ Extract information from excel

2013-01-28 Thread ashish koul
try this see if it helps =MID(B2&" ",FIND("K508",B2&" "),FIND(" ",B2&" ",FIND("K508",B2&" "))-FIND("K508",B2&" ")) On Mon, Jan 28, 2013 at 8:41 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Team, > > > > In above attachment I have a data from which I want to extr

$$Excel-Macros$$ Extract information from excel

2013-01-28 Thread Manjunath Narayanappa
Dear Team, In above attachment I have a data from which I want to extract only the highlighted information For Eg K5024454 Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail