$$Excel-Macros$$ Insertion of calculation column in Pivot

Hi Team, Today i am tucked in a problem related to pivot. I have a pivot table in which i have some calculation outside of pivot and thats the only porblem. That calculation should be part of pivot table only not a outside calculations. Hope it is clear please revert if my problem in not underst

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi Excel Racers, I am working in MNC as Sr. MIS Executive for Reporting & Analytics. I used this forum for learning new excel things I visit daily this forum to learn one new thing daily and this forum help me alot in this. In my free time i do R&D in excel Thanks, Tarun Verma On Saturday, J

$$Excel-Macros$$ Pick from drop down list disable on moust right click

Hi All, I want to disable the "Pick from Drop-down list" option on mouse right click. [image: Inline image 1] -- Thanks Kartik -- 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$$ How to highlight duplicate data

Dear Ashish Sir, It working fine. Thank you Sir. You are Amazing. Thanks & Regards Ashu Kenith On Thu, Nov 6, 2014 at 9:28 PM, Ashish Kumar wrote: > Hi Ashu, > > Check this. > > 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,

Re: $$Excel-Macros$$ How to change texts into numbers by macro

Hi I see there is a space between number and "Kč" so use " Kč" instead. Cheers !! On Nov 7, 2014 8:15 PM, "ivavok" wrote: > Hi, > > I would appreciate if you could help me with this macro: > > *Columns("C:C").Select* > *Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _* > *

$$Excel-Macros$$ How to change texts into numbers by macro

Hi, I would appreciate if you could help me with this macro: *Columns("C:C").Select* *Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _* * SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _* * ReplaceFormat:=False* *Selection.Replace What:=" ", Replac

$$Excel-Macros$$ Re: Need to generate a query form to retrieve the required data by entering only personal ID out of many records stored in a sheet as raw data

Dear Experts! I am still waiting for solution, Plz help me to solve my problem. Thanks M. Rafique -- 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

$$Excel-Macros$$ Re: How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

Hi Dear Excel Experts! I am still looking for solution, plz help me to get me out of problem. Thanks in advance On Tuesday, November 4, 2014 4:20:20 PM UTC+5, MRafique Ujjan wrote: > > Dear Excel Experts! > > Hi, > > Once again I need your help regarding subject matter, mentioned above. I > n

$$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

Hello Ayush Jain, When using this macro. got some error in VBA script as below mentioned screen shot. Kindly solve this issues. Regards, Sampath.S On Saturday, February 19, 2011 1:04:46 PM UTC+5:30, Ayush Jain wrote: > > Hi Rashid, > > You can find the macro at the link below : > http://q