$$Excel-Macros$$ Introduce Yourself !!

2017-05-18 Thread Michael Vinoth
Hi Friends.. I am Michael Vinoth.. I have 5 years experience in developing the excel vba macros.. I love what I am doing.. Excel is my passion.. I hope I will learn many things from you all and I will share what I know.. Thanks MV VBA Developer -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Re: Help for error :Excel help viewer has encountered a problem cannot continue.

2015-06-11 Thread Michael Vinoth
Hi Rohit, Check this :- http://answers.microsoft.com/en-us/office/forum/office_2010-excel/has-anyone-come-across-an-the-help-viewer-has/45771784-b014-414d-b872-8304e1b99dae Regards, MV On Thursday, June 11, 2015 at 2:41:44 PM UTC+5:30, Rohit Jadhav wrote: Hi I'm not able to access any help

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-15 Thread Michael Vinoth
-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Michael Vinoth *Sent:* Thursday, May 14, 2015 12:31 AM *To:* excel-...@googlegroups.com javascript: *Cc:* polkar...@gmail.com javascript: *Subject:* Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-15 Thread Michael Vinoth
Of *Michael Vinoth *Sent:* Friday, May 15, 2015 6:45 PM *To:* excel-...@googlegroups.com javascript: *Cc:* polkar...@gmail.com javascript: *Subject:* Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require Hi Pankaj Sharma , Thank you for your Appreciation

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-13 Thread Michael Vinoth
Hi Pankaj Sharma , Please find the attached macro file. kindly let me know if you have any queries. Regards, MV On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote: i recd 20-30 Mobile Bills in PDF format every month, which i need to copy in Excel with different sheets.

Re: $$Excel-Macros$$ Re: Send Email to Persons in a column Range

2015-04-24 Thread Michael Vinoth
Welcome... ;-) On Friday, April 24, 2015 at 11:41:22 PM UTC+5:30, hilary lomotey wrote: Solid Boss, thanks exactly what i needed On Thu, Apr 23, 2015 at 9:08 PM, Michael Vinoth michael...@gmail.com javascript: wrote: [image: Boxbe] https://www.boxbe.com/overview This message

$$Excel-Macros$$ Re: Send Email to Persons in a column Range

2015-04-23 Thread Michael Vinoth
Hi Hilary Lomotey, Please find the attached macro file. Kindly let me know if you any queries. Regards, MV On Tuesday, April 21, 2015 at 9:26:43 PM UTC+5:30, hilary lomotey wrote: Hello Experts, i have attached an excel sheet which copies a portion of an excel worksheet and attaches it

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Michael Vinoth
Hi Nasir Saikh, Try this:- https://support.office.com/en-ca/article/Use-a-shared--workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61?ui=en-USrs=en-CAad=CA Regards, MV On 18-Mar-2015, at 3:51 pm, Nasir Saikh nasirsa...@gmail.com wrote: Anybody Can help me out on this On

Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

2015-03-13 Thread michael vinoth
Hi André D'Avila, Please try this formula =INDEX(C2:I2,MATCH(1,INDEX(ISNUMBER(C2:I2)+0,0),0)) in cell J2 and also find the attached file. Regards, MV On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila andredavila...@gmail.com wrote: Dear experts, I can't figure out how to create a fórmula to

$$Excel-Macros$$ Re: Sum value of closing balance of date

