$$Excel-Macros$$ Organizational Chart

2017-02-01 Thread Kiran Kancherla
Hi All: I have different kind of requirement in which I have to prepare Organizational Chart. I have googled my requirements but in all the codes, they are adding some reporting numbers or something. In my current sheet I will be giving the same some senior management executive. In my curre

$$Excel-Macros$$ Organizational Chart

2017-02-01 Thread Kiran Kancherla
Hi All: I have different kind of requirement in which I have to prepare Organizational Chart. I have googled my requirements but in all the codes, they are adding some reporting numbers or something. In my current sheet I will be giving the same some senior management executive. In my curre

Re: $$Excel-Macros$$ Sure Shot 20-20: Java Developer Tampa, FL in Tampa, - 20 positions - NO END CLIENT INTERVIEW

2012-04-26 Thread Kiran Kancherla
D Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: DK Sender: excel-macros@googlegroups.com Date: Thu, 26 Apr 2012 10:12:22 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sure Shot 20-20: Java Developer Tampa, FL in Tampa, - 20 pos

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

2012-03-28 Thread Kiran Kancherla
Hi Don, I totally agree. I can use auto filter or advanced filter to get the out put. This report is a daily report for me and there will be lot of additions and deletions will be there. I need a formula to get the output... Thanks, Kiran Sent on my BlackBerry® from Vodafone Thanks & Regards.

Re: $$Excel-Macros$$ Excel Macro to navigate IE

2012-02-01 Thread Kiran Kancherla
arting off point) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: Wednesday, February 01, 2012 9:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE Hi Asa, I am sorry. I can n

Re: $$Excel-Macros$$ Excel Macro to navigate IE

2012-02-01 Thread Kiran Kancherla
oflight.com/2010/07/excel-web-query-urls-with-dynamic- parameters/ . http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameter s-with-web-queries.aspx Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ki

Re: $$Excel-Macros$$ Excel Macro to navigate IE

2012-02-01 Thread Kiran Kancherla
Click 'Wait for page to load Do Until objIE.readyState = READYSTATE_COMPLETE: Loop Err_Hnd: '(Fail gracefully) objIE.Visible = True End Sub Regards, Sam Mathai Chacko On Wed, Feb 1, 2012 at 10:27 PM, Kiran Kancherla wrote: > > Hi

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread Kiran Kancherla
Sam, U are also an very good resource for the group.. Ur knowledge is very helpful for all the members Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:41:24 To:

$$Excel-Macros$$ Excel Macro to navigate IE

2012-02-01 Thread Kiran Kancherla
Hi All, If any of have Macro ''click'' or ''navigate'' internet explorer... My requirement is to click 3 hyper links and copy the data to Excel I have tried googling it.. But no luck.. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -- FORUM RULES (986+ members already BANNE

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread Kiran Kancherla
Cong... Noorain Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:11:57 To: excel-macros Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: $$Excel-Macros$$ Mo

Re: $$Excel-Macros$$ Happy Birth Day

2012-01-02 Thread Kiran Kancherla
Hi Noorain, Many many happy returns of the day... God bless you & have a Rocking Day, Month and year. Regards, Kiran Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Mon, 2 Jan 2012 20:22:29

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

2011-12-14 Thread Kiran Kancherla
Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Wed, 1

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

2011-12-11 Thread Kiran Kancherla
Hi Maulik, Good to know as there is a solution for that problem. Request you please share the same knowledge as I have same issue with me. Thanks, Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: maulik desai Sender: excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Subtotals

2011-12-04 Thread Kiran Kancherla
Hi Sam, Meanwhile, request you to please share the files which you have for the same. I hope u must have the best.. Kiran Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Su

Re: $$Excel-Macros$$ How to recover ppt file saved on email

2011-11-10 Thread Kiran Kancherla
1.Try to search all the temp files. 2.Close and reopen the mail, when the mail pop-up says Yes or No to Save, say Yes. 3.Search for recent files. Sent on my BlackBerryŽ from Vodafone Thanks & Regards. Kiran -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups

Re: $$Excel-Macros$$ INTERVIEW Quetions

2011-09-15 Thread Kiran Kancherla
Hi Noorain, Thanks a lot... This looks very good and very helpful. Guys: Request you to please share some more knowledge if you have any these kind of Handy's Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: NOORAIN ANSARI Sender: excel-macros@g

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Kiran Kancherla
Amit =sumproduct((a2:a22=1)*(b2:b22<>"")) This is the easiest way to do this. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Tue, 30 Aug 2011 22:48:06 To: Reply-To: excel-macros@go