Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation

2013-09-16 Thread Vishwanath
Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor d...@premor.net wrote: PFA and try to run macro named SAVE on module1 On 29-08-2013 18:57, Vishwanath wrote:

Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation

2013-09-16 Thread De Premor
U're welcome i' stay in Borneo Island (Indonesia) (^_^) Pada 16/09/2013 13:13, Vishwanath menulis: Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor

Re: $$Excel-Macros$$ SumProduct

2013-09-16 Thread Chandra Shekar
Hello, Thanks its working fine.. On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar excellearn2...@gmail.comwrote: Hi, ** ** Try this.. ** ** =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) ** ** ** ** * * *Warm Regards,* *Ravi Kumar.* ** ** *From:*

RE: $$Excel-Macros$$ SumProduct

2013-09-16 Thread Ravi Kumar
Ur welcome Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, September 16, 2013 12:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SumProduct Hello, Thanks its

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

2013-09-16 Thread johnson john
Dear Shrinivas, Index - Match function will be the solution for your problem. Pls. see the attachment. thanks JOhnson On Mon, Sep 16, 2013 at 10:21 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Shrinivas, u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0) Warm Regards, Gawli

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

2013-09-16 Thread shraddha malvankar
Hi, I am really new in macro, can you please help me in attached excel as well LI tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I

Re: $$Excel-Macros$$ how to connect with accdb database from excel

2013-09-16 Thread Anshul Arora
Hi , can you please mail me the excel file .I am also trying to connect excel with password protected accdb database but unable to do it. It will show error message Invalid Password.It will be a great help On Mon, Aug 29, 2011 at 9:40 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear

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

2013-09-16 Thread ashish koul
do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Hi, I am really new in macro, can you please help me in attached excel as well L I tired the same principle which you sent me last

$$Excel-Macros$$ macro for required data please find the attachment once

2013-09-16 Thread Renukachari Kasee
Dear experts. please solve my query its very very urgent macro for required data please find the attachment once thanks *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari.

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

2013-09-16 Thread shraddha malvankar
Yes On 16 Sep 2013 20:12, ashish koul koul.ash...@gmail.com wrote: do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Hi, I am really new in macro, can you please help me in

$$Excel-Macros$$ How to do polynomial curve fitting with macro in excel?

2013-09-16 Thread Lingjun Meng
Hi guys, This is my first post in this group. It is great that there is such a group! What I want to do right now is like this: Say, I have four columns of data, Column A, B, C and D, the latter three depend on Column A, there are 4 rows in each column I want to

Re: $$Excel-Macros$$ macro for required data please find the attachment once

2013-09-16 Thread De Premor
Here i'am using Multidimension array to get faster result This will little longer in code, but will much faster then Direct Manipulation Data using For Each ... in Range... Next (Loop) And then... Here we go... Sub Convert() Dim Data, Hasil, LCount As Long, LRow As Long, iCol As Integer

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-16 Thread Anoop K Sharma
Make a query as Select Top 20 From your table name in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query Select Top 20 From your table name order by your sort column In case you

$$Excel-Macros$$ Macro File Saving Restriction

2013-09-16 Thread pankajinfo
Dear All, As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro enabled file extension in those files macros do not work or visible. So i want to make a restriction in macro enabled files .xlsm or .xlsb that they cannot be saved under non-macro enabled file extension. Is it

$$Excel-Macros$$ Need Formula

2013-09-16 Thread Prabhu Pinky
Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks Regards, Prabhu R -- 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$$ Need Formula

2013-09-16 Thread अनिल नारायण गवली
Dear Prabhu, Pl see the attached sheet. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi Experts, Please find the attached file, please revert