$$Excel-Macros$$ Count number of times a part is out of stock without counting all days part is out of stock

[gssstuff]

I have a spreadsheet that has dates across the top row and a list of
items in the first column.  Under each date, if a part had a back-
order, the total quantity appears under the respective date.

What I am trying to do is figure out how many times an item has been
on back-order in the last X days.  I don't want the count of total
days on back-order, that is easy.  What I only want to count is the
first day in a series of consecutive days that the item is on
backorder.

For example, part A has been on backorder for 15 out of the last 30
days.  This could mean it has been on backorder every other day for
the entire 30 day period (15 occurrences)  {scenario 1} or it could
have been in stock for 15 days, and out of stock for 15 consecutive
days (1 occurrence) {scenario 2}.

The example points to the extremes, but the number of occurrences
could fall somewhere in between.

I have the option of changing the layout if it will facilitate the
calculation.  I would also be open to using MSAccess to possibly
perform the operation as well.

I have done some one-time work to achieve results, but I have reached
a point where I need this to be repeatable across a large dataset
(>1 records)

I am pretty well versed in VBA but I cannot get my brain around this
one.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Does anybody have games

[Aindril De]

Try these links

http://www.excelgames.org/
http://www.automateexcel.com/2005/01/13/52_excel_games/

Regards,
Andy

On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram <06n...@gmail.com> wrote:

> Hi All,
>
> Does anybody have games in excel sheet, if so please send me.
>
>
> Thanks,
> Naniram
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Need help in function

[ashish koul]

 Paul  your solution is working fine thanks, i always get to learn something
new from this group

Thanks to all

On Wed, Apr 7, 2010 at 9:07 AM, ashish koul  wrote:

> hi
>
>
> yes to avoid making it text u  an got right click on cell -> format ->
> cutom format -> [mm]
>
>   On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens <
> paul.johan.willek...@gmail.com> wrote:
>
>> Hi Gaurav,
>>
>> Did you try my solution? =(D3 - C3) * 24 * 60
>> What's wrong about that? The result remains numeric, while Ashish's
>> solution becomes text!
>>
>> cu
>>
>> Paul Willekens
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>  To unsubscribe, reply using "remove me" as the subject.
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Need help in function

[ashish koul]

hi


yes to avoid making it text u  an got right click on cell -> format -> cutom
format -> [mm]

On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens <
paul.johan.willek...@gmail.com> wrote:

> Hi Gaurav,
>
> Did you try my solution? =(D3 - C3) * 24 * 60
> What's wrong about that? The result remains numeric, while Ashish's
> solution becomes text!
>
> cu
>
> Paul Willekens
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>  To unsubscribe, reply using "remove me" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Modifying input data

[Harpreet Singh Gujral]

Paul,

This is simply amasing...Thanks a ton

Cheers!!!

Harry

On Apr 6, 10:54 pm, paulwillekens 
wrote:
> Hi Harpreet,
>
> Here it comes... I made a new sheet "test" to test it, but you can
> change that statement in
> cCooked = "MODIFIED DATA"
> after testing, of course.
>
> Feedback is welcome.
>
> Kind regards,
>
> Paul Willekens
> '===
> Sub CookData()
>
> Dim cContent
> Dim cCooked
> Dim cHouse
> Dim cName
> Dim cRaw
> Dim cType
>
> Dim dDate
>
> Dim nEmpty
> Dim nRepurchase
> Dim nRowRaw
> Dim nRowCooked
> Dim nNetValue
> Dim nSales
>
> cRaw = "RAW DATA"
> nRowRaw = 3
> cCooked = "test"
> nRowCooked = 2
>
> Sheets(cRaw).Select
>
> While nEmpty < 3
>   cContent = Trim(Cells(nRowRaw, 1).Value)
>   If Len(cContent) > 0 Then 'not an empty line
>     nEmpty = 0
>     If IsNumeric(cContent) Then 'scheme ID
>       'Scheme Name
>       cName = Cells(nRowRaw, 2)
>       'Net Asset Value
>       nNetValue = Cells(nRowRaw, 3)
>       'Repurchase Price
>       nRepurchase = Cells(nRowRaw, 4)
>       'Sale Price
>       nSales = Cells(nRowRaw, 5)
>       'Date
>       dDate = Cells(nRowRaw, 6)
>       Sheets(cCooked).Select
>       Cells(nRowCooked, 1).Value = cHouse
>       Cells(nRowCooked, 2).Value = cType
>       Cells(nRowCooked, 3).Value = cContent
>       Cells(nRowCooked, 4).Value = cName
>       Cells(nRowCooked, 5).Value = nNetValue
>       Cells(nRowCooked, 6).Value = nRepurchase
>       Cells(nRowCooked, 7).Value = nSales
>       Cells(nRowCooked, 8).Value = dDate
>       nRowCooked = nRowCooked + 1
>       Sheets(cRaw).Select
>     Else 'either a new Mutual Fund House or a new Type
>       If Right(cContent, 1) = ")" Then 'new Type
>         cType = cContent
>         cHouse = ""
>       Else 'new Mutual Fund House
>         cHouse = cContent
>       End If
>     End If
>   Else
>     nEmpty = nEmpty + 1
>   End If
>   nRowRaw = nRowRaw + 1
> Wend
>
> End Sub
> '===

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Need Help to find a date and time calculation

[kishore mohan]

Hi All.,

Need your help with the following macro.. there are Four date and time
columns in the attached spreadsheet. Date A1, Date A2, Date B1 and Date
B2.   The macro I'm looking for should color the entire row if the date and
time range of B1 to B2 falls within (or same as) the date and time range of
A1 to A2. failing which it should color the row red.

Can you guys help me out on this please.. also can you share the code you
are using to get this sorted please..


Many Thanks.,
kishore M I

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Date Range Diff color.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Request Help to make code more efficient.

[seema mba]

HI,
Try out the following:

Sub trial()
Dim rng As Range
 Dim what(9) As String
what(1) = "FD"
what(2) = "EX"
what(3) = "NA"
what(4) = "NB"
what(5) = "NC"
what(6) = "HN"
what(7) = "CLD"
what(8) = "Location"
what(9) = "of"


  For i = 1 To 9
  Do
   Set rng = ActiveSheet.UsedRange.Find(what(i))
   If rng Is Nothing Then
   Exit Do
   Else
   Rows(rng.Row).Delete
   End If
   Loop
   Next i

   End Sub



On 4/6/10, JsinSk  wrote:
>
> Hello all fellow fellow Macro friends :)
>
> I have a short bit of code that I was wondering if it's possible to
> make it run more efficiently. When it runs currently it takes up to 1
> minute which seems like a long time.
>
> Notes: This is designed to remove an entire row if the condition is
> met. There is no *real* set limit on the number of potential rows, but
> in reality it shouldn't exceed 1,500 rows on a bad day. There is more
> code that runs after this but it's basic formatting stuff that dos not
> have a loop function in it.
>
> Regards,
> Jason
>
>
>
> Dim rng As Range
> Dim what As String
> Dim what1 As String
> Dim what2 As String
> Dim what3 As String
> Dim what4 As String
> Dim what5 As String
> Dim what6 As String
> Dim what7 As String
> Dim what8 As String
>
>
> what = "FD"
> what1 = "EX"
> what2 = "NA"
> what3 = "NB"
> what4 = "NC"
> what5 = "HN"
> what6 = "CLD"
> what7 = "Location"
> what8 = "of"
>
>Do
>Set rng = ActiveSheet.UsedRange.Find(what)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
>
>Do
>Set rng = ActiveSheet.UsedRange.Find(what1)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
>
>Do
>Set rng = ActiveSheet.UsedRange.Find(what2)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
>
>Do
>Set rng = ActiveSheet.UsedRange.Find(what3)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
>
>  Do
>Set rng = ActiveSheet.UsedRange.Find(what4)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
>
>  Do
>Set rng = ActiveSheet.UsedRange.Find(what5)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
> Do
>Set rng = ActiveSheet.UsedRange.Find(what6)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
> Do
>Set rng = ActiveSheet.UsedRange.Find(what7)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
> Do
>Set rng = ActiveSheet.UsedRange.Find(what8)
>If rng Is Nothing Then
>Exit Do
>Else
>Rows(rng.Row).Delete
>End If
>Loop
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subsc

