you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Dilan De Silva dila
Hi,
Refer attached sheet(format 1). I want to fill the cells in one
column(Basic Salary) depend on cells value of a another column(Status). It
means if cell E1 has “single” then F1 should be 8000 and if cell E1 has
“Married” then F1 should be 11000.( I don’t want to use formulas)
I wrote the
On Wed, Sep 19, 2012 at 12:37 PM, VBA VABZ v...@vabs.in wrote:
Hi
Replace Private with *Public Put code in module to work.*
PFA
Cheers..
Rgds//Vabs
On Wed, Sep 19, 2012 at 2:32 PM, Dilan De Silva dila...@gmail.com wrote:
Hi,
Refer attached sheet(format 1). I want to fill
Developer
SalesAid Software
dguille...@gmail.com
*From:* Dilan De Silva dila...@gmail.com
*Sent:* Thursday, August 30, 2012 8:58 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Macro to Calculate a total upon a
condition
Dear Guillett,
Thank for the solution
)
Loop While Not c Is Nothing And c.Address firstaddress
End If
End With
'MsgBox ms
Cells(cr, g) = ms
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Dilan De Silva dila...@gmail.com
*Sent:* Thursday, August 30, 2012 3:18 AM
,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Dilan De Silva dila...@gmail.com
*To:* excel-macros
Friends,
I want to run a macro* every day in a give time(say 9.00AM)* when the work
book not open. Then open the work book and show a message if the given
conditions(say two cells have same value) fulfil. see the below written
macro for further explanation.
But the given below macro not working at
*-
--
*From:* Dilan De Silva dila...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tue, August 7, 2012 5:42:48 AM
*Subject:* $$Excel-Macros$$ Run a Macro in a give time
Friends,
I want to run a macro* every day in a give time(say 9.00AM)* when
Dear friends,
I'm looking a macro to put items numbers to a BOQ. My requirements as below.
If Quantity =then
Item nr =
Else
For page 1 to last page
Item nr should be a letter (Starting from A on each page and if reached to
Z within a page, next nrs should be AA, AB….).
End
See the
Dear experts,
I need a macro for following requirement.
Please refer the attached Excel sheet. If there is a value in the cell
C5(Quantity), formula of cell F5(Amount) should be =C5*E5 otherwise cell F5
should be blank.
This should be repeat to each row which has value in Column C.
Thank you.
can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Dilan De Silva dila...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tue, April 10, 2012 9:47:29 AM
** **
If you REALLY need a macro, let me know.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Dilan De Silva dila...@gmail.com
*Sent:* Tuesday, April 10, 2012 8:47 AM
*To:* excel-macros@googlegroups.com
*Subject
) Then
Vr = Wksht.Cells(x, 5)
Wksht.Cells(x, 5).Formula = = Trim(Str(Vr)) *$H$1
End If
Next x
End Sub
On Thu, Jul 7, 2011 at 8:07 PM, Dilan De Silva dila...@gmail.com wrote:
Dear Friends,
I have a BOQ(Bills of Quantity) and I need to add a formula to each rate.
The formula should
Dear Friends,
I have a BOQ(Bills of Quantity) and I need to add a formula to each rate.
The formula should be as follow.
=rate*(Constant cell reference)
For an example;
The rate on cell E18 is 250.00 (see attached BOQ)
It should like this after run the macro
'=250*($H$1)
It need to repeat for
+ 1000, 7)).Find(*, ,
xlValues).Row
Cells(c.Row, 7).Formula = Cells(inRow, 7).Formula
Cells(inRow, 7) =
End If
Next c
End Sub
Regards.
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Dilan De Silva
*Envoyé
Dear friends,
Please refer the attached excel sheet.
I want to get the Item nr and relavent percentage in to a one row for each
item.
For example,
Item A and relavent percentage (105%) is in one row, but Item B and
percentage(150%) not in a on row. Then, I want to get the 150% to above row.
16 matches
Mail list logo