Re: $$Excel-Macros$$ Dynamic Chart

2013-09-13 Thread Chandra Shekar
Hello Ashish, I got the solution for this and also attached formulas if somebody can use it. Let me know is there any steps for doing it Thank you very much. Regards, Chandra On Thu, Sep 12, 2013 at 7:06 PM, ashish koul koul.ash...@gmail.com wrote: click on the series you will see the

$$Excel-Macros$$ Re: 2 LOOKUP-2 MATCH FUNCTION

2013-09-13 Thread Nemi Gandhi
Thank you very much Ravinderji... Nemi Gandhi On Thursday, September 12, 2013 1:36:05 PM UTC+5:30, Nemi Gandhi wrote: Attached worksheet for Nakshatra match gunank function. please give me formula. -- Nemi Gandhi 98204 92963 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ SumProduct

2013-09-13 Thread Chandra Shekar
Hi, I have a problem with Sumproduct function please find attached file for the same where from E1, F1 G1 are condtions based on it I need sum up Column D. Thanks in advance. Regards, Chandra -- 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) !

RE: $$Excel-Macros$$ SumProduct

2013-09-13 Thread Ravi Kumar
Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, September 13, 2013 4:21 PM To:

Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

2013-09-13 Thread Vandalo
Hi Chih Hung, You will need three files to achieve the goal you pretend. File 1 - Origem. This will be the file you got every 2 week with your source data. File 2 - Modelo. This is the file where you will paste data from file Origem. File 2 - Controlador. This is the file where resides the vba

$$Excel-Macros$$ Concatenate.

2013-09-13 Thread Prafull Jadhav
Dear All, Can we concatenate by using range with Arrey formula.? for example From Range(A2:K2) ..i have to concatenate.. but for this i have to put formula like concatenate(A2,B2,C2,D2...) Can we do this by using Range. concatenate(Range(A2:K2) Regards, Prafull Jadhav. -- Are you

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread shraddha malvankar
Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * shraddha malvankar shraddha...@gmail.com javascript:

$$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread shraddha malvankar
Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread koul . ashish
Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: shraddha malvankar shraddhamalvan...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 13 Sep 2013 10:57:37 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread ashish koul
try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject(Outlook.Application) For i = 2 To Sheets(data).Range(a65356).End(xlUp).Row With Sheets(Verification) 'clear exisitng if required

Re: $$Excel-Macros$$ Concatenate.

2013-09-13 Thread ashish koul
you can write udf to concatenate the range On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Can we concatenate by using range with Arrey formula.? for example From Range(A2:K2) ..i have to concatenate.. but for this i have to put formula

$$Excel-Macros$$ Query on vlookup

2013-09-13 Thread Shrinivas Shevde
Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread ashish koul
=VLOOKUP(F3,A:E,MATCH(Total,$2:$2,0),0) On Sat, Sep 14, 2013 at 9:58 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread De Premor
Try this formula *=VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0)* On 14-09-2013 11:28, Shrinivas Shevde wrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

RE: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread Ravi Kumar
Another way G3 is lookup_value =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH(total,A2:F2,0)-1) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Saturday, September 14, 2013 10:03 AM To:

Re: $$Excel-Macros$$ Query on vlookup

2013-09-13 Thread Shrinivas Shevde
Dear Ashish,De Premor,Ravi Kumar Very very thanks for the help All are working fine Thanks once again regards Shrinivas On Sat, Sep 14, 2013 at 10:36 AM, Ravi Kumar excellearn2...@gmail.comwrote: Another way ** ** G3 is lookup_value ** **