$$Excel-Macros$$ Does anybody have games

[Nani Ram]

Hi All,

Does anybody have games in excel sheet, if so please send me.


Thanks,
Naniram

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Excel, go through Column B

[Shawn]

All:

I have the following sub that will go down Column B and stop if there
is no more value presented.  However, it only works on currently
active sheet.  How do I modify it so that I can specify a specific
work sheet named "furniture"?

Sub GoColumnB()
 Dim rngClnB As Range, Cell As Range
 Set rngClnB = Intersect(Range("B:B"), ActiveSheet.UsedRange)
 For Each Cell In rngClnB

'Create Arguments here.

 Next Cell
 On Error Resume Next
 MsgBox "Done!"
End Sub

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

RE: $$Excel-Macros$$ Request Help to make code more efficient.

[Dave Bonallack]

Hi Jason,

One way of speeding this up is to use:

Application.ScreenUpdating=False
at the beginning of your code.

(And don't forget the Application.ScreenUpdating=True at the end.)

But I'm sure we could speed it up in other ways as well.

Any chance of attaching the file, or a sample file?

Regards - Dave.

 

 

 
> Date: Tue, 6 Apr 2010 08:18:05 -0700
> Subject: $$Excel-Macros$$ Request Help to make code more efficient.
> From: jsin...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hello all fellow fellow Macro friends :)
> 
> I have a short bit of code that I was wondering if it's possible to
> make it run more efficiently. When it runs currently it takes up to 1
> minute which seems like a long time.
> 
> Notes: This is designed to remove an entire row if the condition is
> met. There is no *real* set limit on the number of potential rows, but
> in reality it shouldn't exceed 1,500 rows on a bad day. There is more
> code that runs after this but it's basic formatting stuff that dos not
> have a loop function in it.
> 
> Regards,
> Jason
> 
> 
> 
> Dim rng As Range
> Dim what As String
> Dim what1 As String
> Dim what2 As String
> Dim what3 As String
> Dim what4 As String
> Dim what5 As String
> Dim what6 As String
> Dim what7 As String
> Dim what8 As String
> 
> 
> what = "FD"
> what1 = "EX"
> what2 = "NA"
> what3 = "NB"
> what4 = "NC"
> what5 = "HN"
> what6 = "CLD"
> what7 = "Location"
> what8 = "of"
> 
> Do
> Set rng = ActiveSheet.UsedRange.Find(what)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> 
> Do
> Set rng = ActiveSheet.UsedRange.Find(what1)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> 
> Do
> Set rng = ActiveSheet.UsedRange.Find(what2)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> 
> Do
> Set rng = ActiveSheet.UsedRange.Find(what3)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> 
> Do
> Set rng = ActiveSheet.UsedRange.Find(what4)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> 
> Do
> Set rng = ActiveSheet.UsedRange.Find(what5)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> Do
> Set rng = ActiveSheet.UsedRange.Find(what6)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> Do
> Set rng = ActiveSheet.UsedRange.Find(what7)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> Do
> Set rng = ActiveSheet.UsedRange.Find(what8)
> If rng Is Nothing Then
> Exit Do
> Else
> Rows(rng.Row).Delete
> End If
> Loop
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
> 
> To unsubscribe, reply using "remove me" as the subject.
  
_
View photos of singles in your area! Looking for a hot date?
http://clk.atdmt.com/NMN/go/150855801/direct/01/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ VBA VLookup dates

[Dave Bonallack]

You're welcome. Glad to help.

Dave.
 
> Date: Tue, 6 Apr 2010 03:47:24 -0700
> Subject: Re: $$Excel-Macros$$ VBA VLookup dates
> From: andyr...@hotmail.co.uk
> To: excel-macros@googlegroups.com
> 
> Dave,
> 
> Apologies for the late response.
> 
> Very much appreciate the effort you have put into this - it works
> perfectly!
> 
> Thanks again!
> 
> Andy.
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
> 
> To unsubscribe, reply using "remove me" as the subject.
  
_
Browse profiles for FREE! Meet local singles online.
http://clk.atdmt.com/NMN/go/150855801/direct/01/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Plz Help me urgent

[Harmeet Singh]

Good one  guyz nice to see such creative formulas, here is my share of
knowledge.

Kindly check out the index match function without adding additional column.


Thanks & Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Tue, Apr 6, 2010 at 4:59 PM, Born to Win  wrote:

> your welcome.
>
> Thanks,
> Chandrabhan Singh
> 9911255330
>
>
>
> On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena wrote:
>
>> Thanks Lot Chandrabhan Singh Ji
>>
>>
>>
>> On Tue, Apr 6, 2010 at 2:24 PM, Born to Win  wrote:
>>
>>> Dear Mr. Saxena,
>>>
>>> Please find Attached file.
>>>
>>> Thanks,
>>> Chandrabhan Singh
>>> 9911255330
>>>
>>>
>>>
>>> On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena 
>>> wrote:
>>>


 Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Regards
>
> Anil Saxena
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe

>>>
>>>
>>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Harmeet_index match with transpose.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need help in function

[paulwillekens]

Hi Gaurav,

Did you try my solution? =(D3 - C3) * 24 * 60
What's wrong about that? The result remains numeric, while Ashish's
solution becomes text!

cu

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Modifying input data

[paulwillekens]

Hi Harpreet,

Here it comes... I made a new sheet "test" to test it, but you can
change that statement in
cCooked = "MODIFIED DATA"
after testing, of course.

Feedback is welcome.

Kind regards,

Paul Willekens
'===
Sub CookData()

Dim cContent
Dim cCooked
Dim cHouse
Dim cName
Dim cRaw
Dim cType

Dim dDate

Dim nEmpty
Dim nRepurchase
Dim nRowRaw
Dim nRowCooked
Dim nNetValue
Dim nSales

cRaw = "RAW DATA"
nRowRaw = 3
cCooked = "test"
nRowCooked = 2

Sheets(cRaw).Select

While nEmpty < 3
  cContent = Trim(Cells(nRowRaw, 1).Value)
  If Len(cContent) > 0 Then 'not an empty line
