Dear Ravinder
Actually I want Previous balance Quantity of A ( 5 unit) in cell H23 to add
this 5 Quantity in next cell F27 Same Name A means total Received
Quantity+Previous balance Quantity of A (Answer is 2+5=7) like this
next...
Regards
Amar
On Sat, Oct 5, 2013 at 2:48 PM, Ravinder
thank you so much Ravinder.
Regards,
Waseem Saifi
On Mon, Oct 7, 2013 at 10:25 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi
*Sent:* Saturday, October 05, 2013 10:02
Dear De Premor,
Sorry for the late reply. Your code is running perfectly.
Thanks for the code.
On 5 October 2013 18:22, De Premor d...@premor.net wrote:
try this
Sub xcv()
Dim Data As Range, Rng As Range
Set Data = Range(A6)
Set Data = Range(Data,
Dear Experts
** **
I need a help to validate the formula/ function given in the column “E”
** **
The bonus offer is valid upto 7th October 2013function should not
execute the bonus offer if the system date as after 8th October 2013
** **
DATE
7/10/2013
*Product
U want this in which event like when u change value of sheet or do some
calculation or open file or activate sheet or any specific time ?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To:
I think he want to check after data refreshed
*/I have a dynamic spreadsheet that monitors different stock prices that
is refreshed ever x amount of minutes./*
On 07-10-2013 16:23, Ravinder wrote:
U want this in which event like when u change value of sheet or do
some calculation or open
Ok thanks..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of De Premor
Sent: Monday, October 07, 2013 2:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Email Trigger ?
I think he want to check after data refreshed
I have a
Do u have any sample data, then plz provide
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Monday, October 07, 2013 2:59 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Email Trigger ?
Hi,
I am using Excel 2007 and have Gmail as my primary email account.
Dear Experts
Pls anybody guide me on this issue
Regards
Amar
On Mon, Oct 7, 2013 at 11:35 AM, amar takale amartak...@gmail.com wrote:
Dear Ravinder
Actually I want Previous balance Quantity of A ( 5 unit) in cell H23 to
add this 5 Quantity in next cell F27 Same Name A means total Received
=IF(TODAY()$F$3,,IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)
*H6)),,(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Grkrishna Naidu
Sent: Monday, October 07, 2013 1:32 PM
To:
Amar,
You want to add the Balance Qty with your Received Qty (ie in Cell F7) But
where you key-in (on which cell) your second receipt for A??
Regards
Rs.
--
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
Thanks a lot
GRKRISHNA
On Mon, Oct 7, 2013 at 5:02 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
=IF(TODAY()$F$3,,IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6)),,(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6
** **
*From:* excel-macros@googlegroups.com
Dear group any update. please help me out
thanks
On Sunday, 6 October 2013 18:11:35 UTC+5:30, renuka chari wrote:
Dear Group
Please help me this problem for multi sheets select with in the single
click
As per the requirement
Thank
*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
'hi, below option of sending email ( gmail ) without Outlook with SMTP
server
Sub SendEmail()
' Enable Reference Object Microsoft CDO for Windows 2000 Library
Dim iMsg, iConf, Flds, nTo, nFr, rng, psw
nTo = your email address here
nFr = nTo
rng = Range(a1).Value
psw = your email password here
Hi renuka, try to put this code on button1 on click event
Private Sub CommandButton1_Click()
Dim i As Integer, Str As String
For i = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(i) Then Str = Str IIf(Len(Str) 0, |,
) ListBox1.List(i)
Next
Sheets(Split(Str,
Correct !
On Monday, 7 October 2013 05:24:42 UTC-4, De Premor wrote:
I think he want to check after data refreshed
*I have a dynamic spreadsheet that monitors different stock prices
that is refreshed ever x amount of minutes.*
On 07-10-2013 16:23, Ravinder wrote:
U want this in
HI Besole,
I am impressed with your code. I will be really impressed once it works !
I read up a bit on the Enable Reference Object Microsoft CDO for Windows
2000 Library.
Sorry, but I am lost on this one and need guidence.
I have put my email address and password where indicated and I left
18 matches
Mail list logo