date:20110803

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Venkat CV

Dear Ashish,

Find attached Sample Worksheet with my requiremnt..
 *Best Regards,*
*Venkat*
*Chennai*

On Wed, Aug 3, 2011 at 12:01 PM, ashish koul  wrote:

> can you attach the worksheet
>
>
> On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV  wrote:
>
>> Dear All,
>>
>> Let me know how to Vlookup Including Cell Comments..in Each Cells...
>>
>>
>>
>> *Best Regards,*
>>  *Venkat*
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Vlookup Comments.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread sreejith k.s

hi Sanjay,

just see whether this helps...i created a pivot according to my
understanding of the quwestion...just get back to me if it is not enough

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Venkat CV

Hi Rajan,

Thanks for reply How can i give the inputs In Input boxes. Please explain


*Best Regards,*
*Venkat*
*Chennai*
*
*

On Wed, Aug 3, 2011 at 1:27 PM, Rajan_Verma wrote:

>  *See if it Helps :*
>
> * *
>
> *Sub VlookupByCodes()*
>
> * *
>
> *Dim ResultRange As Range*
>
> *Dim SearchRange As Range*
>
> *Dim ColNum As Integer*
>
> *Dim LookUpValue As Range*
>
> *Dim cellResult As Range*
>
> *Dim CellSearch As Range*
>
> *Dim i As Integer*
>
> * *
>
> *Set ResultRange = Application.InputBox("Select the Range Where
> You want Output", , , , , , , 8)*
>
> *Set LookUpValue = Application.InputBox("Select the Range of
> searchable Value", , , , , , , 8)*
>
> *Set SearchRange = Application.InputBox("Select the Range to
> Search Value", , , , , , , 8)*
>
> *ColNum = Application.InputBox("Give Colnum")*
>
> *i = 1*
>
> **
>
> *For Each cellResult In ResultRange*
>
> *For Each CellSearch In SearchRange*
>
> *If CellSearch.Value =
> LookUpValue.Cells(i, 1).Value Then*
>
> *cellResult.Value =
> CellSearch.Offset(0, ColNum).Value*
>
> *If
> hasComment(CellSearch.Offset(0, ColNum)) = True Then*
>
> *cellResult.AddComment
> *
>
> *
> cellResult.Comment.Visible = True*
>
> *
> cellResult.Comment.Text CellSearch.Offset(0, ColNum).Comment.Text*
>
> *End If*
>
> *i = i + 1*
>
> *Exit For*
>
> *End If*
>
> *Next*
>
> *Next*
>
> *Set ResultRange = Nothing*
>
> *Set LookUpValue = Nothing*
>
> *Set SearchRange = Nothing*
>
> *Set cellResult = Nothing*
>
> *Set CellSearch = Nothing*
>
> **
>
> *End Sub*
>
> * *
>
> * *
>
> *Private Function hasComment(cell As Range) As Boolean*
>
> *On Error GoTo err:*
>
> *If cell.Comment.Text <> "" Then*
>
> *hasComment = True*
>
> *Else*
>
> *hasComment = False*
>
> *End If*
>
> *err:*
>
> *If err.Number <> 0 Then*
>
> *hasComment = False*
>
> *End If*
>
> *End Function*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
> *Sent:* Wednesday, August 03, 2011 12:54 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Vlookup Including Cell Comments..
>
> ** **
>
> Dear Ashish,
>
>  
>
> Find attached Sample Worksheet with my requiremnt.. 
>
> *Best Regards,*
>
> *Venkat*
>
> *Chennai*
>
> ** **
>
> On Wed, Aug 3, 2011 at 12:01 PM, ashish koul 
> wrote:
>
> can you attach the worksheet 
>
> ** **
>
> On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV  wrote:*
> ***
>
> Dear All, 
>
> ** **
>
> Let me know how to Vlookup Including Cell Comments..in Each Cells...
>
> ** **
>
>
> 
>
> *Best Regards,*
>
> *Venkat*
>
> *Chennai*
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> 
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile ***
> *
>
>  
>
> P Before printing, think about the environment.
>
>  
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> ** **
>
> ** **
>
> **

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread Rupesh Shrivastava

Hi,
Please find the attached sheet with solution.

Thanks
Rupesh Kr.

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy of problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Rajan_Verma

Select the range according to the msg of Input Box

Like Vlookup Function : just give the Range to input box

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 03, 2011 2:09 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

Hi Rajan,

Thanks for reply How can i give the inputs In Input boxes. Please explain

Best Regards,

Venkat

Chennai

On Wed, Aug 3, 2011 at 1:27 PM, Rajan_Verma 
wrote:

See if it Helps :

Sub VlookupByCodes()

Dim ResultRange As Range

Dim SearchRange As Range

Dim ColNum As Integer

Dim LookUpValue As Range

Dim cellResult As Range

Dim CellSearch As Range

Dim i As Integer

Set ResultRange = Application.InputBox("Select the Range Where You
want Output", , , , , , , 8)

Set LookUpValue = Application.InputBox("Select the Range of
searchable Value", , , , , , , 8)

Set SearchRange = Application.InputBox("Select the Range to Search
Value", , , , , , , 8)

ColNum = Application.InputBox("Give Colnum")

i = 1

For Each cellResult In ResultRange

For Each CellSearch In SearchRange

If CellSearch.Value =
LookUpValue.Cells(i, 1).Value Then

cellResult.Value =
CellSearch.Offset(0, ColNum).Value

If
hasComment(CellSearch.Offset(0, ColNum)) = True Then

cellResult.AddComment

cellResult.Comment.Visible = True

cellResult.Comment.Text
CellSearch.Offset(0, ColNum).Comment.Text

End If

i = i + 1

Exit For

End If

Next

Next

Set ResultRange = Nothing

Set LookUpValue = Nothing

Set SearchRange = Nothing

Set cellResult = Nothing

Set CellSearch = Nothing

End Sub

Private Function hasComment(cell As Range) As Boolean

On Error GoTo err:

If cell.Comment.Text <> "" Then

hasComment = True

Else

hasComment = False

End If

err:

If err.Number <> 0 Then

hasComment = False

End If

End Function

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 03, 2011 12:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

Dear Ashish,

Find attached Sample Worksheet with my requiremnt.. 

Best Regards,

Venkat

Chennai

On Wed, Aug 3, 2011 at 12:01 PM, ashish koul  wrote:

can you attach the worksheet 

On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV  wrote:

Dear All, 

Let me know how to Vlookup Including Cell Comments..in Each Cells...

Best Regards,

Venkat

Chennai

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

Regards

Ashish Koul

  akoul.blogspot.com
http://akoul.posterous.com/

  akoul.wordpress.com

My   Linkedin Profile

P Before printing, think about the environment.

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

-- 
--

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Venkat CV

Done Rajan,

Thank u...

*
Best Regards,
*
*Venkat *
*Chennai*
*
*

On Wed, Aug 3, 2011 at 3:06 PM, Rajan_Verma wrote:

>  *Select the range according to the msg of Input Box*
>
> * *
>
> *Like Vlookup Function : just give the Range to input box*
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
> *Sent:* Wednesday, August 03, 2011 2:09 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Vlookup Including Cell Comments..
>
>  ** **
>
> Hi Rajan,
>
> ** **
>
> Thanks for reply How can i give the inputs In Input boxes. Please explain*
> ***
>
> ** **
>
> ** **
>
> *Best Regards,*
>
> *Venkat*
>
> *Chennai*
>
> ** **
>
> ** **
>
> On Wed, Aug 3, 2011 at 1:27 PM, Rajan_Verma 
> wrote:
>
> *See if it Helps :*
>
> * *
>
> *Sub VlookupByCodes()*
>
> * *
>
> *Dim ResultRange As Range*
>
> *Dim SearchRange As Range*
>
> *Dim ColNum As Integer*
>
> *Dim LookUpValue As Range*
>
> *Dim cellResult As Range*
>
> *Dim CellSearch As Range*
>
> *Dim i As Integer*
>
> * *
>
> *Set ResultRange = Application.InputBox("Select the Range Where
> You want Output", , , , , , , 8)*
>
> *Set LookUpValue = Application.InputBox("Select the Range of
> searchable Value", , , , , , , 8)*
>
> *Set SearchRange = Application.InputBox("Select the Range to
> Search Value", , , , , , , 8)*
>
> *ColNum = Application.InputBox("Give Colnum")*
>
> *i = 1*
>
> **
>
> *For Each cellResult In ResultRange*
>
> *For Each CellSearch In SearchRange*
>
> *If CellSearch.Value =
> LookUpValue.Cells(i, 1).Value Then*
>
> *cellResult.Value =
> CellSearch.Offset(0, ColNum).Value*
>
> *If
> hasComment(CellSearch.Offset(0, ColNum)) = True Then*
>
> *cellResult.AddComment
> *
>
> *
> cellResult.Comment.Visible = True*
>
> *
> cellResult.Comment.Text CellSearch.Offset(0, ColNum).Comment.Text*
>
> *End If*
>
> *i = i + 1*
>
> *Exit For*
>
> *End If*
>
> *Next*
>
> *Next*
>
> *Set ResultRange = Nothing*
>
> *Set LookUpValue = Nothing*
>
> *Set SearchRange = Nothing*
>
> *Set cellResult = Nothing*
>
> *Set CellSearch = Nothing*
>
> **
>
> *End Sub*
>
> * *
>
> * *
>
> *Private Function hasComment(cell As Range) As Boolean*
>
> *On Error GoTo err:*
>
> *If cell.Comment.Text <> "" Then*
>
> *hasComment = True*
>
> *Else*
>
> *hasComment = False*
>
> *End If*
>
> *err:*
>
> *If err.Number <> 0 Then*
>
> *hasComment = False*
>
> *End If*
>
> *End Function*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
> *Sent:* Wednesday, August 03, 2011 12:54 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Vlookup Including Cell Comments..
>
>  
>
> Dear Ashish,
>
>  
>
> Find attached Sample Worksheet with my requiremnt.. 
>
> *Best Regards,*
>
> *Venkat*
>
> *Chennai*
>
>  
>
> On Wed, Aug 3, 2011 at 12:01 PM, ashish koul 
> wrote:
>
> can you attach the worksheet 
>
>  
>
> On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV  wrote:*
> ***
>
> Dear All, 
>
>  
>
> Let me know how to Vlookup Including Cell Comments..in Each Cells...
>
>  
>
>
> 
>
> *Best Regards,*
>
> *Venkat*
>
> *Chennai*
>
>  
>
>  
>
>  
>
>  
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> 
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile

$$Excel-Macros$$ Macro to copy a block of formulas to other blocks

2011-08-03 Thread Pehrson, Dave

 

The attached is a worksheet that I'm working with, actually the data
runs to over 100,000 lines, but I have shortened the example.  Macro1
contains a formula that I wish to place into cells D4 to E9, then copy
and paste to the end of the data.

 

Note, each block is a set of 5 line for one part, so the formulas in
line D4 to E9 are different.  And must be copied in sets.  I can do it
manually, but the macro will not work.

 

 Currently I get an error when the process runs, but I don't know if my
program language in not correct, or is Visual Basic cannot do.  Any
suggestions?  Would removing the blank rows help?

 

Any support would be appreciated.

 

Thanks

Dave

 

 

David Pehrson

Materials Manager, Lawn and Garden North America

Walbro Engine Management, LLC

7400 North Oracle, Suite 311

Tucson, AZ  85704

Office (520) 229-5694

Cell (520) 780-1364

Fax (520) 877-3006

 

Confidentiality Notice: The materials contained within this e-mail
transmission (including all attachments) are private and confidential
and the property of the sender. The information contained in the
materials is priveleged and intended only for the named addressee(s). If
you are not the intended addressee, be advised that any unauthorized
disclosure, copying, distribution or the taking of any action in
reliance on the contents of this material is strictly prohibited. If you
have received this e-mail transmission in error, please immediately
notify the sender by telephone at 520-229-5694 or send an e-mail to 
dpehr...@walbro.com   and thereafter destroy
the e-mail you received and all copies thereof.

 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

wmx mrp with zero req Macro Test.xlsm
Description: wmx mrp with zero req Macro Test.xlsm

Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area

2011-08-03 Thread Guzal Yusupova

Thanks Rajan Verma and everybody for your replies and help!
~Guzal

On 1 авг, 16:30, "Rajan_Verma"  wrote:
> We cant use AutoFilter  on Multiple Row in A Single Sheet, If you want to
> Apply the Filter On Multiple Row , You have to Bifurcated your Data in to
> Separate Areas and then Convert them Used Area to Table , By Default ,Table
> Provides Automatic AutoFilter at The Heading Row,
>
> Hope I Could explain you ..
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of vijayajith VA
> Sent: Monday, August 01, 2011 4:38 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area
>
> Hi raj,
>
> Can you explain in detail .. i tried but i amnot getting
>
> Thanks
>
> On Mon, Aug 1, 2011 at 12:00 PM, Rajan_Verma 
> wrote:
>
> Spilt Your Date in Multiple Table
>
> See the attached file if it helps
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ashish koul
> Sent: Monday, August 01, 2011 11:44 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area
>
> Can you attach the sample sheet
>
> On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova <9uzal.yusup...@gmail.com>
> wrote:
>
> Is there any way to set up more than one filter in one sheet?
> Thank you!
>
> --
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel
>
> --
>
> Regards
>
> Ashish Koul
>
>   akoul.blogspot.comhttp://akoul.posterous.com/
>
>   akoul.wordpress.com
>
> My   Linkedin Profile
>
> P Before printing, think about the environment.
>
> --
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel
>
> --
>
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel
>
> --
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our pa

$$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread KAUSHIK SAVLA

Hi All,
How to import only selected data from another workbook?
Please help.

Regards,
Kaushik

-- 
Sent from Gmail for mobile | mobile.google.com

Kaushik Savla

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Rajan_Verma

Hi kaushik,
I think copy and paste is the best option for this 

Regards
Rajan

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, August 03, 2011 4:47 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help required on Importing Data

Hi All,
How to import only selected data from another workbook?
Please help.

Regards,
Kaushik

-- 
Sent from Gmail for mobile | mobile.google.com

Kaushik Savla

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Venkat CV

Hi Kaushik,

We can Copy Paste Else Link the Cells as Required data by using data
linking...workbook 1 to Workbook 2

*Best Regards,*
*Venkat *
*Chennai*

On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote:

> Hi All,
> How to import only selected data from another workbook?
> Please help.
>
> Regards,
> Kaushik
>
> --
> Sent from Gmail for mobile | mobile.google.com
>
> Kaushik Savla
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro to copy a block of formulas to other blocks

2011-08-03 Thread ashish koul

try this
Sub test()

Sheets("Filter Test").Select
  'Insert columns for filter forumulas

Range("C4").Select
Selection.EntireColumn.Insert
Selection.EntireColumn.Insert
Selection.EntireColumn.Insert
'fill in blanks is column C,D and E
Range("B3:E3").Select
Selection.FillRight

Range("D4").Formula = "=IF(SUM(E4:E8)>0,1,0)"
   Range("e4").Formula = "=SUM(F4:CO4)"
   Range("d4:e" & Range("a1048576").End(xlUp).Row).Select
Selection.FillDown
 For i = 9 To Range("a1048576").End(xlUp).Row
 Range("D" & i).Interior.Color = vbRed
Range("e" & i).Interior.Color = vbyellow
 Range("D" & i).Formula = "=SUM(d" & i - 1 & ":d" & i - 5 & ")"
 Range("e" & i).Formula = "=SUM(e" & i - 1 & ":e" & i - 5 & ")"
 i = i + 5

 Next


End Sub


On Wed, Aug 3, 2011 at 3:49 PM, Pehrson, Dave  wrote:

> The attached is a worksheet that I’m working with, actually the data runs
> to over 100,000 lines, but I have shortened the example.  Macro1 contains a
> formula that I wish to place into cells D4 to E9, then copy and paste to the
> end of the data.
>
> ** **
>
> Note, each block is a set of 5 line for one part, so the formulas in line
> D4 to E9 are different.  And must be copied in sets.  I can do it manually,
> but the macro will not work.
>
> ** **
>
>  Currently I get an error when the process runs, but I don’t know if my
> program language in not correct, or is Visual Basic cannot do.  Any
> suggestions?  Would removing the blank rows help?
>
> ** **
>
> Any support would be appreciated.
>
> ** **
>
> Thanks
>
> Dave
>
> ** **
>
> ** **
>
> David Pehrson
>
> Materials Manager, Lawn and Garden North America
>
> Walbro Engine Management, LLC
>
> 7400 North Oracle, Suite 311
>
> Tucson, AZ  85704
>
> Office (520) 229-5694
>
> Cell (520) 780-1364
>
> Fax (520) 877-3006
>
> ** **
>
> Confidentiality Notice: The materials contained within this e-mail
> transmission (including all attachments) are private and confidential and
> the property of the sender. The information contained in the materials is
> priveleged and intended only for the named addressee(s). If you are not the
> intended addressee, be advised that any unauthorized disclosure, copying,
> distribution or the taking of any action in reliance on the contents of this
> material is strictly prohibited. If you have received this e-mail
> transmission in error, please immediately notify the sender by telephone
> at 520-229-5694 or send an e-mail to 
> dpehr...@walbro.comand thereafter destroy the e-mail you 
> received and all copies thereof.
> 
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

$$Excel-Macros$$ Need to keep history of steps while running a macros

2011-08-03 Thread Guzal Yusupova

Hi Everybody!
Need your smart help again,
Here's the situation:
I have recorded macros for my repetitive task with assigned shortcut key to 
run the macros. When I run the macros all the history of steps I did (data 
editing mainly) before running the macros is erased - I can't push Ctrl+Z to 
go back to the step I need. Is it possible to keep the history of steps 
while the macros is running?
Thank you!
~Guzal

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: remove duplicates - is it a good code?

2011-08-03 Thread Stuart Redmann

On 1 Aug., bpascal123 wrote:
> Hi all Experts,
>
> Below is the code I produced following my learning of vba for Excel
> from excelvbasql.com. I would like to know if there is anything to be
> done about this code. I'm looking to learn from anyone who can share
> his/her experience.
>
> Cheers,

The code shows multiple deficiencies. I'll mark them at the places
where they appear.

> Option Explicit
>
> Sub DeleteDupl2()

Why does your sub not take any parameters? I'd have expected that it
would at least need to know from which Excel.Range it should remove
the duplicates.

> Application.Calculation = xlCalculationManual
> Application.ScreenUpdating = False
>
> Dim wb As Workbook
> Dim ws As Worksheet
> Set wb = ThisWorkbook
> Set ws = wb.Worksheets("sheet1")

A sheet named "sheet1" may not exist. Your code does not deal with
this gracefully.

> Dim lastr As Long, lastc As Long
> Dim i As Integer, j As Integer
> Dim icopy As Integer

This variable declaration style looks a lot like C. It is quite
confusing. Why don't you declare the variables at the places where you
actually use them?

> Dim Table() As Variant 'Array for all values
> Dim TableOK() As Variant 'Array for unique values

The variable names are quite non-descriptive. Instead of "Table" you
should name them "UnfilteredData" or "OriginalValues" or
"ValuesWithDuplicates". The same goes for "TableOK".

> Dim iOkSize As Integer, jOkSize As Integer 'Rows and column size
> for TableOK
> Dim iOK As Integer, jOk As Integer
> Dim idD As String 'to concatenate all values in a rows
> Dim idj As Integer 'loop variable to concatenate idD string
> Dim deleteSt As String
> deleteSt = "---%%%"
>
> lastr = ws.Cells(Rows.Count, 1).End(xlUp).Row
> lastc = ws.Range("A1").End(xlToRight).Column
> ReDim Table(lastr - 2, lastc)

If you invoke this sub on an empty sheet, you'll try to ReDim Table to
(-1, 256), which of course does not work. Furthermore, lastc will be
256 if there is only data in first column of the sheet. Have a look at
Worksheet.UsedRange, this is probably what you want. But keep in mind
that DeleteDupl2 should work on a range that is passed as input
parameter. Then you should add Subs like DeleteDupl2ForSelection and
DeleteDupl2ForUsedRange that can be launched via "Execute Macro" and
launch DeleteDupl2 with the appropriate parameter.

> ReDim TableOK(0, 0)
>
> '''Copy data into Array Table
> '''Concatenate column values into an addito
> For i = 2 To lastr
> For j = 0 To lastc - 1
> Table(i - 2, j) = ws.Cells(i, j + 1)
> Next j
> For idj = 1 To lastc
> idD = CStr(idD) & CStr(ws.Cells(i, idj))
> Next idj
> Table(i - 2, j) = CStr(idD)
> idD = ""
> Next i
>
> '''mark duplicates but keep untouched the original value
> For i = 0 To lastr - 2
> j = lastc
> idD = Table(i, j)
> For j = i + 1 To lastr - 2
> If CStr(Table(j, lastc)) = CStr(idD) And
> Right(CStr(Table(j, lastc)), 6) <> "---%%%" Then
> Table(j, lastc) = CStr(Table(j, lastc)) & "---%%%"
> End If
> Next j
> Next i
>
> Range(ws.Cells(2, 1), ws.Cells(lastr, lastc)).ClearContents
>
> '''Count unique values in Table
> For i = 0 To lastr - 2
> If CStr(Right(Table(i, lastc), 6)) <> deleteSt Then
> iOkSize = iOkSize + 1
> End If
> Next i
>
> iOkSize = iOkSize - 1
> jOkSize = lastc
>
> ReDim TableOK(iOkSize, jOkSize)
>
> ''Copy unique values into TableOK"
> For i = 0 To lastr - 2
> If CStr(Right(Table(i, lastc), 6)) <> deleteSt Then
> For j = 0 To lastc
> TableOK(iOK, jOk) = Table(i, j)
> jOk = jOk + 1
> Next j
> iOK = iOK + 1
> jOk = 0
> End If
> Next i
>
> ''Copy unique values in worksheet
>
> For i = 0 To iOkSize
> For j = 0 To jOkSize - 1
> ws.Cells(i + 2, j + 1) = TableOK(i, j)
> Next j
> Next i
>
> Application.Calculation = xlCalculationAutomatic
> Application.ScreenUpdating = True
>
> End Sub

Your algorithm works OK, but as you have noted, it is quite slow.
There are sevaral ways to make it faster:
(A) Replace the loops that read and write the data into the arrays by
a read operation that reads more than one cell at a time. You'll have
to work with VARIANT arrays, though, as this is what Excel uses
internally.
(B) Don't use strings as key for your array. Strings are quite slow.
Besides you'll get into trouble if you don't use some delimiting
character: With your current implementation the cells  aa  |  bb
will receive the same key as the cells   a  |   abb, so that your
algorithm will detect a false duplicate. Note that if you compare the
contents of the cells as strings, you'll be much slower when the cell
actually contains a

Re: $$Excel-Macros$$ National insurance calculator

2011-08-03 Thread srinivas m

Hi Rajan,

Thanks for providing VBA code. But it is not working properly.

In the attached sheet I will give Pers No , Niablepay and NI category
manually. the remaining things should caluclated by the excel automatically.

Have given one example in the attached sheet. Please review the sheet and
let me know if you have any queries.

Thanks and Regards,
Srinivas.

On Mon, Aug 1, 2011 at 7:07 PM, srinivas m  wrote:

>
>
> -- Forwarded message --
> From: Rajan_Verma 
> Date: Sat, Jul 30, 2011 at 6:09 PM
> Subject: RE: $$Excel-Macros$$ National insurance calculator
> To: excel-macros@googlegroups.com
>
>
>  *See the attached sheet.. Revert if any Queries :*
>
> * *
>
> *Private Sub Worksheet_Change(ByVal Target As Range)*
>
> *On Error Resume Next*
>
> *Dim val1 As Variant*
>
> * *
>
> *If Target.Column = 2 Then*
>
> *Application.EnableEvents = False*
>
> *val1 = Target.Value*
>
> **
>
> *If val1 = "" Then*
>
> *Target.Value = ""*
>
> *GoTo Err:*
>
> *End If*
>
> **
>
> *If val1 < 443 Then*
>
> *Target.Value = "0-442"*
>
> *GoTo Err:*
>
> *ElseIf val1 > 442 And val1 < 590 Then*
>
> *Target.Value = "442-589"*
>
> *GoTo Err:*
>
> *ElseIf val1 > 588 And val1 < 603 Then*
>
> *Target.Value = "589-602"*
>
> *GoTo Err:*
>
> *ElseIf val1 > 601 And val1 < 3338 Then*
>
> *Target.Value = "602-3337"*
>
> *GoTo Err:*
>
> *ElseIf val1 > 3336 And val1 < 3541 Then*
>
> *Target.Value = "3337-3540"*
>
> *GoTo Err:*
>
> *ElseIf val1 > 3539 Then*
>
> *Target.Value = ">3540"*
>
> *GoTo Err:*
>
> *End If*
>
> *Application.EnableEvents = True*
>
> *End If*
>
> *Err:*
>
> *Application.EnableEvents = True*
>
> * *
>
> *End Sub*
>
> * *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *srinivas m
> *Sent:* Saturday, July 30, 2011 4:34 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ National insurance calculator
>
> ** **
>
> Hi All,
>
>  
>
> This is srinivas from Hyderabad  working in a MNC company .
>
>  
>
> I support UK clients here. My job is processing payroll for UK clients on
> Monthly Basis.
>
>  
>
> Normally in UK we need to deduct National Insurance contribution from
> employee salary.
>
>  
>
> There are different NI catogories and for each category I have attached the
> Percentages.
>
>  
>
> Please find below the slabs for calculating national insuarence.
>
>  
>
> 0-442
>
> 442-589
>
> 589-601
>
> 602-3337
>
> 3337-3540
>
> >3540
>
>  
>
> The slabs are same for all the NI categories But the Percentages and
> rebates varies from category to category.
>
>  
>
> 1)In the attached sheet I will enter Pers No's of employees, Niablepay and
> NI category. Once I enter the Niable pay the Macro should divide the niable
> pay as per the above slabs.
>
>  
>
> 2) in the second step it should calculate National insuarance Contribution
> for both Employee and Employer as applicable rates.
>
>  
>
> I am attaching the complete information on the sheet.
>
>  
>
> kindly request you help me on this ??
>
>  
>
> Please let us me know if you need any additional information.
>
>  
>
> Many thanks in advance.
>
>  
>
> Thanks and Regards,
>
> Srinivas.M
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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 po

$$Excel-Macros$$ unable to run macro properly

2011-08-03 Thread KAUSHIK SAVLA

Hi All,

I am trying to run the below macro code in the attached file.
Code is running properly since i am not getting any error message.
But i am getting in Row D2 to H2 "TRUE" and not the calculation value.

Option Explicit

Sub SumifsFormula()
'
' SumifsFormula Macro
' Sumifs Formula for calculating current month total
'

'
Range("D2").Select
ActiveCell.FormulaR1C1 = _
"SUMIFS(D$3:D$200,$C$3:$C$20," > "&EOMONTH(MAX($D$3:$D$20),-1))"
Range("D2").Select
Selection.Copy
Range("D2:H2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Calculate

End Sub

Please help on this macros.

Regards,
kaushik savla

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Sumifs.xlsm
Description: Binary data

$$Excel-Macros$$ copy cell value from clicked hyperlink

2011-08-03 Thread vickey

Is there any way to to get cell value from clicked cell hyperlink.

i.e. if there is sr.no. 1 in cell A1 in sheet1 and it is hyper linked
with sheet2 the value of sheet1 A1 (1) should reflect in Sheet2 A1 or
anywhere.

Please help me out to get it solved.

thanks in advance..


vickey

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread Sanjay Maurya

Dear Frd

Thanks for your reply and solution but I have more data so pivot table
is not possible for it. if u have any easy format please tell me.

Thanks
Sanjay Kumar Maurya

On 8/3/11, sreejith k.s  wrote:
> hi Sanjay,
>
> just see whether this helps...i created a pivot according to my
> understanding of the quwestion...just get back to me if it is not enough
>
> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
> wrote:
>
>> Hi frds
>>
>> Please help me.
>>
>> --
>> ***Thanks
>> Sanjay Kumar Maurya*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
***Thanks
Sanjay Kumar Maurya*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Copy VLookup Formula to alternate columns and update Col_Index_num

2011-08-03 Thread Brilar

Hello all
I am using Excel 2007, have the need to validate a large amount of
data in one workbook which looks up data from a separate worksheet. My
main problem is the size of the sheet, number of columns goes from A
to OY in one instance, number of rows is easier only 500.
I have added an empty column next to each column of data in my main
spreadsheet, into these columns I want to add my Vlookup formula,
however each formula needs to be edited to bring in the appropriate
data based on the Col_index_num, which has to be incremented by 1 when
added to each alternate column. You can see that this is no easy task
manually, Once the formulas have been updated they need to be copied
down into each row in each alternate column.Can anyone please provide
me with a macro or script to undertake this task.

I have attempted to use record macro, but am getting lost in doing the
editing to get the correct code and sequence for the loop till end
bits.

Any help will be greatly appreciated

Regards

Brian

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Sanjay Maurya wants to chat

2011-08-03 Thread Sanjay Maurya

I've been using Google Talk and thought you might like to try it out.
We can use it to call each other for free over the internet. Here's an
invitation to download Google Talk. Give it a try!

---

Sanjay Maurya wants to stay in better touch using some of Google's coolest new
products.

If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-e218799e94-9e8078c012-3cFLKEwL_Oo2GtVVg_q5x4RzOa8
You'll need to click this link to be able to chat with Sanjay Maurya.

To get Gmail - a free email account from Google with over 2,800 megabytes of
storage - and chat with Sanjay Maurya, visit:
http://mail.google.com/mail/a-e218799e94-9e8078c012-3cFLKEwL_Oo2GtVVg_q5x4RzOa8

Gmail offers:
- Instant messaging right inside Gmail
- Powerful spam protection
- Built-in search for finding your messages and a helpful way of organizing
  emails into "conversations"
- No pop-up ads or untargeted banners - just text ads and related information
  that are relevant to the content of your messages

All this, and its yours for free. But wait, there's more! By opening a Gmail
account, you also get access to Google Talk, Google's instant messaging
service:

http://www.google.com/talk/

Google Talk offers:
- Web-based chat that you can use anywhere, without a download
- A contact list that's synchronized with your Gmail account
- Free, high quality PC-to-PC voice calls when you download the Google Talk
  client

We're working hard to add new features and make improvements, so we might also
ask for your comments and suggestions periodically. We appreciate your help in
making our products even better!

Thanks,
The Google Team

To learn more about Gmail and Google Talk, visit:
http://mail.google.com/mail/help/about.html
http://www.google.com/talk/about.html

(If clicking the URLs in this message does not work, copy and paste them into
the address bar of your browser).

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ how automate charts in 2010

2011-08-03 Thread XLS S

please find the links...


http://msdn.microsoft.com/en-us/library/hh227293.aspx
http://office-2010.iyogi.com/microsoft-excel-2010/automate-your-charts-with-pivot-tables-in-microsoft-excel-2010.html

On Wed, Aug 3, 2011 at 1:39 AM, The T  wrote:
> I inherited a large excel workbook, which has about 10 tabs each
> containing many charts. I new workbook is created for each customer by
> dumping data into it from access. Long story short, its seems like a
> big waste of time time to keep changing the new customer name on each
> chart. Has anyone done this in 2010? or in 2007 (assuming the code is
> close). Googling it results in downloading programs, seems like there
> was to be a simple way of doing this
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Copy VLookup Formula to alternate columns and update Col_Index_num

2011-08-03 Thread ashish koul

can you send us sample file

On Wed, Aug 3, 2011 at 7:42 PM, Brilar  wrote:

> Hello all
> I am using Excel 2007, have the need to validate a large amount of
> data in one workbook which looks up data from a separate worksheet. My
> main problem is the size of the sheet, number of columns goes from A
> to OY in one instance, number of rows is easier only 500.
> I have added an empty column next to each column of data in my main
> spreadsheet, into these columns I want to add my Vlookup formula,
> however each formula needs to be edited to bring in the appropriate
> data based on the Col_index_num, which has to be incremented by 1 when
> added to each alternate column. You can see that this is no easy task
> manually, Once the formulas have been updated they need to be copied
> down into each row in each alternate column.Can anyone please provide
> me with a macro or script to undertake this task.
>
> I have attempted to use record macro, but am getting lost in doing the
> editing to get the correct code and sequence for the loop till end
> bits.
>
> Any help will be greatly appreciated
>
> Regards
>
> Brian
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Ayush Jain

>
>   Hello Everyone,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>> July'11
>> He has posted 170 posts in July 2011 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum and but
>> achived this recognition for the first time.
>>
>He has also created a record of highest number of posts by any
individual in a month.

>
>>
>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
> for helping excel enthusiasts !! keep it up !!
>

  We as a group made a record of 1350+ posts in a month. Thanks
everyone...Thats really awesome. :)

>
>Keep posting.
>
>
>>  Regards
>> Ayush Jain
>> Group Manager
>>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need help on Email from Excel

2011-08-03 Thread hemant shah

Dear Team,

I need a help on emailing from excel itself.
I have explained all the steps in the attached excel.

Regards,

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread NOORAIN ANSARI

congrate Rajan Babu, Keep it up...

On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:

>Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and but
>>> achived this recognition for the first time.
>>>
>>He has also created a record of highest number of posts by any
> individual in a month.
>
>>
>>>
>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
>> for helping excel enthusiasts !! keep it up !!
>>
>
>   We as a group made a record of 1350+ posts in a month. Thanks
> everyone...Thats really awesome. :)
>
>>
>>Keep posting.
>>
>>
>>>  Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on Email from Excel

2011-08-03 Thread XLS S

try this

http://akoul.wordpress.com/category/email-through-excel-using-outlook/

On Wed, Aug 3, 2011 at 9:26 PM, hemant shah  wrote:
> Dear Team,
>
> I need a help on emailing from excel itself.
> I have explained all the steps in the attached excel.
>
> Regards,
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread XLS S

congrate  छैल-छबीले पुने वाले हंसमुख राजन बाबु.

On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:
>>> Hello Everyone,
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and but
>>> achived this recognition for the first time.
>
>    He has also created a record of highest number of posts by any
> individual in a month.
>>>
>>>
>>
>>    Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
>> for helping excel enthusiasts !! keep it up !!
>
>
>   We as a group made a record of 1350+ posts in a month. Thanks
> everyone...Thats really awesome. :)
>>
>>
>>    Keep posting.
>>
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>
>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Jorge Marques

if your data format doesn´t change i recomend using links, i use links for a
database which doesn´t change the format, but i have another database i have
to add new data every month which is always changing values and cells, for
that i use a copy paste macro which copies all the data by selecting certain
cells, or by a certain condition.

2011/8/3 Venkat CV 

> Hi Kaushik,
>
> We can Copy Paste Else Link the Cells as Required data by using data
> linking...workbook 1 to Workbook 2
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
> On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote:
>
>> Hi All,
>> How to import only selected data from another workbook?
>> Please help.
>>
>> Regards,
>> Kaushik
>>
>> --
>> Sent from Gmail for mobile | mobile.google.com
>>
>> Kaushik Savla
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>   *
> *
> *
> *
> *
> *
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread XLS S

Use paste special with paste link..

On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA  wrote:
> Hi All,
> How to import only selected data from another workbook?
> Please help.
>
> Regards,
> Kaushik
>
> --
> Sent from Gmail for mobile | mobile.google.com
>
> Kaushik Savla
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Sant Ram

congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
S),Noorain..

On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:

>   Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and but
>>> achived this recognition for the first time.
>>>
>>He has also created a record of highest number of posts by any
> individual in a month.
>
>>
>>>
>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
>> for helping excel enthusiasts !! keep it up !!
>>
>
>   We as a group made a record of 1350+ posts in a month. Thanks
> everyone...Thats really awesome. :)
>
>>
>>Keep posting.
>>
>>
>>>  Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards,
Santy

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ What is the Mean of Working Day??

2011-08-03 Thread XLS S

Working days = M-F in certain countries. S-F in some others... Less
public and religious and bank holidays less vacation days less sick
days less personal days less pater/maternal days less military service
days less study days less sabbaticals less compensating time off for
overtimeless
Sorry, no time left for work, gotta go, ...

I am right?


.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread XLS S

Thnx Santy...

On Thu, Aug 4, 2011 at 12:21 AM, Sant Ram  wrote:
> congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
> S),Noorain..
>
> On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:

 Hello Everyone,
 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 July'11
 He has posted 170 posts in July 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and but
 achived this recognition for the first time.
>>
>>    He has also created a record of highest number of posts by any
>> individual in a month.


>>>
>>>    Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other
>>> folks for helping excel enthusiasts !! keep it up !!
>>
>>
>>   We as a group made a record of 1350+ posts in a month. Thanks
>> everyone...Thats really awesome. :)
>>>
>>>
>>>    Keep posting.
>>>

 Regards
 Ayush Jain
 Group Manager
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>
>
>
> --
> Regards,
> Santy
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread XLS S

Hey Sanjay

Try to use Indirect Functionplease find the attachment



On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya  wrote:
> Dear Frd
>
> Thanks for your reply and solution but I have more data so pivot table
> is not possible for it. if u have any easy format please tell me.
>
> Thanks
> Sanjay Kumar Maurya
>
> On 8/3/11, sreejith k.s  wrote:
>> hi Sanjay,
>>
>> just see whether this helps...i created a pivot according to my
>> understanding of the quwestion...just get back to me if it is not enough
>>
>> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
>> wrote:
>>
>>> Hi frds
>>>
>>> Please help me.
>>>
>>> --
>>> ***Thanks
>>> Sanjay Kumar Maurya*
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread KAUSHIK SAVLA

Query on paste link - Should i select each worksheet of workbook and
do the paste special value paste link? If so then is there any
shortcut to link whole workbook to another workvook.

Regards,
Kaushik

On 8/4/11, XLS S  wrote:
> Use paste special with paste link..
>
> On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA 
> wrote:
>> Hi All,
>> How to import only selected data from another workbook?
>> Please help.
>>
>> Regards,
>> Kaushik
>>
>> --
>> Sent from Gmail for mobile | mobile.google.com
>>
>> Kaushik Savla
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> .
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
Sent from Gmail for mobile | mobile.google.com

Kaushik Savla

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Venkat CV

Hi SantRam,

Thank u so much...

*Best Regards,*
*Venkat *
*Chennai*

On Thu, Aug 4, 2011 at 12:21 AM, Sant Ram  wrote:

> congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
> S),Noorain..
>
> On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:
>
>>   Hello Everyone,

 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 July'11
 He has posted 170 posts in July 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and but
 achived this recognition for the first time.

