date:20091120

RE: $$Excel-Macros$$ Urgent Help Needed

2009-11-20 Thread Dave Bonallack


Hi, If you can open the file in Read-only mode, then do so, make the changes 
you want, then Save As whatever name you want. Then just delete the original.
Regards - Dave

> Date: Fri, 20 Nov 2009 17:59:46 -0800
> Subject: $$Excel-Macros$$ Urgent Help Needed
> From: sheetallakho...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hi Friends,
> 
> Is there anyway to remove or crack the VBA password from the an excel
> file. As soon as u double click to open the file. It gives a message
> that Enter password for write access or open read only.
> 
> My colleague who created this sheet has forgot the password and we
> need to make changes in this sheet very urgently.
> 
> It would be great if any of you can let me know how to do it. Any help
> on this would be greatly appreciated.
> 
> Thanks and Regards,
> Sheetal Lakhotia
> 
> -- 
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>  
> 
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,500 subscribers worldwide and receive many nice notes about 
> the learning and support from the group. Our goal is to have 10,000 
> subscribers by the end of 2009. Let friends and co-workers know they can 
> subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
Looking for a date? View photos of singles in your area!
http://clk.atdmt.com/NMN/go/150855801/direct/01/

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Urgent Help Needed

2009-11-20 Thread sheetallakho...@gmail.com

Hi Friends,

Is there anyway to remove or crack the VBA password from the an excel
file. As soon as u double click to open the file. It gives a message
that Enter password for write access or open read only.

My colleague who created this sheet has forgot the password and we
need to make changes in this sheet very urgently.

It would be great if any of you can let me know how to do it. Any help
on this would be greatly appreciated.

Thanks and Regards,
Sheetal Lakhotia

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Add a column of matching numbers

2009-11-20 Thread mike

What I need to do is insert a column at A:A
if there is data in B1 number A:1 as 1
down one to B2 number A:2 as 2
and so on to the end of data in column B

start with this

Col A
aaa
bbb
ccc

end with this

Col A  Col B
1.aaa
2.bbb
3.ccc
(dots shown here as spacers)


The code I wrote below works perfectly, but it is SLOW
Does anyone have any suuggestions to speed it up?
(10,000+ rows)


Columns("A:A").Select
Selection.Insert Shift:=xlToRight

myrow = 1


Do Until IsEmpty(Range("B" & myrow))

Range("A" & myrow).Select
ActiveCell.FormulaR1C1 = myrow

myrow = myrow + 1
Loop

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Setting of Axes(xlCategory) for a chart-sheet in Excel 2007

2009-11-20 Thread Arkadiy

I am unsuccessfully trying to set TickLabelSpacing for X-axis in a
chart-sheet. Tries recording the steps into a macro, but the recorded
code
returns an error when i attempt to run it myself.
The problem has something to do with the fact that the charts in
chart-sheets aren't embedded into ChartObjects, and setting
TickLabelSpacing
directly for a chart object doesn't do anyhting.

Here's the recorded code (fails in 2007):

Sub Macro3()
'
' Macro3 Macro
'

'
Sheets("Chart").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlCategory).Select
ActiveChart.Axes(xlCategory).TickMarkSpacing = 12
ActiveChart.Axes(xlCategory).TickLabelSpacing = 12
End Sub

Removing ActiveSheet.ChartObjects("Chart 1").Activate will make excel
ignore TickLabelSpacing in 2007, and will actaully work fine in 2003

Could you please advise if I am doing something wrong or this is a
known bug
(and in that case if a workaround exists)?

Thank you

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Require help on a condition

2009-11-20 Thread Pooja Sharma

Thanks Sandeep,

This is simplest way and yes the assumption is correct...the assumption
sustains as it is assumed.

Best Regards
Pooja Sharma

On Fri, Nov 20, 2009 at 8:13 PM, Sandeep Kumar Maurya  wrote:

> Hi,
>
> Find the attached sheet with formula.
>
> Regards
> Sandeep
>
>
> On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S  wrote:
>
>> pooja Sharma
>>
>> Find attached an excel file with vba macro.  place ur cursor anywhere in
>> reference column and run macro... u will see result in next sheet Hope
>> this helps
>>
>> Regards
>> sivakumar
>>
>> On Thu, Nov 19, 2009 at 1:35 PM, Pooja Sharma wrote:
>>
>>> Hi All,
>>>
>>> I've attached a file in which, a data is mentioned with the required
>>> solution. If any body can help me in this, it will be of great help.
>>>
>>> --
>>> Best Regards
>>> Pooja Sharma
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>> If you find any spam message in the group, please send an email to:
>>> Ayush Jain @ jainayus...@gmail.com or
>>> Ashish Jain @ 26may.1...@gmail.com
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group. Our goal is to have 10,000
>>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Best Regards
Pooja Sharma

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Fwd: Urgent Help required

2009-11-20 Thread RolfJ

Ooops. I forgot to mention that you need to explicitly reference the
MS Outlook library for the code I posted to be able to run by
selecting Tools | References from the VBE main menu and then select
'Microsoft Outlook 11.0 (or 12.0) Object Library' from the 'Available
References' list.

Best wishes,
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm


On Nov 20, 4:01 pm, RolfJ  wrote:
> I am not quite clear exactly when you would like an email to be sent.
> Is it when you change a cell in column A ('Subject Line') or when you
> update an email address in column D. Anyhow here is code that you
> could place in the VBA module associated with the worksheet you would
> like to respond to changes by sending email. This code assumes that
> you want email to be sent when you change the subject line, but it
> would be straightforward to change that by modifying the event
> handler. I hope the rest is sufficiently clear.
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>     If Target.Row = 1 Then Exit Sub
>     If Target.Column > 1 Then Exit Sub
>     If Target.Offset(, 3).Value <> "" Then
>         Call SendMail(Target.Offset(, 3).Value, Target.Value)
>     End If
> End Sub
>
> Sub SendMail(strTo As String, strSubject As String)
>
>     Dim objOut As Outlook.Application
>     Dim objMail As Outlook.MailItem
>     Dim strBody As String
>
>     On Error Resume Next
>
>     Application.DisplayAlerts = False
>
>     Set objOut = New Outlook.Application
>     Set objMail = objOut.CreateItem(olMailItem)
>
>     strBody = "Hi Team:"
>     strBody = strBody & vbCrLf & vbCrLf & "Pls provide the email id
> for the email with above subject line."
>     strBody = strBody & vbCrLf & vbCrLf & "Thanks."
>
>     With objMail
>         .To = strTo
>         .Body = strBody
>         .Subject = strSubject
>         .Send
>     End With
>
>     Set objOut = Nothing
>     Application.DisplayAlerts = True
>
> End Sub
>
> Rolf Jaeger
> SoarentComputinghttp://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
>
> On Nov 18, 8:52 am, hemant shah  wrote:
>
>
>
> > Hello Everyone,
>
> > Can you help me with my query. I have updated everything i require in
> > the attached excel.
>
> > Regards,
>
> > Hemant Shah
>
> > Please do not print this email unless it is absolutely necessary.
>
> > The information contained in this electronic message and any
> > attachments to this message are intended for the exclusive use of the
> > addressee(s) and may contain proprietary, confidential or privileged
> > information. If you are not the intended recipient, you should not
> > disseminate, distribute or copy this e-mail. Please notify the sender
> > immediately and destroy all copies of this message and any
> > attachments.
>
> > WARNING: Computer viruses can be transmitted via email. The recipient
> > should check this email and any attachments for the presence of
> > viruses. The company accepts no liability for any damage caused by any
> > virus transmitted by this email.
>
> >www.wipro.com
>
> >  Book1.xls
> > 29KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Fwd: Urgent Help required

2009-11-20 Thread RolfJ

I am not quite clear exactly when you would like an email to be sent.
Is it when you change a cell in column A ('Subject Line') or when you
update an email address in column D. Anyhow here is code that you
could place in the VBA module associated with the worksheet you would
like to respond to changes by sending email. This code assumes that
you want email to be sent when you change the subject line, but it
would be straightforward to change that by modifying the event
handler. I hope the rest is sufficiently clear.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 Then Exit Sub
If Target.Column > 1 Then Exit Sub
If Target.Offset(, 3).Value <> "" Then
Call SendMail(Target.Offset(, 3).Value, Target.Value)
End If
End Sub

Sub SendMail(strTo As String, strSubject As String)

Dim objOut As Outlook.Application
Dim objMail As Outlook.MailItem
Dim strBody As String

On Error Resume Next

Application.DisplayAlerts = False

