Re: $$Excel-Macros$$ use full link to learn Excel

2013-06-03 Thread Nikhil Shah
Thanks.. Nikhil On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar wrote: > Dear Frndz, > > > Use full link to learn Excel. please find attached link!!! > > > > > http://www.excel-pratique.com/en/index.php > > Thanks > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

Re: $$Excel-Macros$$ Want to add every third row or coloumn!

2013-06-03 Thread NOORAIN ANSARI
Dear Sandeep, Select required range and run this code... Sub InsertSpecificRows() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox("Enter number of rows to insert", "Your Call") If InsQuan <= 0 Then MsgBox "Invalid number entered", vbCritical, "Stop!" Exit Sub End If Application.Scr

Re: $$Excel-Macros$$ Re: Please help Excel Gurus

2013-06-03 Thread Harish P Y
Hi, Thank you very much for replying to my quire y, firstly the amount needs to be calculated for a day and then equally distributed for no of days in that particular month. kindly help me regarding this. regards Harish With Regards *HARISH P Y* *P** **THINK BEFORE YOU PRINT:**Before printing

Re: $$Excel-Macros$$ Marge Data from Different workssheet.

2013-06-03 Thread Vabz
Hi PFA Macro which i have made for users. You can change as per your need. HTH//Vabs On Tuesday, June 4, 2013 9:23:42 AM UTC+5:30, Tariq Aziz wrote: > > Dear Vijy Kumar > > > i already try this add-in but it is not working. > > > Tariq > > > On 3 June 2013 23:48, P.VIJAYKUMAR >wrote: > >> Respe

Re: $$Excel-Macros$$ Want to add every third row or coloumn!

2013-06-03 Thread VBA VABZ
Hi Send sample file for more clarity Thanks On Tue, Jun 4, 2013 at 9:51 AM, wrote: > Dear expert, > Many time I have to add every third or every forth or every second row or > column etc...can you suggest a function which will ease my problem! Till > now I am adding required cell one by one

$$Excel-Macros$$ Re: Please help Excel Gurus

2013-06-03 Thread Vabz
Hi Chek this file. I have changed dates in header to respective month ends since deductions are made at the end of the month. HTH//Vabs On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, Harish P Y wrote: > > Hi Every One, > Please find the attached file, > Kindly help me with the required formula

Re: $$Excel-Macros$$ use full link to learn Excel

2013-06-03 Thread VBA VABZ
Thanks!! On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar wrote: > Dear Frndz, > > > Use full link to learn Excel. please find attached link!!! > > > > > http://www.excel-pratique.com/en/index.php > > Thanks > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

$$Excel-Macros$$ Want to add every third row or coloumn!

2013-06-03 Thread chhajersandeep
Dear expert, Many time I have to add every third or every forth or every second row or column etc...can you suggest a function which will ease my problem! Till now I am adding required cell one by one! Kindly help! Sandeep Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NO

Re: $$Excel-Macros$$ Marge Data from Different workssheet.

2013-06-03 Thread Tariq Aziz
Dear Vijy Kumar i already try this add-in but it is not working. Tariq On 3 June 2013 23:48, P.VIJAYKUMAR wrote: > Respected Tariq , > > You can download the add-in from the following link : > http://www.rondebruin.nl/win/addins/rdbmerge.htm or please find the > attachment. > > Regards, >

$$Excel-Macros$$ Please help Excel Gurus

2013-06-03 Thread Harish P Y
Hi Every One, Please find the attached file, Kindly help me with the required formula In the file there is a table, with start date end date amount and corresponding months in rows i want a formula to distribute the amount month wise by referring to start date and end date Kindly help me regardin

$$Excel-Macros$$ Know cell.address for a clicked hyperlink

2013-06-03 Thread Kim Sig Andersen
Hi When clicking a hyperlink, I want to know the address for the cell that holds the hyperlink (internal to another sheet in the workbook)? When using the follow_hyperlink event I can get the address for followed link, but not the address from which I jumped. Regards¨ Kim -- Are you =EXP(E

$$Excel-Macros$$ use full link to learn Excel

2013-06-03 Thread Ashish Kumar
Dear Frndz, Use full link to learn Excel. please find attached link!!! http://www.excel-pratique.com/en/index.php Thanks 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.f

$$Excel-Macros$$ Marge Data from Different workssheet.

2013-06-03 Thread Tariq Aziz
Dear Experts I need your help. I want to marge data from different worksheets. All worksheets have same colom names but data are different. I need add-in for that. If it is possible i need like : 1. when we run this add-in on screen one window will appear and in this window the system will a

Re: $$Excel-Macros$$ Macro to take Itens from Inventory sheet that don't exist in Sheet Raw Data - my code gives error

2013-06-03 Thread Jorge Marques
Perfect Ashish, thank you very much :). On 30 May 2013 17:55, ashish koul wrote: > see if it helps > > Sub incluvazios() > > Dim i As Long > > For i = 2 To Sheets("Inventory").Range("a65356").End(xlUp).Row > If Application.WorksheetFunction.CountIf(Sheets("Raw > Data").Range("a:a"), Sheets("

Re: $$Excel-Macros$$

2013-06-03 Thread Vikas Bhosale
Thanks thanks. it's work Frnd Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: Prafull Jadhav Sender: excel-macros@googlegroups.com Date: Mon, 3 Jun 2013 11:47:06 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dear Vikas, if the