$$Excel-Macros$$ Macro for NAV Calculation

2009-05-09 Thread mahesh parab
Dear All i want to wirte macro for attach NAV calculation. i want when i click on button the macro will calculate the results,steps are mention in sheet, please find the attach sheet. --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Run a macro on Enter?

2009-05-09 Thread Akhilesh Karna
You may use the following code instead of last one. In place of msgbox you can call some macro which you wish to run when Enter is pressed. The present code assumes column 3 as having the data instead of column 4 which you need. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim

$$Excel-Macros$$ Download data from NSE site and sort and group it

2009-05-09 Thread Balla
Hi, I want to basically fetch historical data of stock markets - derivatives - from the website of NSEINDIA.COM, when i manually go to the site and try to fetch data for a data, the URL generally comes like eg: http://www.nseindia.com/content/historical/DERIVATIVES/2009/MAY/fo06MAY2009bhav.csv

$$Excel-Macros$$ Re: Average's

2009-05-09 Thread Aindril De
Hi Sabby, Sorry for the delay in responce. Could you please attach a sample sheet so that it is easy to understand the organization of the data in your worksheets. Regards, Andy On Fri, May 8, 2009 at 4:38 PM, Sabbycat dancoo...@googlemail.com wrote: hi Aindril as i am trying to calculate

$$Excel-Macros$$ Re: Need help

2009-05-09 Thread Harmeet Singh
Addressing the group On Sat, May 9, 2009 at 11:35 PM, shariq khan shariqcoo...@gmail.com wrote: Hi Harmeet, Actually I got your ID from macro group and saw some of your macro codes, they was really very good. I need your help , I want 2 merge the 100 excel files placed in a folder

$$Excel-Macros$$ Re: single password for excel

2009-05-09 Thread zheng yu
Can anyone explain a bit principle and ways of BREAKING passwords? On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati kamalgula...@gmail.com wrote: Plz help me to crack the password for MS - Word. Thanks and regards, Kamal Gulati On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte

$$Excel-Macros$$ Re: pls help- i need to get the column name in the fields

2009-05-09 Thread kvc praveen kumar
Hi, I wrote this formula for ur purpose. =IF(RANK($A2,$A2:$D2,1)=F$1,$A$1,IF(RANK($B2,$A2:$D2,1)=F$1,$B$1,IF(RANK($C2,$A2:$D2,1)=F$1,$C$1,$D$1))) See the attached sheet for reference. Let me know if this helps. On Sat, May 9, 2009 at 8:53 PM, subs subbu1...@gmail.com wrote: ca1 ca2 ca3

$$Excel-Macros$$ Re: E Book on Excel.

2009-05-09 Thread Kamal Gulati
Dear Hari, Plz send the advance book of excel along with the VBA and MACROS using excel. regards, Kamal Gulati E-mail:kamalgula...@gmail.com On Sat, May 9, 2009 at 9:57 AM, hari kumar prekkeh...@gmail.com wrote: Hi Prateek, FYI. This book covers basics. if need more details or