Set objOut = New Outlook.Application
Set objMail = objOut.CreateItem(olMailItem)

strBody = "Hi Team:"
strBody = strBody & vbCrLf & vbCrLf & "Pls provide the email id
for the email with above subject line."
strBody = strBody & vbCrLf & vbCrLf & "Thanks."

With objMail
.To = strTo
.Body = strBody
.Subject = strSubject
.Send
End With

Set objOut = Nothing
Application.DisplayAlerts = True

End Sub

Rolf Jaeger
SoarentComputing
http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm

On Nov 18, 8:52 am, hemant shah  wrote:
> Hello Everyone,
>
> Can you help me with my query. I have updated everything i require in
> the attached excel.
>
> Regards,
>
> Hemant Shah
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any
> attachments to this message are intended for the exclusive use of the
> addressee(s) and may contain proprietary, confidential or privileged
> information. If you are not the intended recipient, you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately and destroy all copies of this message and any
> attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of
> viruses. The company accepts no liability for any damage caused by any
> virus transmitted by this email.
>
> www.wipro.com
>
>  Book1.xls
> 29KViewDownload

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ How to sum on the basis of color

2009-11-20 Thread Sandeep

Hi Manoj,

I already suggested you the way which is possible using formula. I have a sound 
grip on formulas and didn't know one which let you handle the cell color. So 
the alternative is on Coding side which you already have.

