Oh that's great... thank you very much
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: Monday, August 29, 2011 04:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$E
Dear Anil,
Please follow very useful below link to convert Ms Word in Ms Excel.
http://www.ehow.com/how_4899431_convert-word-files-excel-files.html
On Mon, Aug 29, 2011 at 9:46 AM, anil kumar wrote:
> Hi friends,
>
>
> I want to know that how to change msword file into excel plz reply
> ver
Hi friends,
I want to know that how to change msword file into excel plz reply verey
urgent.
Thanks & Regards
Anil
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
I think you could insert a new column A and use 1,2,3.1000 to label rows
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Sunday, August 28, 2011 7:18 PM
Subject: Re: $$Excel-Macros$$ VLOOKUP or Similiar
Dear Cab,
If possible please provide a sample sheet..
On Mon, Aug 29, 2
Hi Noorain
I have tried it using normal vlookup and it works great.I thought that
in the column that the number is searched in had to be a column with no
blanks. I had not tried when I sent email. Have tried now and it is ok.
Apologies for taking up your time.
Regards
Charlie
On Mon, Aug
Dear Cab,
If possible please provide a sample sheet..
On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose wrote:
> Hi
>
>
> I have a list of data 5 columns 1000 rows. There are some blank rows in
> this list. Sometimes one sometimes several. I do not want to delete the
> rows.
> I want a vlookup functi
Dear Anil,
Benefit of Array Function.
If you've done even a little programming, you've probably run across the
term *array*. For our purposes, an array is just a collection of items. In
Excel, those items can reside in a single row (called a* one-dimensional
horizontal* array), a
Hi
I have a list of data 5 columns 1000 rows. There are some blank rows in this
list. Sometimes one sometimes several. I do not want to delete the rows.
I want a vlookup function or similiar, to lookup column A for the required
number and copy into normal cell where formula is. That is: just a n
I didn't test the other code but you may want to try this simple version.
Put in sheet module & modify to suit your range and top row
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Range("sortarea").Sort Key1:=Cells(2, ActiveCell.Column),
Order1:=xlAscendin
Hey Jocky,
please find the attachment.
On Sun, Aug 28, 2011 at 7:08 PM, jocky Beta wrote:
> Hi,
>
> Can you create same for me?
>
> The Formula is given below.
>
>*FORMULA - A = P* (1 + r/12)12
>
>*P* is the principal (the initial amount you borrow or deposit) - *
>
well done rajan
On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote:
> Hi Group,
>
> Refer the attached sheet with some Data Sorting Example. Hope you will like
> it
>
> ** **
>
> Rajan.
>
> ** **
>
> --
>
> -
Wow .you guys are great!!!
I've stumbled upon a sorting code at :
www.clearlyandsimply.com/clearly_and_simply/2011/05/sort-excel-tables-by-double-clicking.html
Here is the code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Dim rngTable As Range
Dim rngActi
hey Zafar,
i think there is 5 condition...
1st if result is 1
2nd if result is 2
3rd if result is 3
4th if result is 0
and 5 is if On Leave
if is it ok then give the confirmation, then i start the work
On Sat, Aug 27, 2011 at 12:59 PM, Zafar Iqbal wrote:
> Dear Expert,
>
> Ref your instr
Also I wanted understand, the benefit of Array in excel.
Based on your example, I got the idea on how to use this??? But what if I use 3
Vlookup or 1 Array is that making significant change or what is the benefit of
it,
The drawback which I could see here of Array is "We can't change the formul
Hi,
Can you create same for me?
The Formula is given below.
*FORMULA - A = P* (1 + r/12)12
*P* is the principal (the initial amount you borrow or deposit) - *TextBox1*
*r* is the annual rate of interest (percentage) - *TextBox2*
*n* is the number of years the amount is deposited or b
Your Worksheet Doesnt have any Code to Calculate on Click.
On Sun, Aug 28, 2011 at 12:20 PM, jocky Beta wrote:
>
> Hi Team,
>
>I had create Compound Calculator in Excel VB sheet , i had already set
> the Formula in VB but when i Click on the Calculate Button it shows error,
> hence i request
16 matches
Mail list logo
