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

2014-11-07 Thread Sampath Kumar
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 :

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

2014-11-07 Thread MRafique Ujjan
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 need

$$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

2014-11-07 Thread MRafique Ujjan
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

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

2014-11-07 Thread ivavok
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:= ,

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

2014-11-07 Thread Vaibhav Joshi
Hi I see there is a space between number and Kč so use Kč instead. Cheers !! On Nov 7, 2014 8:15 PM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hi, I would appreciate if you could help me with this macro: *Columns(C:C).Select* *Selection.Replace What:=Kč, Replacement:=,

Re: $$Excel-Macros$$ How to highlight duplicate data

2014-11-07 Thread Ashu k
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 kumar.ashish...@gmail.com 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

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

2014-11-07 Thread Kartik Dale
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 @

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

2014-11-07 Thread Tarun Verma
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 RD in excel Thanks, Tarun Verma On Saturday,

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

2014-11-07 Thread Tarun Verma
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