2015-03-12 Thread Michael Vinoth
Hi Ashish, Please find the attached macro file. Regards, MV On Thursday, March 12, 2015 at 3:34:33 PM UTC+5:30, Ashish_Bhalara wrote: Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara 9624111822

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-11 Thread Michael Vinoth
Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9, you will get result in curly bracket, after = sign enter CONCATENATE( press enter to get result

$$Excel-Macros$$ Re: Excel VBA Example

2015-03-09 Thread michael vinoth
Nice.. Nikanth Raval... On Tuesday, March 3, 2015 at 8:03:45 AM UTC+5:30, Nilkanth Raval wrote: Hi Friends, Find attached some examples of VBA Macro *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE

Re: $$Excel-Macros$$ Shape Colors (VBA)

2015-03-09 Thread michael vinoth
Hi Smith, Can you send the model of excel file for more clarity. Regards, MV On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith iain.nata...@gmail.com wrote: Hi. If anyone can assist. I have a map of the world in individual shapes per country, each named. I have a sales spreadsheet which, through

$$Excel-Macros$$ Re: PLS SOLVE

2015-03-09 Thread michael vinoth
Hi David, Please find the attached macro file. Regards, MV On Monday, March 9, 2015 at 10:05:03 AM UTC+5:30, sush@gmail.com wrote: -- 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 @

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread michael vinoth
the macro. Have a nice day. Regards, MV On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find

$$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

2015-03-01 Thread michael vinoth
Hi Ashish, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 5:04:35 PM UTC+5:30, Ashish_Bhalara wrote: Dear expert, I need help in attached file in which if cheque amount is greater than zero and date cheque number field Blank then msgbox should display,

$$Excel-Macros$$ Re: Help Needed

2015-03-01 Thread michael vinoth
Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

2015-02-26 Thread michael vinoth
Thankl You Vabz... :) On Thursday, February 26, 2015 at 10:59:17 AM UTC+5:30, Vabz wrote: This is superb MV Cheers!! On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth michael...@gmail.com javascript: wrote: Hi Sal Sal , Please find the attached updated macro file. Regards, MV

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

2015-02-26 Thread michael vinoth
Welcome... :) On Thursday, February 26, 2015 at 2:25:08 PM UTC+5:30, Sal Sal wrote: no words! this is exactly wath i need. Tks for all. 2015-02-26 6:28 GMT+01:00 Vaibhav Joshi v...@vabs.in javascript:: This is superb MV Cheers!! On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth michael

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

2015-02-25 Thread michael vinoth
-23 22:36 GMT+01:00 michael vinoth michael...@gmail.com javascript:: *Hi Sal Sal,* Please find the attached macro file. Regards, MV On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote: Possible to show a toltiptext on mouse over on each items of combobox? Note

Re: $$Excel-Macros$$ Re: Removing duplicates within cell

2015-02-25 Thread michael vinoth
Welcome Chandru.. :) On Wednesday, February 25, 2015 at 11:53:57 AM UTC+5:30, Chandru wrote: Hello Michael, Thanks for the solution. Regards, Chandru On Tue, Feb 24, 2015 at 11:35 PM, michael vinoth michael...@gmail.com javascript: wrote: Hi Chandru, Please find the attached

$$Excel-Macros$$ Re: Removing duplicates within cell

2015-02-24 Thread michael vinoth
Hi Chandru, Please find the attached macro files for Removing Duplicates within the cell. Kindly let me know, if you have any queries. Regards, MV On Tuesday, February 24, 2015 at 3:47:00 PM UTC+5:30, Chandru wrote: Hello, How to remove duplicates within a cell using VBA? Please

$$Excel-Macros$$ Re: Export Data on new Sheet with same Id of that column

2015-02-24 Thread michael vinoth
Hi Harpreet Singh, Please find the attached macro file. Regards, MV On Saturday, February 21, 2015 at 1:35:35 PM UTC+5:30, Harpreet Singh wrote: First of all let me tell you all that i am totally new to Excel. I never used it before.. I am in a little trouble, so i need help of your guyz...

$$Excel-Macros$$ Re: mouseover on list of item in combobox

2015-02-23 Thread michael vinoth
*Hi Sal Sal,* Please find the attached macro file. Regards, MV On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote: Possible to show a toltiptext on mouse over on each items of combobox? Note: combobox is on a vba useform -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ Re: how can I color with the help of list I simple want intersection to be color if cell of intersection