nEmpty = 0
If IsNumeric(cContent) Then 'scheme ID
  'Scheme Name
  cName = Cells(nRowRaw, 2)
  'Net Asset Value
  nNetValue = Cells(nRowRaw, 3)
  'Repurchase Price
  nRepurchase = Cells(nRowRaw, 4)
  'Sale Price
  nSales = Cells(nRowRaw, 5)
  'Date
  dDate = Cells(nRowRaw, 6)
  Sheets(cCooked).Select
  Cells(nRowCooked, 1).Value = cHouse
  Cells(nRowCooked, 2).Value = cType
  Cells(nRowCooked, 3).Value = cContent
  Cells(nRowCooked, 4).Value = cName
  Cells(nRowCooked, 5).Value = nNetValue
  Cells(nRowCooked, 6).Value = nRepurchase
  Cells(nRowCooked, 7).Value = nSales
  Cells(nRowCooked, 8).Value = dDate
  nRowCooked = nRowCooked + 1
  Sheets(cRaw).Select
Else 'either a new Mutual Fund House or a new Type
  If Right(cContent, 1) = ")" Then 'new Type
cType = cContent
cHouse = ""
  Else 'new Mutual Fund House
cHouse = cContent
  End If
End If
  Else
nEmpty = nEmpty + 1
  End If
  nRowRaw = nRowRaw + 1
Wend

End Sub
'===

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Any Excel file for Payroll

[jignesh parmar]

I have designed Excel base Payroll program but it is for India Please
download from www.jiguparmar.com and see whether It may helful to You.

On Apr 6, 5:22 pm, "Vasi S D"  wrote:
> Hi,
>
> I am looking for a format in Excel for Payroll & Overtime compatiable to UAE
>
> With Summary reports.
>
> Thanks
>
>       I'm not the BEST but I'm not like the REST ! ! !
> Shabbir Dawoodi Vasi
>         Prosperity Consultant
>
> vas...@gmail.com
>
>  faint_grain.jpg
> 1KViewDownload
>
>  image001122.gif
> 32KViewDownload
>
>  image0011133.gif
> 12KViewDownload
>
>  image002244.gif
> 37KViewDownload
>
>  IMSTP9.gif
> 61KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA

[Paul Schreiner]

You ought to look for an Outlook VBA group.
this group is focused on Excel VBA.
With all microsoft applications, VBA has sepecific capabilities for each 
application.

For instance, Outlook and Word have no use for a .Range object.
at the same time, Excel has no use for a .Body object.
your question really should be addressed by those with intense knowledge
of VBA for Outlook.

sorry,

paul





From: janet dickson 
To: excel-macros@googlegroups.com
Sent: Tue, April 6, 2010 1:08:22 PM
Subject: Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA


Okay
 
Am looking for codes to forward emails which am receiving in my OUTLOOK 2007 to 
my second mail/Account and if some emails contain attachment, then all email 
with attachment file >=3MB will be excluded automatically. 
I hope you understood
Thanks for helping
Jenie..


On Tue, Apr 6, 2010 at 8:28 AM, rf1234 rf1234  wrote:

Hello Dear,
>I appriciate your prompt reply,it may be a missunderstanding,but please
>let me know if any one has a outlook express in his or her PC,Then
>what is need to write a macro for outlook("To Send The Mail") .
>
>
>
>It is useful when we are accessing outlook from another application.
>
>
>
>Your suggestion are welcome,so that i can improve my prompt reply.
>
>
>
>
>
>
>Hope it Will Help
>Happy to Help
>:)
>Shyam
>
>
>
>
>On Tue, Apr 6, 2010 at 1:48 AM, paulwillekens
>
> wrote:
>>
>
>> Hi Shyam,
>>
>> I mean the following: I understand what Janet wrote in a different way
>> than you. I had the impression that you assume that Janet wants
>> something from Excel, but I think he/she wants VBA macros for Outlook
>> (not for Excel)...
>>
>> regards
>>
>> Paul Willekens
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links : 
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @ 
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com/
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes about 
>> the learning and support from the group.Let friends and co-workers know they 
>> can subscribe to group at 
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe, reply using "remove me" as the subject.
>>
>
>
>
>
>--
>
>Thanks Regards
>Shyam
>Software Engineer
>''
>When one door of happiness closes, another opens;
> but often we look so long at the closed door that we do not see the
> one which has been opened for us.
>- Helen Keller
>''
>Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
>aber oft schauen wir so lange auf die geschlossene Tür,
> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>''
>
>--
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
>
>We reach over 6,800 subscribers worldwide and receive many nice notes about 
>the learning and support from the group.Let friends and co-workers know they 
>can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

[Paul Schreiner]

are the workbook names listed somewhere?
or are they all in one folder?
Paul




From: janet dickson 
To: excel-macros@googlegroups.com
Sent: Tue, April 6, 2010 1:18:13 PM
Subject: $$Excel-Macros$$ HELP: Appending multiple sheet into one


Hello Team

I have more than 52 workbooks each contain 3 sheets but only one sheet "sheet1" 
contain data. all sheets containing data have the same column names in the 1st 
row, i want to append all sheets into one excel sheet.
Please send me some codes to  accomplish the task.

Thanks in advance
Jenie.. -- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ HELP: Appending multiple sheet into one

[janet dickson]

Hello Team

I have more than 52 workbooks each contain 3 sheets but only one sheet
"sheet1" contain data. all sheets containing data have the same column names
in the 1st row, i want to append all sheets into one excel sheet.
Please send me some codes to  accomplish the task.

Thanks in advance
Jenie..

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA

[janet dickson]

Okay

Am looking for codes to forward emails which am receiving in my OUTLOOK 2007
to my second mail/Account and if some emails contain attachment, then all
email with attachment file >=3MB will be excluded automatically.

I hope you understood
Thanks for helping
Jenie..

On Tue, Apr 6, 2010 at 8:28 AM, rf1234 rf1234  wrote:

> Hello Dear,
> I appriciate your prompt reply,it may be a missunderstanding,but please
> let me know if any one has a outlook express in his or her PC,Then
> what is need to write a macro for outlook("To Send The Mail") .
>
>
>
> It is useful when we are accessing outlook from another application.
>
>
>
> Your suggestion are welcome,so that i can improve my prompt reply.
>
>
>
>
>
> Hope it Will Help
> Happy to Help
> :)
> Shyam
>
>
>
>
> On Tue, Apr 6, 2010 at 1:48 AM, paulwillekens
>  wrote:
> >
>  > Hi Shyam,
> >
> > I mean the following: I understand what Janet wrote in a different way
> > than you. I had the impression that you assume that Janet wants
> > something from Excel, but I think he/she wants VBA macros for Outlook
> > (not for Excel)...
> >
> > regards
> >
> > Paul Willekens
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
> >
> > To unsubscribe, reply using "remove me" as the subject.
> >
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
>
> ''
> When one door of happiness closes, another opens;
>  but often we look so long at the closed door that we do not see the
>  one which has been opened for us.
> - Helen Keller
>
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>
> ''
>
> --
>
> --
>  Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Request Help to make code more efficient.

[JsinSk]

Hello all fellow fellow Macro friends :)

I have a short bit of code that I was wondering if it's possible to
make it run more efficiently. When it runs currently it takes up to 1
minute which seems like a long time.

Notes: This is designed to remove an entire row if the condition is
met. There is no *real* set limit on the number of potential rows, but
in reality it shouldn't exceed 1,500 rows on a bad day. There is more
code that runs after this but it's basic formatting stuff that dos not
have a loop function in it.

Regards,
Jason



 Dim rng As Range
 Dim what As String
 Dim what1 As String
 Dim what2 As String
 Dim what3 As String
 Dim what4 As String
 Dim what5 As String
 Dim what6 As String
 Dim what7 As String
 Dim what8 As String


 what = "FD"
 what1 = "EX"
 what2 = "NA"
 what3 = "NB"
 what4 = "NC"
 what5 = "HN"
 what6 = "CLD"
 what7 = "Location"
 what8 = "of"

