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,
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
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 that I can
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
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 yahya...@gmail.com 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 can
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.
what u want to find .. hours , or minutes ,
On Mon, Jan 7, 2013 at 7:50 PM, Nitesh Sharma
nitesh.sharma2...@gmail.comwrote:
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
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
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 koul.ash...@gmail.com 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,
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
--
*http://www.win2job.info/* 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 Advice
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
FORUM
Hi Manjunath,
Here is the some stuffs that i refer some times. These are some standard
books that help you a lot .
Excel 200 http://www.excelforum.com/#7 Power Programming with VBA, by
John Walkenbach
VBA and Macros for Microsoft Excel http://www.excelforum.com/#, by Bill
Jelen Mr.Excel and
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 comment
_*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 at
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 of
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
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
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 gjmothi...@gmail.com wrote:
dear any one
how to convert to excel 2007 to dbf files.
Thanks with
--
*J.Mothilal : **Universal
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 @
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
-- Forwarded message --
From: Hari harisha.prabha...@gmail.com
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
-- Forwarded message --
From: Hari harisha.prabha...@gmail.com
Date: 8 January 2013 11:43
Subject: Fwd: Interest formulae
To: excel-macros@googlegroups.com
-- Forwarded message --
From: Hari harisha.prabha...@gmail.com
Date: 8 January 2013 11:42
Subject:
Hi Prabhakar,
Here is the some stuffs that i refer some times. These are some standard
books that help you a lot .
Excel 200 http://www.excelforum.com/#7 Power Programming with VBA, by
John Walkenbach
VBA and Macros for Microsoft Excel http://www.excelforum.com/#, by Bill
Jelen Mr.Excel and
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-2*
Thanks Raja sekar
On Tue, Jan 8, 2013 at 11:24 AM, RAJA SEKAR apkra...@gmail.com 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 gjmothi...@gmail.com wrote:
dear any one
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)
http://en.kioskea.net/download/download-5751-xls-excel-to-dbf-converter
On Tue, Jan 8, 2013 at 12:49 PM, Asa Rossoff a...@lovetour.info 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
use ((amount* int/100)/365) * no of days
On Tue, Jan 8, 2013 at 11:43 AM, Hari harisha.prabha...@gmail.com wrote:
-- Forwarded message --
From: Hari harisha.prabha...@gmail.com
Date: 8 January 2013 11:43
Subject: Fwd: Interest formulae
To: excel-macros@googlegroups.com
29 matches
Mail list logo