Hi Iqbal,
If your data is scattered, then a macro wld be useful in this task.
Sub delrow()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Cells(1, 1).Select
For a = 1 To 65536
Selection.EntireRow.Select
If Application.WorksheetFunction.CountA(Selection) < 1 Then
Selection.Ent
I am trying to create 3 columns for an ongoing monthly master
spreadsheet. The data includes: Product Name (highest level of info),
Product Item # (essentially, a part #), and Product Description.
Currently the list is 193 records long.
I'd like for the first column (Product Name) to be a pick li
Dave
In general I agree with you. The algorithms can be copied. The catch
here is that only parties that would be interested in my algorithms
are large insurance carriers with deep pockets. Concurrent with
writing this program, I'm also serving as an expert witness for a very
large insurance compa
Hi,Too little information to answer your question properly, but maybe you an
make use of the attached.Regards from Brasil - Dave.
From: nandkumar.hindust...@gmail.com
Date: Mon, 14 Jun 2010 10:21:42 +0530
Subject: $$Excel-Macros$$ Insurance Calculation sheet
To: excel-macros@googlegroups.com
De
Hi Michael,If you want to stop people copying your algorithms, then Excel is
not the platform to use. Its security is about as good as wet tissue paper;
Excel 2007 being slightly better, as good as dry tissue paper.The advantage of
using Excel is that you can design a workbook that meets very s
Kavita,
Thank you. I have been using this book as a coaster: "Excel 2007 VBA
for Dummies"...looks like I'm going to have to read it now. I think
I'm going to need more coffee.
Michael Hayes
On Jun 13, 11:50 pm, kavita ahuja wrote:
> Hi Michael,
>
> You can us userforms in excel VBA to show the
Please advise. I still cannot see an option to attach a file.
If no reply I will upload to another site and link..
On Jun 8, 9:16 pm, Harpreet Singh Gujral
wrote:
> Jason,
>
> There can be a way to automate end-to-end, of what the employees are
> doing or may be to some extent atleast
>
> Can yo
Hi
Thanks for sending Excel formula
Can you explain me how to display "formula" n yellow box as u done in this
sheet?
Regards
Nikhil Shah
On Mon, Jun 14, 2010 at 12:04 PM, vidyut more wrote:
> hi
> it can be done by using sumif and counif formula.plz see attchment
>
> --
>
> ---
to display "formula" just go Data -Validation- Input Message-Enter
what you want to display below input message.
On Mon, Jun 14, 2010 at 2:29 PM, Dharmesh Shah wrote:
> Hi
>
> how to display "formula" n yellow box as u done in this sheet?
>
> Dharmesh Shah
>
> On Mon, Jun 14, 2010 at 12:04 PM, v
sorry i cant get your meaning
On Mon, Jun 14, 2010 at 2:29 PM, Dharmesh Shah wrote:
> Hi
>
> how to display "formula" n yellow box as u done in this sheet?
>
> Dharmesh Shah
>
> On Mon, Jun 14, 2010 at 12:04 PM, vidyut more wrote:
>>
>> hi
>> it can be done by using sumif and counif formula.plz
Hi
how to display "formula" n yellow box as u done in this sheet?
Dharmesh Shah
On Mon, Jun 14, 2010 at 12:04 PM, vidyut more wrote:
> hi
> it can be done by using sumif and counif formula.plz see attchment
>
> --
>
>
Dear Nandkumar,
You have given specification for Model Year and what about the
specifications for I.D.V, i mean on what basis you want to make it.
Say for model year you have given like 2003 & below 1.342%, 2004 - 2005
1.310% ...
In the same way give for I.D.V
More over
Hi Michael,
You can us userforms in excel VBA to show the notice and you can put a
button on the userform and if the user clicks on the button, then only the
spreadsheet will be displayed
Regards
Kavita
On Mon, Jun 14, 2010 at 2:18 AM, Michael Hayes wrote:
> Good Afternoon to all,
>
> I'm devel
On 10 Jun.schouw wrote:
> How do I define and implement an interface in VBA?
>
> I would like to keep the implementation flexible but the interface
> should stay stable.
See http://msdn.microsoft.com/en-us/library/aa165323(v=office.10).aspx.
I've never checked out this feature of VBA, but it will
hi
it can be done by using sumif and counif formula.plz see attchment
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Linke
Dear Gurus,
Find the enclosed sheet in which the calculation of insurance could be
possible by only entering the vehicle model year & its IDV.
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTE
Hi Saurabh,
Thank you for your time and efforts..Yeah, it will suffice for the time
being..thanks again
Steve
On Fri, Jun 11, 2010 at 2:04 PM, Saurabh Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Is the attached resolution you want?
>
>
>
> *Regards,
> Saurabh Patel *
>
>
>
17 matches
Mail list logo
