RE: $$Excel-Macros$$ vba for loops -beginner

[Rajan_Verma]

Please Attach Your Code and Workbook

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of netuser501
Sent: Sunday, July 24, 2011 6:37 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ vba for loops -beginner

I'm looking more for an explanation, why cells.(r+1,1) = ""  is not
working?

I have to use rng.Rows.Count always to do the equivalent?

Thanks

On Jul 24, 7:38 am, "Rajan_Verma"  wrote:
> See if it Helps
>
> Option Base 1
> Sub StoreInArrya()
>     Dim Arr() As Variant
>     Dim rng As Range
>     Dim Rw As Integer
>     Dim Cl As Integer
>
>     Set rng = Range("A1:C5")
>     ReDim Arr(rng.Cells.Rows.Count, rng.Cells.Columns.Count)
>
>             For Rw = 1 To rng.Rows.Count
>                     For Cl = 1 To rng.Columns.Count
>                     Arr(Rw, Cl) = rng.Cells(Rw, Cl).Value
>                     Next
>             Next
>
>                For Rw = 1 To rng.Rows.Count
>                     For Cl = 1 To rng.Columns.Count
>                     st = st & vbTab & Arr(Rw, Cl)
>                     Next
>                     st = st & vbCrLf
>                 Next
>                MsgBox st
> End Sub
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of netuser501
> Sent: Sunday, July 24, 2011 6:42 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ vba for loops -beginner
>
> Hi
>
> The question worksheets is filled with data on 5 rows and 3 columns.
> I'd like to have this data stored in an Array. For testing purpose, I
> want to test if the loop is "reading" the data with an integer "tmp"
> that should return the number of cells filled in with data.
>
>  Set wkb = ThisWorkbook
>  Set wks = wkb.Worksheets("questions")
>
>   For i = 0 To wks.Cells(i + 1, 1 = ""
>     For j = 0 To wks.Cells(i + 1, j + 1) = ""
>       tmp = tmp + 1
>     Next j
>   Next i
>
> Why aren't Loop j and i looping?
>
> Another question :
>
> Is this possible to redim an array in a 2d for loop :
>
> dim SomeArray() as variant
> redim SomeArray(0,0) 'A
>
> for i = 0 to MAXL
> for j = 0 to MAXC
> SomeArray(i,j) = cells(i+1,j+1)
> redim preserve SomeArray(i,j+1)
> next j
> redim preserve SomeArray(i+1,j) 'j has still MAXC as value
> next i
>
> I understand it's not making sense since MAXL and MAXC could be
> declared in A.
>
> Back to the previous question it would make sense to redim a 2d array
> in a for loop until a cell is empty in the column and a cell is empty
> in the lines.
>
> Thanks for your precious help,
>
> --
>
---
-
> --
> 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
>
>
>
>  ArrayLoop.xlsm
> 16KViewDownload

-- 

--
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$$ HI --help me

[Cab Boose]

Hi

Get the PUP V3 utility on the J-Walk site.   Do all errors on whole sheet in
one click.  Magic.

Charlie







On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote:

>
>
>  Dear Vijay,
>
> Please find Error remover technique.
>
>   * Errors-World* Error Type
> Error Remover Functions*ISNA()* *ISREF()* *ISERR()* *ISERROR()* *
> IFERROR()*  #N/A YES YES NO YES YES   #ISREF NO YES YES YES YES  #NULL NO
> YES YES YES YES  #DIV/0! NO YES YES YES YES  #NUM NO YES YES YES YES
> #NAME? NO YES YES YES YES  #VALUES NO YES YES YES YES Other Errors
>  # Press Alt+O+C+A  2.32335E+16 Press
> Ctrl+1,Custom Format->Press 0  Circular Reference Formula-Error
> checking-Select Circular Reference and Decreas formula Range
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>
>
> On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
>
>> Hi,
>>
>>
>> I have one questions.Usually while doing reports what are errors you will
>> get ?
>>
>>
>> Thanks
>>
>> --
>>
>> --
>> 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$$ HI --help me

[NOORAIN ANSARI]

 Dear Vijay,

Please find Error remover technique.

  * Errors-World* Error Type   Error
Remover Functions   *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()*
#N/A YES YES NO YES YES  #ISREF NO YES YES YES YES #NULL NO YES YES YES YES
#DIV/0! NO YES YES YES YES #NUM NO YES YES YES YES #NAME? NO YES YES YES YES
#VALUES NO YES YES YES YES Other Errors # Press
Alt+O+C+A 2.32335E+16 Press Ctrl+1,Custom Format->Press 0
   Circular
Reference Formula-Error checking-Select Circular Referenceand Decreas
formula Range


-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 



On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:

> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> --
> 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$$ HI --help me

[Sant Ram]

use formula
=IF(iserror(ur formula),"",ur formula))

On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:

> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> --
> 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$$ Copy Variable data

[Dkin]

The below code works and return on single name match. Basically copies
the data from sheet one to sheet two using Name as a key. Now would
like create loop to go through both sheets and compare the names, and
if the name exist in sheet one then copy his value into sheet two.
Please let me know the possibilities.