Do
Set rng = ActiveSheet.UsedRange.Find(what)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop

Do
Set rng = ActiveSheet.UsedRange.Find(what1)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop

Do
Set rng = ActiveSheet.UsedRange.Find(what2)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop

Do
Set rng = ActiveSheet.UsedRange.Find(what3)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop

  Do
Set rng = ActiveSheet.UsedRange.Find(what4)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop

  Do
Set rng = ActiveSheet.UsedRange.Find(what5)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop
 Do
Set rng = ActiveSheet.UsedRange.Find(what6)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop
 Do
Set rng = ActiveSheet.UsedRange.Find(what7)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop
 Do
Set rng = ActiveSheet.UsedRange.Find(what8)
If rng Is Nothing Then
Exit Do
Else
Rows(rng.Row).Delete
End If
Loop

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Urgent Help

[madhu nair]

Done, see attach




On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar  wrote:

> *Hi friends*
> **
> *Please help me urgent*
> *problem of Hlookup formula in attached file.
> *
> --
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9211219649
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks,

Madhu Nair

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Help(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Modifying input data

[Harpreet Singh Gujral]

Thanks Seema and Paul, for posting your reply to my problem.

I am aware of the fuctionality to import data from text files.

Seema: the file you have attached is the exact point from where i have
my problem, i need to modify the input data from here.

If you see at Column A: you will find the following:

Row 1: states the column headings

Row3: i.e. "Open Ended Schemes(Balanced)" [This is one type of data in
the file]

Row5, 10,17: are the Scheme Names [or companies that have Row3 kind of
schemes]

Row7&8: are two sub schemes available under the company [Baroda
Pioneer Mutual Fund]

Now, the problem i am facing is as follows:
I need, Company Name, Scheme Type, in front of every Sub Schemes, so
that my data becomes adequate to apply Autofilter on.

Please help, or advise on how to approach this problem

Thanks

Harry

On Apr 5, 10:09 pm, paulwillekens 
wrote:
> Hi Hapreet,
>
> I agree with Seema: import with delimiter semicolon and the first
> sheet RAW DATA becomes easier.
>
> If it is still "very cumbersome" for you to convert this Seema-Raw
> Data to the Modified data sheet, tell me and I'll make it in the blink
> of an eye...
>
> Kind regards,
>
> Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Urgent Help

[sudhir kumar]

*Hi friends*
**
*Please help me urgent*
*problem of Hlookup formula in attached file.
*
-- 
Sudhir Verma
Asstt. Mngr. A/c's
9211219649

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Help.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ list of file name from explorer to excel

[chaturvedi vishal]

Hi Shyam,

I created a folder on C ; & on D; and copied the file to the folder from the 
server 

when I run the Macro , I get an error as below :

"Run time error 445 Object doesn't support this action"
 Regards, 


Vishal Chaturvedi
Mo# +971504532896 





From: rf1234 rf1234 
To: excel-macros@googlegroups.com
Cc: vishalbunty2...@yahoo.com
Sent: Tue, April 6, 2010 4:59:14 PM
Subject: Re: $$Excel-Macros$$ list of file name from explorer to excel

Hello Dear,
It is great that you can save that folder on your PC.
Now check it out the macro attached.You have to only
give the path and file type.

path:"path of your folder"
type:*.xls"For excel"









Hope it Will Help
Happy To Help
:)
Shyam

On Tue, Apr 6, 2010 at 5:54 PM, chaturvedi vishal
 wrote:
> Hi Shyam,
>
> I can save the folders in my desktop for sure as I do have an access ..
>
> Please advice the solution ..
>
> I am greatful to you for giving me light in the tunnel
>
> Further , do advice me where i have to change the path names in the Macro or
> the solution.
>
> Regards,
>
> Vishal Chaturvedi
> Mo# +971504532896
>
> 
> From: rf1234 rf1234 
> To: excel-macros@googlegroups.com
> Sent: Tue, April 6, 2010 2:52:37 PM
> Subject: Re: $$Excel-Macros$$ list of file name from explorer to excel
>
> Hello Dear,
> I do not know. that is there any way,to bypass network security and access
> that
> folder,but if u can save that folder in your pc,then i can provide u the
> macro,
> which will display or list file in particular folder.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
> On Tue, Apr 6, 2010 at 4:03 PM, chaturvedi vishal
>  wrote:
>> Dear All,
>>
>> I am looking for a solution which can provide me the list of file names
>> from
>> a folder which has sub folders on a server (not on my desktop) in excel
>>
>> Few pointers :
>> - I am using excel 2007
>> - the server is a restricted server and can be accessed only if permission
>> is provided
>>
>> I did google it and there is a solution with the help of VBA , but to my
>> despair since i am not an expert on VBA cannot play around with the script
>> .
>>
>> Sub AllFilenames()
>> Rem Change D:
>> Y = "D:"
>> Cells(1, 1) = "Filenames"
>> r = 2
>> f = Dir(D, 7)
>> Do While f <> ""
>>   Cells(r, 1) = f
>>   r = r + 1
>>   f = Dir
>> Loop
>> End Sub
>>
>> If some one can help I will be more then grateful.
>>
>> Regards,
>>
>> Vishal Chaturvedi
>> Mo# +971504532896
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about
>> the learning and support from the group.Let friends and co-workers know
>> they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
> ''
> When one door of happiness closes, another opens;
> but often we look so long at the closed door that we do not see the
> one which has been opened for us.
> - Helen Keller
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> ''
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><

Re: $$Excel-Macros$$ hi-help required .

[Sarvesh]

thanks ..thanks a lot.
one little doubt...if i delete or add a qty in the list...then pivot table is 
not updated immediately ?
i need it to be updated

regards,sarvesh lahoti.

--- On Tue, 6/4/10, rf1234 rf1234  wrote:

From: rf1234 rf1234 
Subject: Re: $$Excel-Macros$$ hi-help required .
To: excel-macros@googlegroups.com
Cc: sarve...@yahoo.com
Date: Tuesday, 6 April, 2010, 10:52 AM

Hello Dear,
Attached workbook has a sample for your problem.
 
 
 
 
 
 
 
 
 
 
 
Hope it Will Help
Happy to Help
:)
Shyam
 
 
 
 
 


 
On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh  wrote:






hi 


firstly r u from hyderabad... just felt so with ur mail id.( i am from 
hyderabad)


i am attaching my actual file. plz go thru it.


thanks a ton.






regards,
sarvesh lahoti.

--- On Mon, 5/4/10, rf1234 rf1234  wrote:



From: rf1234 rf1234 
Subject: Re: $$Excel-Macros$$ hi-help required .

To: excel-macros@googlegroups.com
Cc: sarve...@yahoo.com
Date: Monday, 5 April, 2010, 5:03 PM 






Hello Dear,
Following attachment have a solution regarding your problem.
 
 
 
 
 
 
 
 
 
 
 
 
 
Hope it Will Help
Happy to Help
:)
Shyam
 
 
 
 
 
 
 


 
On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh  wrote:






hi  


i have a worksheet where sizes and qty are maintained for each item in this way








460*12 Pet
31

460*12 Pet
265

460*12 Pet
340

460*12 Pet
392

460*12 Pet
523

460*12 Pet
150

470*12 Pet
35

470*12 Pet
212

470*12 Pet
159

