$$Excel-Macros$$ Line & Stacked Line

2014-10-30 Thread Chandra Shekar
Hello, What is the difference between Stacked Line with Markers & Stacked line with Markers. Thanks in advance. Regards, Chandru -- 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.faceboo

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-30 Thread Vaibhav Joshi
Cheers Bro.. + *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar wrote: > Hi Vaibhav Bhai, > > It's great.!! > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-30 Thread Ashish Kumar
Hi Vaibhav Bhai, It's great.!! Regards Ashish -- 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 concise, accurate thread titles. Poor th

Re: $$Excel-Macros$$ A simple standard listbox to call subrotines

2014-10-30 Thread luciano de souza
The solution is really very well. Dropdown menus are very accessible for screen readers. I think 90% of problems are solved. Why 90%? Becose sometimes macros are not associated to a specific plan. I have been trying to develop a xlam to make quick some interactions with screen reader. Let me give

Re: $$Excel-Macros$$ Load data's Update using vba

2014-10-30 Thread Laxmanan M
Dear Paul, Yes you are right..You got the point..as im new to this type of formula's..Either it may be a formula or vba...Can you please help to complete this ..Am trying here..but i could not get the click to apply the formula as am knowing little in the vba and formula sections.. Kind Rega

Re: $$Excel-Macros$$ Load data's Update using vba

2014-10-30 Thread Paul Schreiner
OK, so basically, if I went through the list and: a) Combine the ID and Name b) If this combination is "new", add it to a list of unique records c) if this combination already exists, mark the CURRENT and PREVIOUS record of this combination as "FAILED" What do you want to do with the "FAILED" de

Re: $$Excel-Macros$$ Load data's Update using vba

2014-10-30 Thread Laxmanan M
Dear paul, Here is the answer.Please help me on the same.. *Adding additional information:* so basically we should check the column H first. For instance if you found 3 similar match of "1ST MILESTONE LTD", then first you should check if it has id in the column G, if not then "FAILED", if

Re: $$Excel-Macros$$ A simple standard listbox to call subrotines

2014-10-30 Thread Vaibhav Joshi
Hi Luciana, I suggest simple way, using data validation in excel. Goto cell A1, assign data validation to it. By pressing Alt + D then V & then L will invoke data validation menu. Under Setting tab, under Allow select List. Keep Ignore blank & In cell dropdown as checked. Under source type mac

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-30 Thread Vaibhav Joshi
Check this one...its fully automated now, you need to click on button to run macro & select range, rest things will be taken care by VBA. Q- can you please explain that how you did this??? I used IE VBA automation to navigate webpage & fetching data from it using HTML underlying it. Refer this fo

$$Excel-Macros$$ A simple standard listbox to call subrotines

2014-10-30 Thread luciano de souza
Hello all, I want to create several subrotines: macro1, macro2, macro3, macro4... And I want to select one of then in a dialog box. I could add a form and add a combobox to the form. Each item of the combo would be associated to a different subrotine. This could be a solution for most people, but