>>>He has also created a record of highest number of posts by any
>> individual in a month.
>>
>>>

>>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other
>>> folks for helping excel enthusiasts !! keep it up !!
>>>
>>
>>   We as a group made a record of 1350+ posts in a month. Thanks
>> everyone...Thats really awesome. :)
>>
>>>
>>>Keep posting.
>>>
>>>
  Regards
 Ayush Jain
 Group Manager

>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards,
> Santy
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Venkat CV

Dear Rajan& Ashish, Dilip,Sunny(XLS S), Noorain,...


Congrats Everyone...

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:

>   Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and but
>>> achived this recognition for the first time.
>>>
>>He has also created a record of highest number of posts by any
> individual in a month.
>
>>
>>>
>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
>> for helping excel enthusiasts !! keep it up !!
>>
>
>   We as a group made a record of 1350+ posts in a month. Thanks
> everyone...Thats really awesome. :)
>
>>
>>Keep posting.
>>
>>
>>>  Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ how automate charts in 2010

2011-08-03 Thread Venkat CV

Hi,

Find Below Links it may helps...

http://www.teachexcel.com/excel-help/excel-how-to.php?i=180693
http://www.vbaexpress.com/forum/archive/index.php/t-21697.html

*Best Regards,*
*Venkat *
*Chennai*