480*12 Pet
131

480*12 Pet
7

480*12 Pet
56

480*12 Pet
12

480*12 Pet
91

daily some sizes and qty are added , deleted, modified.

i need to know the total requirement of each size eg: 480*12 pet 
=+131+7+56+12+91  which is 297.


same way need for all the sizes. the list is very big.

i am not familiar with macros , any other formulae based solution will be 
helpful.

thanks 







regards,
sarvesh lahoti.




Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. 
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe




-- 

Thanks Regards
Shyam
Software Engineer
''

When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''

Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, 
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe





The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.


-- 

Thanks Regards

Shyam
Software Engineer
''

When one door of happiness closes, another opens;
but often we look so long a

Re: $$Excel-Macros$$ Group Data

[Dave]

Thanks AJ I was able to solve the problem. Thanks again!!

On Mar 26, 12:18 am, Abhishek Jain  wrote:
> Hi,
>
> A sample file of your query would help to understand better, please attach
> if possible. However, you may try subtotal. Data>Subtotal.
>
> Cheers!
>
> AJ
>
>
>
> On Thu, Mar 25, 2010 at 11:21 PM, Dave  wrote:
> > Hi,
> > I have a spreadsheet with the following columns:
>
> > Item # 1 to 1000
> > Account Number alphanumeric 20 characters long
> > Amount 1
> > Amount 2
> > Period 1
> > Period 2
>
> > Data is currently sorted by Amount 2 ( largest to smallest).
>
> > There are multiple entries for the same account number
>
> >  What I want to do is now group the data so that All the same account
> > numbers are grouped together along with all other fields but  in this
> > grouping I want the amounts to keep the current sort  largest to
> > smallest ( largest to smallest).If an account as three numbers I want
> > them on the sheet in consecutive lines
>
> > Thanks for all your help,
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> >http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> > To unsubscribe from this group, send email to excel-macros+
> > unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> > ME" as the subject.- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ list of file name from explorer to excel

[chaturvedi vishal]

Hi Shyam,

I can save the folders in my desktop for sure as I do have an access ..

Please advice the solution ..

I am greatful to you for giving me light in the tunnel 

Further , do advice me where i have to change the path names in the Macro or 
the solution.
 Regards, 


Vishal Chaturvedi
Mo# +971504532896 





From: rf1234 rf1234 
To: excel-macros@googlegroups.com
Sent: Tue, April 6, 2010 2:52:37 PM
Subject: Re: $$Excel-Macros$$ list of file name from explorer to excel

Hello Dear,
I do not know. that is there any way,to bypass network security and access that
folder,but if u can save that folder in your pc,then i can provide u the macro,
which will display or list file in particular folder.














Hope it Will Help
Happy To Help
:)
Shyam

On Tue, Apr 6, 2010 at 4:03 PM, chaturvedi vishal
 wrote:
> Dear All,
>
> I am looking for a solution which can provide me the list of file names from
> a folder which has sub folders on a server (not on my desktop) in excel
>
> Few pointers :
> - I am using excel 2007
> - the server is a restricted server and can be accessed only if permission
> is provided
>
> I did google it and there is a solution with the help of VBA , but to my
> despair since i am not an expert on VBA cannot play around with the script .
>
> Sub AllFilenames()
> Rem Change D:
> Y = "D:"
> Cells(1, 1) = "Filenames"
> r = 2
> f = Dir(D, 7)
> Do While f <> ""
>   Cells(r, 1) = f
>   r = r + 1
>   f = Dir
> Loop
> End Sub
>
> If some one can help I will be more then grateful.
>
> Regards,
>
> Vishal Chaturvedi
> Mo# +971504532896
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.



  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 s

Re: $$Excel-Macros$$ Plz Help me urgent

[Born to Win]

your welcome.

Thanks,
Chandrabhan Singh
9911255330


On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena wrote:

> Thanks Lot Chandrabhan Singh Ji
>
>
>
> On Tue, Apr 6, 2010 at 2:24 PM, Born to Win  wrote:
>
>> Dear Mr. Saxena,
>>
>> Please find Attached file.
>>
>> Thanks,
>> Chandrabhan Singh
>> 9911255330
>>
>>
>>
>> On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena 
>> wrote:
>>
>>>
>>>
>>> Hi Dilip
 plz do the needful it is urgent

 I want the same ans match with ID and Questions ?

 Plz Sir show the Formula also




 Regards

 Anil Saxena

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe

>>>
>>>  --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Need help in function

[GAURAV JAIN]

Hi,

Ashish Koul is right.
His formula is working prefectly fine.

Superb Ashish.
Cheers
Gaurav Jain



On Tue, Apr 6, 2010 at 10:44 AM, seema mba  wrote:

>  Hi,
>
> I have attached your sheet with formula for finding the difference in
> minutes.
>
> I have used the formula CONVERT.
> If the CONVERT function is not available, install and load the Analysis
> ToolPak add-in.
> On the Tools menu, click Add-Ins.
> In the Add-Ins available list, select the Analysis ToolPak box, and then
> click OK.
>
> Example of CONVERT
> =CONVERT(A2,"day","hr") Convert 6 days to hours (144)
> =CONVERT(A2,"hr","mn") Convert 6 hours to minutes (360)
> =CONVERT(A2,"yr", "day") Convert 6 years to days (2191.5)
>
>
> The above information is given on help section of Excel.
> I used the formula like this.
> =CONVERT((d3-c3),"day","mn")
> As your both dates are written in d3 and c3, it will first calculate the
> difference and then convert the days into minutes.
>
> Hope this is helpful.
>
> Regards,
>
> Seema
>
>
>   On 4/6/10, ╚►♥ѕαη∂єєρ♥◄╝  wrote:
>>
>>
>> Hi All,
>>
>>
>> I want to calculate difference between two date , but i want result
>> in minute's.
>> please suggest function,
>> Please find attached & if u r sending solved reply Please "CC"
>> sandeepxxxku...@gmail.com
>>
>>
>>
>>
>> --
>>
>> Thanks & Regards:
>> ╚►♥ѕαη∂єєρ♥◄╝
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ VBA VLookup dates

[Andy]

Dave,

Apologies for the late response.

Very much appreciate the effort you have put into this - it works
perfectly!

Thanks again!

Andy.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ list of file name from explorer to excel

[rf1234 rf1234]

Hello Dear,
I do not know. that is there any way,to bypass network security and access that
folder,but if u can save that folder in your pc,then i can provide u the macro,
which will display or list file in particular folder.














Hope it Will Help
Happy To Help
:)
Shyam

On Tue, Apr 6, 2010 at 4:03 PM, chaturvedi vishal
 wrote:
> Dear All,
>
> I am looking for a solution which can provide me the list of file names from
> a folder which has sub folders on a server (not on my desktop) in excel
>
> Few pointers :
> - I am using excel 2007
> - the server is a restricted server and can be accessed only if permission
> is provided
>
> I did google it and there is a solution with the help of VBA , but to my
> despair since i am not an expert on VBA cannot play around with the script .
>
> Sub AllFilenames()
> Rem Change D:
> Y = "D:"
> Cells(1, 1) = "Filenames"
> r = 2
> f = Dir(D, 7)
> Do While f <> ""
>   Cells(r, 1) = f
>   r = r + 1
>   f = Dir
> Loop
> End Sub
>
> If some one can help I will be more then grateful.
>
> Regards,
>
> Vishal Chaturvedi
> Mo# +971504532896
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

