Re: $$Excel-Macros$$ Averege by Using by Sumproduct.

2014-03-13 Thread Anil Gawli
Dear Praful, Why u are using sumproduct u can use averageif formula. =averageif(range,criteria,criteriarange). Warm Regards, Gawli Anil. On Wed, Mar 12, 2014 at 5:36 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Good Evening , 1)I am not able to calculate the Average

$$Excel-Macros$$ Help!!(Dashboard)

2014-03-13 Thread Soum
Dear Ashish, Could you help me out about some sample dashboards on Financial Reporting? Regards, Soumyendu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] Averege by Using by Sumproduct.

2014-03-13 Thread Prafull Jadhav
Dear All, Waiting for the same. Dear All, Thanks for reply.. MY question is when I use the Dynamic Range then output of Avg Response time is coming but it is not applicable to Resolution. Why this happen ..? Please explain Regards, Prafull Jadhav 9920553518 On 12 March 2014 20:10,

RE: $$Excel-Macros$$ Validation cells

2014-03-13 Thread Ravinder
Pfa. try this may be you like...I have put data validation till 20th row you can increased as per your requirement. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, March 13, 2014 9:49 AM To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

2014-03-13 Thread Caroline Campos
Obrigada Ricardo. Muito legal a planilha, mas a minha dúvida é que quando adiciono um hyperlink em uma das suas celulas da pasta 1, a pasta 2 não atualiza a mesma celula, adicionando o hyperlink automático. *Att. Caroline Campos (21) 8102-4893* *Preserve o Meio Ambiente* *Por favor, pense

$$Excel-Macros$$ Dynamic Attachment with Email Send

2014-03-13 Thread Vijay
Hi Team, I need a help in creating a macro for attached Excel File in E Mail. Process Brief:- 1) I have one excel file. In that excel file, there is one column named as Branch Name. Which is important us to find out Branch Name and that particular branch details should be create as Separate

$$Excel-Macros$$ row addition macro

2014-03-13 Thread E J
Hi Everyone, I was wondering if I could get help with a macro. I'm trying to write a macro where the macro walks down a column of data based on where I initially highlight the active cell. If the data in two consecutive cells are different it adds 2 rows (or N rows). I've attached an example

$$Excel-Macros$$ additional row creation

2014-03-13 Thread E J
Hi Everyone, I was wondering if I could get help with a macro. I'm trying to write a macro (with no luck) that walks down a column based on the initial placement of the active cell. Every time there are two cells with different data it adds two (or N rows). It doesn't, however, view blank

RE: $$Excel-Macros$$ additional row creation

2014-03-13 Thread Ravinder
PFA, just select first complete row From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of E J Sent: Friday, March 14, 2014 4:03 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ additional row creation Hi Everyone, I was wondering if I

Re: $$Excel-Macros$$ additional row creation

2014-03-13 Thread mrExcel4u
Hi E J try this... Sub testing() Dim rng As Range Dim rcount As Long Dim cel As Range rcount = Sheets(1).Cells(Rows.Count, c).End(xlUp).Row Set rng = Sheets(1).Range(c1:c rcount) For Each cel In rng If cel cel.Offset(1, 0) And cel Then cel.Offset(1, 0).Select