On Wed, Aug 3, 2011 at 1:39 AM, The T  wrote:

> I inherited a large excel workbook, which has about 10 tabs each
> containing many charts. I new workbook is created for each customer by
> dumping data into it from access. Long story short, its seems like a
> big waste of time time to keep changing the new customer name on each
> chart. Has anyone done this in 2010? or in 2007 (assuming the code is
> close). Googling it results in downloading programs, seems like there
> was to be a simple way of doing this
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ What is the Mean of Working Day??

2011-08-03 Thread Venkat CV

Hi,

Look Below Link..

http://office.microsoft.com/en-us/excel-help/workday-HP005209339.aspx
http://www.exceltip.com/st/Calculating_the_Number_of_Business_Days_in_a_Specified_Period/918.html

*Best Regards,*
*Venkat *
*Chennai*

On Thu, Aug 4, 2011 at 12:33 AM, XLS S  wrote:

> Working days = M-F in certain countries. S-F in some others... Less
> public and religious and bank holidays less vacation days less sick
> days less personal days less pater/maternal days less military service
> days less study days less sabbaticals less compensating time off for
> overtimeless
> Sorry, no time left for work, gotta go, ...
>
> I am right?
>
>
>
> .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Venkat CV

Hi Kaushik

You Have to Select Entire Page on Copying time as well Paste special and use
As told Mr XLS S Steps


