$$Excel-Macros$$ Break Internal Links with in a Workbook-Excel

2014-05-22 Thread Sandeep Kumar Chhajer
Dear Excel Gurus, I have a workbook with multiple Tabs which are interlinked. I want to break all the link at once. Is it possible with any shortcut / key stroke or Tricks ? Please help me out. Thanks in advance. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) f

Re: $$Excel-Macros$$ Complex cell formulas

2014-05-22 Thread Bill Roberts
Paul, I attempted to do that but could never get it to work correctly. I constantly received errors. I wanted some input from someone to see what I might be doing wrong. Any help would be appreciated. On Thursday, May 22, 2014 1:34:45 PM UTC-4, Paul Schreiner wrote: > > I must be missing someth

Re: $$Excel-Macros$$ Complex cell formulas

2014-05-22 Thread Paul Schreiner
I must be missing something. This looks to be a simple VLookup function.   You have a sheet that has a list of department/GL codes. when you enter the department number, use a VLookup() function to retrieve the GL Account number.   what is the issue? what am I missing?  Paul -

Re: $$Excel-Macros$$ Website data update in excel (www.nseindia.com)

2014-05-22 Thread amar takale
Ok Thanks very much Vabs Bro... & sorry for more disturb On Thu, May 22, 2014 at 7:09 PM, Vaibhav Joshi wrote: > give this last try.. > > > On Thu, May 22, 2014 at 6:54 PM, amar takale wrote: >> >> vabs bro...you check file with updated total 50 stocks in excel if yes >> the send me that file.H

Re: $$Excel-Macros$$ Website data update in excel (www.nseindia.com)

2014-05-22 Thread amar takale
vabs bro...you check file with updated total 50 stocks in excel if yes the send me that file.Here are not updated sheet with total 50 stocks .I think it is not slow net connection. On Thu, May 22, 2014 at 5:40 PM, Vaibhav Joshi wrote: > then this you are getting less name because of slow net conn

Re: $$Excel-Macros$$ Website data update in excel (www.nseindia.com)

2014-05-22 Thread Vaibhav Joshi
then this you are getting less name because of slow net connection data is picked up too early. Change line in Macro for pausing code for more time & it will work... Cheers!! On Thu, May 22, 2014 at 5:23 PM, amar takale wrote: > Dear Vabs > > In link there are total 50 stocks So i want to sho

Re: $$Excel-Macros$$ Website data update in excel (www.nseindia.com)

2014-05-22 Thread amar takale
Dear Vabs In link there are total 50 stocks So i want to shown 50 stock also in excel Regards Amar On Thu, May 22, 2014 at 5:00 PM, Vaibhav Joshi wrote: > How many stock is appearing when you open link in browser manually. > > > On Thu, May 22, 2014 at 4:33 PM, amar takale wrote: >> >> Dear Va

Re: $$Excel-Macros$$ Website data update in excel (www.nseindia.com)

2014-05-22 Thread Vaibhav Joshi
How many stock is appearing when you open link in browser manually. On Thu, May 22, 2014 at 4:33 PM, amar takale wrote: > Dear Vabs > > But there are only 32 stock show in excel, I want to show all 50 stock > show in excel & update with market price whenever click on button > > Regards > Amar >

Re: $$Excel-Macros$$ Moving Row Data to the Left Forcing Blank Cells to the Right

2014-05-22 Thread JohnA
Paul, Absolutely PERFECT! Thank you so very much. I will analyze every line of code to learn, but it worked just as I needed. Thank you again. John On Wednesday, May 21, 2014 2:10:55 PM UTC-4, Paul Schreiner wrote: > This macro seems to work with the sample data: > > Option Explicit

Re: $$Excel-Macros$$ Website data update in excel (www.nseindia.com)

2014-05-22 Thread amar takale
Dear Vabs But there are only 32 stock show in excel, I want to show all 50 stock show in excel & update with market price whenever click on button Regards Amar On Wed, May 21, 2014 at 7:24 PM, Vaibhav Joshi wrote: > Hi > > Delete all contents & try this.. > > Cheers!! > > > On Wed, May 21, 2014