2015-02-19 Thread michael vinoth
Thank you... :) On Wednesday, February 18, 2015 at 10:06:47 AM UTC+5:30, Mandeep baluja wrote: awesome looping thanks :) i will apply it on a huge data by changing the parametres. On Tuesday, 17 February 2015 16:10:37 UTC+5:30, Mandeep Baluja wrote: help required !! -- Are you

$$Excel-Macros$$ Re: how can I color with the help of list I simple want intersection to be color if cell of intersection

2015-02-17 Thread michael vinoth
Hi Mandeep, Please find the attached macro file. kindly check and let me know, if you have any questions or queries. Regards, MV On Tuesday, February 17, 2015 at 4:10:37 PM UTC+5:30, Mandeep Baluja wrote: help required !! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Re: Want to disable copy, cut paste

2015-02-17 Thread michael vinoth
Welcome Abdulgani... On Saturday, February 14, 2015 at 9:54:44 AM UTC+5:30, ITP Abdulgani wrote: Thanks Michael, I will go through it and will update. On Sat, Feb 14, 2015 at 1:38 AM, michael vinoth michael...@gmail.com javascript: wrote: Hi Abdulgani, Please check this.. http

$$Excel-Macros$$ Re: Want to disable copy, cut paste

2015-02-13 Thread michael vinoth
Hi Abdulgani, Please check this.. http://www.asap-utilities.com/excel-tips-detail.php?categorie=9m=85 On Friday, February 13, 2015 at 11:51:05 AM UTC+5:30, ITP Abdulgani wrote: I want to disable copy, cut paste in the attached file. And I also request If Copy, cut paste is disable

$$Excel-Macros$$ Re: Run time error...

2015-02-10 Thread michael vinoth
Welcome Christos... On Tuesday, February 10, 2015 at 4:52:30 PM UTC+5:30, Christos Alekopoulos wrote: Hi Michael, That works perfect thank you!!! Cheers, Christos -- 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

$$Excel-Macros$$ Re: Run time error...

2015-02-09 Thread michael vinoth
Hi Christos, Try this code... Sub Button1_Click() Dim WS As Worksheet Dim Search As String Dim Replacement As String Dim Prompt As String Dim Title As String Dim ID As String Dim mu As String Dim temp As Long Dim R As Long Dim C As Long Dim MatchCase As Boolean Prompt = What is the risk ID?

Re: $$Excel-Macros$$ MOS Certificate Query

2015-02-06 Thread michael vinoth
Thank You Ashish.. On Thursday, February 5, 2015 at 8:34:27 PM UTC+5:30, Ashish Kumar wrote: HI MV, Check this : http://education-portal.com/microsoft_office_specialist_certification_online.html Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ MOS Certificate Query

2015-02-05 Thread michael vinoth
Hi All, I would like to go for a MOS Certificate in excel 2007. I need some support for the following queries. how to approach on this exam? What would be the syllabus? Is there any fees details available? Please share your thoughts and comments. Wish you all a Great day. Thank you MV --

$$Excel-Macros$$ Re: How to convert PDF file to Excel file using excel vba?

2015-02-05 Thread michael vinoth
Thank u... Paul... Vabz... On Thursday, February 5, 2015 at 1:25:18 AM UTC+5:30, michael vinoth wrote: Dear All, I have a doubt. How to convert PDF file to Excel file using excel vba? It is very useful to me. Thanks in advance... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

$$Excel-Macros$$ How to convert PDF file to Excel file using excel vba?

2015-02-04 Thread michael vinoth
Dear All, I have a doubt. How to convert PDF file to Excel file using excel vba? It is very useful to me. Thanks in advance... -- 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 @

Re: $$Excel-Macros$$ need help with looping a find - cut - paste macro Excel 2013

2015-02-04 Thread michael vinoth
Hi, Sub CommandButton_Click() Dim i As Long For i = 1 To Range(K65000).End(xlUp).Row If Trim(Range(K i).Text) = Empty Then Range(L i).Cut Range(P i).Select ActiveSheet.Paste End If Next I End Sub On Saturday, January 10, 2015 at 2:00:54 PM UTC+5:30, Vabz