*Best Regards,*
*Venkat *
*Chennai*

On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA wrote:

> Query on paste link - Should i select each worksheet of workbook and
> do the paste special value paste link? If so then is there any
> shortcut to link whole workbook to another workvook.
>
> Regards,
> Kaushik
>
> On 8/4/11, XLS S  wrote:
> > Use paste special with paste link..
> >
> > On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA 
> > wrote:
> >> Hi All,
> >> How to import only selected data from another workbook?
> >> Please help.
> >>
> >> Regards,
> >> Kaushik
> >>
> >> --
> >> Sent from Gmail for mobile | mobile.google.com
> >>
> >> Kaushik Savla
> >>
> >> --
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 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
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >
> >
> >
> > --
> > .
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
> --
> Sent from Gmail for mobile | mobile.google.com
>
> Kaushik Savla
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread XLS S

Hey Kaushik,

can you attach the worksheet

and also..easy way to make link file..just create
workbook shortcut and use





On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA  wrote:
> Query on paste link - Should i select each worksheet of workbook and
> do the paste special value paste link? If so then is there any
> shortcut to link whole workbook to another workvook.
>
> Regards,
> Kaushik
>
> On 8/4/11, XLS S  wrote:
>> Use paste special with paste link..
>>
>> On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA 
>> wrote:
>>> Hi All,
>>> How to import only selected data from another workbook?
>>> Please help.
>>>
>>> Regards,
>>> Kaushik
>>>
>>> --
>>> Sent from Gmail for mobile | mobile.google.com
>>>
>>> Kaushik Savla
>>>
>>> --
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> .
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
> Sent from Gmail for mobile | mobile.google.com
>
> Kaushik Savla
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Job

