Re: $$Excel-Macros$$ Interest formulae

use ((amount* int/100)/365) * no of days On Tue, Jan 8, 2013 at 11:43 AM, Hari wrote: > > > -- Forwarded message -- > From: Hari > Date: 8 January 2013 11:43 > Subject: Fwd: Interest formulae > To: excel-macros@googlegroups.com > > > > > > -- Forwarded message --

Re: $$Excel-Macros$$ Re: dbf conversions

http://en.kioskea.net/download/download-5751-xls-excel-to-dbf-converter On Tue, Jan 8, 2013 at 12:49 PM, Asa Rossoff wrote: > Excel 2007+ can import DBF files, but not save to them. Excel 2003 and > prior allow saving as Dbase (DBF) files. > > ** ** > > A few alternsatives for saving/expor

RE: $$Excel-Macros$$ Re: dbf conversions

Excel 2007+ can import DBF files, but not save to them. Excel 2003 and prior allow saving as Dbase (DBF) files. A few alternsatives for saving/exporting to DBase DBF files: .Excel 2003 and prior versions .LibreOffice https://www.libreoffice.org (open source office suite) supp

Re: $$Excel-Macros$$ dbf conversions

Thanks Raja sekar On Tue, Jan 8, 2013 at 11:24 AM, RAJA SEKAR wrote: > Hi, > > You have to use Excel 2003 to convert excel into dbf... Excel 2007 doesnt > having option to export excel into DBF > > > > On 8 January 2013 10:52, jmothilal wrote: > >> dear any one >> >> how to convert to excel 2

$$Excel-Macros$$ Re: dbf conversions

i dont feel it is actually happen. Regards Prince On Tuesday, January 8, 2013 10:52:09 AM UTC+5:30, mothi wrote: > > dear any one > > how to convert to excel 2007 to dbf files. > > Thanks with > > -- > > *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex > :Otteri, Vellore

$$Excel-Macros$$ Re: Want to Learn Macro

Hi Prabhakar, Here is the some stuffs that i refer some times. These are some standard books that help you a lot . Excel 200 7 Power Programming with VBA, by John Walkenbach VBA and Macros for Microsoft Excel , by Bill Jelen "Mr.Excel

$$Excel-Macros$$ Interest formulae

-- Forwarded message -- From: Hari Date: 8 January 2013 11:43 Subject: Fwd: Interest formulae To: excel-macros@googlegroups.com -- Forwarded message -- From: Hari Date: 8 January 2013 11:42 Subject: Interest formulae To: excel-macros@googlegroups.com Dear exc

$$Excel-Macros$$ Fwd: Interest formulae

-- Forwarded message -- From: Hari Date: 8 January 2013 11:42 Subject: Interest formulae To: excel-macros@googlegroups.com Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical functio

$$Excel-Macros$$ Interest formulae

Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Yours, Hari. -- Join official Facebook pag

$$Excel-Macros$$ Interest formulae

Dear excel experts, PFA document of FD made with interest compuation made. Provide me interest formulae in the attached sheet with the mathematical function or any macros. Your help will be guide for us to save time. -- Yours, Hari. -- Join official Facebook page of this forum @ https:

Re: $$Excel-Macros$$ dbf conversions

Hi, You have to use Excel 2003 to convert excel into dbf... Excel 2007 doesnt having option to export excel into DBF On 8 January 2013 10:52, jmothilal wrote: > dear any one > > how to convert to excel 2007 to dbf files. > > Thanks with > > -- > > *J.Mothilal : **Universal Computer Systems

$$Excel-Macros$$ Re: Want to Learn Macro

Dear Lalit, Thanks for sharing details. will try to learn from provided materials. Rgds, Prabhakar On Monday, January 7, 2013 3:07:08 PM UTC+5:30, Lalit Mohan Pandey wrote: > Hi Prabhakar, > > Find below mentioned link: > > http://www.dur.ac.uk/resources/its/info/guides/39Excel2003Macros.pdf

$$Excel-Macros$$ dbf conversions

dear any one how to convert to excel 2007 to dbf files. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thre

$$Excel-Macros$$ Re: date time subtraction

hi all thanks for your help!! On Monday, January 7, 2013 8:20:25 AM UTC-6, Nitesh Sharma wrote: > > Hi all, > need your help > > i need a vba code which able to subtract user given DateTime in any > cell(say a1 = 07-01-2012 19:44) with the current system time. > -- Join official Facebook page

Re: $$Excel-Macros$$ Needs excel formula to find the running totals between two dates

_*Compatible, Faster & Shorter Length formula *_*=SUMPRODUCT((A2:A11>=F2)*(A2:A11<= G2),(-B2:B11)+(C2:C11))* On 07-01-2013 9:00 PM, Yahya Muhammad wrote: Thanks Ashish. Is there any way we can combine two SUMPRODUCTS/SUMIFS into one, to reduce the length of formula ? On Mon, Jan 7, 2013

$$Excel-Macros$$ Re: Need a macro to copy cells based upon a values in other cell.

