Re: $$Excel-Macros$$ Substitute a value of a cell in to a cell reference of a vba code

2012-09-20 Thread Dilan De Silva
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

$$Excel-Macros$$ Substitute a value of a cell in to a cell reference of a vba code

2012-09-19 Thread Dilan De Silva
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

Re: $$Excel-Macros$$ Substitute a value of a cell in to a cell reference of a vba code

2012-09-19 Thread Dilan De Silva
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

Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

2012-09-01 Thread Dilan De Silva
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

Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

2012-08-30 Thread Dilan De Silva
) 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

Re: $$Excel-Macros$$ Run a Macro in a give time

2012-08-11 Thread Dilan De Silva
, 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

$$Excel-Macros$$ Run a Macro in a give time

2012-08-07 Thread Dilan De Silva
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

Re: $$Excel-Macros$$ Run a Macro in a give time

2012-08-07 Thread Dilan De Silva
*- -- *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

$$Excel-Macros$$ Put items numbers to a BOQ

2012-07-18 Thread Dilan De Silva
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

$$Excel-Macros$$ Macro to calculate amount

2012-04-10 Thread Dilan De Silva
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.

Re: $$Excel-Macros$$ Macro to calculate amount

2012-04-10 Thread Dilan De Silva
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

Re: $$Excel-Macros$$ Macro to calculate amount

2012-04-10 Thread Dilan De Silva
** ** 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

Re: $$Excel-Macros$$ Macro for a BOQ

2011-07-11 Thread Dilan De Silva
) 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

$$Excel-Macros$$ Macro for a BOQ

2011-07-07 Thread Dilan De Silva
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

Re: $$Excel-Macros$$ Excel formula for a BOQ

2011-03-23 Thread Dilan De Silva
+ 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é

$$Excel-Macros$$ Excel formula for a BOQ

2011-03-20 Thread Dilan De Silva
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.