2011-08-03 Thread XLS S

 The sender of this email is registered with Naukri.com as Source One
Management Services Pvt.Ltd

*Dear Candidate,*

Hi !

Hope you are doing well !!

This is Farheeen from SourceOne. Source One (www.msourceone.com) one of the
fastest growing

company from India needs many candidates on vba

location:BANGALORE with 3-6 years of experience



Only those candidates who can join us in 10days notice period after offer,
should apply.
Your employment with Source One would be permanent after selection and would
be
deputed at multi b$ MNC for a long term project. Salary and long term career
opportunity
with Source One would be excellent.


Kindly send your updated CV with below input if you would be interested for
this

opportunity.

Your Contact Number:

Present Company Name location:

Total Exp :

Date of Birth:

Are you working at present (Y/N):

If not please specify reason for not working:

Present Employment (Permanent or Contract):

Current Salary:

Expected minimum salary:

What is your current Notice Period:

Willing to join Source One in 7-10 Days or Immediate, please specify:

Please specify your reason for change:

Willing to relocate.

Thanks & Regards,
_

Farheen S
Source One Management Services Pvt Ltd,
E-Mail:farhee...@msourceone.com;
URL : www.msourceone.com, www.sourceone.co.in

Is this job relevant to you?
Yes
No
 Your