Please check the data ranges you provided and it will not activate the sheet it will run for all sheets in the workbook. On Monday, 7 January 2013 23:43:51 UTC+5:30, Best Of Luck wrote: > > Thank you Lalit, > The macros is running but does not select the activesheet and does not > insert a comme

$$Excel-Macros$$ Re: Need a macro to copy cells based upon a values in other cell.

Thank you Lalit, The macros is running but does not select the activesheet and does not insert a comment in cell that already have a value in the target cell. On Thursday, January 3, 2013 2:53:00 AM UTC-6, Best Of Luck wrote: > hi, > Happy new year, > > I need a macro that would copy cells

Re: $$Excel-Macros$$ Re: Keen to more Learn

Hi Manjunath, Here is the some stuffs that i refer some times. These are some standard books that help you a lot . Excel 200 7 Power Programming with VBA, by John Walkenbach VBA and Macros for Microsoft Excel , by Bill Jelen "Mr.Excel

$$Excel-Macros$$ Re: required formula

Hi Rajesh PFA, Regards Prince On Tuesday, November 20, 2012 9:55:49 PM UTC+5:30, rajeyssh wrote: > > Hello Every one. Please find the attachment. > rgds > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

$$Excel-Macros$$ MRG.COM

*http://www.win2job.info/* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advic

$$Excel-Macros$$ Re: office stationery template

Hi Smitha, PFA, Regards Prince On Sunday, January 6, 2013 9:30:40 AM UTC+5:30, Smitha S R wrote: > > HI, > > Can anyone send some good excel template to maintain the office stationery > items, their consumption, opening stock , closing stock, and reports on > monthly basis and daily basis > -

Re: $$Excel-Macros$$ Needs excel formula to find the running totals between two dates

Thanks Ashish. Is there any way we can combine two SUMPRODUCTS/SUMIFS into one, to reduce the length of formula ? On Mon, Jan 7, 2013 at 4:41 PM, ashish koul wrote: > try this > > =SUMIFS(C:C,A:A,">="&F2,A:A,"<="&G2)-SUMIFS(B:B,A:A,">="&F2,A:A,"<="&G2) > > > > On Mon, Jan 7, 2013 at 7:06 PM, Ya

Re: $$Excel-Macros$$ date time subtraction

It really depends on what you want to do with the result. Keep in mind that to Excel, any "date" is really just a number. That is: The number of days since 1/1/1900. and TIME, is really the fractional part of a day. So, today, January 7, 2013 at 9:45:33am is: 41281.406633680600  You can find the

Re: $$Excel-Macros$$ date time subtraction

what u want to find .. hours , or minutes , On Mon, Jan 7, 2013 at 7:50 PM, Nitesh Sharma wrote: > Hi all, > need your help > > i need a vba code which able to subtract user given DateTime in any > cell(say a1 = 07-01-2012 19:44) with the current system time. > > -- > Join official Facebook pag

$$Excel-Macros$$ date time subtraction

Hi all, need your help i need a vba code which able to subtract user given DateTime in any cell(say a1 = 07-01-2012 19:44) with the current system time. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. P

Re: $$Excel-Macros$$ Needs excel formula to find the running totals between two dates

try this =SUMIFS(C:C,A:A,">="&F2,A:A,"<="&G2)-SUMIFS(B:B,A:A,">="&F2,A:A,"<="&G2) On Mon, Jan 7, 2013 at 7:06 PM, Yahya Muhammad wrote: > > Dear experts > > I have an excel file to track the bank transactions. It has a debit column > for the withdrawals and credit column for the deposits. I c

$$Excel-Macros$$ Needs excel formula to find the running totals between two dates

Dear experts I have an excel file to track the bank transactions. It has a debit column for the withdrawals and credit column for the deposits. I can get the running totals by adding another column and just using simple excel formulae. However, sometimes I want to find the running totals in the ac

Re: $$Excel-Macros$$ Re: Keen to more Learn

try this book *Power Programming* with VBA by *John Walkenbach* * * * * On Mon, Jan 7, 2013 at 4:21 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear All, > > > > I wanna learn more Advance Excel & share the knowledge to others, please > send me the link or PPT, So tha

$$Excel-Macros$$ Re: Keen to more Learn

Dear All, I wanna learn more Advance Excel & share the knowledge to others, please send me the link or PPT, So that I can refer to learn. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated wi

$$Excel-Macros$$ Re: Want to Learn Macro

Hi Prabhakar, Find below mentioned link: http://www.dur.ac.uk/resources/its/info/guides/39Excel2003Macros.pdf http://www.few.vu.nl/~rbekker/VBA-intro.pdf http://www.fontstuff.com/downloads/Excel%20VBA%20Course%20Notes%201%20-%20Macro%20Basics.pdf Regards, Lalit Mohan On Monday, 7 January 2013

$$Excel-Macros$$ Want to Learn Macro

Dear Team, I want to learn how to write macros in excel from the basi. pls help me to learn -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

$$Excel-Macros$$ Re: How to calculate years of completion from Date of Joining in last and upcoming month.

Dear Santhosh, Please Find Attached File, As per your requirement. Please let me know of you have any query. Thanks & regards, Suriyaprakash -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread