date:20110214

Re: $$Excel-Macros$$ Solution required

2011-02-14 Thread Sanjoy Nath

Dear Jitender,
Use the mail merge option in the word



On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar wrote:

> Dear Excel Gurus,
>
> Urgent help required from your part, Plz help me on the file attached.
> Problem in file
>
> Thanks in advance
>
> Regards
>
> Jitender
>
> --
>
> --
> 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
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

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

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

$$Excel-Macros$$ Need Help Urgent..!

2011-02-14 Thread rashid memon

please Provide Macro Code...

File is Attached...
-- 
Looking forward to receive your kind attention.


Thanks & Best Regards

M.Rashid.

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


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

Re: $$Excel-Macros$$ Need Help Urgent..!

2011-02-14 Thread ashish koul

use this code in sheet 1

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 1 And Target.Row = 3 Then
Sheets(2).Activate
Sheets(2).Cells(2, 1).Select
End If
End Sub



On Mon, Feb 14, 2011 at 12:48 PM, rashid memon wrote:

> please Provide Macro Code...
>
> File is Attached...
> --
> Looking forward to receive your kind attention.
>
>
> Thanks & Best Regards
>
> M.Rashid.
>
> --
>
> --
> 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 
*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


querry(1).xlsm
Description: Binary data

Re: $$Excel-Macros$$ reduce the size of code

2011-02-14 Thread Paul Schreiner

I'm not sure what your Import_fromregister macro is doing,
so I'm not sure whether the sheet name needs to be a public variable.

But this should loop through the months:


Sub Update_sheets_All()
    Dim M, ShtName
    For M = 1 To 12
    ShtName = Format(M & "/1/2011", "")
    If Sheets(ShtName).Range("b5") = 0 Then
    Application.ScreenUpdating = False
    Sheets("EMP REG").Select
    Range("B2:O200").Select
    Selection.Copy
    Sheets(ShtName).Select
    Application.Run "Compare.XLS!Module2.Import_fromregister"
    End If
    Next M
End Sub

Paul





From: Rajesh Kainikkara 
To: MS EXCEL AND VBA MACROS 
Sent: Sun, February 13, 2011 11:17:50 AM
Subject: $$Excel-Macros$$ reduce the size of code

Hi

I have a workbook which contain 15 sheets ,sheet1 is the data of
January, sheet2 is February and so on, the last 3 sheet have some data
for comparison.I am using a macro code to copy the data like this
Sub Update_sheet_April()
    If Sheets("APRIL").Range("b5") = 0 Then
    Application.ScreenUpdating = False
    Sheets("EMP REG").Select
    Range("B2:O200").Select
    Selection.Copy
    Sheets("APRIL").Select
    Application.Run "Compare.XLS!Module2.Import_fromregister"
    End If
End Sub
Sub Update_sheet_May()
    If Sheets("MAY").Range("b5") = 0 Then
    Application.ScreenUpdating = False
    Sheets("EMP REG").Select
    Range("B2:O200").Select
    Selection.Copy
    Sheets("MAY").Select
    Application.Run "Compare.XLS!Module2.Import_fromregister"
    End If
If it is possible the macro can remember the sheet which give command
and come back to the page after copying data I can reduce the size of
code.If possible pls give me the code

Regards
Rajesh

-- 
--

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 issue passing values from Cell to columns

2011-02-14 Thread Paul Schreiner

I'm still not sure what you're trying to do.
Your original data looked something like:
A;11;21;31;1
B;12;22;32;2
C;13;23;33;3
D;14;24;34;4
E;15;25;35;5
F;16;26;36;6
G;17;27;37;7
H;18;28;38;8
I;19;29;39;9

You split it into separate columns, using ";" as a delimeter..

Now you're saying that you want to move
the "19" from the last line in column "B" to column "C" of the first line?
Then the "18" from Column "B" in the second to last line, to the second line of 
column "C"?

I'm sure I can do that with a loop...
but is that what you mean?
What do you want to the do with the value already in column "C"?

Paul





From: Jorge Marques 
To: excel-macros@googlegroups.com
Sent: Sun, February 13, 2011 10:54:40 AM
Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

I have names from cell B1 to cell B1000, but sometimes i need to pass the B1000 
to C1 B999 to C2 and so on, i don´t know if this is a stupid question lol, 
because i can do it by putting a filter in it in A cell but i was wondering if 
there´s a tool ou way to do this!


2011/2/12 Paul Schreiner 

I'm not sure what you mean by "the last A goes to the first B".
>
>Can you give an example?
>
>Paul
>
>
>
>

