$$Excel-Macros$$ Macro to print outlook attachment and email body

2015-10-01 Thread B.N.Chethan Kumar
Dear Friends,

I am using outlook 2010. Does anyone know how to print outlook attachment
and body of email.

As a request from new client, we print close to 1000 email per day.

Please share if you any code which can either run in outlook or in excel
sheet.

Thanks
-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ PDF file name with Subject line

2015-05-08 Thread B.N.Chethan Kumar
I am trying to download PDF attachment.. It is working, But need to add
Subject along with file name when file is saved in the folder.

Kindly advise.



-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


donload pdf from outlook.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12


$$Excel-Macros$$ how to download PDF to specific folder

2015-05-08 Thread B.N.Chethan Kumar
Respected sir,

I am using the following code to download PDF from Outlook. But it is
giving error message. Kindly let me know how to fix it.

Sub Test()'Arg 1 = Folder name of folder inside your Inbox
'Arg 2 = File extension,  is every file
'Arg 3 = Save folder, C:\Users\Ron\test or 
'If you use  it will create a date/time stamped folder for
you in your Documents folder
'Note: If you use this C:\Users\Ron\test the folder must exist.

SaveEmailAttachmentsToFolder MyFolder, , 

End Sub


Sub SaveEmailAttachmentsToFolder(OutlookFolderInInbox As String, _
 ExtString As String, DestFolder As String)
Dim ns As Namespace
Dim Inbox As MAPIFolder
Dim SubFolder As MAPIFolder
Dim Item As Object
Dim Atmt As Attachment
Dim FileName As String
Dim MyDocPath As String
Dim I As Integer
Dim wsh As Object
Dim fs As Object

On Error GoTo ThisMacro_err

Set ns = GetNamespace(MAPI)
Set Inbox = ns.GetDefaultFolder(olFolderInbox)
Set SubFolder = Inbox.Folders(OutlookFolderInInbox)

I = 0
' Check subfolder for messages and exit of none found
If SubFolder.Items.Count = 0 Then
MsgBox There are no messages in this folder :  
OutlookFolderInInbox, _
   vbInformation, Nothing Found
Set SubFolder = Nothing
Set Inbox = Nothing
Set ns = Nothing
Exit Sub
End If

'Create DestFolder if DestFolder = 
If DestFolder =  Then
Set wsh = CreateObject(WScript.Shell)
Set fs = CreateObject(Scripting.FileSystemObject)
MyDocPath = wsh.SpecialFolders.Item(mydocuments)
DestFolder = MyDocPath  \  Format(Now, dd-mmm- hh-mm-ss)
If Not fs.FolderExists(DestFolder) Then
fs.CreateFolder DestFolder
End If
End If

If Right(DestFolder, 1)  \ Then
DestFolder = DestFolder  \
End If

' Check each message for attachments and extensions
For Each Item In SubFolder.Items
For Each Atmt In Item.Attachments
If LCase(Right(Atmt.FileName, Len(ExtString))) =
LCase(ExtString) Then
FileName = DestFolder  Item.SenderName Atmt.FileName
Atmt.SaveAsFile FileName
I = I + 1
End If
Next Atmt
Next Item

' Show this message when Finished
If I  0 Then
MsgBox You can find the files here :  _
  DestFolder, vbInformation, Finished!
Else
MsgBox No attached files in your mail., vbInformation, Finished!
End If

' Clear memory
ThisMacro_exit:
Set SubFolder = Nothing
Set Inbox = Nothing
Set ns = Nothing
Set fs = Nothing
Set wsh = Nothing
Exit Sub

' Error information
ThisMacro_err:
MsgBox An unexpected error has occurred. _
  vbCrLf  Please note and report the following information. _
  vbCrLf  Macro Name: SaveEmailAttachmentsToFolder _
  vbCrLf  Error Number:   Err.Number _
  vbCrLf  Error Description:   Err.Description _
 , vbCritical, Error!
Resume ThisMacro_exit

End Sub


-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ PDF file name with Subject line

2015-05-08 Thread B.N.Chethan Kumar
-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread B.N.Chethan Kumar
Yes. it is single column A:A

On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 how is your sheet data.??? it contain a single column or multiple columns
 ??




 On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote:

 Hi,

 I need some help in modify the Macro. Current it combine multiple sheet
 in one column. I  need to copy each sheet to one column,

 Like
 Sheet 1 to A
 Sheet 2 to B
 Sheet 3 to C
 Sheet 4 to D

 Etc..


 Sub Combine()
 Dim J As Integer
 Dim rey As Range
 On Error Resume Next
 Sheets(1).Select
 Worksheets.Add
 Sheets(1).Name = Combined
 Sheets(2).Activate
 Range(A1).EntireRow.Select
 Selection.Copy Destination:=Sheets(1).Range(A1)
 For J = 2 To Sheets.Count
 Sheets(J).Activate
 Range(A1).Select
 Selection.CurrentRegion.Select
 Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
 Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2)
 Next
 End Sub

 --

 Chethan

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread B.N.Chethan Kumar
Thank Pankaj

It work perfect. Yes i was looking for something like these

On Thu, May 7, 2015 at 7:28 PM, Pankaj Sharma pankaj123...@gmail.com
wrote:

 r u looking for this ??

 Sub Combine()
 Dim J As Integer
 Dim rey As Range

 On Error Resume Next
 Sheets(1).Select
 Worksheets.Add
 Sheets(1).Name = Combined
 Sheets(1).Activate
 For J = 2 To Sheets.Count
 Sheets(J).Activate
 Range(A:A).Copy
 Sheets(Combined).Select
 If Range(XFD1).End(xlToLeft) =  Then
 Selection.PasteSpecial Paste:=xlPasteAll
 Else
 Selection.Offset(0, 1).PasteSpecial Paste:=xlPasteAll
 End If

 Next
 End Sub


 On Thu, May 7, 2015 at 6:33 PM, B.N.Chethan Kumar 
 chetankumar1...@gmail.com wrote:

 Yes. it is single column A:A

 On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja rockerna...@gmail.com
 wrote:

 how is your sheet data.??? it contain a single column or multiple
 columns ??




 On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote:

 Hi,

 I need some help in modify the Macro. Current it combine multiple sheet
 in one column. I  need to copy each sheet to one column,

 Like
 Sheet 1 to A
 Sheet 2 to B
 Sheet 3 to C
 Sheet 4 to D

 Etc..


 Sub Combine()
 Dim J As Integer
 Dim rey As Range
 On Error Resume Next
 Sheets(1).Select
 Worksheets.Add
 Sheets(1).Name = Combined
 Sheets(2).Activate
 Range(A1).EntireRow.Select
 Selection.Copy Destination:=Sheets(1).Range(A1)
 For J = 2 To Sheets.Count
 Sheets(J).Activate
 Range(A1).Select
 Selection.CurrentRegion.Select
 Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
 Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2)
 Next
 End Sub

 --

 Chethan

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




 --

 Chethan

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message

$$Excel-Macros$$ Move coloum

2015-05-06 Thread B.N.Chethan Kumar
Hi,

I need some help in modify the Macro. Current it combine multiple sheet in
one column. I  need to copy each sheet to one column,

Like
Sheet 1 to A
Sheet 2 to B
Sheet 3 to C
Sheet 4 to D

Etc..


Sub Combine()
Dim J As Integer
Dim rey As Range
On Error Resume Next
Sheets(1).Select
Worksheets.Add
Sheets(1).Name = Combined
Sheets(2).Activate
Range(A1).EntireRow.Select
Selection.Copy Destination:=Sheets(1).Range(A1)
For J = 2 To Sheets.Count
Sheets(J).Activate
Range(A1).Select
Selection.CurrentRegion.Select
Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2)
Next
End Sub

-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ excel Macro

2015-04-18 Thread B.N.Chethan Kumar
Hi

Please help me with macro code. I am trying to send file to each individual.

I need to filter and send the file to each individual. Current i have macro
it work on person.



-- 

Chethan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sample file.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12


$$Excel-Macros$$ Open office

2014-05-23 Thread B.N.Chethan Kumar
Hi,
Can we create macro in open office calc. I need to send file every hour
using outlook.

Regards
CK

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


RE: $$Excel-Macros$$ Ie

2013-12-22 Thread B.N.Chethan Kumar
Hi. Please let me how to use HTML code in excel macro. I am trying to login
into a tool and pull a report in PDF format.
Regards
Ck
On Dec 21, 2013 12:46 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:

 Thanks. It worked.
 On Dec 19, 2013 11:44 AM, Ravinder ravinderexcelgr...@gmail.com wrote:

 Try this if looking for this..  actually in this you can login in yahoo
 and gmail through form…



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
 *Sent:* Thursday, December 19, 2013 10:41 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* RE: $$Excel-Macros$$ Ie



 I am trying to connect Google \ analytics and pull report.

 On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com
 wrote:

 Provide website and data you want to extract…



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
 *Sent:* Thursday, December 19, 2013 4:19 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Ie



 Hi
 I am trying to connect IE 9 using vba and create a loop download data.
 Any help.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT

RE: $$Excel-Macros$$ Ie

2013-12-20 Thread B.N.Chethan Kumar
Thanks. It worked.
On Dec 19, 2013 11:44 AM, Ravinder ravinderexcelgr...@gmail.com wrote:

 Try this if looking for this..  actually in this you can login in yahoo
 and gmail through form…



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
 *Sent:* Thursday, December 19, 2013 10:41 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* RE: $$Excel-Macros$$ Ie



 I am trying to connect Google \ analytics and pull report.

 On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com wrote:

 Provide website and data you want to extract…



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
 *Sent:* Thursday, December 19, 2013 4:19 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Ie



 Hi
 I am trying to connect IE 9 using vba and create a loop download data. Any
 help.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula

RE: $$Excel-Macros$$ VBA to send excel file using outlook

2013-12-20 Thread B.N.Chethan Kumar
It worked. . thanks
On Dec 10, 2013 11:29 AM, Ravinder ravinderexcelgr...@gmail.com wrote:

 give some examples



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
 *Sent:* Monday, December 09, 2013 6:13 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ VBA to send excel file using outlook



 I have to send excel as attachment to end user. But using  different
 account. Like using from as a Common I'd

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


$$Excel-Macros$$ Ie

2013-12-18 Thread B.N.Chethan Kumar
Hi
I am trying to connect IE 9 using vba and create a loop download data. Any
help.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


RE: $$Excel-Macros$$ Ie

2013-12-18 Thread B.N.Chethan Kumar
I am trying to connect Google \ analytics and pull report.
On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com wrote:

 Provide website and data you want to extract…



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
 *Sent:* Thursday, December 19, 2013 4:19 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Ie



 Hi
 I am trying to connect IE 9 using vba and create a loop download data. Any
 help.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ Sharepoint

2013-12-16 Thread B.N.Chethan Kumar
Thanks it is working
On Dec 16, 2013 1:45 AM, ashish koul koul.ash...@gmail.com wrote:

 try this



 http://social.msdn.microsoft.com/Forums/sharepoint/en-US/d04fd6b2-6db4-47f2-97a3-3bb364eef80a/upload-an-excel-document-from-an-open-workbook-into-a-sharepoint-document-library?forum=sharepointdevelopmentlegacy


 On Sat, Dec 14, 2013 at 4:15 PM, B.N.Chethan Kumar 
 chetankumar1...@gmail.com wrote:

 Please help.
 On Dec 14, 2013 1:58 AM, bhupendra singh raghav 
 raghav.bhupen...@gmail.com wrote:

 Yes
 On Dec 14, 2013 1:56 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
 wrote:

 Hi.
 I am upload excel file to a SharePoint portal. In a day close to 100
 file need to be upload at different folder. Any macro which can automated
 it.
 Regards
 Ck

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 *Regards*

 *Ashish Koul*


 *Visit*
 http://www.excelvbamacros.in
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.



 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Sharepoint

2013-12-14 Thread B.N.Chethan Kumar
Please help.
On Dec 14, 2013 1:58 AM, bhupendra singh raghav 
raghav.bhupen...@gmail.com wrote:

 Yes
 On Dec 14, 2013 1:56 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
 wrote:

 Hi.
 I am upload excel file to a SharePoint portal. In a day close to 100 file
 need to be upload at different folder. Any macro which can automated it.
 Regards
 Ck

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


$$Excel-Macros$$ Sharepoint

2013-12-13 Thread B.N.Chethan Kumar
Hi.
I am upload excel file to a SharePoint portal. In a day close to 100 file
need to be upload at different folder. Any macro which can automated it.
Regards
Ck

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


$$Excel-Macros$$ VBA to send excel file using outlook

2013-12-09 Thread B.N.Chethan Kumar
I have to send excel as attachment to end user. But using  different
account. Like using from as a Common I'd

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail

2013-04-09 Thread B.N.Chethan Kumar
You can use code2 outlook addins. It does the same work with ease.
On Apr 9, 2013 12:01 PM, Prabhu Pinky prabhupin...@gmail.com wrote:

 Hi,

 For testing purpose, i have attached three mail herewith.

 This is not (.pst), i have copied sent items in my local folder.


 On 9 April 2013 11:56, Abhishek Jain abhishek@gmail.com wrote:

 I think MS outlook has only one file (.pst) which has all its folders. Do
 you mean you saved your sent items in a folder? Can you attach 2-3 of your
 emails for testing purpose?


 On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi Abhishek,


 It is MS Outlook mails, i just copied sent mails from MS Outlook and
 copied in local folder.


 Thanks  regards,
 Prabhu R


 On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote:

 Is it MS Outlook (having .pst in your local folder) ? or Outlook
 Express (having .dbx in your local folder) ?


 On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky 
 prabhupin...@gmail.comwrote:

 Hi everyone,

 it will be so appreciated if anyone gimme a macro program for my
 requirement.

 i have nearly 100 outlook mails saved in my local folder. can i
 extract all mails sent time and subject in excel sheet one by one by using
 macro program?

 Please help because am doing this task manually on every month and its
 killing my whole day.

 Thanks  Regards
 Prabhu R

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to 

Re: $$Excel-Macros$$ Power pivot

2013-03-27 Thread B.N.Chethan Kumar
Thanks . Let me check .
On Mar 27, 2013 9:27 AM, ashish koul koul.ash...@gmail.com wrote:

 Hi

 try this


 http://technet.microsoft.com/en-us/library/gg413497.aspx
 http://technet.microsoft.com/en-us/library/gg399078.aspx
 http://www.microsoft.com/en-us/bi/powerpivot.aspx

 http://blogs.office.com/b/microsoft-excel/archive/2009/10/23/using-powerpivot-with-excel-2010.aspx

 http://blogs.office.com/b/microsoft-excel/archive/2011/05/24/getting-started-with-powerpivot-for-excel.aspx

 Regards
 Ashish



 On Wed, Mar 27, 2013 at 1:04 AM, B.N.Chethan Kumar 
 chetankumar1...@gmail.com wrote:

 Hi, please help me some material on useage of power pivot in ms office
 2010.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.



 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: $$Excel-Macros$$ Need help with Macro

2012-10-16 Thread B.N.Chethan Kumar
Please help.
On Oct 15, 2012 8:08 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:

 Dear Experts,

 Please help me with Macro. I need to assign a auditor for each Policy and
 create worksheet for each auditor in same workbook by copy the policy to it.

 Kindly refer the attached file. Based on policy ID (Column B) i need to
 assign a auditor. I have 5 auditor, need to assign equal number of audit.

 One auditor for each policy and same policy may be repeated more than once
 in the sheet. So unique policy need t be given to each auditor(if possible
 equally). Finally create  one worksheet for each auditor by split the data,

 I have around 30k to 50k row per day, added a sample file for your
 reference.

 Kindly help in allocate each auditor with unique Policy ID and split in
 one worksheet for auditor.

 Regards
 CK

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Re: $$Excel-Macros$$ All time high Price *

2012-09-21 Thread B.N.Chethan Kumar
Apology for delay response.

Please find the example of how to use max function with conditonal.

 note: these is an array formuale.

Regards
CK

On Fri, Sep 21, 2012 at 3:31 AM, dguillett1 dguille...@gmail.com wrote:

   And just HOW is it MORE dynamic??

 Don Guillett
 Microsoft Excel Developer
 SalesAid Software
 dguille...@gmail.com

  *From:* resp...@gmail.com
 *Sent:* Thursday, September 20, 2012 3:34 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ All time high Price *

 Its because of what I am applying it to. Formula makes it much more
 dynamic rather than macros.

 Hi kumar I no I should use the max function but how to apply it to the
 scenario Ȋ̝̊̅§ the problem. Thanks


 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: *dguillett1 dguille...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Thu, 20 Sep 2012 15:04:40 -0500
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ All time high Price *

  Why use a complicated formula that can inadvertently be deleted when the
 macro is automatic?


 Don Guillett
 Microsoft Excel Developer
 SalesAid Software
 dguille...@gmail.com

  *From:* resp...@gmail.com
 *Sent:* Thursday, September 20, 2012 2:59 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ All time high Price *

 Thanks Don. Really appreciate. Pls can you assist with an excel formula as
 well?
 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: *dguillett1 dguille...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Thu, 20 Sep 2012 14:13:37 -0500
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ All time high Price *

 [image: Boxbe] https://www.boxbe.com/overview This message is eligible
 for Automatic Cleanup! (dguille...@gmail.com) Add cleanup 
 rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dfp6Uq9cjZpOIDX6rjkOHwCP%252BlPjwplqHSLTo%252FBDzPV1humc%252FBixYwYPuQ8BZty5GzNkmwhz3d84KKBdTYw2GVqA4mdY9bC32%252FuHKcrLaLF%252FlBPLdSes%252FPkONziRm%252F6wl0G1hFXO%252FLL0%253D%26key%3DznyqkERaXQb8uDHU3hOwyUUS5cAonuSymqGbdgVOIbw%253Dtc=12446925854_493039259|
  More
 infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12446925854_493039259
 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.


 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.


 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code 

Re: $$Excel-Macros$$ All time high Price

2012-09-20 Thread B.N.Chethan Kumar
Use max function
On Sep 21, 2012 12:43 AM, dguillett1 dguille...@gmail.com wrote:

   Put this in the SHEET module

 Private Sub Worksheet_Change(ByVal Target As Range)
 If Intersect(Target, Range(b1)) Is Nothing Then Exit Sub
 Dim ss As Worksheet
 Dim mf As Range
 Set ss = Sheets(Monthly End Prices)
 Set mf = ss.Rows(1).Find(What:=Target, LookIn:=xlFormulas, _
 LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
 MatchCase:=False, SearchFormat:=False)
 If Not mf Is Nothing Then Range(e2).Value =
 Application.Max(ss.Columns(mf.Column))
 End Sub
 ‘
 Don Guillett
 Microsoft Excel Developer
 SalesAid Software
 dguille...@gmail.com

  *From:* Hilary Lomotey resp...@gmail.com
 *Sent:* Thursday, September 20, 2012 10:57 AM
 *To:* excel-macros EXCEL-MACROS@googlegroups.com
 *Subject:* $$Excel-Macros$$ All time high Price

 Hello Experts,

 i need a formula to calculate the all time highest price if i select an
 equity in the attached sheet. kindly help with the formula. thanks
 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Re: $$Excel-Macros$$ Re: Calculated Field not Working

2012-09-19 Thread B.N.Chethan Kumar
check..if these help. check and let me know

Regards
CK

On Wed, Sep 19, 2012 at 2:45 PM, SG sonal...@gmail.com wrote:

 Experts,

 plz help mei need solution.plz look in to this

 On Monday, September 17, 2012 8:20:53 PM UTC+5:30, SG wrote:

 Hi Experts,

 I'm again in to a problem whic is silly but still i can't make it.I
 calculate the scores for individuals seperately but this time i want to
 make all under one table.For this, i have created a pivot table  for
 Calculating the Score, I have used Calculated field which is not giving me
 the right ans.I'm attaching the sheet.Plz look in to this.I have
 highlighted the column for which i nedd your help.

 thanks in advance

  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.






-- 

Chethan

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Calculate Field not working.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Fwd: PDF to excel table

2012-09-11 Thread B.N.Chethan Kumar
Due to restrict i will not able to use third party soft ware in my work
place.

Regards
CK

On Sep 11, 2012 11:08 AM, SAGAR KASANGOTTUWAR 
sagarkasangottu...@gmail.com wrote:

 Dear Chethan,

 You can use the Able to extract software 

 Best Regards,

 Sagar
 On Tue, Sep 11, 2012 at 10:22 AM, B.N.Chethan Kumar 
 chetankumar1...@gmail.com wrote:

 Apology friends,

 Please ignore my previous email.

 I need to convert attached PDF to Excel and we have close to 500
 documents on weekly basis.

 Kindly advice do we have any easy and alternation method for doing it,

 Regards
 Chethan Kumar BN

 -- Forwarded message --
 From: B.N.Chethan Kumar chetankumar1...@gmail.com
 Date: Tue, Sep 11, 2012 at 10:20 AM
 Subject: PDF to excel table
 To: excel-macros@googlegroups.com




 --

 Chethan




 --

 Chethan

  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Re: $$Excel-Macros$$ need to consolidate data in one sheet

2012-07-23 Thread B.N.Chethan Kumar
Hi Don,

kindly explain how did you do that.

Regards
CK

On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 dguille...@gmail.com wrote:

   See attached file that automatically makes a drop down in range d9 when
 you activate the sheet and when you select the date from the drop down will
 populate the cells.


 Don Guillett
 Microsoft Excel Developer
 SalesAid Software
 dguille...@gmail.com

  *From:* सुनिता पौडेल tosune...@gmail.com
 *Sent:* Friday, July 20, 2012 4:11 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ need to consolidate data in one sheet

   Dear all,

 In this attached file there is data in one sheet 1, I want the same
 account head amount from the sheet 1 to appear in sheet 2. Is it possible?.
 I tried manually but takin time so if you all could help me on this.

 Thank you very much for the cooperation.

 Regards,

 Sunita
 --
 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com



 --
 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com






-- 
B.N Chetan kumar

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Re: $$Excel-Macros$$ Re: Macro on daily task

2012-05-27 Thread B.N.Chethan Kumar
Hi,

any update on my request

On Fri, May 25, 2012 at 12:03 PM, B.N.Chethan Kumar 
chetankumar1...@gmail.com wrote:

 Thanks Pascaal,

 Apology for delay response and thanks for working on the macro.

 As i was busy with kids first birthday, i did not reply to ur email.

 on the query raised. Current, i apply filter and search anything which
 start as Win   group them under Brokerage win. Like wise TCAP
 under Brokerage – TCAP, DED under deductibles and rest under others.


 Brokerage win – WIN

 Brokerage – TCAP – TCAP

 Deductibles – DED

 Brokerage others – others

 Thanks again for working on these project.

 One last thing, i need broder entire row  column where the data is
 available.

 Regards
 Chethan
  On Thu, May 24, 2012 at 6:13 AM, bpascal123 bpascal...@gmail.com wrote:

  Hi Chetan,

 I'm half way with your data query, column O is about Trans Type, now I'm
 not sure to understand how you want to copy the data, I don't see anything
 related to Brokerage win or Win and else.

 Please clarify,
 Pascal Baro

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 B.N Chetan kumar




-- 
B.N Chetan kumar

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Macro on daily task

2012-05-25 Thread B.N.Chethan Kumar
Thanks Pascaal,

Apology for delay response and thanks for working on the macro.

As i was busy with kids first birthday, i did not reply to ur email.

on the query raised. Current, i apply filter and search anything which
start as Win   group them under Brokerage win. Like wise TCAP under
Brokerage – TCAP, DED under deductibles and rest under others.


Brokerage win – WIN

Brokerage – TCAP – TCAP

Deductibles – DED

Brokerage others – others

Thanks again for working on these project.

One last thing, i need broder entire row  column where the data is
available.

Regards
Chethan
On Thu, May 24, 2012 at 6:13 AM, bpascal123 bpascal...@gmail.com wrote:

  Hi Chetan,

 I'm half way with your data query, column O is about Trans Type, now I'm
 not sure to understand how you want to copy the data, I don't see anything
 related to Brokerage win or Win and else.

 Please clarify,
 Pascal Baro

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




-- 
B.N Chetan kumar

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Help with PPT

2012-05-19 Thread B.N.Chethan Kumar
Dear friends,

Do we have any macro which will automatic will update slide in PPT with
same size and shape. If it is possible, please help with it.

-- 
B.N Chetan kumar

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Re: $$Excel-Macros$$ Plz help urgent

2011-12-13 Thread B.N.Chethan Kumar
Please find the data in required format.

Regards
Chethan Kumar BN

On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena anilsaxena170...@gmail.comwrote:

 Plz let me know that how can possible to % in pivot table. base of Caller.

 Plz show the snap short also.

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Merge_Mumbai_Calling_(13-Dec-11).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Insert rows in tables for comparison

2011-12-13 Thread B.N.Chethan Kumar
Please find the table in comparsion model. I have used pivot table option.

Regards
Chethan kumar BN

On Wed, Dec 14, 2011 at 11:07 AM, Darwin Chan
darwin.chankaw...@gmail.comwrote:

 Dear all,

 I have 2 tables concerning sales volume of several customers across 2
 months. I want to make a comparison on the sales volume, however, some
 customer buy service in previous month may not buy in the next month and
 vice versa. This makes such a  tedious task by inserting rows in both
 tables and fill up with zero and then to calculate the change in sales
 volume. Does anyone have solutions to create a macro or any other solutions?

  Below please find the attachment.

 --
 Darwin Chan
 darwin.chankaw...@gmail.com
 kw42c...@yahoo.com.hk

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Insert_row_question.xls
Description: MS-Excel spreadsheet


Re: $$Excel-Macros$$ Correction in Formula

2011-12-02 Thread B.N.Chethan Kumar
Please find the information as requested

On Sat, Dec 3, 2011 at 1:25 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:

 Dear Group,

 I am using Countifs function how I give the second criteria e.g. I want
 9 it's mean only pick the buckets of 10,11  12. See the attached file
 plz.

 Regards,

 Aamir Shahzad

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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


Re: $$Excel-Macros$$ Need Help

2011-11-30 Thread B.N.Chethan Kumar
Hi,

As feared, these was not working...no issue in codes.

only issue was...i was not able to select a folder in network...these was
helpful for all folder in my local harddisck...

I was not able to select any other loction or path.

Regards
Chethan Kumar BN

On Wed, Nov 30, 2011 at 4:49 AM, dguillett1 dguille...@gmail.com wrote:

   I didn’t create the file but the macro appears to get ALL file
 extensions.

 Denon_AVR786_1.pdf
  Denon_DVD556_DFU.pdf desktop.ini Double click symbol in Symbols to get
 chart.gif DSC_0001 [800x600].JPG


 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* B.N.Chethan Kumar chetankumar1...@gmail.com
 *Sent:* Tuesday, November 29, 2011 5:03 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Need Help

   Hi,

 Thanks these help.

 But need some additional input. these work only PST or OST file...can u
 help with any file pattern..like .DOC, XLS,.XL.PPT ,etc

 Regards
 Chethan Kumar BN
 On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:

   Here is a file that should help

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* B.N.Chethan Kumar chetankumar1...@gmail.com
 *Sent:* Tuesday, November 29, 2011 4:04 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Need Help

   Hi All,

 I got these Macro template from one guys of these group some time back. I
 need some additional infortmation to be added in the macro.

 Currently these macro help with list of folder and files based on
 locaton. Kindly let me know how to add some additioanl information like
 Size of file and Last modified date of the file.

 As i have maintain these data to help Archieve the Server on regular
 basis.

 Expect a solution ASAP.

 --
 B.N Chetan kumar
 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com
  --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




 --
 B.N Chetan kumar
 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post

Re: $$Excel-Macros$$ Need Help

2011-11-29 Thread B.N.Chethan Kumar
Hi,

Thanks these help.

But need some additional input. these work only PST or OST file...can u
help with any file pattern..like .DOC, XLS,.XL.PPT ,etc

Regards
Chethan Kumar BN
On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:

   Here is a file that should help

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* B.N.Chethan Kumar chetankumar1...@gmail.com
 *Sent:* Tuesday, November 29, 2011 4:04 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Need Help

   Hi All,

 I got these Macro template from one guys of these group some time back. I
 need some additional infortmation to be added in the macro.

 Currently these macro help with list of folder and files based on locaton.
 Kindly let me know how to add some additioanl information like Size of file
 and Last modified date of the file.

 As i have maintain these data to help Archieve the Server on regular basis.

 Expect a solution ASAP.

 --
 B.N Chetan kumar
 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Re: $$Excel-Macros$$ Adding Conditional Formatting to an existing formula

2011-11-23 Thread B.N.Chethan Kumar
Hi Sunnie,

The attached file with the condition format. Hope these is what your
requirment was.

Regards
Chethan Kumar BN
On Thu, Nov 24, 2011 at 5:18 AM, Susan 1 sunni...@gmail.com wrote:

 I’m having trouble using the conditional formatting.
 I’m trying to get a calculated value (would like to use the IF function),
 on the YTD spreadsheet from Cells D17 through M28, to become Red Font,
 based on the value of the Cell in C18 through C28, 2011 Unit Target

 Currently I am updating the spreadsheet to include a formula to pull data
 from another spreadsheet , so the actual data I am referring to in this
 question is  the cells M18 through M28 because it has the formula in it
 that I'd like to use for the rest of the spreadsheet for this year and
 future years,  ='G:\Data\NHPPD\2011 NHPPD Summaries\[2011 AD Weekly and
 Monthly Summaries.xls]Oct 23-Oct 29, 2011'!$D5
 Makes my job easier and faster :-)

 For example  i thought i could write an IF formula such as =if (m19C19,
 (conditional formatting to red font), but I cannot figure it out.

 Can you please help?
 PS there is no data for cells C16 , because PPICU doesn't require a targeT
 number.

 Thanks and Happy Holidays!
 xoxx
 Sunnie

 --
 FORUM RULES (934+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


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


Re: $$Excel-Macros$$ Number Formats in French

2011-10-28 Thread B.N.Chethan Kumar
Hi Kent,

I have attached the file with custom format. Kindly check if these help.

Regards
Chethan Kumar BN

On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles kent.bouc...@tbs-sct.gc.ca
 wrote:

 Hi guys!
 I have a quick question regarding formats. I have to
 convert english accounting procedures into French accounting
 procedures.

 In English one thousand dollars is equal to $1,000.00.
 In French one thousand dollars is equal to 1 000,00.

 the difference is that the comma before a thousand is replaced with a
 space AND our decimal is replaced with a comma and NO dollar sign.

 Another example is:

 In English one thousand dollars is equal to $9,555,333.00.
 In French one thousand dollars is equal to 9 555 333,00.

 Can you help me create this custom format? Your help is great
 appreciated!!

 Thank you,
 Kent

 --
 FORUM RULES (925+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Englsih to french format.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Number Formats in French

2011-10-28 Thread B.N.Chethan Kumar
Thanks SAM,

I missed that part. please find the updated format.
Regards
Chethan Kumar BN
On Sat, Oct 29, 2011 at 3:15 AM, Sam Mathai Chacko samde...@gmail.comwrote:

 The OP had requested for the decimal separator to be a comma (,)

 Sam


 On Sat, Oct 29, 2011 at 3:07 AM, B.N.Chethan Kumar 
 chetankumar1...@gmail.com wrote:

 Hi Kent,

 I have attached the file with custom format. Kindly check if these help.

 Regards
 Chethan Kumar BN

   On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles 
 kent.bouc...@tbs-sct.gc.ca wrote:

 Hi guys!
 I have a quick question regarding formats. I have to
 convert english accounting procedures into French accounting
 procedures.

 In English one thousand dollars is equal to $1,000.00.
 In French one thousand dollars is equal to 1 000,00.

 the difference is that the comma before a thousand is replaced with a
 space AND our decimal is replaced with a comma and NO dollar sign.

 Another example is:

 In English one thousand dollars is equal to $9,555,333.00.
 In French one thousand dollars is equal to 9 555 333,00.

 Can you help me create this custom format? Your help is great
 appreciated!!

 Thank you,
 Kent

 --
 FORUM RULES (925+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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




 --
 B.N Chetan kumar

 --
 FORUM RULES (925+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




 --
 Sam Mathai Chacko

 --
 FORUM RULES (925+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


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




-- 
B.N Chetan kumar

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Englsih to french format updated.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Sum Product Sheet

2011-10-18 Thread B.N.Chethan kumar
Hi,

Please find some more example on sum product.

Regards
Chethan Kumar BN

On Tue, Oct 18, 2011 at 10:59 AM, ashish koul koul.ash...@gmail.com wrote:

 http://www.bygsoftware.com/Excel/functions/sumproduct.htm

 http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

 http://www.exceluser.com/explore/sumproduct_11.htm
 http://www.excelhero.com/blog/2010/01/the-venerable-sumproduct.html
 www.maysstuff.com/*excel*/*sumproduct*.xls


 On Tue, Oct 18, 2011 at 10:49 AM, Ankit Agrawal 
 ankit.agrawal...@gmail.com wrote:

 Dear Sirs,

 Please provide me sumproduct functions sheet which having different
 example in it.

 @Noorain Ansari sir, Looking your help also.

 Thanks  Regards,
 Ankit

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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*
 *http://www.excelvbamacros.com/*


 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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


Sumproduct.xls
Description: MS-Excel spreadsheet


Re: $$Excel-Macros$$ Extract from date and time

2011-10-18 Thread B.N.Chethan kumar
Hi,

Lot of option you as suggested by many expert.

if the data need to extract to 2 different formt..

Use below formualeInt( a1)Date and Mod(a2,1)---time...change the
format of cell as required.

Happy learning

Regards
Chethan Kumar BN

On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan arslanacca...@gmail.comwrote:




 Dear Experts
 I need to disjoint date and time form a text. Help me out how to tackle in
 excel using formual. Text is following

 4/11/2011 08:39:20 PM

 Help me out hoping for your prompt relpy.
 Kind Regards
 Muhammad Arslan

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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$$ Get the Unique value from pivot table in combo box

2011-10-17 Thread B.N.Chethan kumar
Hi,

http://datapigtechnologies.com/blog/index.php/recordset-tricks-in-excel-1-filling-a-combobox-with-unique-values/

Hope these link help u better.

On Mon, Oct 17, 2011 at 11:03 PM, ICWAI Help icwai.answ...@gmail.comwrote:

 Hello,

 I have a pivot table which is dynamic which is going to be change
 every time when i open the workbook
 i want to get the unique value from pivot table field in combo box
 add
 item.


 lets example :


 my pivot table field is Agent name there are several agent who work
 repetedly till 4 rows so i need to get the unique vallue in combo
 box item


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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 Request

2011-10-12 Thread B.N.Chethan kumar
Hi,

Hope these help, Drag the file down untill last row of the data sheet.

On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest ahmedhon...@gmail.com wrote:

  Dear Mr. Shiek,

 Tons of thanks for your help. I hope that U achieved it by VBA but is there
 any formula of excel to achieve this?

 Dear Mr. Don Guillet,

 Thanks for your inputs as well...!

 Regards
 Ahmed Bawazir

   On Wed, Oct 12, 2011 at 4:02 PM, Shiek Peer Mohd shiekp...@gmail.comwrote:

 **Hi,

 Hope it helps.

 Regards

 Shiek

   On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.comwrote:

   You say “single LINE”. Do you mean one cell ? If so, NO.

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* Ahmed Honest ahmedhon...@gmail.com
 *Sent:* Wednesday, October 12, 2011 7:12 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Solution Request

Dear All,

 If an excel file contains 1000's of emails ids in a column say as below :

 'pi...@gmail.com --- in Cell A1
 'ti...@gmail.com--- in Cell A2
 li...@yahoo.com --- in Cell A3
 zi...@yahoo.com--- in Cell A4
 I need a formula to make all these email id as : *pi...@gmail.com,
 ti...@gmail.com,li...@gmail.com,zi...@gmail.com  i.e Each email id
 separated by comma but in  a single line. But please note i have 1000's of
 records so want to convert these into a single line.*
 **
 Waiting in anticipation for your help...!
 **
 **
 --
  Ahmed Bawazir
 *احمد باوزير*

 --

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

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

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

 --

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

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

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




 --
 Regards,

 Shiek

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




 --
  Ahmed Bawazir
 *احمد باوزير*

   --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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 of email Ids.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Need a help -----very urgent

2011-10-06 Thread B.N.Chethan kumar
HI Swapnil,

Thnxs for the code...along with date..i also need to convert time from
textplease refer coloum O to AA in excel.

Kindly help me with the code...please

On Thu, Oct 6, 2011 at 11:36 AM, Swapnil Palande 
palande.swapni...@gmail.com wrote:

 Hi,

 Further to Sam's solution, here is the complete code
 Sub converToDate()
 Dim sht As Worksheet
 Dim rng As Range
 Dim r1 As Integer, r2 As Integer

 For Each sht In ThisWorkbook.Sheets
 Set rng = sht.Range(A1)
 Do While UCase(Trim(rng.Value))  DATE
 Set rng = rng.Offset(1)
 Loop
 Set rng = rng.Offset(1)
 r1 = rng.Row
 r2 = rng.End(xlDown).Offset(-1).Row
 sht.Range(A  r1  :A  r2).TextToColumns Destination:=rng,
 DataType:=1, TextQualifier:=1, FieldInfo:=Array(1, 4),
 TrailingMinusNumbers:=True
 Next sht
 End Sub

 Pls find attached excel for ref.

 Press Ctrl + q to run the code.

 Regards,

 Swapnil.
   On Thu, Oct 6, 2011 at 11:06 AM, Sam Mathai Chacko 
 samde...@gmail.comwrote:

 Well, actually, use

 Range(A3:A6).TextToColumns Destination:=Range(A3), DataType:=1,
 TextQualifier:=1, FieldInfo:=Array(1, 4), TrailingMinusNumbers:=True

 Sorry for posting without testing the previous one.


 Regards,

 Sam Mathai Chacko (GL)


   On Thu, Oct 6, 2011 at 10:57 AM, Sam Mathai Chacko 
 samde...@gmail.comwrote:

 Range(A3:A6).TextToColumns Range(A3), 0, 1, False, True, False,
 False, False, False, Array(1, 4), True

 Regards,

 Sam


 On Thu, Oct 6, 2011 at 10:56 AM, B.N.Chethan kumar 
 chetankumar1...@gmail.com wrote:

 Hi,

 As the data volume is high... i will have 100 to 200 sheets in a
 month..hence take more time

 Can we write any macro to convert for all sheet in the work book.

 Thanks Asa Rossoff...i will try below option.

 Regards
 Chethan Kumar BN

   On Thu, Oct 6, 2011 at 10:48 AM, Asa Rossoff a...@lovetour.infowrote:

  Hello B.N.Chethan,

 ** **

 Here are two methods courtesy of
 http://www.ozgrid.com/Excel/convert-true-time-date.htm

 ** **

 1. Option 1: Copy an empty cell, then highlight the cells (or entire
 column(s)) containing your textual date/times, then Paste SpecialAdd.  
 The
 add operation forces Excel to convert the date/time.

 ** **

 2. Option 2: use a formula in another cell that does a neutral math
 operation like *=A3+0* or *=A3*1* or *=--A3*.   You could if desired
 copy those cells to another location using Paste SpecialValues.

 ** **

 I'll just add that if the data is being imported from a text file, make
 sure you highlight the column containing date/times during import and
 specify the correct date format for that column; it may avoid the whole
 problem.

 ** **

 Asa

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan kumar
 *Sent:* Wednesday, October 05, 2011 9:50 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Need a help -very urgent

 ** **

 Hi All,

  

 I have attached file where i get some data in text format. I need
 convert to date and time format.

  

 Currently using text to coloumn method which is manually pocess.  As
 sheet count is high in a workbook, these is very painful work to do in 
 month
 end.

  

 Kindly request your help to very painful work.

 -- 

 Regards
 B.N Chetan kumar

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




 --
  B.N Chetan kumar

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel

Re: $$Excel-Macros$$ Excel is showing Error

2011-10-06 Thread B.N.Chethan kumar
Once i faced some issue. these happen because of comments updated in
previous excel sheer from where data was copied..

i also not able hide columns. Select worksheet and remove comments (excel
2007 steps)

Removing Comments from All Cells

   1.

   Open the sheet with the comments to be deleted
   2.

   From the *Ribbon*, select the *Home* command tab
   3.

   In the *Editing* group, click *FIND  SELECT*» select *Comments*
   All comments on the active sheet will be selected.
   4.

   From the *Editing* group, click *CLEAR*» select *Clear Comments*
   All comments are cleared.

Regards
Chethan Kumar BN

On Fri, Oct 7, 2011 at 12:47 AM, Dilip Pandey dilipan...@gmail.com wrote:

 Just an additional check.
 Verify if there are some objects lying at the boarder of the
 worksheet.  See the attachment for better understanding.

 Feel free to get back in case of any queries.

 Regards,
 DILIPandey

 On 10/6/11, Sam Mathai Chacko samde...@gmail.com wrote:
  I wasn't able to see the picture earlier. Strange! Anyway, Anil, apart
 from
  the reasons mentioned by MS, this also occurs when the used range of your
  sheet covers the entire sheet area, and if you insert a row or column,
 Excel
  blocks the action assuming that there might be some row or column that
 could
  get pushed out of the sheet (which it stops from happening by giving an
  error)
 
  HTH
 
  Sam
 
  On Thu, Oct 6, 2011 at 1:25 PM, Mahesh parab mahes...@gmail.com wrote:
 
  Hi Anil
 
  check whether this helps
  http://support.microsoft.com/kb/211769/en-us
 
 
 
  HTH
  Mahesh
 
 
  On Thu, Oct 6, 2011 at 1:20 PM, Sam Mathai Chacko
  samde...@gmail.comwrote:
 
  What error?
 
 
 
  On Thu, Oct 6, 2011 at 1:16 PM, Anil Bhange 
  anil.bha...@tatacommunications.com wrote:
 
  Hi Expert,
 
  ** **
 
  Could you please let me know why below error is coming while hiding
 some
  of the columns
 
  ** **
 
  
 
  ** **
 
  ** **
 
  *Anil Bhange*
 
  *Assistant Manager*
  Financial Reporting  Compliance,
 
  TATA Communications Ltd.
  VSB, Fort,  Mumbai – 400 001,
  India
 
  ** **
 
  ' Desk : + 91 22 6659 2320
  | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
 
  anil.bha...@tatacommunications.com
 
  ** **
 
  ** **
  
  --
 
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 
 
 
 
  --
  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
 


 --
 Thanks  Regards,

 DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
 Mobile: 

$$Excel-Macros$$ Need a help -----very urgent

2011-10-05 Thread B.N.Chethan kumar
Hi All,

I have attached file where i get some data in text format. I need convert to
date and time format.

Currently using text to coloumn method which is manually pocess.  As sheet
count is high in a workbook, these is very painful work to do in month end.

Kindly request your help to very painful work.

-- 
Regards
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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 data.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Need a help -----very urgent

2011-10-05 Thread B.N.Chethan kumar
Thanks SAM, for prompt response...currently i using the same option to
convert date and text to columns option for time...

Due to data size...it is taking more time.

Regards
Chethan Kumar BN

On Thu, Oct 6, 2011 at 10:43 AM, Sam Mathai Chacko samde...@gmail.comwrote:

 =DATEVALUE(LEFT(A3,2)/MID(A3,FIND( ,A3)+1,3)/RIGHT(A3,4))

 Regards,

 Sam Mathai Chacko (GL)


 On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar 
 chetankumar1...@gmail.com wrote:

 Hi All,

 I have attached file where i get some data in text format. I need convert
 to date and time format.

 Currently using text to coloumn method which is manually pocess.  As sheet
 count is high in a workbook, these is very painful work to do in month end.

 Kindly request your help to very painful work.

 --
 Regards
 B.N Chetan kumar

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

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


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


Re: $$Excel-Macros$$ Need a help -----very urgent

2011-10-05 Thread B.N.Chethan kumar
Hi,

As the data volume is high... i will have 100 to 200 sheets in a
month..hence take more time

Can we write any macro to convert for all sheet in the work book.

Thanks Asa Rossoff...i will try below option.

Regards
Chethan Kumar BN

On Thu, Oct 6, 2011 at 10:48 AM, Asa Rossoff a...@lovetour.info wrote:

  Hello B.N.Chethan,

 ** **

 Here are two methods courtesy of
 http://www.ozgrid.com/Excel/convert-true-time-date.htm

 ** **

 1. Option 1: Copy an empty cell, then highlight the cells (or entire
 column(s)) containing your textual date/times, then Paste SpecialAdd.  The
 add operation forces Excel to convert the date/time.

 ** **

 2. Option 2: use a formula in another cell that does a neutral math
 operation like *=A3+0* or *=A3*1* or *=--A3*.   You could if desired copy
 those cells to another location using Paste SpecialValues.

 ** **

 I'll just add that if the data is being imported from a text file, make
 sure you highlight the column containing date/times during import and
 specify the correct date format for that column; it may avoid the whole
 problem.

 ** **

 Asa

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan kumar
 *Sent:* Wednesday, October 05, 2011 9:50 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Need a help -very urgent

 ** **

 Hi All,

  

 I have attached file where i get some data in text format. I need convert
 to date and time format.

  

 Currently using text to coloumn method which is manually pocess.  As sheet
 count is high in a workbook, these is very painful work to do in month end.
 

  

 Kindly request your help to very painful work.

 -- 

 Regards
 B.N Chetan kumar

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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 Add A Year Field to a PivotTable Field List

2011-10-03 Thread B.N.Chethan kumar
Hi,

you have option to group the file...Bring the data in excel pivit..and right
clickselect group...and select group by year..

you can also group my month  Quarter too..


Regards
Chethan Kumar BN

On Tue, Oct 4, 2011 at 1:32 AM, John A. Smith johnasmit...@gmail.comwrote:

 Attached is a spreadsheet from this forum.  I would like to know how the
 Year field was added to a pivot table with only a date and amount column
 in the Data Source (See Attached File).

 This would be very helpful in a lot of applications I run into.

 Thank you for your ongoing assistance and teachings.

 John

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread B.N.Chethan kumar
congrate mate

On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Group,

 Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
 for the 2nd year in row...

 Congrate Ayush
 --
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

 --

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

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

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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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$$ Incremental Time Calculation from 11:30:00 AM Time Format

2011-09-29 Thread B.N.Chethan kumar
(d2-c2)*24*60 ...change format to number

Regards
Chethan Kumar

On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 dguille...@gmail.com wrote:

  =(D2-C2)*24

  *From:* John A. Smith johnasmit...@gmail.com
 *Sent:* Thursday, September 29, 2011 2:55 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM
 Time Format

   Excel Experts,

 I need to calculate the time differences between 11:30:00 AM and 11:37:00
 AM and show the 7 minutes in the decimal hour format.

 Please see attached sample spreadsheet for the solution I need.

 Thank you for your continuing Excel help.

 John
 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER 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




-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER 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