[rf1234 rf1234]

Hello Dear,
I am using excel 2003.


Ok,So generally we can add text on our controlls which can be
highlighted after any event
triggers..i.e
MouseOver
MouseClick ETC.


If you want to create your sample 1.use the stem.


Tools-->Macro-->Visual Basic Editor-->Insert-->UserForm-->Addcontrols(TOOLS)

ListBox1-->Property-->ControlsTipText---"Text What U want To write
After ListBox1 Activate"

Run form.








Hope it Will Help
Happy to Help
:)
Shyam







On Tue, Apr 6, 2010 at 3:28 PM, L.K. Modi  wrote:
>
> Dear Sir
>
> May i know how can we use that excel tool tip file.
> sry i m new to excel but like this group much its help me a lot
> pls tell me the way how can we use that
> as i m clicking on that there is some id type is there and nothing else
>
> please suggest me
>
>
> Regards
> On 4/6/10, rf1234 rf1234  wrote:
>>
>> Hello Dear,
>> Attached workbook have the solution for your proble.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope it Will Help
>> Happy To Help
>> :)
>> Shyam
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Tue, Apr 6, 2010 at 1:26 PM, Anantha  wrote:
>> > Hello Folks,
>> >
>> > Can someone help me in adding tooltips for each listbox items
>> > selected.
>> >
>> > I'm using Excel 2007 and using list box from Active x control.
>> >
>> > Thanks in Advance,
>> >
>> > Regards,
>> >
>> > Anantha
>> >
>> > --
>> >
>> > --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our Facebook Group @
>> > http://www.facebook.com/group.php?gid=287779555678
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 6,800 subscribers worldwide and receive many nice notes
>> > about the learning and support from the group.Let friends and co-workers
>> > know they can subscribe to group at
>> > http://groups.google.com/group/excel-macros/subscribe
>> >
>>
>>
>>
>> --
>>
>> Thanks Regards
>> Shyam
>> Software Engineer
>>
>> ''
>> When one door of happiness closes, another opens;
>> but often we look so long at the closed door that we do not see the
>> one which has been opened for us.
>> - Helen Keller
>>
>> ''
>> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
>> aber oft schauen wir so lange auf die geschlossene Tür,
>> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>>
>> ''
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe, reply using "remove me" as the subject.
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the

Re: $$Excel-Macros$$ Plz Help me urgent

[Anil Saxena]

Thanks Lot Chandrabhan Singh Ji


On Tue, Apr 6, 2010 at 2:24 PM, Born to Win  wrote:

> Dear Mr. Saxena,
>
> Please find Attached file.
>
> Thanks,
> Chandrabhan Singh
> 9911255330
>
>
>
> On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>>
>>
>> Hi Dilip
>>> plz do the needful it is urgent
>>>
>>> I want the same ans match with ID and Questions ?
>>>
>>> Plz Sir show the Formula also
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Anil Saxena
>>>
>>>  --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ list of file name from explorer to excel

[chaturvedi vishal]

Dear All,

I am looking for a solution which can provide me the list of file names from a 
folder which has sub folders on a server (not on my desktop) in excel

Few pointers :
- I am using excel 2007
- the server is a restricted server and can be accessed only if permission is 
provided

I did google it and there is a solution with the help of VBA , but to my 
despair since i am not an expert on VBA cannot play around with the script .

Sub AllFilenames()
Rem Change D:
Y = "D:"
Cells(1, 1) = "Filenames"
r = 2
f = Dir(D, 7)
Do While f <> ""
  Cells(r, 1) = f
  r = r + 1
  f = Dir
Loop
End Sub

If some one can help I will be more then grateful.
 Regards, 


Vishal Chaturvedi
Mo# +971504532896 


  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

[L.K. Modi]

Dear Sir

May i know how can we use that excel tool tip file.
sry i m new to excel but like this group much its help me a lot
pls tell me the way how can we use that
as i m clicking on that there is some id type is there and nothing else

please suggest me


Regards

On 4/6/10, rf1234 rf1234  wrote:
>
> Hello Dear,
> Attached workbook have the solution for your proble.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Tue, Apr 6, 2010 at 1:26 PM, Anantha  wrote:
> > Hello Folks,
> >
> > Can someone help me in adding tooltips for each listbox items
> > selected.
> >
> > I'm using Excel 2007 and using list box from Active x control.
> >
> > Thanks in Advance,
> >
> > Regards,
> >
> > Anantha
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
> >
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
>
> ''
> When one door of happiness closes, another opens;
> but often we look so long at the closed door that we do not see the
> one which has been opened for us.
> - Helen Keller
>
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>
> ''
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Plz Help me urgent

[Sivakumar E.S]

Dear Anil Saxena

Find attached solution to your problem. Hope this suffies

Regards
Sivakumar ES



On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wrote:

> Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Regards
>
> Anil Saxena
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards
Sivakumar ES
+91 99250 12482

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


excel solved match and index.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

[L.K. Modi]

Dear Sir

May i know how can we use that excel tool tip file.
sry i m new to excel but like this group much its help me a lot
pls tell me the way how can we use that
as i m clicking on that there is some id type is there and nothing else

please suggest me


Regards
LKmodi







On 4/6/10, rf1234 rf1234  wrote:
>
> Hello Dear,
> Attached workbook have the solution for your proble.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Tue, Apr 6, 2010 at 1:26 PM, Anantha  wrote:
> > Hello Folks,
> >
> > Can someone help me in adding tooltips for each listbox items
> > selected.
> >
> > I'm using Excel 2007 and using list box from Active x control.
> >
> > Thanks in Advance,
> >
> > Regards,
> >
> > Anantha
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
> >
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
>
> ''
> When one door of happiness closes, another opens;
> but often we look so long at the closed door that we do not see the
> one which has been opened for us.
> - Helen Keller
>
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>
> ''
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Plz Help me urgent

[Abhishek Jain]

You're welcome Anil.

On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena wrote:

> Thanks to Lot Abhishek Ji
> about help me thanks
>
>
> On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote:
>
>> Dear Anil,
>>
>> Please see the attached file. I've used an array formula. Press
>> Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
>> the range names.
>>
>> Let me know if you need any further help on this.
>>
>> Dilip's friend... :)
>>
>> Abhishek
>>
>>
>> On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena 
>> wrote:
>>
>>> Hi Dilip
>>> plz do the needful it is urgent
>>>
>>> I want the same ans match with ID and Questions ?
>>>
>>> Plz Sir show the Formula also
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Anil Saxena
>>>
>>>  --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Plz Help me urgent

[Born to Win]

Dear Mr. Saxena,

Please find Attached file.

Thanks,
Chandrabhan Singh
9911255330


On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:

>
>
> Hi Dilip
>> plz do the needful it is urgent
>>
>> I want the same ans match with ID and Questions ?
>>
>> Plz Sir show the Formula also
>>
>>
>>
>>
>> Regards
>>
>> Anil Saxena
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Copy of Questions-1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Plz Help me urgent

[Anil Saxena]

Thanks to Lot Abhishek Ji
about help me thanks

On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote:

> Dear Anil,
>
> Please see the attached file. I've used an array formula. Press
> Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
> the range names.
>
> Let me know if you need any further help on this.
>
> Dilip's friend... :)
>
> Abhishek
>
>
> On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena 
> wrote:
>
>> Hi Dilip
>> plz do the needful it is urgent
>>
>> I want the same ans match with ID and Questions ?
>>
>> Plz Sir show the Formula also
>>
>>
>>
>>
>> Regards
>>
>> Anil Saxena
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Plz Help me urgent

[Abhishek Jain]

Dear Anil,

Please see the attached file. I've used an array formula. Press
Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
the range names.

Let me know if you need any further help on this.

Dilip's friend... :)

Abhishek

On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wrote:

> Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Regards
>
> Anil Saxena
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Questions.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Plz Help me urgent

[ashish koul]

check it if this helps u

On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:

>
>
> Hi Dilip
>> plz do the needful it is urgent
>>
>> I want the same ans match with ID and Questions ?
>>
>> Plz Sir show the Formula also
>>
>>
>>
>>
>> Regards
>>
>> Anil Saxena
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Questions(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

[rf1234 rf1234]

Hello Dear,
Attached workbook have the solution for your proble.














Hope it Will Help
Happy To Help
:)
Shyam













On Tue, Apr 6, 2010 at 1:26 PM, Anantha  wrote:
> Hello Folks,
>
> Can someone help me in adding tooltips for each listbox items
> selected.
>
> I'm using Excel 2007 and using list box from Active x control.
>
> Thanks in Advance,
>
> Regards,
>
> Anantha
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Tool Tip Text For List Box.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How can I Add tool tips to each of list items ?

[Anantha]

Hello Folks,

Can someone help me in adding tooltips for each listbox items
selected.

I'm using Excel 2007 and using list box from Active x control.

Thanks in Advance,

Regards,

Anantha

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Plz Help me urgent

[Anil Saxena]

Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Regards
>
> Anil Saxena
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Questions.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ hi-help required .

[Hemant K]

Here is the solution attached you can do it with the help of sumproduct
formula or with Sumif Formula

Regards
Hemant

On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh  wrote:

>
> hi
>
> i have a worksheet where sizes and qty are maintained for each item in this
> way
>
>  460*12 Pet 31  460*12 Pet 265  460*12 Pet 340  460*12 Pet 392  460*12 Pet
> 523  460*12 Pet 150  470*12 Pet 35  470*12 Pet 212  470*12 Pet 159  480*12
> Pet 131  480*12 Pet 7  480*12 Pet 56  480*12 Pet 12  480*12 Pet 91
>
> daily some sizes and qty are added , deleted, modified.
>
> i need to know the total requirement of each size eg: 480*12 pet
> =+131+7+56+12+91  which is 297.
>
> same way need for all the sizes. the list is very big.
>
> i am not familiar with macros , any other formulae based solution will be
> helpful.
>
> thanks
>
>
> regards,
> *sarvesh lahoti.*
>
> --
> Your Mail works best with the New Yahoo Optimized IE8. Get it 
> NOW!.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards

Hemant Koranne
Check out my web site for learning excel
http://exceltnt.blogspot.com/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Solution.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Importing Text file

[Vikas Chouhan]

HI,


Right Click .txt file and open with excel just try it

On Mon, Apr 5, 2010 at 2:37 PM, Mahesh  wrote:

> Dear All,
>
> Need ur advise...
>
> I got around 20 text files in a day,which had 13 to 15 columns separated by
> "|" this sign. each file contains around 15 lacs or more line items.
>
> when i import that text file in excel 2007, it takes the first 10 lacs
> records; rest does not come.
>
> Need ur help to solve this,
>
> I want that rest records should move to next sheet of the same workbook
>
> --
> With Love,
> Mahesh Bisht
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
One Team One Dream One Goal

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ hi-help required .

[rf1234 rf1234]

Hello Dear,

Use the following instruction.

Select Range
Data Menu
Pivot Table And Pivot Chart Report
Next("Follow the instruction")



or go to link below
http://www.cpearson.com/excel/pivots.htm

http://www.contextures.com/xlpivot07.html








Hope it Will Help
Happy to Help
:)
Shyam


On Tue, Apr 6, 2010 at 11:47 AM, Sarvesh  wrote:

>   hi
> thanks for your help.
>
> what you are doing is right..but i dont knwo pivot table and how did u do
> it...any tutorial for the same...?
>
>
>
>  regards,
> *sarvesh lahoti.*
>
>
> --- On *Tue, 6/4/10, rf1234 rf1234 * wrote:
>
>
> From: rf1234 rf1234 
> Subject: Re: $$Excel-Macros$$ hi-help required .
> To: excel-macros@googlegroups.com
> Cc: sarve...@yahoo.com
> Date: Tuesday, 6 April, 2010, 10:52 AM
>
>
>  Hello Dear,
> Attached workbook has a sample for your problem.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy to Help
> :)
> Shyam
>
>
>
>
>
>
>
>
> On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh 
> http://mc/compose?to=sarve...@yahoo.com>
> > wrote:
>
>>
>> hi
>>
>> firstly r u from hyderabad... just felt so with ur mail id.( i am from
>> hyderabad)
>>
>> i am attaching my actual file. plz go thru it.
>>
>> thanks a ton.
>>
>>
>>  regards,
>> *sarvesh lahoti.*
>>
>>
>> --- On *Mon, 5/4/10, rf1234 rf1234 
>> http://mc/compose?to=rfhyd1...@gmail.com>
>> >* wrote:
>>
>>
>> From: rf1234 rf1234 
>> http://mc/compose?to=rfhyd1...@gmail.com>
>> >
>> Subject: Re: $$Excel-Macros$$ hi-help required .
>> To: 
>> excel-macros@googlegroups.com
>> Cc: sarve...@yahoo.com 
>> Date: Monday, 5 April, 2010, 5:03 PM
>>
>>
>>  Hello Dear,
>> Following attachment have a solution regarding your problem.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope it Will Help
>> Happy to Help
>> :)
>> Shyam
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh 
>> http://mc/compose?to=sarve...@yahoo.com>
>> > wrote:
>>
>>>
>>> hi
>>>
>>> i have a worksheet where sizes and qty are maintained for each item in
>>> this way
>>>
>>>460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet
>>> 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12
>>> Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91
>>>
>>> daily some sizes and qty are added , deleted, modified.
>>>
>>> i need to know the total requirement of each size eg: 480*12 pet
>>> =+131+7+56+12+91  which is 297.
>>>
>>> same way need for all the sizes. the list is very big.
>>>
>>> i am not familiar with macros , any other formulae based solution will be
>>> helpful.
>>>
>>> thanks
>>>
>>>
>>>   regards,
>>> *sarvesh lahoti.*
>>>
>>> --
>>> Your Mail works best with the New Yahoo Optimized IE8. Get it 
>>> NOW!.
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to 
>>> excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>>
>> --
>>
>> Thanks Regards
>> Shyam
>> Software Engineer
>>
>> ''
>> When one door of happiness closes, another opens;
>> but often we look so long at the closed door that we do not see the
>> one which has been opened for us.
>> - Helen Keller
>>
>> ''
>> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
>> aber oft schauen wir so lange auf die geschlossene Tür,
>> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>>
>> ''
>>
>> --
>>
>> 

$$Excel-Macros$$ Re: Need help in function

[paulwillekens]

Hi Sandeep,

Just try the simple function as follows...

on row 3
=(D3 - C3) * 24 * 60

make sure the editing of the result column is standard (i.e. nothing)

Let me know...

Greetings

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Plz Help me urgent

[Anil Saxena]

Hi Dilip
plz do the needful it is urgent

I want the same ans match with ID and Questions ?