BTW how you color cells. Is there any condtion for that (no matter if you 
aren't using that at this time) ? If yes then you may get you answer using 
formula.

Thanks & Regards
Sandeep
  - Original Message - 
  From: Manoj S Negi 
  To: excel-macros@googlegroups.com 
  Sent: Friday, November 20, 2009 8:36 PM
  Subject: Re: $$Excel-Macros$$ How to sum on the basis of color


  Hi Sandeep,

  Thanks for your consideration on this but i was looking for some kind of 
formula so that whenever any coloured cell get any value, the sum formula get 
update automatically.


  Unfeigned Regards
  Manoj S Negi
  Skype - manojsnegi



  On Fri, Nov 20, 2009 at 7:52 PM, Sandeep Kumar Maurya  
wrote:

Hi,

You can filter on the basis of color in excel 2007. And with that you can 
use subtotal(9,Range) for your data.

Subtotal don't sum those value which are hidden.

Thus you can get sum on the basis of color in excel 2007 using filter and 
subtotal.

But if you want to see both value at time then it is not possible using 
this method. There are many experienced person in the group who may help you 
out.

Regards
Sandeep



On Fri, Nov 20, 2009 at 5:30 PM, Dave Bonallack  
wrote:

  Hi Manoj,
  I've looked at XL2007, but it appears I was mis-informed. I see no 
built-in function for summing by colour. Sorry.

  Regards - Dave.


--
  Date: Thu, 19 Nov 2009 13:40:27 +0530

  Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
  From: manojsnegi.uttranc...@gmail.com
  To: excel-macros@googlegroups.com

  Thank you very much Dave.
  Can you suggest some clue how to do the same think in excel 2007 without 
macro.

  Unfeigned Regards
  Manoj S Negi
  Skype - manojsnegi



  -- Forwarded message --
  From: Dave Bonallack 
  Date: Thu, Nov 19, 2009 at 1:12 PM
  Subject: RE: $$Excel-Macros$$ How to sum on the basis of color
  To: "excel-macros@googlegroups.com" 



  Hi,
  The attached uses a macro to do your bidding. But I think XL2007 can do 
this without macros, but I only have XL2003.
  Regards - Dave
   

--
  Date: Thu, 19 Nov 2009 12:45:00 +0530
  Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
  From: manojsnegi.uttranc...@gmail.com

  To: excel-macros@googlegroups.com

  Hi All,

  please help on this


  Unfeigned Regards
  Manoj S Negi
  Skype - manojsnegi



  -- Forwarded message --
  From: Manoj S Negi 
  Date: Wed, Nov 18, 2009 at 12:56 PM
  Subject: $$Excel-Macros$$ How to sum on the basis of color
  To: excel-macros@googlegroups.com


  Hi All,


  Kindly help me out as I want to sum the no. as per the color. Is there 
any command by which we can sum the data as per color.


  Sheet is also attached for further reference.

  Hoping for a favorable response soon.


  Unfeigned Regards
  Manoj S Negi
  Skype - manojsnegi

  -- 
  
--
  Some important links for excel users:
  1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
  2. Excel tutorials at http://www.excel-macros.blogspot.com
  3. Learn VBA Macros at http://www.vbamacros.blogspot.com
  4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

   
  To post to this group, send email to excel-macros@googlegroups.com
  If you find any spam message in the group, please send an email to:
  Ayush Jain @ jainayus...@gmail.com or
  Ashish Jain @ 26may.1...@gmail.com
  <><><><><><><><><><><><><><><><><><><><><><>
  HELP US GROW !!
   
  We reach over 6,500 subscribers worldwide and receive many nice notes 
about the learning and support from the group. Our goal is to have 10,000 
subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
  2. Excel tutorials at http://www.excel-macros.blogspot.com
  3. Learn VBA Macros at http://www.vbamacros.blogspot.com
  4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

   
  To post to this group,

Re: $$Excel-Macros$$ How to sum on the basis of color

2009-11-20 Thread Manoj S Negi

Hi Sandeep,

Thanks for your consideration on this but i was looking for some kind of
formula so that whenever any coloured cell get any value, the sum formula
get update automatically.


Unfeigned Regards
Manoj S Negi
Skype - manojsnegi


On Fri, Nov 20, 2009 at 7:52 PM, Sandeep Kumar Maurya  wrote:

> Hi,
>
> You can filter on the basis of color in excel 2007. And with that you can
> use subtotal(9,Range) for your data.
>
> Subtotal don't sum those value which are hidden.
>
> Thus you can get sum on the basis of color in excel 2007 using filter and
> subtotal.
>
> But if you want to see both value at time then it is not possible using
> this method. There are many experienced person in the group who may help you
> out.
>
> Regards
> Sandeep
>
>
> On Fri, Nov 20, 2009 at 5:30 PM, Dave Bonallack  > wrote:
>
>>  Hi Manoj,
>> I've looked at XL2007, but it appears I was mis-informed. I see no
>> built-in function for summing by colour. Sorry.
>>
>> Regards - Dave.
>>
>> --
>> Date: Thu, 19 Nov 2009 13:40:27 +0530
>>
>> Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
>> From: manojsnegi.uttranc...@gmail.com
>> To: excel-macros@googlegroups.com
>>
>> Thank you very much Dave.
>> Can you suggest some clue how to do the same think in excel 2007 without
>> macro.
>>
>> Unfeigned Regards
>> Manoj S Negi
>> Skype - manojsnegi
>>
>>
>> -- Forwarded message --
>> From: *Dave Bonallack* 
>> Date: Thu, Nov 19, 2009 at 1:12 PM
>> Subject: RE: $$Excel-Macros$$ How to sum on the basis of color
>> To: "excel-macros@googlegroups.com" 
>>
>>
>>  Hi,
>> The attached uses a macro to do your bidding. But I think XL2007 can do
>> this without macros, but I only have XL2003.
>> Regards - Dave
>>
>> --
>> Date: Thu, 19 Nov 2009 12:45:00 +0530
>> Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
>> From: manojsnegi.uttranc...@gmail.com
>>
>> To: excel-macros@googlegroups.com
>>
>> Hi All,
>>
>> please help on this
>>
>>
>> Unfeigned Regards
>> Manoj S Negi
>> Skype - manojsnegi
>>
>>
>> -- Forwarded message --
>> From: *Manoj S Negi* 
>> Date: Wed, Nov 18, 2009 at 12:56 PM
>> Subject: $$Excel-Macros$$ How to sum on the basis of color
>> To: excel-macros@googlegroups.com
>>
>>
>> Hi All,
>>
>>
>> Kindly help me out as I want to sum the no. as per the color. Is there any
>> command by which we can sum the data as per color.
>>
>>
>> Sheet is also attached for further reference.
>>
>> Hoping for a favorable response soon.
>>
>>
>> *Unfeigned Regards
>> Manoj S Negi
>> Skype - manojsnegi*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. Let friends and co-workers know they can
>> subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>> --
>> Brought to you exclusively by Windows Live Download new and classic
>> emoticon packs at Emoticon 
>> World
>>
>> --
>>
>> -

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

2009-11-20 Thread SHIVA KUMAR

Hi Anil,

You can vlookup function.  Please see the attached file for your
information.

Regards,
R. SHIVAKUMAR

On Thu, Nov 19, 2009 at 10:28 AM, Anil Saxena wrote:

> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>Anil 100 Saxena 70 Guni 150 Sonu 50 Yash 65 Thakur 57 Mathur 49
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe

-- 
Regards,
R. SHIVAKUMAR

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Require help on a condition

2009-11-20 Thread Sandeep Kumar Maurya

Hi,

Find the attached sheet with formula.

Regards
Sandeep

On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S  wrote:

> pooja Sharma
>
> Find attached an excel file with vba macro.  place ur cursor anywhere in
> reference column and run macro... u will see result in next sheet Hope
> this helps
>
> Regards
> sivakumar
>
> On Thu, Nov 19, 2009 at 1:35 PM, Pooja Sharma wrote:
>
>> Hi All,
>>
>> I've attached a file in which, a data is mentioned with the required
>> solution. If any body can help me in this, it will be of great help.
>>
>> --
>> Best Regards
>> Pooja Sharma
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Conditional result.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to sum on the basis of color

2009-11-20 Thread Sandeep Kumar Maurya

Hi,

You can filter on the basis of color in excel 2007. And with that you can
use subtotal(9,Range) for your data.

Subtotal don't sum those value which are hidden.

Thus you can get sum on the basis of color in excel 2007 using filter and
subtotal.

But if you want to see both value at time then it is not possible using this
method. There are many experienced person in the group who may help you out.

Regards
Sandeep

On Fri, Nov 20, 2009 at 5:30 PM, Dave Bonallack
wrote:

>  Hi Manoj,
> I've looked at XL2007, but it appears I was mis-informed. I see no built-in
> function for summing by colour. Sorry.
>
> Regards - Dave.
>
> --
> Date: Thu, 19 Nov 2009 13:40:27 +0530
>
> Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
> From: manojsnegi.uttranc...@gmail.com
> To: excel-macros@googlegroups.com
>
> Thank you very much Dave.
> Can you suggest some clue how to do the same think in excel 2007 without
> macro.
>
> Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi
>
>
> -- Forwarded message --
> From: *Dave Bonallack* 
> Date: Thu, Nov 19, 2009 at 1:12 PM
> Subject: RE: $$Excel-Macros$$ How to sum on the basis of color
> To: "excel-macros@googlegroups.com" 
>
>
>  Hi,
> The attached uses a macro to do your bidding. But I think XL2007 can do
> this without macros, but I only have XL2003.
> Regards - Dave
>
> --
> Date: Thu, 19 Nov 2009 12:45:00 +0530
> Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
> From: manojsnegi.uttranc...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> Hi All,
>
> please help on this
>
>
> Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi
>
>
> -- Forwarded message --
> From: *Manoj S Negi* 
> Date: Wed, Nov 18, 2009 at 12:56 PM
> Subject: $$Excel-Macros$$ How to sum on the basis of color
> To: excel-macros@googlegroups.com
>
>
> Hi All,
>
>
> Kindly help me out as I want to sum the no. as per the color. Is there any
> command by which we can sum the data as per color.
>
>
> Sheet is also attached for further reference.
>
> Hoping for a favorable response soon.
>
>
> *Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi*
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
> --
> Brought to you exclusively by Windows Live Download new and classic
> emoticon packs at Emoticon 
> World
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, p

RE: $$Excel-Macros$$ How to sum on the basis of color

2009-11-20 Thread Dave Bonallack

Hi Manoj,
I've looked at XL2007, but it appears I was mis-informed. I see no built-in 
function for summing by colour. Sorry.

Regards - Dave.

Date: Thu, 19 Nov 2009 13:40:27 +0530
Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
From: manojsnegi.uttranc...@gmail.com
To: excel-macros@googlegroups.com

Thank you very much Dave.

Can you suggest some clue how to do the same think in excel 2007 without macro.
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi

-- Forwarded message --
From: Dave Bonallack 

Date: Thu, Nov 19, 2009 at 1:12 PM
Subject: RE: $$Excel-Macros$$ How to sum on the basis of color
To: "excel-macros@googlegroups.com" 

Hi,

The attached uses a macro to do your bidding. But I think XL2007 can do this 
without macros, but I only have XL2003.

Regards - Dave

Date: Thu, 19 Nov 2009 12:45:00 +0530
Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
From: manojsnegi.uttranc...@gmail.com

To: excel-macros@googlegroups.com

Hi All,

please help on this

Unfeigned Regards
Manoj S Negi
Skype - manojsnegi

-- Forwarded message --
From: Manoj S Negi 
Date: Wed, Nov 18, 2009 at 12:56 PM

Subject: $$Excel-Macros$$ How to sum on the basis of color
To: excel-macros@googlegroups.com

Hi All,

Kindly help me out as I want to sum the no. as per the color. Is there any 
command by which we can sum the data as per color.

Sheet is also attached for further reference.

Hoping for a favorable response soon.

Unfeigned Regards
Manoj S Negi
Skype - manojsnegi

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com

2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com

4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

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

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com

2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com

4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

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

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe   

Brought to you exclusively by Windows Live Download new and classic emoticon 
packs at Emoticon World

-- 

--

Some important links for excel users:

1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com

2. Excel tutorials at http://www.excel-macros.blogspot.com

3. Learn VBA Macros at http://www.vbamacros.blogspot.com

4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

If you find any spam message in the group, please send an email to:

Ayush Jain  @ jainayus...@gmail.com or

Ashish Jain @ 26may.1...@gmail.com

<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com

2. Excel tutorials at http://www.excel-macros.blogspot.com

3. Learn VBA Mac

Re: $$Excel-Macros$$ Re: Urgent Need help on formula.

2009-11-20 Thread vinod rao

HI Rolf

I got it, Thank you.
On Fri, Nov 20, 2009 at 2:42 PM, vinod rao  wrote:

> Hello Rolf,
>
> Can you plz put it in xls file?
> Thanks
> vr
>   On Fri, Nov 20, 2009 at 11:58 AM, RolfJ  wrote:
>
>> This might work for you. Let's assume that the total numbers of
>> minutes is located in cell A2. The following formulae would calculate
>> the number of whole days, hours of next fractional day and minutes of
>> next fractional hour:
>>
>> Number of days (Cell B2): =INT(A2/60/24)  -> 22 for your example
>> Hours of next fractional day (Cell C2): =INT((A2-B2*24*60)/60)  -> 9
>> for your example
>> Minutes of next fractional hour (Cell D2): =A2-B2*24*60-C2*60  -> 49
>> for your example
>>
>> Hope this helped,
>> Rolf Jaeger
>> SoarentComputing
>> http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
>>
>>  On Nov 19, 8:47 am, vinod rao  wrote:
>> > HI Friends,
>> >
>> > I have a question in excel formula,
>> >
>> > I have a number which gives total numbers of minuts, example 32269 and
>> it is
>> > minutes total. Can excel find numbe of days and hours and minutes in
>> that
>> > total.
>> >
>> > This is very urgent. kindly help
>> > Regards,
>> > Vr
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Change index number in filter mode

2009-11-20 Thread Aindril De

Hi Anil,

It seems the file you have attached has virus in it.
I have created a sample solution for you. Attaching the File.
Hope this Helps...

Let me know if u need further help.

Regards,
Andy

On Fri, Nov 20, 2009 at 1:47 PM, Anil Saxena wrote:

> Hi Ayush/Dilip
>
> plz How I can change index number in filter mode. Please suggest me as soon
> as possible.
>
> I am very thankful to you.
>
>
>
> Thanks & Regards,
>
>
> Anil Saxena
> +919971870460
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

ForAnil by Andy.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Urgent Help Needed

$$Excel-Macros$$ Urgent Help Needed

$$Excel-Macros$$ Add a column of matching numbers

$$Excel-Macros$$ Setting of Axes(xlCategory) for a chart-sheet in Excel 2007

Re: $$Excel-Macros$$ Require help on a condition

$$Excel-Macros$$ Re: Fwd: Urgent Help required

$$Excel-Macros$$ Re: Fwd: Urgent Help required

Re: $$Excel-Macros$$ How to sum on the basis of color

Re: $$Excel-Macros$$ How to sum on the basis of color

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

Re: $$Excel-Macros$$ Require help on a condition

Re: $$Excel-Macros$$ How to sum on the basis of color

RE: $$Excel-Macros$$ How to sum on the basis of color

Re: $$Excel-Macros$$ Re: Urgent Need help on formula.

Re: $$Excel-Macros$$ Change index number in filter mode

15 matches

Site Navigation

Mail list logo

Footer information