$$Excel-Macros$$ AlT I +R Not working

Hi, Can someone help me on why Alt I+R is not working? I am using excel 2007. It was working till few days ago but not now. I am using Alt + H + I + R to add rows. Thanks in advance. Regards, Sharad -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Plant Operating Days in Each Year

Dear Experts, Please help me in calculating operating days in the attached sheet. There are 2 contracts which will run after one after other. These start and end at particular days. There is gap of some days between start of 2nd contract and end of 1st contract. I need to calculate that for how

$$Excel-Macros$$ Locking Only Selected Cell

Dear Experts, Can someone please let me know how to lock only selected cell? Thanks, Sharad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Discounting factor for monthly payments

Hi, Can someone give me a formula for calculating the discounting factor to get present value of monthly interest payment? Regards, Sharad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ Excel Chart of Four Quadrants

Hi All, Can you someone help us in putting the attached data in four quadrants chart in excel? We need name of the company against its dot. We have tried the following url, however it does not allows us to put names on dots.

Re: $$Excel-Macros$$ payback Period Formula / Macro

Hi David, Thanks a lot for your help on this. Really appreciate. Best Regards, Sharad On Tue, Aug 14, 2012 at 3:19 PM, David Grugeon da...@grugeon.com.au wrote: Sorry. I worked it for each input value being the cash flow for a year. I see that you have put down a Year 0 and the cash flows

$$Excel-Macros$$ payback Period Formula / Macro

Hi, I need a formula or macro for calculating payback period which is dynamic. I mean that it can calculate the payback period for series of data without changing the formula itself again again. I am attaching an example sheet with 3 scenarios where we can have same formula / macro. Will

$$Excel-Macros$$ Curser not moving while editing

Hi All, I can not move my curser directly in excel while editing. In the attached example, if I want to make B2 to A2. I can not do it directly. I have to actually type it in place of B2. Can someone help? Thanks. Sharad -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Curser not moving while editing

, It is working on my system. once again Please press on scrolllock button. On Wed, Aug 1, 2012 at 4:38 PM, sharad jain jainshar...@gmail.comwrote: Hi All, I can not move my curser directly in excel while editing. In the attached example, if I want to make B2 to A2. I can not do it directly. I have

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

Thanks Maries, However, I am not able to download any price data. Regards, Sharad On Mon, Feb 13, 2012 at 10:25 AM, Maries talk2mar...@gmail.com wrote: http://www.mrexcel.com/tip103.shtml On Mon, Feb 13, 2012 at 8:37 AM, sharad jain jainshar...@gmail.comwrote: Hi Experts, Can anyone

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

Priyanka, Can you please explain in detail? Thanks, Sharad On Mon, Feb 13, 2012 at 3:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sharad Do u use ODIN? if yes then recent prices can be get directly from there On Mon, Feb 13, 2012 at 3:07 PM, sharad jain jainshar...@gmail.comwrote

$$Excel-Macros$$ Price Download from NSE - Urgent

Hi Experts, Can anyone suggest a way to directly download the prices from NSE website? I can provide ticker in a cell. I am talking about downloading the latest price following url: http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD Please treat this

Re: $$Excel-Macros$$ Prices from NSE website

WEB using FROM WEB option in Get External Data.** ** ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *sharad jain *Sent:* Jan/Wed/2012 11:52 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Prices from NSE

$$Excel-Macros$$ Prices from NSE website

Hi, Is there any way to extract current / closing price of a particular share from NSE website in an excel sheet? Thanks, Sharad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ PDF to Excel

Hi All, I have PDF containing record of more 200 companies and running into 35 pages into the form of table. I am using the free version of PDF. Is there any way that I can import the table into excel. Thanks, Sharad -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise,

$$Excel-Macros$$ How to remove page 1

Hi Experts, Is there an option to remove the page no in background when a section in a sheet is viewed in Page Break Preview? Thanks in advance. Best, Sharad -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ How to remove page 1

:11 PM, sharad jain jainshar...@gmail.comwrote: Hi Experts, Is there an option to remove the page no in background when a section in a sheet is viewed in Page Break Preview? Thanks in advance. Best, Sharad -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ I want customised web query in excel

Thanks Ashish, But the file only gets the data from 10-Jun-2010 to 19-Oct-2010. Also can you please let me know how create this type of macro? Thanks, Sharad On Wed, Jun 22, 2011 at 7:18 PM, ashish koul koul.ash...@gmail.com wrote: try this On Wed, Jun 22, 2011 at 5:59 PM, Ketan

Re: $$Excel-Macros$$ I want customised web query in excel

I have alread tried that. I have put date range as 1-Jun-2010 to 21-Jun-2011. On Wed, Jun 22, 2011 at 9:17 PM, ashish koul koul.ash...@gmail.com wrote: chage the date in cell d2 and f2 and client in b2 and then run the macro On Wed, Jun 22, 2011 at 7:35 PM, sharad jain jainshar