From: Jorge Marques 
>To: excel-macros@googlegroups.com
>Sent: Sat, February 12, 2011 9:47:21 AM 
>
>Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns
>
>
>Oh ok Paul, i did it that way, because i recorded it first, then defined the 
>Range("A" & i), but it´s good now, millions thanks, the activecell i did 
>remember to leave just the range, still taking baby steps in this :) 
>
>
>
>I forgot to mention, after this  i have to switch the cells, the Last A goes 
>to 
>the first B, like inverting the order, is this possible?thanks
>
>
>2011/2/12 Dave Bonallack 
>
>Hi Paul,
>>I'm really interested in the part of the macro that I have highlighted below 
>>(in 
>>case the highlighting doesn't travel well, I've marked each line with a *)
>>I've not seen the 'Split' function before. I looked it up in the Help, but 
>>still 
>>couldn't make sense of it. If you have time, could you please explain that 
>>part?
>>Regards - Dave.
>> 
>>
Date: Fri, 11 Feb 2011 06:15:45 -0800
>>From: schreiner_p...@att.net
>>Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns 
>>
>>To: excel-macros@googlegroups.com
>>
>>
>>Curious...
>>Actually, the Activecell object is not necessary.
>>
>>I changed it to:
>>
>>If Range("A"&i) = "" then exit sub else
>>
>>and it worked just fine.
>>
>>BTW:
>>I changed the loop to:
>>
>>Application.ScreenUpdating = False
>>For R = 1 To 1000
>>    If (Range("A" & R).Value = "") Then Exit Sub
>>*    StrArray = Split(Range("A" & R).Value, ";")
>>*    For C = 0 To UBound(StrArray)
>>*    Cells(R, C + 1).Value = StrArray(C)
>>    Next C
>>Next R
>>Application.ScreenUpdating = True
>>
>>and it worked almost instantaneously instead of all the
>>screen "flashing" that goes on with TextToColumns.
>>
>>Paul
>>
>>
>>
>>

From: Jorge Marques 
>>To: excel-macros@googlegroups.com
>>Sent: Thu, February 10, 2011 6:46:37 AM
>>Subject: $$Excel-Macros$$ Macro issue passing values from Cell to columns
>>
>>
>>Hi, i have a macro i´ve done, but it it has a problem, when it passes the 
>>data 
>>from cells A to various columns it stops no cell 20 in the sheet2 e the 
>>another 
>>stops at another cell number, i have the file attached here with the code 
>>below, 
>>can´t seem to discover the error, taking baby steps at this!i think the issue 
>>is 
>>on the "if" statement, but if i take it out, it does the macro well but 
>>indicates error in the end!
>>
>>Sub Macro2()
>>'
>>' Macro2 Macro
>>'
>>' Keyboard Shortcut: Ctrl+p
>>'
>>Dim i As Double
>>i = 1
>>
>>While ActiveSheet.Select
>>    If ActiveCell.Range("A" & i) = "" Then Exit Sub Else
>>    Range("A" & i).Select
>>    Selection.TextToColumns Destination:=Range("A" & i), 
>>DataType:=xlDelimited, 
>>_
>>    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, 
_
>>    Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
>>    :=";", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
>>    TrailingMinusNumbers:=True
>>    i = i + 1
>>Wend
>>End Sub
>> 
>>
>>Thank you very much for your help
>>-- 
>>--
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our 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
>> 
>><><><><><><><><

Re: $$Excel-Macros$$ Insert raw based on condition in a range

2011-02-14 Thread Paul Schreiner

Let me know if you need any help.

Paul





From: Rajesh K R 
To: excel-macros@googlegroups.com
Sent: Sun, February 13, 2011 7:08:16 AM
Subject: Re: $$Excel-Macros$$ Insert raw based on condition in a range

Hi Paul

Thanks for the code, I want to get the copied data in a bold format to
understand it as a group head and if possible merged with the two
adjacent cells. .

Regards & Thanks

Rajesh Kainikkara

On 2/12/11, Paul Schreiner  wrote:
> I think your description is a little off.
> evidently, you're testing column C=1
> your IF statement checks to see if the following row matches criteria.
>
> I can do it very quickly with a macro.
> This macro processed 1300 lines in about 3 seconds.
>
>
> Sub Insert_Row()
>     Dim nRows, R
>     Application.ScreenUpdating = False
>     nRows = ActiveCell.SpecialCells(xlLastCell).Row
>     For R = nRows To 2 Step -1
>     If ((Cells(R, 2).Value <> "") _
>     And (Cells(R - 1, 2).Value <> "")) Then
>     If (Cells(R, 2).Value <> Cells(R - 1, 2).Value) Then
>     Cells(R, 2).EntireRow.Insert Shift:=xlDown, _
>     CopyOrigin:=xlFormatFromLeftOrAbove
>     Cells(R, 1).Value = Cells(R + 1, 2).Value
>     End If
>     End If
>     Next R
>     Application.ScreenUpdating = True
> End Sub
>
> Paul
>
>
>
> 
> From: Rajesh K R 
> To: excel-macros 
> Sent: Fri, February 11, 2011 12:26:39 PM
> Subject: $$Excel-Macros$$ Insert raw based on condition in a range
>
> Hi Experts
> Here is my issue about inserting raws in a range of cells.
>
>     A              B                          C
> 1 ABC    ALPHABETS    =IF(B1<>B2,1,"")
> 2  123      NUMERICS
> 3 *@&    SYMBOLS
>
> I want to insert a raw if the cell value in column B = 1.& copy the
> text of column B & paste it in the column A of the inserted raw.So the
> result will be
>     A                B                          C
> ALPHABETS
> 1 ABC          ALPHABETS    =IF(B1<>B2,1,"")
>   NUMERICS
> 2  123          NUMERICS
> SYMBOLS
> 3 *@&          SYMBOLS
>
>
>
> Regards
> Rajesh Kainikkara
>
> --
>--
>-
>
> 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://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

OT Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-14 Thread Paul Schreiner

This is "Off Topic" (I put "OT" in the title)
Technically, to keep from "hijacking" a thread
if you wish to continue this discussion, 
we ought to start a separate topic
Or take it "off-line" (email between the two of us)

However, since others might be interested, I'll mention  it here...

You CAN load a VBA array from a two dimensional range.
For example, Data like:
   A   B     C
101258 PIPE BUSHNG 16
219255 DRILL CHUCK 14
221280 ABRAS CLOTH 11
233553 SPOT DRILL 12
241280 HAND FILE 15
328982 GRINDING WHEEL 15

Can be loaded into a VBA array using:
Dim StrArray
StrArray = Range("A1:C6").Value

the result will be:
StrArray(1,1) = 101258
StrArray(1,2) = "PIPE BUSHING"
StrArray(1,3) = 16

and so on.

Curiously, you CANNOT declare the array initially as:

Dim StrArray(10,20)
and then exptect load it with: Strarray = Range("A1:C6").value

This technique is essentially ReDimensioning the variable.
as in:

You CAN:
Dim TempVar
ReDim TempVar(20)

But you CANNOT:
Dim TempVar(10)
ReDim TempVar(20)

Paul

 




From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Sat, February 12, 2011 7:02:36 PM
Subject: RE: $$Excel-Macros$$ Macro issue passing values from Cell to columns

Hi Paul,
Very helpful and clearly explained, thank-you.
Can we use this, or something similar, to load a range (say A1:A20) into an 
array without using a loop?
Sorry, but my knowledge of arrays in VBA is very limited.
Regards - Dave.
 

Date: Sat, 12 Feb 2011 09:20:50 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns
To: excel-macros@googlegroups.com


It's like the text-to-columns in Excel 2007.

If you have a string:
"The Quick Brown Fox jumped over the lazy dog"

and you wanted to store the words into an array,
If you're using Option Explicit (recommended)
you have to declare the variable:
Dim StrArray

(but don't define an array SIZE)

Next, split the string using a space (" ") as delimeter:
StrArray = Split("The Quick Brown Fox jumped over the lazy dog", " ")
or:
Str = ("The Quick Brown Fox jumped over the lazy dog"
StrArray = Split(Str," ")

The array is now:
StrArray(0) = "The"
Strarray(1) = "Quick" 
Strarray(2) = "Brown" 
Strarray(3) = "Fox" 
Strarray(4) = "jumped" 
Strarray(5) = "over" 
Strarray(6) = "the" 
Strarray(7) = "lazy" 
Strarray(8) = "dog"

and of course ubound(StrArray) gives the upper bound of the array (8).

I wrote a function LONG ago using this to accomplish what is now done with 
txt-to-columns in Excel2007!

hope this helps,

Paul



From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Sat, February 12, 2011 3:17:14 AM
Subject: RE: $$Excel-Macros$$ Macro issue passing values from Cell to columns

Hi Paul,
I'm really interested in the part of the macro that I have highlighted below 
(in 
case the highlighting doesn't travel well, I've marked each line with a *)
I've not seen the 'Split' function before. I looked it up in the Help, but 
still 
couldn't make sense of it. If you have time, could you please explain that part?
Regards - Dave.
 

Date: Fri, 11 Feb 2011 06:15:45 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns
To: excel-macros@googlegroups.com


Curious...
Actually, the Activecell object is not necessary.

I changed it to:

If Range("A"&i) = "" then exit sub else

and it worked just fine.

BTW:
I changed the loop to:

Application.ScreenUpdating = False
For R = 1 To 1000
    If (Range("A" & R).Value = "") Then Exit Sub
*    StrArray = Split(Range("A" & R).Value, ";")
*    For C = 0 To UBound(StrArray)
*    Cells(R, C + 1).Value = StrArray(C)
    Next C
Next R
Application.ScreenUpdating = True

and it worked almost instantaneously instead of all the
screen "flashing" that goes on with TextToColumns.

Paul





From: Jorge Marques 
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 6:46:37 AM
Subject: $$Excel-Macros$$ Macro issue passing values from Cell to columns


Hi, i have a macro i´ve done, but it it has a problem, when it passes the data 
from cells A to various columns it stops no cell 20 in the sheet2 e the another 
stops at another cell number, i have the file attached here with the code 
below, 
can´t seem to discover the error, taking baby steps at this!i think the issue 
is 
on the "if" statement, but if i take it out, it does the macro well but 
indicates error in the end!

Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+p
'
Dim i As Double
i = 1

While ActiveSheet.Select
    If ActiveCell.Range("A" & i) = "" Then Exit Sub Else
    Range("A" & i).Select
    Selection.TextToColumns Destination:=Range("A" & i), DataType:=xlDelimited, 
_
    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
    Semicolon:=False, Comma:=False, Space:=Fa

$$Excel-Macros$$ RASHI QUERRY

2011-02-14 Thread Nemi Gandhi

attached herewith rashi querry sheet. Please provide me formula and help.

-- 
Nemi Gandhi
98204 92963

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


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

Re: $$Excel-Macros$$ How to Get Filtered Data from SQL server into Microsoft Excel 2007

2011-02-14 Thread Regina Medhanie

Hello
Whan you import data  from SQL you have the query wizard and just
before it ends importing data form SQL to excel
it asks you to go directly to excel or EDIT IN MICROSOFT QUERY , if
you choose editing in microsoft query you can specify and add terms
where you specify which data from which table , etc

I hope this helps.

R. M.
On Sun, Feb 13, 2011 at 8:45 AM, Manish  wrote:
> I want to import data from SQL server 2005 into Excel 2007 using
> Data=>from other sources=>From SQL server. I am able to import
> complete table (e.g. Item) but there are too many unnecessary fields
> as well as records which also get imported. I want to filter the data
> before importing into excel but don't know how to do that? For e.g. I
> want to import "item" table with only the records whose item code
> starts with FG and only "code" and "unit price" fields.
>
> Can anybody help me out in this regard?
>
> Manish
>
> --
> --
> 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$$ Nos. of Sundays between two days

2011-02-14 Thread N Pradhan

Dear Sir,

Formula required for nos. of sundays between two days.
e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010 
and 31/01/2011.

Thanks & Regards.

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

2011-02-14 Thread ashish koul

see if it helps

On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi  wrote:

> attached herewith rashi querry sheet. Please provide me formula and help.
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
> --
> 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 
*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


rashi_querry(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-14 Thread ashish koul

start date in a1

and end date in a2

no of sundays  =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1

On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote:

>  Dear Sir,
>
> Formula required for nos. of sundays between two days.
> e.g. if an employee has joined on 18/7/2010, how many sundays between
> 18/7/2010 and 31/01/2011.
>
> Thanks & Regards.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our 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 
*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$$ reduce the size of code

2011-02-14 Thread Paul Schreiner

This isn't EXACTLY the same problem.
In your original post, you were selecting a range from "EMP REG"
and then selecting a monthly sheet and running an external macro called
Import_fromregister.

In THIS file, all you're doing is copying range B2-O200 of sheet "ITEM MASTER" 
to each sheet.

This should do it:

Sub Update_sheets_All()
    Dim M, ShtName
    For M = 1 To 12
    ShtName = Format(M & "/1/2011", "")
    If Sheets(ShtName).Range("b5") = 0 Then
    Application.ScreenUpdating = False
    Sheets("ITEM MASTER").Select
    Range("B2:O200").Select
    Selection.Copy
    Sheets(ShtName).Select
    Range("F2").Select
    ActiveSheet.Paste
    End If
    Next M
End Sub

Paul




From: Rajesh K R 
To: excel-macros@googlegroups.com
Sent: Mon, February 14, 2011 9:29:32 AM
Subject: Re: $$Excel-Macros$$ reduce the size of code

Hi Paul,
Thank you very much for your quick replies .Due to my lack of
knowledge in vba I can't understand the code well .So I am attaching a
project what I am supposed to make which have the same problem. please
check the attached file and make necessary change.

Regards & thanks
Rajesh kainikkara



On 2/14/11, Paul Schreiner  wrote:
> I'm not sure what your Import_fromregister macro is doing,
> so I'm not sure whether the sheet name needs to be a public variable.
>
> But this should loop through the months:
>
>
> Sub Update_sheets_All()
>    Dim M, ShtName
>    For M = 1 To 12
>        ShtName = Format(M & "/1/2011", "")
>        If Sheets(ShtName).Range("b5") = 0 Then
>            Application.ScreenUpdating = False
>            Sheets("EMP REG").Select
>            Range("B2:O200").Select
>            Selection.Copy
>            Sheets(ShtName).Select
>            Application.Run "Compare.XLS!Module2.Import_fromregister"
>        End If
>    Next M
> End Sub
>
> Paul
>
>
>
>
> 
> From: Rajesh Kainikkara 
> To: MS EXCEL AND VBA MACROS 
> Sent: Sun, February 13, 2011 11:17:50 AM
> Subject: $$Excel-Macros$$ reduce the size of code
>
> Hi
>
> I have a workbook which contain 15 sheets ,sheet1 is the data of
> January, sheet2 is February and so on, the last 3 sheet have some data
> for comparison.I am using a macro code to copy the data like this
> Sub Update_sheet_April()
>    If Sheets("APRIL").Range("b5") = 0 Then
>    Application.ScreenUpdating = False
>    Sheets("EMP REG").Select
>    Range("B2:O200").Select
>    Selection.Copy
>    Sheets("APRIL").Select
>    Application.Run "Compare.XLS!Module2.Import_fromregister"
>    End If
> End Sub
> Sub Update_sheet_May()
>    If Sheets("MAY").Range("b5") = 0 Then
>    Application.ScreenUpdating = False
>    Sheets("EMP REG").Select
>    Range("B2:O200").Select
>    Selection.Copy
>    Sheets("MAY").Select
>    Application.Run "Compare.XLS!Module2.Import_fromregister"
>    End If
> If it is possible the macro can remember the sheet which give command
> and come back to the page after copying data I can reduce the size of
> code.If possible pls give me the code
>
> Regards
> Rajesh
>
> --
>--
>-
>
> 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

Re: $$Excel-Macros$$ reduce the size of code

2011-02-14 Thread Rajesh K R

Hi Paul

Thanks for reply, still I have a problem in it I copy the code u
suggested but it updated the sheet "JANUARY" only. why please check
once more.

Regards
Rajesh kainikkara

On 2/14/11, Paul Schreiner  wrote:
> This isn't EXACTLY the same problem.
> In your original post, you were selecting a range from "EMP REG"
> and then selecting a monthly sheet and running an external macro called
> Import_fromregister.
>
> In THIS file, all you're doing is copying range B2-O200 of sheet "ITEM
> MASTER"
> to each sheet.
>
> This should do it:
>
> Sub Update_sheets_All()
>     Dim M, ShtName
>     For M = 1 To 12
>     ShtName = Format(M & "/1/2011", "")
>     If Sheets(ShtName).Range("b5") = 0 Then
>     Application.ScreenUpdating = False
>     Sheets("ITEM MASTER").Select
>     Range("B2:O200").Select
>     Selection.Copy
>     Sheets(ShtName).Select
>     Range("F2").Select
>     ActiveSheet.Paste
>     End If
>     Next M
> End Sub
>
> Paul
>
>
>
> 
> From: Rajesh K R 
> To: excel-macros@googlegroups.com
> Sent: Mon, February 14, 2011 9:29:32 AM
> Subject: Re: $$Excel-Macros$$ reduce the size of code
>
> Hi Paul,
> Thank you very much for your quick replies .Due to my lack of
> knowledge in vba I can't understand the code well .So I am attaching a
> project what I am supposed to make which have the same problem. please
> check the attached file and make necessary change.
>
> Regards & thanks
> Rajesh kainikkara
>
>
>
> On 2/14/11, Paul Schreiner  wrote:
>> I'm not sure what your Import_fromregister macro is doing,
>> so I'm not sure whether the sheet name needs to be a public variable.
>>
>> But this should loop through the months:
>>
>>
>> Sub Update_sheets_All()
>>    Dim M, ShtName
>>    For M = 1 To 12
>>        ShtName = Format(M & "/1/2011", "")
>>        If Sheets(ShtName).Range("b5") = 0 Then
>>            Application.ScreenUpdating = False
>>            Sheets("EMP REG").Select
>>            Range("B2:O200").Select
>>            Selection.Copy
>>            Sheets(ShtName).Select
>>            Application.Run "Compare.XLS!Module2.Import_fromregister"
>>        End If
>>    Next M
>> End Sub
>>
>> Paul
>>
>>
>>
>>
>> 
>> From: Rajesh Kainikkara 
>> To: MS EXCEL AND VBA MACROS 
>> Sent: Sun, February 13, 2011 11:17:50 AM
>> Subject: $$Excel-Macros$$ reduce the size of code
>>
>> Hi
>>
>> I have a workbook which contain 15 sheets ,sheet1 is the data of
>> January, sheet2 is February and so on, the last 3 sheet have some data
>> for comparison.I am using a macro code to copy the data like this
>> Sub Update_sheet_April()
>>    If Sheets("APRIL").Range("b5") = 0 Then
>>    Application.ScreenUpdating = False
>>    Sheets("EMP REG").Select
>>    Range("B2:O200").Select
>>    Selection.Copy
>>    Sheets("APRIL").Select
>>    Application.Run "Compare.XLS!Module2.Import_fromregister"
>>    End If
>> End Sub
>> Sub Update_sheet_May()
>>    If Sheets("MAY").Range("b5") = 0 Then
>>    Application.ScreenUpdating = False
>>    Sheets("EMP REG").Select
>>    Range("B2:O200").Select
>>    Selection.Copy
>>    Sheets("MAY").Select
>>    Application.Run "Compare.XLS!Module2.Import_fromregister"
>>    End If
>> If it is possible the macro can remember the sheet which give command
>> and come back to the page after copying data I can reduce the size of
>> code.If possible pls give me the code
>>
>> Regards
>> Rajesh
>>
>> --
>>--
>>-
>>
>> 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 issue passing values from Cell to columns

2011-02-14 Thread Jorge Marques

Yes exactly like you demonstrated :), sorry for my poor explanation, i can
do it if i separate first to columns, but can it be done all at the same
time?

2011/2/14 Paul Schreiner 

>  I'm still not sure what you're trying to do.
> Your original data looked something like:
> A;11;21;31;1
> B;12;22;32;2
> C;13;23;33;3
> D;14;24;34;4
> E;15;25;35;5
> F;16;26;36;6
> G;17;27;37;7
> H;18;28;38;8
> I;19;29;39;9
>
> You split it into separate columns, using ";" as a delimeter..
>
> Now you're saying that you want to move
> the "19" from the last line in column "B" to column "C" of the first line?
> Then the "18" from Column "B" in the second to last line, to the second
> line of column "C"?
>
> I'm sure I can do that with a loop...
> but is that what you mean?
> What do you want to the do with the value already in column "C"?
>
> Paul
>
>  --
> *From:* Jorge Marques 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sun, February 13, 2011 10:54:40 AM
>
> *Subject:* Re: $$Excel-Macros$$ Macro issue passing values from Cell to
> columns
>
> I have names from cell B1 to cell B1000, but sometimes i need to pass the
> B1000 to C1 B999 to C2 and so on, i don´t know if this is a stupid question
> lol, because i can do it by putting a filter in it in A cell but i was
> wondering if there´s a tool ou way to do this!
>
> 2011/2/12 Paul Schreiner 
>
>>  I'm not sure what you mean by "the last A goes to the first B".
>>
>> Can you give an example?
>>
>> Paul
>>
>>  --
>> *From:* Jorge Marques 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Sat, February 12, 2011 9:47:21 AM
>>
>> *Subject:* Re: $$Excel-Macros$$ Macro issue passing values from Cell to
>> columns
>>
>> Oh ok Paul, i did it that way, because i recorded it first, then defined
>> the Range("A" & i), but it´s good now, millions thanks, the activecell i did
>> remember to leave just the range, still taking baby steps in this :)
>>
>> I forgot to mention, after this  i have to switch the cells, the Last A
>> goes to the first B, like inverting the order, is this possible?thanks
>>
>> 2011/2/12 Dave Bonallack 
>>
>>> Hi Paul,
>>> I'm really interested in the part of the macro that I have highlighted
>>> below (in case the highlighting doesn't travel well, I've marked each line
>>> with a *)
>>> I've not seen the 'Split' function before. I looked it up in the Help,
>>> but still couldn't make sense of it. If you have time, could you please
>>> explain that part?
>>> Regards - Dave.
>>>
>>> --
>>> Date: Fri, 11 Feb 2011 06:15:45 -0800
>>> From: schreiner_p...@att.net
>>> Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to
>>> columns
>>>
>>> To: excel-macros@googlegroups.com
>>>
>>>  Curious...
>>> Actually, the Activecell object is not necessary.
>>>
>>> I changed it to:
>>>
>>> If Range("A"&i) = "" then exit sub else
>>>
>>> and it worked just fine.
>>>
>>> BTW:
>>> I changed the loop to:
>>>
>>> Application.ScreenUpdating = False
>>> For R = 1 To 1000
>>> If (Range("A" & R).Value = "") Then Exit Sub
>>> **StrArray = Split(Range("A" & R).Value, ";")
>>> *For C = 0 To UBound(StrArray)
>>> *Cells(R, C + 1).Value = StrArray(C)
>>> *Next C
>>> Next R
>>> Application.ScreenUpdating = True
>>>
>>> and it worked almost instantaneously instead of all the
>>> screen "flashing" that goes on with TextToColumns.
>>>
>>> Paul
>>>
>>>  --
>>> *From:* Jorge Marques 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Thu, February 10, 2011 6:46:37 AM
>>> *Subject:* $$Excel-Macros$$ Macro issue passing values from Cell to
>>> columns
>>>
>>> Hi, i have a macro i´ve done, but it it has a problem, when it passes the
>>> data from cells A to various columns it stops no cell 20 in the sheet2 e the
>>> another stops at another cell number, i have the file attached here with the
>>> code below, can´t seem to discover the error, taking baby steps at this!i
>>> think the issue is on the "if" statement, but if i take it out, it does the
>>> macro well but indicates error in the end!
>>>
>>> Sub Macro2()
>>> '
>>> ' Macro2 Macro
>>> '
>>> ' Keyboard Shortcut: Ctrl+p
>>> '
>>> Dim i As Double
>>> i = 1
>>>
>>> While ActiveSheet.Select
>>> If ActiveCell.Range("A" & i) = "" Then Exit Sub Else
>>> Range("A" & i).Select
>>> Selection.TextToColumns Destination:=Range("A" & i),
>>> DataType:=xlDelimited, _
>>> TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
>>> Tab:=True, _
>>> Semicolon:=False, Comma:=False, Space:=False, Other:=True,
>>> OtherChar _
>>> :=";", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
>>> TrailingMinusNumbers:=True
>>> i = i + 1
>>> Wend
>>> End Sub
>>>
>>>
>>> Thank you very much for your help
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-14 Thread Sundarvelan N

Check if mine is ok for you

Thanks,
Sundarvelan,
9600160150

On Mon, Feb 14, 2011 at 8:08 PM, ashish koul  wrote:

> see if it helps
>
>
> On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi  wrote:
>
>> attached herewith rashi querry sheet. Please provide me formula and help.
>>
>> --
>> Nemi Gandhi
>> 98204 92963
>>
>> --
>>
>> --
>> 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 
> *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
>



-- 
Thanks
N.Sundarvelan
9600160150

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


Xl002.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Query

2011-02-14 Thread Aamir Shahzad

Hi all experts,

Please resolve my query by formula. sheet attached.

Regards,

Aamir Shahzad

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


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

$$Excel-Macros$$ Excel graphs and formula for adding time spent

2011-02-14 Thread vinod rao

Hi Team,

I need a graphs in the attached  file and need a formula to add the total
time spend.
Any quick help will be appreciated.
Regards,
Vin

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


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

$$Excel-Macros$$ data in horizontal row

2011-02-14 Thread Hems

Hi Guys,

Pls check attached excel sheet.

I have data in across 2 columns which i want move in one row through macro,
is it possible?

actually the data is extracted from access database so if its poss through
macro then i can process in access rather trolling it through excel.

appreciate your efforts and thanks in advance.

-- 
Kind Regards,
Hems

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


Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Array or Variant ???

2011-02-14 Thread hanumant shinde

if i seclare variable like this 

dim abc

is this array or variant or something else. if array the what data type
i have code in my office (somebody else's code) where variables are declared 
like this and i thought these are variants but after going through paul's mail 
chain i guess those are arrays which seems more accurate. bcoz the kind of it 
has i always used to wonder how variant is used like an array.

so can somebody explain it.

-- 
--
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$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

2011-02-14 Thread Nasim

Hi,

we are using excel 2010. I use sheets(2) in my code and it was working
fine (since this was the 2nd tab in my file till I manually added
another sheet and I moved this 3rd sheet betwenn sheet 1 and 2 so now
3rd sheet is in 2nd order in my file(2nd tab). I have renamed the tabs
ofcourse and the indexes should still work but they dont. here is the
broblem

set wsh = thisworkbook.sheets(2)
wsh.activate  : this line activates sheets(3) which is the 2nd tab in
my file now

I used sheets("sheet2") and it produces errors.
It seems like all sheet indexes after have shifted 1 number up.
I need to reference many different sheets in this file and I want to
be able to add/delete/move/rename sheets without any problems. Only if
index was working 
I have never had this problem before. this is the first time this is
happening. Is it seemthing I do wrong or is it the setup or is it
excel 2010?

I appreciate your help.

Best regards,

Nasim

-- 
--
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: Array or Variant ???

2011-02-14 Thread hanumant shinde

also pls tell me if dim abc is array then
does dim abc is equal to dim abc() ?

From: hanumant shinde 
To: excel macros 
Sent: Tue, 15 February, 2011 1:38:21 AM
Subject: Array or Variant ???

if i seclare variable like this 

dim abc

is this array or variant or something else. if array the what data type
i have code in my office (somebody else's code) where variables are declared 
like this and i thought these are variants but after going through paul's mail 
chain i guess those are arrays which seems more accurate. bcoz the kind of it 
has i always used to wonder how variant is used like an array.

so can somebody explain it.

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

2011-02-14 Thread ashish koul

On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad wrote:

>
> Hi all experts,
>
> Please resolve my query by formula. sheet attached.
>
> Regards,
>
> Aamir Shahzad
>
> --
>
> --
> 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 
*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


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

Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

2011-02-14 Thread Paul Schreiner

In your VBA Object Explorer, you'll see 
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)

If you delete the sheet named "Name2", create a new sheet, and call the NEW 
sheet "Name2"
It won't be:
Sheet2(Name2), it'll be:
Sheet4(Name2).

So the LIST will be:
Sheet1(Name1)
Sheet3(Name3)
Sheet4(Name4)

in VBA the Sheets array is:
Sheets(1).Name = "Name1"
Sheets(2).Name = "Name3"
Sheets(3).Name = "Name2"

Because the Sheets() array is a list of sheet names.
An odd occurence though is: 
If you save and exit Excel, open the file,
and create a new Sheet (Name4)
it will create it as:
Sheet2(Name4)
and the array becomes:
Sheets(1).Name = "Name1"
Sheets(2).Name = "Name4"
Sheets(3).Name = "Name3"
Sheets(4).Name = "Name2"

So, basically, when you see "sheet1", "sheet2", etc in the VBA Project 
Explorer, 
it is NOT a sheet name and canNOT be used as the array.

Because of this, using sheets(1) or Sheets(2) is inconsistent, and I NEVER use 
it.
(some of my macros delete and create several sheets during processing.  It's 
not 
uncommon to be up to sheet300 in a session).

What I would suggest is to use:
Sheets("Name1") or set a variable for the sheet name
ShtName = "Name3"
and use:

Sheets(ShtName).Select

Paul



From: Nasim 
To: MS EXCEL AND VBA MACROS 
Sent: Mon, February 14, 2011 6:02:46 PM
Subject: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not 
sheet 
with index2

Hi,

we are using excel 2010. I use sheets(2) in my code and it was working
fine (since this was the 2nd tab in my file till I manually added
another sheet and I moved this 3rd sheet betwenn sheet 1 and 2 so now
3rd sheet is in 2nd order in my file(2nd tab). I have renamed the tabs
ofcourse and the indexes should still work but they dont. here is the
broblem

set wsh = thisworkbook.sheets(2)
wsh.activate  : this line activates sheets(3) which is the 2nd tab in
my file now

I used sheets("sheet2") and it produces errors.
It seems like all sheet indexes after have shifted 1 number up.
I need to reference many different sheets in this file and I want to
be able to add/delete/move/rename sheets without any problems. Only if
index was working 
I have never had this problem before. this is the first time this is
happening. Is it seemthing I do wrong or is it the setup or is it
excel 2010?

I appreciate your help.

Best regards,

Nasim

-- 
--

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: Array or Variant ???

2011-02-14 Thread Paul Schreiner

"Array" and "Variant" is like saying
Is this apple Red or Peeled?

I think what you really want to know is if
Dim ABC 
declares a single value variable or array.

Because, without defining a type, the default
data type is Variant.  That means that:
Dim ABC
is the same as:
Dim ABC as Variant

and
Dim ABC(10)
is the same as
Dim ABC(10) as Variant
which is a 10 element array of type Variant values!

I think what is confusing you is that if you declare (Dim) a variable as one 
type, it's possible to Re-Declare (ReDim) the variable and change it to an 
array 
and even change type!

Dim Temp as Variant
redim Temp(10) as Integer

Now, let's say you have a string:
"Test One Two Three"
and you start out with an array:
dim Temp(2)

But that's not big enough to store the whole string, so you change the array 
size to 4:
ReDim Temp(4)
and:
Temp(0) = "Test"
Temp(1) = "One"
Temp(2) = "Two"
Temp(3) = "Three"

But that's a lot of work, because you first have to determine how many words 
are 
in the string, then re-define the size of the array to hold it.

The Split() function does all of that in one step:

Dim Temp
Temp = Split("Test One Two Three", " ")

It Redimensions the array based on the number of words, and stores the values.

Hope this helps,

paul





From: hanumant shinde 
To: excel macros 
Sent: Mon, February 14, 2011 3:12:43 PM
Subject: $$Excel-Macros$$ Re: Array or Variant ???


also pls tell me if dim abc is array then
does dim abc is equal to dim abc() ?






From: hanumant shinde 
To: excel macros 
Sent: Tue, 15 February, 2011 1:38:21 AM
Subject: Array or Variant ???


if i seclare variable like this 

dim abc

is this array or variant or something else. if array the what data type
i have code in my office (somebody else's code) where variables are declared 
like this and i thought these are variants but after going through paul's mail 
chain i guess those are arrays which seems more accurate. bcoz the kind of it 
has i always used to wonder how variant is used like an array.

so can somebody explain it.



-- 
--

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$$ A little OT

2011-02-14 Thread Dave Bonallack


Hi Paul,
I have also noticed that after deleting and creating sheets, the Sheet numbers 
are out of order, and can be missing altogether. ie in a workbook of 7 sheets, 
one of them may be Sheet(11), while sheets 8 and 9 are not present at all.
So, my question is, why does this line of code (Sheets(Sheets.Count).Select) 
always select the last sheet in a workbook, even when the last sheet isn't 
necessarily the one with the highest sheet number, and also, if the sheet.count 
is say, 7, the thing still works if Sheet(7) doesn't exist!
Regards - Dave

 


Date: Mon, 14 Feb 2011 19:07:28 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not 
sheet with index2
To: excel-macros@googlegroups.com






In your VBA Object Explorer, you'll see 
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)
 
If you delete the sheet named "Name2", create a new sheet, and call the NEW 
sheet "Name2"
It won't be:
Sheet2(Name2), it'll be:
Sheet4(Name2).
 
So the LIST will be:
Sheet1(Name1)
Sheet3(Name3)
Sheet4(Name4)
 
in VBA the Sheets array is:
Sheets(1).Name = "Name1"
Sheets(2).Name = "Name3"
Sheets(3).Name = "Name2"
 
Because the Sheets() array is a list of sheet names.
An odd occurence though is: 
If you save and exit Excel, open the file,
and create a new Sheet (Name4)
it will create it as:
Sheet2(Name4)
and the array becomes:

Sheets(1).Name = "Name1"
Sheets(2).Name = "Name4"
Sheets(3).Name = "Name3"
Sheets(4).Name = "Name2"
 
So, basically, when you see "sheet1", "sheet2", etc in the VBA Project 
Explorer, it is NOT a sheet name and canNOT be used as the array.
 
Because of this, using sheets(1) or Sheets(2) is inconsistent, and I NEVER use 
it.
(some of my macros delete and create several sheets during processing.  It's 
not uncommon to be up to sheet300 in a session).
 
What I would suggest is to use:
Sheets("Name1") or set a variable for the sheet name
ShtName = "Name3"
and use:
 
Sheets(ShtName).Select
 
Paul



From: Nasim 
To: MS EXCEL AND VBA MACROS 
Sent: Mon, February 14, 2011 6:02:46 PM
Subject: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not 
sheet with index2

Hi,

we are using excel 2010. I use sheets(2) in my code and it was working
fine (since this was the 2nd tab in my file till I manually added
another sheet and I moved this 3rd sheet betwenn sheet 1 and 2 so now
3rd sheet is in 2nd order in my file(2nd tab). I have renamed the tabs
ofcourse and the indexes should still work but they dont. here is the
broblem

set wsh = thisworkbook.sheets(2)
wsh.activate  : this line activates sheets(3) which is the 2nd tab in
my file now

I used sheets("sheet2") and it produces errors.
It seems like all sheet indexes after have shifted 1 number up.
I need to reference many different sheets in this file and I want to
be able to add/delete/move/rename sheets without any problems. Only if
index was working 
I have never had this problem before. this is the first time this is
happening. Is it seemthing I do wrong or is it the setup or is it
excel 2010?

I appreciate your help.

Best regards,

Nasim

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

$$Excel-Macros$$ Excel intrinsic constants/enumerations

2011-02-14 Thread Jeff

I'm starting to write some code in VB (may end up as vbscript, or vb) and 
would like to understand how the proper way to get all the internal 
constants declared?  A couple of examples might  include xlDayofWeek or 
vbCRLF.  Do I include a header file that defines them for me?

Thank for your insight?

Jeff

-- 
--
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$$ Load image from the url

2011-02-14 Thread San Pat

How I can load a image from a url using the LoadPicture function in
userform.

Regards,

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

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

Re: $$Excel-Macros$$ Excel intrinsic constants/enumerations

2011-02-14 Thread Sanjoy Nath

in editor press F2 you will get all



On Tue, Feb 15, 2011 at 11:13 AM, Jeff  wrote:

> I'm starting to write some code in VB (may end up as vbscript, or vb) and
> would like to understand how the proper way to get all the internal
> constants declared?  A couple of examples might  include xlDayofWeek or
> vbCRLF.  Do I include a header file that defines them for me?
>
> Thank for your insight?
>
> Jeff
>
> --
>
> --
> 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
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
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$$ Solution required

$$Excel-Macros$$ Need Help Urgent..!

Re: $$Excel-Macros$$ Need Help Urgent..!

Re: $$Excel-Macros$$ reduce the size of code

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

Re: $$Excel-Macros$$ Insert raw based on condition in a range

OT Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

$$Excel-Macros$$ RASHI QUERRY

Re: $$Excel-Macros$$ How to Get Filtered Data from SQL server into Microsoft Excel 2007

$$Excel-Macros$$ Nos. of Sundays between two days

Re: $$Excel-Macros$$ RASHI QUERRY

Re: $$Excel-Macros$$ Nos. of Sundays between two days

Re: $$Excel-Macros$$ reduce the size of code

Re: $$Excel-Macros$$ reduce the size of code

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

Re: $$Excel-Macros$$ RASHI QUERRY

$$Excel-Macros$$ Query

$$Excel-Macros$$ Excel graphs and formula for adding time spent

$$Excel-Macros$$ data in horizontal row

$$Excel-Macros$$ Array or Variant ???

$$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

$$Excel-Macros$$ Re: Array or Variant ???

Re: $$Excel-Macros$$ Query

Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

Re: $$Excel-Macros$$ Re: Array or Variant ???

$$Excel-Macros$$ A little OT

$$Excel-Macros$$ Excel intrinsic constants/enumerations

$$Excel-Macros$$ Load image from the url

Re: $$Excel-Macros$$ Excel intrinsic constants/enumerations

29 matches

Site Navigation

Mail list logo

Footer information