feedback would help us in sending you the most relevant job opportunities
Disclaimer:
 The sender of this email is registered with naukri.com as *Source One
Management Services Pvt.Ltd* (f...@msourceone.com, *, BANGALORE, Karnataka -
560001) using Naukri.com services. The responsibility of checking the
authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you may:

   1. Report abuse by forwarding this email to: complia...@naukri.com
   2. You can also Block this
Companyfrom
searching your resume in the database.


Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise.
   *To be on the top of Employer's Resume Search
Update Your Resume Now
*  *Your CV has only 30 seconds to impress a Recruiter. Use Resume
Services& see
difference!
*



-- 

-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Dilip Pandey

Congratulations Rajan...!!

Regards,
DILIPandey

On 8/3/11, Ayush Jain  wrote:
>>
>>   Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and but
>>> achived this recognition for the first time.
>>>
>>He has also created a record of highest number of posts by any
> individual in a month.
>
>>
>>>
>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
>> for helping excel enthusiasts !! keep it up !!
>>
>
>   We as a group made a record of 1350+ posts in a month. Thanks
> everyone...Thats really awesome. :)
>
>>
>>Keep posting.
>>
>>
>>>  Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ What is the Mean of Working Day??

2011-08-03 Thread Dilip Pandey

ha ha ha!!
This is a kind of dilemma which every user experiences while working
with Date & Time calculations.  Best option is to define the holidays
and use functions like networkday and workday.

Regards,
DILIPandey

On 8/4/11, XLS S  wrote:
> Working days = M-F in certain countries. S-F in some others... Less
> public and religious and bank holidays less vacation days less sick
> days less personal days less pater/maternal days less military service
> days less study days less sabbaticals less compensating time off for
> overtimeless
> Sorry, no time left for work, gotta go, ...
>
> I am right?
>
>
> .
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Microsoft Excel 2010 function translations

2011-08-03 Thread Dilip Pandey

Nice work!!

Thanks,
DILIPandey

On 8/4/11, XLS S  wrote:
> Hey All,
>
>
> In Microsoft Excel the names of functions depend on the language of
> the installed version of MS-Office. Here's a table containing the
> Excel function names in 16 languages
> --
> .
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread karan 1237

I knewcongrats Rajan..!!!

You are great...!!!


~~~
Karan
www.karanxel.blogspot.com
**



On Thu, Aug 4, 2011 at 9:50 AM, Dilip Pandey  wrote:

> Congratulations Rajan...!!
>
> Regards,
> DILIPandey
>
> On 8/3/11, Ayush Jain  wrote:
> >>
> >>   Hello Everyone,
> >>>
> >>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> >>> July'11
> >>> He has posted 170 posts in July 2011 and helped many people through his
> >>> expertise. He has been consistent contributor to this excel forum and
> but
> >>> achived this recognition for the first time.
> >>>
> >>He has also created a record of highest number of posts by any
> > individual in a month.
> >
> >>
> >>>
> >>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other
> folks
> >> for helping excel enthusiasts !! keep it up !!
> >>
> >
> >   We as a group made a record of 1350+ posts in a month. Thanks
> > everyone...Thats really awesome. :)
> >
> >>
> >>Keep posting.
> >>
> >>
> >>>  Regards
> >>> Ayush Jain
> >>> Group Manager
> >>>
> >>
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread ashish koul

Congrats Rajan

On Thu, Aug 4, 2011 at 10:13 AM, karan 1237  wrote:

> I knewcongrats Rajan..!!!
>
> You are great...!!!
>
>
> ~~~
> Karan
> www.karanxel.blogspot.com
> **
>
>
>
> On Thu, Aug 4, 2011 at 9:50 AM, Dilip Pandey  wrote:
>
>> Congratulations Rajan...!!
>>
>> Regards,
>> DILIPandey
>>
>> On 8/3/11, Ayush Jain  wrote:
>> >>
>> >>   Hello Everyone,
>> >>>
>> >>> Rajan Verma has been selected as 'Most Helpful Member' for the month
>> of
>> >>> July'11
>> >>> He has posted 170 posts in July 2011 and helped many people through
>> his
>> >>> expertise. He has been consistent contributor to this excel forum and
>> but
>> >>> achived this recognition for the first time.
>> >>>
>> >>He has also created a record of highest number of posts by any
>> > individual in a month.
>> >
>> >>
>> >>>
>> >>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other
>> folks
>> >> for helping excel enthusiasts !! keep it up !!
>> >>
>> >
>> >   We as a group made a record of 1350+ posts in a month. Thanks
>> > everyone...Thats really awesome. :)
>> >
>> >>
>> >>Keep posting.
>> >>
>> >>
>> >>>  Regards
>> >>> Ayush Jain
>> >>> Group Manager
>> >>>
>> >>
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 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
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> > http://www.facebook.com/discussexcel
>> >
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>>   MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ copy cell value from clicked hyperlink

2011-08-03 Thread Dilip Pandey

Hi Vickey,

Based on your description, attached is the solution.  Let us know if this works.

Thanks,
DILIPandey

On 8/3/11, vickey  wrote:
> Is there any way to to get cell value from clicked cell hyperlink.
>
> i.e. if there is sr.no. 1 in cell A1 in sheet1 and it is hyper linked
> with sheet2 the value of sheet1 A1 (1) should reflect in Sheet2 A1 or
> anywhere.
>
> Please help me out to get it solved.
>
> thanks in advance..
>
>
> vickey
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Hyperlink by DILIPandey.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ VBA macro runs fine, but freezes if I try to do ANYTHING else while it's running

2011-08-03 Thread Rruffpaw

I have a very large Excel spreadsheet (13 MB) with several macros. One
of them runs a loop with multiple commands.

The macro runs fine, as long as I sit back and just watch it run. If I
click on another window however, it invariably freezes and I have to
terminate Excel.

Any ideas on how I can remedy this?

I'm running Excel 2003 on Windows XP, but have noticed the same
problem with the same spreadsheet on a machine running Excel 2007,
also on Windows XP.

Thanks

-Sharat

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: FW: $$Excel-Macros$$ Need help on MIS

2011-08-03 Thread Amit Desai

Dear Praksh,

Thanks a lot for your help. It worked..

I have tried countifs function before passing on to the group...but could
not get success. Do you have more some writeups on details of how & where to
use countifs, sumifs etc...

Best Regards,
Amit

On Wed, Aug 3, 2011 at 8:59 PM, Prakash Paul  wrote:

> Dear Amit,
>
> I have completed the report.  Could you check and tell whether it is
> sufficent for you.
>
> Give your feed back.
>
> Regards
> Paul
>
>  On Wed, Aug 3, 2011 at 2:18 PM, Amit Desai wrote:
>
>>   Dear All,
>>
>> ** **
>>
>> Please help me on this at the earliest…
>>
>> ** **
>>
>> I need your help *for giving correct formula *on MIS preparation. I have
>> attached one excel file with 3 work sheet ;
>>
>> 1) 2 MIS format on first 2 worksheet & 
>>
>> 2) sample data on last work sheet.
>>
>>  
>>
>> I need say count of Opening stock with several criteria, down time with
>> several criteria etc
>>
>> For each head criterias are written below MIS format.
>>
>>  
>>
>> Thanks a lot in Advance...
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai
>> *Sent:* 02 August 2011 21:10
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* RE: $$Excel-Macros$$ Need help on MIS
>>
>>   ** **
>>
>> Dear All,
>>
>> ** **
>>
>> Please help me on this at the earliest…
>>
>> ** **
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai
>> *Sent:* 01 August 2011 17:29
>> *To:* excel-macros@googlegroups.com
>> *Subject:* FW: $$Excel-Macros$$ Need help on MIS
>>
>> ** **
>>
>> Dear All,
>>
>> ** **
>>
>> Please help me on this at the earliest…
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai
>> *Sent:* 30 July 2011 09:59
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Need help on MIS
>>
>> ** **
>>
>> Dear Expert,
>>
>>  
>>
>> I need your help *for giving correct formula *on MIS preparation. I have
>> attached one excel file with 3 work sheet ;
>>
>> 1) 2 MIS format on first 2 worksheet & 
>>
>> 2) sample data on last work sheet.
>>
>>  
>>
>> I need say count of Opening stock with several criteria, down time with
>> several criteria etc
>>
>> For each head criterias are written below MIS format.
>>
>>  
>>
>> Thanks a lot in Advance...
>>
>>  
>>
>> Best Regards,
>>
>> Amit
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linked

$$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread tuffhu...@yahoo.com

Hello!

First post, so bear with me.

I'm a novice VBA user (and love it!), but here is what I want to do:
I want to create a data-validated list box whose options changed based
on entries in an original list box. For example, the first list box
would contain product manufacturers, and the second list box would
contain products names (based on the manufacturer chosen).

I understand that in an excel sheet, the indirect function works
well.  I just can't seem to make this work using user forms.

Thanks much for your help.

Robb

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread always online

Dear Friends

Thank your very much for your great reply.
may u define this formula. I can not find any source for *Groups* . I am
using that other place that function is not working.

Thanks again
Sanjay Kumar Maurya

On Thu, Aug 4, 2011 at 5:18 AM, XLS S  wrote:

> Hey Sanjay
>
> Try to use Indirect Functionplease find the attachment
>
>
>
> On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya 
> wrote:
> > Dear Frd
> >
> > Thanks for your reply and solution but I have more data so pivot table
> > is not possible for it. if u have any easy format please tell me.
> >
> > Thanks
> > Sanjay Kumar Maurya
> >
> > On 8/3/11, sreejith k.s  wrote:
> >> hi Sanjay,
> >>
> >> just see whether this helps...i created a pivot according to my
> >> understanding of the quwestion...just get back to me if it is not enough
> >>
> >> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
> >> wrote:
> >>
> >>> Hi frds
> >>>
> >>> Please help me.
> >>>
> >>> --
> >>> ***Thanks
> >>> Sanjay Kumar Maurya*
> >>>
> >>> --
> >>>
> >>>
> --
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip
> >>> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> >>> 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
> >>>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> Like our page on facebook , Just follow below link
> >>> http://www.facebook.com/discussexcel
> >>>
> >>
> >> --
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 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
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >
> >
> > --
> > ***Thanks
> > Sanjay Kumar Maurya*
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
>
> --
> .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Brajesh Kumar Porwal

Congratulations RajanKeep it up.

-- 
-- 
One Team One Dream One Goal

Warm Regards,
Brajesh Kumar Porwal
"We can't Spell S_ccess without U"

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




On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:

>   Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and but
>>> achived this recognition for the first time.
>>>
>>He has also created a record of highest number of posts by any
> individual in a month.
>
>>
>>>
>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
>> for helping excel enthusiasts !! keep it up !!
>>
>
>   We as a group made a record of 1350+ posts in a month. Thanks
> everyone...Thats really awesome. :)
>
>>
>>Keep posting.
>>
>>
>>>  Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Rajan_Verma

Thank You All, J

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Brajesh Kumar Porwal
Sent: Thursday, August 04, 2011 10:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

 

 

Congratulations RajanKeep it up.

 

-- 

-- 
One Team One Dream One Goal 

Warm Regards,
Brajesh Kumar Porwal
"We can't Spell S_ccess without U" 

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

 

 

 

On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain  wrote:

Hello Everyone,


Rajan Verma has been selected as 'Most Helpful Member' for the month of
July'11

He has posted 170 posts in July 2011 and helped many people through his
expertise. He has been consistent contributor to this excel forum and but
achived this recognition for the first time.   

   He has also created a record of highest number of posts by any
individual in a month. 

 

   Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
for helping excel enthusiasts !! keep it up !!

 

  We as a group made a record of 1350+ posts in a month. Thanks
everyone...Thats really awesome. :)

 

   Keep posting.

 

Regards
Ayush Jain
Group Manager

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel





-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread Prakash Paul

Dear Robb,

I have attached a simple example on drop down list box.

Based on the first selection the details in the second list box get
changed.  Similarly in the third list box.

1.  name the range
2.  go data ---> data validation ---> select list box
3.  use indirect function to call the named range

Hope this example is sufficient for you.

Regards
Paul


On Thu, Aug 4, 2011 at 5:21 AM, tuffhu...@yahoo.com wrote:

> Hello!
>
> First post, so bear with me.
>
> I'm a novice VBA user (and love it!), but here is what I want to do:
> I want to create a data-validated list box whose options changed based
> on entries in an original list box. For example, the first list box
> would contain product manufacturers, and the second list box would
> contain products names (based on the manufacturer chosen).
>
> I understand that in an excel sheet, the indirect function works
> well.  I just can't seem to make this work using user forms.
>
> Thanks much for your help.
>
> Robb
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


drop down example.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread Dilip Pandey

Hi Rob,

Attached is the solution to your query.
It may not be a perfect one, but tried it as it came to mind :)

Regards,
DILIPandey

On 8/4/11, tuffhu...@yahoo.com  wrote:
> Hello!
>
> First post, so bear with me.
>
> I'm a novice VBA user (and love it!), but here is what I want to do:
> I want to create a data-validated list box whose options changed based
> on entries in an original list box. For example, the first list box
> would contain product manufacturers, and the second list box would
> contain products names (based on the manufacturer chosen).
>
> I understand that in an excel sheet, the indirect function works
> well.  I just can't seem to make this work using user forms.
>
> Thanks much for your help.
>
> Robb
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


list box - data validation by DILIPandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Plz help me how can posible

2011-08-03 Thread Dilip Pandey

Hi,

I just replied to this post, but wonder where that gone.
Anil, please wait for some time and search that again. Let me know if
you do not find the same, I'll send another one.

Regards,
DILIPandey

On 8/4/11, Anil Saxena  wrote:
> Hi All,
> Plz find the attached file and solved this query.
> How can used the hyperlink the same.
>
>
> 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Mostly Uses Excel 2007 Short cut key

2011-08-03 Thread NOORAIN ANSARI

   *Short Key* *Activity* Alt+A+Q Advance Filter Alt+D+F+A Advance Filter
Alt+D+P Pivot Table Alt+E+I+S Fill Series Alt+E+L Delete Sheet Alt+H+B For
Border Alt+H+F Font Colour Alt+H+F+P Format Painter Alt+H+FF Font Alt+H+FS Font
Size Alt+H+H Them Colour Alt+H+I Insert Alt+H+L Conditional Formating
Alt+H+S Sort Normally Alt+D+S Sorting Alt+M+M+D Define Name Alt+M+N Name
Manager Alt+N+C Insert Column Chart Alt+N+E Pie Chart Alt+N+E Bar Chart
Alt+N+K Insert Chart Alt+N+N Line Chart Alt+N+V+C Pivot Chart Alt+N+V+T Pivot
Table Alt+O+DL Conditional Formating Alt+O+H+R Rename Of Sheet Alt+E+L Delete
Current Sheet Alt+R+P+S Protect Sheet Alt+T+G Goal Seak Alt+W+F+F Freeze
Alt+D+E Text To Column Alt+A+E Text To Column Alt+D+L Data Validation
Alt+A+V+V Data Validation CTRL+9 Hides The Selected Rows. CTRL+0 Hides The
Selected Columns.
-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Mostly Uses Excel 2007 Short cut key

2011-08-03 Thread Venkat CV

Hi Noorain,

it Relay Helps to Every one...Good...

*Best Regards,*
*Venkat *
*Chennai*


On Thu, Aug 4, 2011 at 11:49 AM, NOORAIN ANSARI wrote:

>
> *Short Key* *Activity*  Alt+A+Q Advance Filter  Alt+D+F+A Advance
> Filter  Alt+D+P Pivot Table  Alt+E+I+S Fill Series  Alt+E+L Delete Sheet
> Alt+H+B For Border  Alt+H+F Font Colour  Alt+H+F+P Format Painter
> Alt+H+FF Font  Alt+H+FS Font Size  Alt+H+H Them Colour  Alt+H+I Insert
> Alt+H+L Conditional Formating  Alt+H+S Sort Normally  Alt+D+S Sorting
> Alt+M+M+D Define Name  Alt+M+N Name Manager  Alt+N+C Insert Column Chart
> Alt+N+E Pie Chart  Alt+N+E Bar Chart  Alt+N+K Insert Chart  Alt+N+N Line
> Chart  Alt+N+V+C Pivot Chart  Alt+N+V+T Pivot Table  Alt+O+DL Conditional
> Formating  Alt+O+H+R Rename Of Sheet  Alt+E+L Delete Current Sheet
> Alt+R+P+S Protect Sheet  Alt+T+G Goal Seak  Alt+W+F+F Freeze  Alt+D+E Text
> To Column  Alt+A+E Text To Column  Alt+D+L Data Validation  Alt+A+V+V Data
> Validation  CTRL+9 Hides The Selected Rows.  CTRL+0 Hides The Selected
> Columns.
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Mostly Uses Excel 2007 Short cut key

2011-08-03 Thread Dilip Pandey

Nice collection. . .

Regards,
DILIPandey

On 8/4/11, NOORAIN ANSARI  wrote:
>*Short Key* *Activity* Alt+A+Q Advance Filter Alt+D+F+A Advance Filter
> Alt+D+P Pivot Table Alt+E+I+S Fill Series Alt+E+L Delete Sheet Alt+H+B For
> Border Alt+H+F Font Colour Alt+H+F+P Format Painter Alt+H+FF Font Alt+H+FS
> Font
> Size Alt+H+H Them Colour Alt+H+I Insert Alt+H+L Conditional Formating
> Alt+H+S Sort Normally Alt+D+S Sorting Alt+M+M+D Define Name Alt+M+N Name
> Manager Alt+N+C Insert Column Chart Alt+N+E Pie Chart Alt+N+E Bar Chart
> Alt+N+K Insert Chart Alt+N+N Line Chart Alt+N+V+C Pivot Chart Alt+N+V+T
> Pivot
> Table Alt+O+DL Conditional Formating Alt+O+H+R Rename Of Sheet Alt+E+L
> Delete
> Current Sheet Alt+R+P+S Protect Sheet Alt+T+G Goal Seak Alt+W+F+F Freeze
> Alt+D+E Text To Column Alt+A+E Text To Column Alt+D+L Data Validation
> Alt+A+V+V Data Validation CTRL+9 Hides The Selected Rows. CTRL+0 Hides The
> Selected Columns.
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
Sent from my mobile device

Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

59 matches

Mail list logo