Sheet one: “Cargo”
Cargo Summary
Request



Total 1 Total 2
Lori Trump
Susan doo
Dii Kon 888 111
Moo Kevin
Ajax James
Alex Trapek
Kevin O'neil
Ming Kii
Kung Kwan
Dii Kii
Nung No
Li  Morgan
Total


Sheet2:” ORDER”
New Cargo



Cargo   Captain Sea NameTotal A Total B
General ZW  N/A Lori Trump  122 66
General DE  N/A Moris Bee   40  56
General DD  N/A Dii Kon 888 78
General DD  N/A Moo Kevin   127 99
General DD  N/A Ajax James  24  33
General DD  N/A Alex Trapek 231 12
General MM  N/A Kevin O'neil0   10
General Total
Reeefer HU  N/A Dii Kon 0   33
Reefer  HU  N/A Kevin O'neil515 55
Reefer  Total   515
Fish cargo  NI  N/A Moris Bee   0   67
Fish cargo  NI  N/A Ajax James  0   83
Fish cargo  Total


Here the code:
Option Explicit

Option Compare Text


Public Captain As String
Public LastRow As Double
Public Variable(15) As Variant
Public VarTemp(15) As Variant


Sub Cargo_Data()
Dim iCol As Long
Dim x As Long, x1 As Long, x2 As Long
Dim NewBook As Workbook
Dim bFind As Boolean
Dim Name As String
Dim iTmp As Long

  Worksheets("Cargo").Select

'clear the array variable
For x1 = 1 To 15
Variable(x1) = 0
VarTemp(x1) = 0
Next x1

   Captain = Name
If Captain <> " " Then
  '  GoTo Name
End If


ActiveWorkbook.Sheets("Order").Select
'Worksheets("Order").Select
Range("A6").Select
Selection.End(xlDown).Select
LastRow = ActiveCell.Row

For x1 = 6 To LastRow
If Cells(x1, 4) = "Dii Kon" Then

Call AddTo(Variable(2), Cells(x1, 5))
Call AddTo(Variable(3), Cells(x1, 6))


End If


Next x1





 
'--
'Imports to the data

  Worksheets("Cargo").Select
Range("A7").Select
Selection.End(xlDown).Select
LastRow = ActiveCell.Row
For x1 = 7 To LastRow
If Cells(x1, 1) = "Dii Kon" Then

For iCol = 2 To 15
Select Case iCol
Case 2 To 3

Cells(x1, iCol) = Variable(iCol)
End Select
Next iCol

Exit For
End If
Next x1





End Sub



Sub AddTo(ByRef vValue As Variant, vNew As Variant)
If IsNumeric(vNew) Then
If IsNumeric(vValue) Then
vValue = vValue + vNew
ElseIf vValue = "na" Or vValue = "" Then
vValue = vNew
End If
ElseIf vNew = "na" Then
If vValue = 0 Then
vValue = "na"
End If
End If

End Sub


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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$$ HI --help me

[Rajan_Verma]

1)  Duplicate Unique Key

2)  Blank Cells

3)  Wrong Data/time format

4)  Wrong Data Type (Number to String)

5)   

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 24, 2011 5:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HI --help me

 

Hi,

 

 

I have one questions.Usually while doing reports what are errors you will
get ?

 

 

Thanks 

-- 

--
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$$ Data Validation - Create a drop down list containing only unique

[Venkat CV]

Hi Kaushik,

Yes We can remove duplicates I want in Formula that's the
reason... already got it..
Thanks for your suggestion
*
*
*Best Regards,*
*Venkat*
*
*

On Mon, Jul 25, 2011 at 6:09 AM, KAUSHIK SAVLA wrote:

> u can use removw duplicate option in excel. Data then available can bw
> used as data validation range.
>
> On 7/24/11, Venkatesan c  wrote:
> > Dear All,
> >
> > I have attached sheet contains my query on Data Validation - Create a
> drop
> > down list containing only unique
> >
> >
> > --
> > *Best Regards,*
> > *Venkat*
> > *
> > *
> > *
> > *
> >
> > --
> >
> --
> > 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$$ Macro needed for ms access database

[§»VIPER«§]

Hi


First of all I have to thank you. Unfortunately you did something for excel.
But my query is about ms access. Please find the OP. Your help will be
appreciated.

-- 
*Great day,*
*viper*



On Fri, Jul 22, 2011 at 7:49 PM, Rajan_Verma wrote:

>  *Try the Attached Sheet*
>
> * *
>
> *When it will open it will ask the UserName  , I have Give Two User name
> in Codes 1) Adam 2) Rajan *
>
> *After enter the Username as CommandBar will add with Different Menus*
>
> * *
>
> *Regards*
>
> *Rajan.*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *§»VIPER«§
> *Sent:* Friday, July 22, 2011 9:39 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro needed for ms access database
>
> ** **
>
> ** **
>
> Hi
>
>  
>
> 1. I have created a database with some custom menus. In that I am having a
> menu called "Manage" and I require a code which should hide the particular
> menu for particular users.
>
> 2. I have created a form for startup and I don’t want allow the users to
> close the form using the Cnrl+W. It should be always open till the database
> is open.  I have removed the form control property close box from the form
> but the users are still able to close the form using Cntrl+W button.
>
>  
>
> Can anyone give me the solution? 
>
>
> --
> *Great day,*
> *viper*
>
> ** **
>
> --
>
> --
> 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

$$Excel-Macros$$ Job

[XLS S]

>  *Experience required for the Job:* 2 - 6 years
> *Job Location:* Bengaluru/Bangalore
>
> *Dear Candidate,*
>
> Warm Greetings!!
>
> We are Teamware Solutions, a professional IT services company head
> quartered in Bangalore. Teamware is a division of Quantum Leap Consulting
> Pvt. Ltd. and we specialize in contract staffing, placements and executive
> search. Our clientele include some of the best names in the IT industry
> worldwide like HP, Accenture, Deloitte, Cap Gemini, EDS, TCS, ATOS, to name
> a few.
>
> Our offices in Bangalore, Chennai and Mumbai look after our client's
> domestic requirements and our Singapore outfit, Teamware Solutions Pte Ltd.
> takes care of requirements in the Asia-pacific region.
>
> The choice of clients and our presence in national and international market
> can assure you of our commitment in providing you the best of opportunities
> and ending your search for a dream job.
>
> Mandatory Skill: Vba, Advanced excel , Macros
>
> Exp Level: 2+ Yrs
>
> Location:Bangalore
>
> Client : " TCS"
>
> Note: Candidates who can join within short notice period & (10-14 days)
> from the date of selection need to apply for this position.
>
> Also mention the details given below.
>
> Willingness to work on the direct payrolls of Teamware Solutions- Yes/No
> Total Experience:
> Relevant Experience:
> Current CTC:
> Expected CTC:
> NTC:
> Official Mail:
> Date of Birth-
> Educational Details-(Mention if regular or Correspondence):
> Current Company:
> Current Location:
> Preferred Location:
>
>
> If this mail is irrelevant to you kindly oblige and Ignore this Mail
>
> Thanking You
>
> Wishing you a nice day ahead !!!
>
> Warm Regards,
>
> Thanks & regards
> Swati
> Teamware Solution
> 201-203, First Floor , Oxford Chambers, Rustambagh Road
> Off: Airport Road, Bangalore-560017
> email-sw...@twsol.com
> office-08040818510
> website:www.teamwaresolutions.net
>
>
>
>
>
> --
>

-- 
--
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$$ Date & Time picker on a userform

[KAUSHIK SAVLA]

U can use date function or today function of excel.

On 7/24/11, alisha malhotra  wrote:
> Hi,
>
> I am using one userform, In that I need Date & time Picker in excel 2003.
> But when I click on Additional controls Nothing Happens.
>
> I need to add some reference for this? How can I add the Date & time Picker
> on a userform?
>
> I am attaching the file also.
>
> Pls help.
>
> Thanks & Regards,
> Alisha
>
> --
> --
> 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$$ HI --help me

[KAUSHIK SAVLA]

It depends upon the mistakes u do.

On 7/24/11, vijayajith VA  wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
> --
> 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$$ Data Validation - Create a drop down list containing only unique

[KAUSHIK SAVLA]

u can use removw duplicate option in excel. Data then available can bw
used as data validation range.

On 7/24/11, Venkatesan c  wrote:
> Dear All,
>
> I have attached sheet contains my query on Data Validation - Create a drop
> down list containing only unique
>
>
> --
> *Best Regards,*
> *Venkat*
> *
> *
> *
> *
>
> --
> --
> 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$$ Employee Data

[KAUSHIK SAVLA]

Pivot will be useful rather than using macros.
Use macros only if excel functions are not there.

On 7/25/11, Adam Hamilton  wrote:
> Hello,  I need to take employee data, and run a macro that will allow
> me to populate many different types of conclusions from this data.
> For example,
>
> If I have the resource, project, hours, description, spend, etc, I
> would like to be able to quickly see the conclusions of resources
> spend by project, hours, dollars.
>
> --
> --
> 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$$ Data Validation - Create a drop down list containing only unique

[Venkat CV]

Hi Dilip,

ThanksWorking...

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

On Sun, Jul 24, 2011 at 11:47 PM, Dilip Pandey  wrote:

> Hi Venkat,
>
> I have managed to solve your query using defined Names in Excel.
>
> Let me know if this works.
>
> Regards,
> DILIPandey
>
> On 7/24/11, Venkatesan c  wrote:
> > Dear All,
> >
> > I have attached sheet contains my query on Data Validation - Create a
> drop
> > down list containing only unique
> >
> >
> > --
> > *Best Regards,*
> > *Venkat*
> > *
> > *
> > *
> > *
> >
> > --
> >
> --
> > 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$$ Re: Employee Data

[GoldenLance]

You might be looking for Excel dashboards then. Try chandoo.org, they
have some nice dashboards..

On Jul 25, 1:43 am, Adam Hamilton  wrote:
> Hello,  I need to take employee data, and run a macro that will allow
> me to populate many different types of conclusions from this data.
> For example,
>
> If I have the resource, project, hours, description, spend, etc, I
> would like to be able to quickly see the conclusions of resources
> spend by project, hours, dollars.

-- 
--
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$$ Re: Employee Data

[Adam Hamilton]

That's what I'm currently doing, but want something more efficient.


On Sun, Jul 24, 2011 at 1:45 PM, GoldenLance  wrote:
> Try using a Pivot Table. one of the quickest and easiest ways for
> data consolidation and view in Excel
>
> Sam Mathai Chacko
>
> On Jul 25, 1:43 am, Adam Hamilton  wrote:
>> Hello,  I need to take employee data, and run a macro that will allow
>> me to populate many different types of conclusions from this data.
>> For example,
>>
>> If I have the resource, project, hours, description, spend, etc, I
>> would like to be able to quickly see the conclusions of resources
>> spend by project, hours, dollars.
>
> --
> --
> 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$$ Re: Employee Data

[GoldenLance]

Try using a Pivot Table. one of the quickest and easiest ways for
data consolidation and view in Excel

Sam Mathai Chacko

On Jul 25, 1:43 am, Adam Hamilton  wrote:
> Hello,  I need to take employee data, and run a macro that will allow
> me to populate many different types of conclusions from this data.
> For example,
>
> If I have the resource, project, hours, description, spend, etc, I
> would like to be able to quickly see the conclusions of resources
> spend by project, hours, dollars.

-- 
--
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$$ Employee Data

[Adam Hamilton]

Hello,  I need to take employee data, and run a macro that will allow
me to populate many different types of conclusions from this data.
For example,

If I have the resource, project, hours, description, spend, etc, I
would like to be able to quickly see the conclusions of resources
spend by project, hours, dollars.

-- 
--
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$$ Data Validation - Create a drop down list containing only unique

[Dilip Pandey]

Hi Venkat,

I have managed to solve your query using defined Names in Excel.

Let me know if this works.

Regards,
DILIPandey

On 7/24/11, Venkatesan c  wrote:
> Dear All,
>
> I have attached sheet contains my query on Data Validation - Create a drop
> down list containing only unique
>
>
> --
> *Best Regards,*
> *Venkat*
> *
> *
> *
> *
>
> --
> --
> 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


Drop down list containing unique by DILIPandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ HI --help me

[Dilip Pandey]

Hi Vijayajith,

It depends which report having what kind of formula / function /
macros you are working on.

I have came across following errors so far:-

1) Excel Function errors -> Can be corrected using ISError function(s)
2) VBA Macros -> Can be prevented using Error handlers
3) Linking errors -> if other sheets / databases are linked in your
excel report.

There are errors but there are solutions as well.  So cheers :)

Regards,
DILIPandey

On 7/24/11, vijayajith VA  wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
> --
> 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$$ Date & Time picker on a userform

[alisha malhotra]

Thanks a lot for ur help.

Regards,
Alisha

On Sun, Jul 24, 2011 at 9:54 PM, Sam Mathai Chacko wrote:

> Here
>
>
> On Sun, Jul 24, 2011 at 9:36 PM, alisha malhotra <
> alisha.malhotr...@gmail.com> wrote:
>
>>
>> Thanks for adding the date picker.
>>
>> But I need the time picker also if you can add. In my PC, Additional
>> controls are not appearing. I think some reference has not been added.
>>
>> I don't know which reference should I add to get the additional controls?
>>
>> Regards,
>> Alisha
>>
>>
>>
>> On Sun, Jul 24, 2011 at 7:51 PM, Sam Mathai Chacko wrote:
>>
>>> Try this... Date and Time Picker Control 6.0 (SP6) is what I used
>>>
>>>
>>> On Sun, Jul 24, 2011 at 6:43 PM, alisha malhotra <
>>> alisha.malhotr...@gmail.com> wrote:
>>>
 Hi,

 I am using one userform, In that I need Date & time Picker in excel
 2003. But when I click on Additional controls Nothing Happens.

 I need to add some reference for this? How can I add the Date & time
 Picker on a userform?

 I am attaching the file also.

 Pls help.

 Thanks & Regards,
 Alisha

 --

 --
 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

>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>>  --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
>
> --
> 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$$ Re: Date & Time picker on a userform

[GoldenLance]

It is the same control, just need to change the format. I have sent an
attachment, with a new control, and changed the format.

Sam Mathai Chacko

On Jul 24, 9:11 pm, alisha malhotra 
wrote:
> Generally it comes in toolbox after right click & selecting additional
> controls or From tool menu. But it is not appearing in my PC. I think some
> of the reference has not been added.
>
> So which reference should I add to get the additional controls?
>
> Regards,
> Alisha
>
>
>
>
>
>
>
> On Sun, Jul 24, 2011 at 7:52 PM, GoldenLance  wrote:
> > Use Date and Time Picker Control 6.0 (SP6) from the tool box. That
> > would list the control in the toolbox window. Click on it, and use it
> > on your userform.
>
> > On Jul 24, 6:13 pm, alisha malhotra 
> > wrote:
> > > Hi,
>
> > > I am using one userform, In that I need Date & time Picker in excel 2003.
> > > But when I click on Additional controls Nothing Happens.
>
> > > I need to add some reference for this? How can I add the Date & time
> > Picker
> > > on a userform?
>
> > > I am attaching the file also.
>
> > > Pls help.
>
> > > Thanks & Regards,
> > > Alisha
>
> > >  Trng Hall Bookings.xls
> > > 62KViewDownload
>
> > --
>
> > --
> > 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 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$$ Re: Date & Time picker on a userform

[alisha malhotra]

Generally it comes in toolbox after right click & selecting additional
controls or From tool menu. But it is not appearing in my PC. I think some
of the reference has not been added.

So which reference should I add to get the additional controls?

Regards,
Alisha

On Sun, Jul 24, 2011 at 7:52 PM, GoldenLance  wrote:

> Use Date and Time Picker Control 6.0 (SP6) from the tool box. That
> would list the control in the toolbox window. Click on it, and use it
> on your userform.
>
> On Jul 24, 6:13 pm, alisha malhotra 
> wrote:
> > Hi,
> >
> > I am using one userform, In that I need Date & time Picker in excel 2003.
> > But when I click on Additional controls Nothing Happens.
> >
> > I need to add some reference for this? How can I add the Date & time
> Picker
> > on a userform?
> >
> > I am attaching the file also.
> >
> > Pls help.
> >
> > Thanks & Regards,
> > Alisha
> >
> >  Trng Hall Bookings.xls
> > 62KViewDownload
>
> --
>
> --
> 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$$ Max value from a set of group

[GoldenLance]

=IF(B1 wrote:
> Thank you so much sir, but I have one query, the maximum salary must reflect
> against relative salary, becuase there is further formula for other members
> to increase rest of the members their salary by 20% of maximum.
> could you please help me out further please find attched sample excel.
>
> Thanks again...!
>
> Vikas
>
>  sample.xlsx
> 11KViewDownload

-- 
--
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$$ Date & Time picker on a userform

[alisha malhotra]

Thanks for adding the date picker.

But I need the time picker also if you can add. In my PC, Additional
controls are not appearing. I think some reference has not been added.

I don't know which reference should I add to get the additional controls?

Regards,
Alisha


On Sun, Jul 24, 2011 at 7:51 PM, Sam Mathai Chacko wrote:

> Try this... Date and Time Picker Control 6.0 (SP6) is what I used
>
>
> On Sun, Jul 24, 2011 at 6:43 PM, alisha malhotra <
> alisha.malhotr...@gmail.com> wrote:
>
>> Hi,
>>
>> I am using one userform, In that I need Date & time Picker in excel 2003.
>> But when I click on Additional controls Nothing Happens.
>>
>> I need to add some reference for this? How can I add the Date & time
>> Picker on a userform?
>>
>> I am attaching the file also.
>>
>> Pls help.
>>
>> Thanks & Regards,
>> Alisha
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
>
> --
> 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$$ Max value from a set of group

[vickey]

Thank you so much sir, but I have one query, the maximum salary must reflect 
against relative salary, becuase there is further formula for other members 
to increase rest of the members their salary by 20% of maximum. 
could you please help me out further please find attched sample excel.
 
Thanks again...!
 
Vikas 

-- 
--
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


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

$$Excel-Macros$$ Excel Specialist VBA Developer With Access SQL Skills Required

[GoldenLance]

Dear Group Members,

We are looking for an Excel Specialist, one who is well versed in
Excel formula and it's application in various situations (should be
well versed with text functions, lookup functions, and array
formulas), at least intermediate level VBA skills (able to develop
generic independent modules that can be plugged in to a report with
minimal modifications + clear understanding of manipulating charts and
other objects in Excel, able to design and develop user friendly
userforms), at least intermediate level SQL skills and basic VBA
skills in MS-Access (should be able to optimize table relationships
and to create the joins for quick execution of queries). The
designation will be that of Analyst, however, if inducted, you will be
part of the Business Transformation team consisting of 20+ Excel, VBA,
Access specialists with 4-8 years of core experience providing
dedicated technical support, creation of marquee projects, integration
of Excel, Access. Automation of Powerpoint and Word and Outlook will
be considered as added advantage.

You should have relevant experience of at least 2 years. The shift
will be normal office hours (8-5). If you feel your skill matches the
above requirements, feel free to send your resume to me.

If you feel your skills exceed the above criteria, you will be
screened for a possible higher role. Salary will be comparable to
market rates. The job will be based out of Gurgaon. Company: WNS
Global Services Pvt Ltd

Members who can join at the earliest will be given preference.

Regards,
Sam Mathai Chacko

-- 
--
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: Max value from a set of group

[GoldenLance]

Taking Ashish's example which showcases the more versatile sumproduct
function,

Use =IF(COUNTIF($A$2:A2,A2)=1,SUMPRODUCT(MAX(($A$2:$A$15=A2)*($C$2:$C
$15))),"") to display the maximum salary only once against each family

Sam Mathai Chacko

On Jul 24, 4:55 pm, vickey  wrote:
> How can I get maximum value from a set of goup i.e there are two to three
> families out of this from each family maximum age of family member is
> require in next colum corresponding to maximum age member.
>
> for example
>
> A  xyz 45
> A uyy 33
> A yss 65
>
> B sas 34
> B ree 45
> B ww 55
>
> taking to abobe example maximum age from group a should releflect in next
> column as 65 and from goup b 55.
>
> kindly help me out to solve this issue.
>
> Thanks in advance.
>
> Vikas

-- 
--
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$$ Max value from a set of group

[Sam Mathai Chacko]

In case you need a sample workbook

On Sun, Jul 24, 2011 at 5:25 PM, vickey  wrote:

> How can I get maximum value from a set of goup i.e there are two to three
> families out of this from each family maximum age of family member is
> require in next colum corresponding to maximum age member.
>
> for example
>
> A  xyz 45
> A uyy 33
> A yss 65
>
> B sas 34
> B ree 45
> B ww 55
>
> taking to abobe example maximum age from group a should releflect in next
> column as 65 and from goup b 55.
>
> kindly help me out to solve this issue.
>
> Thanks in advance.
>
> Vikas
>
> --
>
> --
> 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
>



-- 
Sam Mathai Chacko

-- 
--
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


Max Value From A Set.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Max value from a set of group

[ashish koul]

check the attachment

On Sun, Jul 24, 2011 at 5:25 PM, vickey  wrote:

> How can I get maximum value from a set of goup i.e there are two to three
> families out of this from each family maximum age of family member is
> require in next colum corresponding to maximum age member.
>
> for example
>
> A  xyz 45
> A uyy 33
> A yss 65
>
> B sas 34
> B ree 45
> B ww 55
>
> taking to abobe example maximum age from group a should releflect in next
> column as 65 and from goup b 55.
>
> kindly help me out to solve this issue.
>
> Thanks in advance.
>
> Vikas
>
> --
>
> --
> 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


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

$$Excel-Macros$$ Re: Max value from a set of group

[GoldenLance]

Vikas, if your data start from A2 (excluding the heading, use the
large function in an array formula

=IF(COUNTIF($A$2:A2,A2)=1,LARGE(($A$2:$A$15=A2)*($C$2:$C$15),1),"")

Use CTRL+SHIFT+ENTER to confirm an array formula

On Jul 24, 4:55 pm, vickey  wrote:
> How can I get maximum value from a set of goup i.e there are two to three
> families out of this from each family maximum age of family member is
> require in next colum corresponding to maximum age member.
>
> for example
>
> A  xyz 45
> A uyy 33
> A yss 65
>
> B sas 34
> B ree 45
> B ww 55
>
> taking to abobe example maximum age from group a should releflect in next
> column as 65 and from goup b 55.
>
> kindly help me out to solve this issue.
>
> Thanks in advance.
>
> Vikas

-- 
--
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: Date & Time picker on a userform

[GoldenLance]

Use Date and Time Picker Control 6.0 (SP6) from the tool box. That
would list the control in the toolbox window. Click on it, and use it
on your userform.

On Jul 24, 6:13 pm, alisha malhotra 
wrote:
> Hi,
>
> I am using one userform, In that I need Date & time Picker in excel 2003.
> But when I click on Additional controls Nothing Happens.
>
> I need to add some reference for this? How can I add the Date & time Picker
> on a userform?
>
> I am attaching the file also.
>
> Pls help.
>
> Thanks & Regards,
> Alisha
>
>  Trng Hall Bookings.xls
> 62KViewDownload

-- 
--
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$$ Excel Puzzle

[Michael Brumby]

Rajan,
A most excel-ant game, thank you for sharing.
 
Kind Regards. 

Michael Brumby

Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und 
sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte 
umgehend 
und loschen Sie diese Nachricht mit allen beigefugten Anhangen, falls Sie nicht 
der vorgesehene Empfanger sind. Der Inhalt dieser Email darf nicht an oder von 
dritten weitergeleitet, veroffentlicht, verwendet, oder kopiert werden, oder 
durch jegliches Medium gespeichert werden. 







From: Rajan_Verma 
To: excel-macros@googlegroups.com
Sent: Fri, 22 July, 2011 15:32:33
Subject: $$Excel-Macros$$ Excel Puzzle


Hope you will like it,  J
 
 -- 
--

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$$ Max value from a set of group

[vickey]

How can I get maximum value from a set of goup i.e there are two to three 
families out of this from each family maximum age of family member is 
require in next colum corresponding to maximum age member.
 
for example
 
A  xyz 45
A uyy 33
A yss 65
 
B sas 34
B ree 45
B ww 55
 
taking to abobe example maximum age from group a should releflect in next 
column as 65 and from goup b 55.
 
kindly help me out to solve this issue.
 
Thanks in advance.
 
Vikas

-- 
--
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$$ vba for loops -beginner

[netuser501]

I'm looking more for an explanation, why cells.(r+1,1) = ""  is not
working?

I have to use rng.Rows.Count always to do the equivalent?

Thanks

On Jul 24, 7:38 am, "Rajan_Verma"  wrote:
> See if it Helps
>
> Option Base 1
> Sub StoreInArrya()
>     Dim Arr() As Variant
>     Dim rng As Range
>     Dim Rw As Integer
>     Dim Cl As Integer
>
>     Set rng = Range("A1:C5")
>     ReDim Arr(rng.Cells.Rows.Count, rng.Cells.Columns.Count)
>
>             For Rw = 1 To rng.Rows.Count
>                     For Cl = 1 To rng.Columns.Count
>                     Arr(Rw, Cl) = rng.Cells(Rw, Cl).Value
>                     Next
>             Next
>
>                For Rw = 1 To rng.Rows.Count
>                     For Cl = 1 To rng.Columns.Count
>                     st = st & vbTab & Arr(Rw, Cl)
>                     Next
>                     st = st & vbCrLf
>                 Next
>                MsgBox st
> End Sub
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of netuser501
> Sent: Sunday, July 24, 2011 6:42 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ vba for loops -beginner
>
> Hi
>
> The question worksheets is filled with data on 5 rows and 3 columns.
> I'd like to have this data stored in an Array. For testing purpose, I
> want to test if the loop is "reading" the data with an integer "tmp"
> that should return the number of cells filled in with data.
>
>  Set wkb = ThisWorkbook
>  Set wks = wkb.Worksheets("questions")
>
>   For i = 0 To wks.Cells(i + 1, 1 = ""
>     For j = 0 To wks.Cells(i + 1, j + 1) = ""
>       tmp = tmp + 1
>     Next j
>   Next i
>
> Why aren't Loop j and i looping?
>
> Another question :
>
> Is this possible to redim an array in a 2d for loop :
>
> dim SomeArray() as variant
> redim SomeArray(0,0) 'A
>
> for i = 0 to MAXL
> for j = 0 to MAXC
> SomeArray(i,j) = cells(i+1,j+1)
> redim preserve SomeArray(i,j+1)
> next j
> redim preserve SomeArray(i+1,j) 'j has still MAXC as value
> next i
>
> I understand it's not making sense since MAXL and MAXC could be
> declared in A.
>
> Back to the previous question it would make sense to redim a 2d array
> in a for loop until a cell is empty in the column and a cell is empty
> in the lines.
>
> Thanks for your precious help,
>
> --
> --- -
> --
> 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
>
>
>
>  ArrayLoop.xlsm
> 16KViewDownload

-- 
--
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$$ HI --help me

[ashish koul]

http://www.ozgrid.com/Excel/formula-errors.htm

http://chandoo.org/wp/2009/04/20/excel-formula-errors/


On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV  wrote:

> Hi Vijay,
>
> In Excel You May get errors are
>
> #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
> if u want avoid this Tou may us IFERROR or IFERROR ISERROR  Function
>
> *Best Regards,*
> *Venkat*
>
>
> On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
>
>> Hi,
>>
>>
>> I have one questions.Usually while doing reports what are errors you will
>> get ?
>>
>>
>> Thanks
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> *
> *
> *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$$ HI --help me

[Venkat CV]

Hi Vijay,

In Excel You May get errors are

#NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
if u want avoid this Tou may us IFERROR or IFERROR ISERROR  Function

*Best Regards,*
*Venkat*


On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:

> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> --
> 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
>



-- 
*
*
*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

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

[Venkat CV]

Hi Daniel,

Thanks..it's Working

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

On Sun, Jul 24, 2011 at 6:01 PM, Daniel  wrote:

> Another way to do it (see attached workbook).
>
> ** **
>
> Regards.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Venkatesan c
> *Envoyé :* dimanche 24 juillet 2011 12:19
> *À :* Google
> *Objet :* $$Excel-Macros$$ Data Validation - Create a drop down list
> containing only unique
>
> ** **
>
> Dear All,
>
> ** **
>
> I have attached sheet contains my query on Data Validation - Create a drop
> down list containing only unique 
>
> ** **
>
> ** **
>
> -- 
>
> *Best Regards,*
>
> *Venkat*
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> 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$$ Data Validation - Create a drop down list containing only unique

[Venkat CV]

Hi Rajan,

It's Working Thanks...

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

On Sun, Jul 24, 2011 at 4:19 PM, Rajan_Verma wrote:

>  *Hi Venkat*
>
> *See the attached Sheet*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkatesan c
> *Sent:* Sunday, July 24, 2011 3:49 PM
> *To:* Google
> *Subject:* $$Excel-Macros$$ Data Validation - Create a drop down list
> containing only unique
>
> ** **
>
> Dear All,
>
> ** **
>
> I have attached sheet contains my query on Data Validation - Create a drop
> down list containing only unique 
>
> ** **
>
> ** **
>
> -- 
>
> *Best Regards,*
>
> *Venkat*
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> 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

$$Excel-Macros$$ HI --help me

[vijayajith VA]

Hi,


I have one questions.Usually while doing reports what are errors you will
get ?


Thanks

-- 
--
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 to enter journal entry using VBA in excel

[Rajan_Verma]

Attached Some data with more Clearification


-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jurich
Sent: Sunday, July 24, 2011 3:40 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How to enter journal entry using VBA in excel

I want to keep record of accounting transaction in double entry book
keeping system. But how ? I have not advanced skill of vba macro.

-- 

--
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$$ How to enter journal entry using VBA in excel

[jurich]

I want to keep record of accounting transaction in double entry book
keeping system. But how ? I have not advanced skill of vba macro.

-- 
--
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$$ Data Validation - Create a drop down list containing only unique

[Venkatesan c]

Dear All,

I have attached sheet contains my query on Data Validation - Create a drop
down list containing only unique


-- 
*Best Regards,*
*Venkat*
*
*
*
*

-- 
--
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


Create a drop down list containing only unique.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ vba for loops -beginner

[Rajan_Verma]

See if it Helps

Option Base 1
Sub StoreInArrya()
Dim Arr() As Variant
Dim rng As Range
Dim Rw As Integer
Dim Cl As Integer

Set rng = Range("A1:C5")
ReDim Arr(rng.Cells.Rows.Count, rng.Cells.Columns.Count)

For Rw = 1 To rng.Rows.Count
For Cl = 1 To rng.Columns.Count
Arr(Rw, Cl) = rng.Cells(Rw, Cl).Value
Next
Next
   
   For Rw = 1 To rng.Rows.Count
For Cl = 1 To rng.Columns.Count
st = st & vbTab & Arr(Rw, Cl)
Next
st = st & vbCrLf
Next
   MsgBox st
End Sub

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of netuser501
Sent: Sunday, July 24, 2011 6:42 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ vba for loops -beginner

Hi

The question worksheets is filled with data on 5 rows and 3 columns.
I'd like to have this data stored in an Array. For testing purpose, I
want to test if the loop is "reading" the data with an integer "tmp"
that should return the number of cells filled in with data.

 Set wkb = ThisWorkbook
 Set wks = wkb.Worksheets("questions")


  For i = 0 To wks.Cells(i + 1, 1 = ""
For j = 0 To wks.Cells(i + 1, j + 1) = ""
  tmp = tmp + 1
Next j
  Next i

Why aren't Loop j and i looping?



Another question :

Is this possible to redim an array in a 2d for loop :

dim SomeArray() as variant
redim SomeArray(0,0) 'A

for i = 0 to MAXL
for j = 0 to MAXC
SomeArray(i,j) = cells(i+1,j+1)
redim preserve SomeArray(i,j+1)
next j
redim preserve SomeArray(i+1,j) 'j has still MAXC as value
next i

I understand it's not making sense since MAXL and MAXC could be
declared in A.

Back to the previous question it would make sense to redim a 2d array
in a for loop until a cell is empty in the column and a cell is empty
in the lines.

Thanks for your precious help,

-- 

--
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


ArrayLoop.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

RE: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

[Rajan_Verma]

See if it Helps

Sub UpdateAll()
Dim sh As Worksheet
Dim pt As PivotTable
For each  sh in ActiveWorkbook.sheets
For Each pt In sh.PivotTables
pt.PivotCache.Refresh
Next
next
End Sub

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ruchi B
Sent: Saturday, July 23, 2011 10:36 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different
sheets

All,

Have a excel workbook with around 15 tabs ..each of tab has multiple
pivots referring to different sets of data. All the pivots refer to 4
data sets in all .What is the best way of refreshing these multiple
Pivots in different tabs at one go?

Regards,
Ruchi

-- 

--
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 text from Word and paste into Excel

[Rajan_Verma]

See if it Helps

 

Sub CopyTextFromWord()

Dim wApp As Word.Application

Set wApp = New Word.Application

wApp.Visible = True

wApp.Activate

wApp.Documents.Open "YourFilePath\SampleWord.docx"

wApp.Selection.WholeStory

wApp.Selection.Copy

Range("A1").Activate

ActiveSheet.Paste

End Sub

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Darin Kelberlau
Sent: Sunday, July 24, 2011 4:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy text from Word and paste into Excel

 

Attached is a sample word and excel documents.

 

Thanks.

On Fri, Jul 22, 2011 at 11:50 PM, Rajan_Verma 
wrote:

Attached your word document.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf dkelb1970
Sent: Saturday, July 23, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy text from Word and paste into Excel

 

I dont' know the details of the code. Do you mind scripting it up??

 

Thanks.

 

On Fri, Jul 22, 2011 at 11:23 AM, hari kumar  wrote:

Do the following 1.creTe word app 2.take microsoft word library in the
references 3m specify the path of word doc and


On 7/22/11, dkelb  wrote:
> I am a newbie to VBA
> I have a word document that is composed of many pages with text. I
> want to find the first occurance of "Objective" and copy the text that
> follows then paste it into A1. Find the next occurance and past it
> into A2. Do this until the end of the word file. Then find the first
> occurance of "Date" and copy the text that follows then paste it into
> B1.  Find the next occurance and paste it into B2. Do this until the
> end of the word file.
>
> Thanks in advance for some VBA code for Excel that can save me tons
> of
> time!
>
> --
>

--
> 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
>

--
Hari kumar
Our strength grows out of our weaknesses.


--

--
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.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