Plz Sir show the Formula also




Regards

Anil Saxena

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Questions.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Worksheets password break

[kumara datta yagneswara]

Thanks alot Shyam,

But it has VBA Password ,will you please help me in breaking that
password.

Regards,
Kumara Datta

On Mon, Apr 5, 2010 at 6:01 PM, rf1234 rf1234  wrote:

> Hello Dear
>
> Try to use
> tools--> unprotect workbook
>
> tools-->unprotect sheets
>
> tools-->unprotect  & share workbook
>
>
> Password is abc123
>
> Remember this password while working on that workbook.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy to Help
> :)
> Shyam
>
>
>
>
>
>
>
>
>
>
>
>  On Mon, Apr 5, 2010 at 5:47 PM, rf1234 rf1234 
> wrote:
> > Hello Dear,
> > I can try,i will let you as soon as possible.
> >
> >
> > Please wait for next post.
> >
> >
> >
> > Hope it Will Help
> > Happy to Help
> > :)
> > Shyam
> >
> > On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara
> >  wrote:
> >> Hi Frnds,
> >>
> >>
> >> Can any one break this file's password.
> >>
> >> Thanks & Regards,
> >> Kumara Datta.
> >>
> >>
> >> On Mon, Apr 5, 2010 at 12:37 AM, Nishant Sharma 
> >> wrote:
> >>>
> >>>
> >>> On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar  >
> >>> wrote:
> 
>  Hi  Friends
> >>>
> >>> is there any vba code to break excel file which has a password to open
> >>> Thanks
> >>> Nishant
> >>>
> 
>  Today i am going to show you how to crack excel sheets password.
> 
>  Vba code to break password.
> 
>  Sub PasswordBreaker()
>   Dim i As Integer, j As Integer, k As Integer
>   Dim l As Integer, m As Integer, n As Integer
>   Dim i1 As Integer, i2 As Integer, i3 As Integer
>   Dim i4 As Integer, i5 As Integer, i6 As Integer
>   On Error Resume Next
>   For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
>   For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
>   For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
>   For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
>   ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
>   Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
>   Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
>   If ActiveSheet.ProtectContents = False Then
>   MsgBox "Tata sky laga dala life will be jiga lala"
>   Range("a1").Value = "Tata sky laga dala life will be jiga lala"
>   Exit Sub
>   End If
>   Next: Next: Next: Next: Next: Next
>   Next: Next: Next: Next: Next: Next
>  End Sub
> 
>  I hope i like this one.
> 
>  Regards
>  Vishal Parihar
>  9910415530
>  vish.pari...@gmail.com
> 
> 
> 
>  --
> 
> 
> --
>  Some important links for excel users:
>  1. Follow us on TWITTER for tips tricks and links :
>  http://twitter.com/exceldailytip
>  2. Join our Facebook Group @
>  http://www.facebook.com/group.php?gid=287779555678
>  3. Excel tutorials at http://www.excel-macros.blogspot.com
>  4. Learn VBA Macros at http://www.quickvba.blogspot.com
>  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
>  To post to this group, send email to excel-macros@googlegroups.com
> 
>  <><><><><><><><><><><><><><><><><><><><><><>
>  HELP US GROW !!
> 
>  We reach over 6,800 subscribers worldwide and receive many nice notes
>  about the learning and support from the group.Let friends and
> co-workers
>  know they can subscribe to group at
>  http://groups.google.com/group/excel-macros/subscribe
> 
>  To unsubscribe, reply using "remove me" as the subject.
> >>>
> >>> --
> >>>
> >>>
> --
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip
> >>> 2. Join our Facebook Group @
> >>> http://www.facebook.com/group.php?gid=287779555678
> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>>
> >>> To post to this group, send email to excel-macros@googlegroups.com
> >>>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> HELP US GROW !!
> >>>
> >>> We reach over 6,800 subscribers worldwide and receive many nice notes
> >>> about the learning and support from the group.Let friends and
> co-workers
> >>> know they can subscribe to group at
> >>> http://groups.google.com/group/excel-macros/subscribe
> >>
> >> --
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our Facebook Group @
> >> http://www.facebook.com/group.php?gid=287779555678
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at htt

Re: $$Excel-Macros$$ Need help in function

[seema mba]

Hi,

I have attached your sheet with formula for finding the difference in
minutes.

I have used the formula CONVERT.
If the CONVERT function is not available, install and load the Analysis
ToolPak add-in.
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.

Example of CONVERT
=CONVERT(A2,"day","hr") Convert 6 days to hours (144)
=CONVERT(A2,"hr","mn") Convert 6 hours to minutes (360)
=CONVERT(A2,"yr", "day") Convert 6 years to days (2191.5)


The above information is given on help section of Excel.
I used the formula like this.
=CONVERT((d3-c3),"day","mn")
As your both dates are written in d3 and c3, it will first calculate the
difference and then convert the days into minutes.

Hope this is helpful.

Regards,

Seema


On 4/6/10, ╚►♥ѕαη∂єєρ♥◄╝  wrote:
>
>
> Hi All,
>
>
> I want to calculate difference between two date , but i want result
> in minute's.
> please suggest function,
> Please find attached & if u r sending solved reply Please "CC"
> sandeepxxxku...@gmail.com
>
>
>
>
> --
>
> Thanks & Regards:
> ╚►♥ѕαη∂єєρ♥◄╝
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Book14(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need help in function

[Born to Win]

Dear sandeep,
Please Find Attached File


Thanks,
Chandrabhan

2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ 

>
> Hi All,
>
> I want to calculate difference between two date , but i want result
> in minute's.
> please suggest function,
> Please find attached & if u r sending solved reply Please "CC"
> sandeepxxxku...@gmail.com
>
>
>
> --
>
> Thanks & Regards:
> ╚►♥ѕαη∂єєρ♥◄╝
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Copy of Book14.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need help in function

[Abhishek Jain]

Sandeep,

Please check the attached file. I used a custom format of "[m]:ss" (without
quotes). Remove ":ss" part if you don't want seconds. Is this what you want
?


Best,


AJ

2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ 

>
> Hi All,
>
> I want to calculate difference between two date , but i want result
> in minute's.
> please suggest function,
> Please find attached & if u r sending solved reply Please "CC"
> sandeepxxxku...@gmail.com
>
>
>
> --
>
> Thanks & Regards:
> ╚►♥ѕαη∂єєρ♥◄╝
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Book14.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need help in function

[ashish koul]

=TEXT(D5-C5,"[MM]")

On Tue, Apr 6, 2010 at 10:06 AM, ashish koul  wrote:

> =TEXT(D5-C5,"[MM]")
>
> 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ 
>
>
>> Hi All,
>>
>> I want to calculate difference between two date , but i want result
>> in minute's.
>> please suggest function,
>> Please find attached & if u r sending solved reply Please "CC"
>> sandeepxxxku...@gmail.com
>>
>>
>>
>> --
>>
>> Thanks & Regards:
>> ╚►♥ѕαη∂єєρ♥◄╝
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Need help in function

[ashish koul]

=TEXT(D5-C5,"[MM]")

2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ 

>
> Hi All,
>
> I want to calculate difference between two date , but i want result
> in minute's.
> please suggest function,
> Please find attached & if u r sending solved reply Please "CC"
> sandeepxxxku...@gmail.com
>
>
>
> --
>
> Thanks & Regards:
> ╚►♥ѕαη∂єєρ♥◄╝
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.