Hey Naidu, Please find the attachment.
On Thu, Aug 11, 2011 at 1:47 PM, ck naidu <sai21...@gmail.com> wrote:
>> Pleae help me.....................
>>
>> How to restrict the Special character (!@#$%^&*()_+{}:"<>?) on excel
>> sheet with Macros or Data validation.
>>
>> Thanks
>> Chaitu........
>>
>> +91 880-142-3425
>>
>>
>>
>> On 10 August 2011 18:50, <excel-macros+nore...@googlegroups.com> wrote:
>>>
>>> Today's Topic Summary
>>>
>>> Group: http://groups.google.com/group/excel-macros/topics
>>>
>>> Overflow Error 6 [2 Updates]
>>> REMOVE THE ERROR IN THIS FILE [2 Updates]
>>> Can you please help regd. lists [3 Updates]
>>> Want a shortcut to browse tabs, alas, classic code found is not working.
>>> [5 Updates]
>>> Please help [3 Updates]
>>> Locking cells based on conditions / todays date [4 Updates]
>>> Macro copy filter data in a new sheet [2 Updates]
>>> Notes : Help [1 Update]
>>> Job opening [1 Update]
>>> Email : Paste Object [1 Update]
>>> How to add a name column to scatter chart's data label? [1 Update]
>>>
>>> Topic: Overflow Error 6
>>>
>>> <hariharan.thara...@wipro.com> Aug 10 04:21PM +0530 ^
>>>
>>> Hi All,
>>>
>>>
>>>
>>> I am getting Overflow Error 6...in this macro code...Could somebody
>>> please help me in this...
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Hariharan Tharagan
>>>
>>>
>>>
>>> "Rajan_Verma" <rajanverma1...@gmail.com> Aug 10 06:43PM +0530 ^
>>>
>>> What you use (2) in the last of HighLighted Line??
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of hariharan.thara...@wipro.com
>>> Sent: Wednesday, August 10, 2011 4:22 PM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Overflow Error 6
>>>
>>>
>>>
>>> Hi All,
>>>
>>>
>>>
>>> I am getting Overflow Error 6.in this macro code.Could somebody please
>>> help
>>> me in this.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Hariharan Tharagan
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------
>>> ------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Topic: REMOVE THE ERROR IN THIS FILE
>>>
>>> Jai <jaihumtu...@gmail.com> Aug 10 11:39AM +0530 ^
>>>
>>> PLEASE HELP
>>>
>>>
>>>
>>> "Rajan_Verma" <rajanverma1...@gmail.com> Aug 10 06:42PM +0530 ^
>>>
>>> See the attached sheet
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Jai
>>> Sent: Wednesday, August 10, 2011 11:39 AM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ REMOVE THE ERROR IN THIS FILE
>>>
>>>
>>>
>>> PLEASE HELP
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------
>>> ------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Topic: Can you please help regd. lists
>>>
>>> naresh v <naresh.veerabo...@gmail.com> Aug 10 04:51PM +0530 ^
>>>
>>> Hello experts,
>>>
>>> Let us assume in the particular cell i want a dropdown like "south" or
>>> "north".
>>> I will select anyone of it.If I select "south" In the next cell it
>>> should show the "AP","Tamilnadu","Karnataka"
>>> If I select "North" it should show the "Maharastra", "UP" like that
>>> can you please help me...
>>>
>>> Regards,
>>> Naresh V
>>>
>>>
>>>
>>> "Rajan_Verma" <rajanverma1...@gmail.com> Aug 10 06:37PM +0530 ^
>>>
>>> See if it helps
>>>
>>> -----Original Message-----
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of naresh v
>>> Sent: Wednesday, August 10, 2011 4:51 PM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Can you please help regd. lists
>>>
>>> Hello experts,
>>>
>>> Let us assume in the particular cell i want a dropdown like "south" or
>>> "north".
>>> I will select anyone of it.If I select "south" In the next cell it
>>> should show the "AP","Tamilnadu","Karnataka"
>>> If I select "North" it should show the "Maharastra", "UP" like that
>>> can you please help me...
>>>
>>> Regards,
>>> Naresh V
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------
>>> ------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Prakash Paul <jprakashp...@gmail.com> Aug 10 06:39PM +0530 ^
>>>
>>> Hi Naresh,
>>>
>>> Based on your query i have attached the sample file for your reference.
>>>
>>>
>>> Regards
>>> Prakash Paul
>>>
>>>
>>>
>>>
>>>
>>> Topic: Want a shortcut to browse tabs, alas, classic code found is not
>>> working.
>>>
>>> Dsastray <taylor.bry...@gmail.com> Aug 09 02:29PM -0700 ^
>>>
>>> I would like to be able to press a hotkey and have a sheet pop up that
>>> allows me to navigate to any sheet in my workbook. (A shorter version
>>> to bring up the "Activate" dialog you get when you right click on tab
>>> arrows and select "More Sheets...")
>>>
>>> For simplicity sake, we'll say I'm using the following code:
>>>
>>> Sub SheetListAbridged()
>>> Application.CommandBars("Workbook Tabs").Controls("More
>>> Sheets...").Execute
>>> End Sub
>>>
>>> I get the activate popup one would expect when "More Sheets..." is
>>> selected. Alas, clicking on a workbook name dismisses the dialog, but
>>> does not take me to the selected sheet. Ideas?
>>>
>>>
>>>
>>> Full code:
>>> Sub SheetList_CP()
>>> 'Chip Pearson, 2002-10-29, misc., %23ByZYZ3fCHA.1308%40tkmsftngp11
>>> 'Dave Peterson, same date/thread, 3DBF0BA8.4DAE9DA0%40msn.com
>>> On Error Resume Next
>>>
>>> Application.CommandBars("Workbook Tabs").Controls("More
>>> Sheets...").Execute
>>> If Err.Number > 0 Then
>>> Err.Clear
>>> Application.CommandBars("Workbook Tabs").ShowPopup
>>> End If
>>> On Error GoTo 0
>>> End Sub
>>>
>>>
>>>
>>> "Rajan_Verma" <rajanverma1...@gmail.com> Aug 10 10:41AM +0530 ^
>>>
>>> See the attached file, Press Shift+CTRL +S ,
>>> Hope it will help you
>>>
>>> -----Original Message-----
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Dsastray
>>> Sent: Wednesday, August 10, 2011 2:59 AM
>>> To: MS EXCEL AND VBA MACROS
>>> Subject: $$Excel-Macros$$ Want a shortcut to browse tabs, alas, classic
>>> code
>>> found is not working.
>>>
>>> I would like to be able to press a hotkey and have a sheet pop up that
>>> allows me to navigate to any sheet in my workbook. (A shorter version
>>> to bring up the "Activate" dialog you get when you right click on tab
>>> arrows and select "More Sheets...")
>>>
>>> For simplicity sake, we'll say I'm using the following code:
>>>
>>> Sub SheetListAbridged()
>>> Application.CommandBars("Workbook Tabs").Controls("More
>>> Sheets...").Execute
>>> End Sub
>>>
>>> I get the activate popup one would expect when "More Sheets..." is
>>> selected. Alas, clicking on a workbook name dismisses the dialog, but
>>> does not take me to the selected sheet. Ideas?
>>>
>>>
>>>
>>> Full code:
>>> Sub SheetList_CP()
>>> 'Chip Pearson, 2002-10-29, misc., %23ByZYZ3fCHA.1308%40tkmsftngp11
>>> 'Dave Peterson, same date/thread, 3DBF0BA8.4DAE9DA0%40msn.com
>>> On Error Resume Next
>>>
>>> Application.CommandBars("Workbook Tabs").Controls("More
>>> Sheets...").Execute
>>> If Err.Number > 0 Then
>>> Err.Clear
>>> Application.CommandBars("Workbook Tabs").ShowPopup
>>> End If
>>> On Error GoTo 0
>>> End Sub
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------
>>> ------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Viswanathan M <vis...@gmail.com> Aug 10 08:30AM +0530 ^
>>>
>>> Dear Sir
>>> CTRL+PageUP/PageDN may be tried for a change
>>>
>>>
>>>
>>>
>>> --
>>> *With warm regards*
>>> *Viswanathan M*
>>> DE(Tech)
>>> RGM TTC Chennai-600027
>>> mviswanat...@bsnl.co.in
>>> 94861 00423
>>> *Vande* *Mataram*
>>>
>>>
>>>
>>> ashish koul <koul.ash...@gmail.com> Aug 10 09:48AM +0530 ^
>>>
>>> try this method .
>>>
>>>
>>> you can add the code to personal workbook or can create an add-in
>>>
>>>
>>> also i have created a simple addin for this press alt f11 to see the code
>>> of addin "xl_in_excel.xlam" for 2007 and above
>>>
>>> addin "xl_in_excel.xla" for 2003
>>>
>>> you can also keep on adding ur own menus and macros in it
>>>
>>>
>>>
>>>
>>>
>>>
>>> > <><><><><><><><><><><><><><><><><><><><><><>
>>> > Like our page on facebook , Just follow below link
>>> > http://www.facebook.com/discussexcel
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>>> http://akoul.posterous.com/
>>> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>> "dguillett1" <dguille...@gmail.com> Aug 10 07:53AM -0500 ^
>>>
>>> Notice the sheet arrow keys at the bottom left. RIGHT click one>voila
>>>
>>> -----Original Message-----
>>> From: Dsastray
>>> Sent: Tuesday, August 09, 2011 4:29 PM
>>> To: MS EXCEL AND VBA MACROS
>>> Subject: $$Excel-Macros$$ Want a shortcut to browse tabs, alas, classic
>>> code
>>> found is not working.
>>>
>>> I would like to be able to press a hotkey and have a sheet pop up that
>>> allows me to navigate to any sheet in my workbook. (A shorter version
>>> to bring up the "Activate" dialog you get when you right click on tab
>>> arrows and select "More Sheets...")
>>>
>>> For simplicity sake, we'll say I'm using the following code:
>>>
>>> Sub SheetListAbridged()
>>> Application.CommandBars("Workbook Tabs").Controls("More
>>> Sheets...").Execute
>>> End Sub
>>>
>>> I get the activate popup one would expect when "More Sheets..." is
>>> selected. Alas, clicking on a workbook name dismisses the dialog, but
>>> does not take me to the selected sheet. Ideas?
>>>
>>>
>>>
>>> Full code:
>>> Sub SheetList_CP()
>>> 'Chip Pearson, 2002-10-29, misc., %23ByZYZ3fCHA.1308%40tkmsftngp11
>>> 'Dave Peterson, same date/thread, 3DBF0BA8.4DAE9DA0%40msn.com
>>> On Error Resume Next
>>>
>>> Application.CommandBars("Workbook Tabs").Controls("More
>>> Sheets...").Execute
>>> If Err.Number > 0 Then
>>> Err.Clear
>>> Application.CommandBars("Workbook Tabs").ShowPopup
>>> End If
>>> On Error GoTo 0
>>> End Sub
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Topic: Please help
>>>
>>> Sundarvelan N <nsund...@gmail.com> Aug 10 10:22AM +0530 ^
>>>
>>> Hi Friends,
>>>
>>> Please refer the attached image. Please help on this scenatio.
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>>
>>>
>>> "Rajan_Verma" <rajanverma1...@gmail.com> Aug 10 10:59AM +0530 ^
>>>
>>> Please Attach Your excel file..
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Sundarvelan N
>>> Sent: Wednesday, August 10, 2011 10:23 AM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Please help
>>>
>>>
>>>
>>> Hi Friends,
>>>
>>>
>>>
>>> Please refer the attached image. Please help on this scenatio.
>>>
>>>
>>> Thanks
>>>
>>> N.Sundarvelan
>>>
>>> 9600160150
>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------
>>> ------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> "dguillett1" <dguille...@gmail.com> Aug 10 07:50AM -0500 ^
>>>
>>> Attach a file
>>>
>>> From: Sundarvelan N
>>> Sent: Tuesday, August 09, 2011 11:52 PM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Please help
>>>
>>> Hi Friends,
>>>
>>> Please refer the attached image. Please help on this scenatio.
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Topic: Locking cells based on conditions / todays date
>>>
>>> AJ <laxplaya000...@gmail.com> Aug 09 12:20PM -0700 ^
>>>
>>> There are dates in calendar order stored in row 4, beginning in column
>>> F through column BR. How can I write a code so that it locks a
>>> certain amount of cells below the date if it occurs in the past. For
>>> example: January 14th is in cell O4. If todays date was January
>>> 14th, i would want to lock all cells within the range F4:O21
>>>
>>> Thanks in advance for the help,
>>>
>>> AJ
>>>
>>>
>>>
>>> ashish koul <koul.ash...@gmail.com> Aug 10 09:49AM +0530 ^
>>>
>>> can you attach the sample worksheet
>>>
>>>
>>> > <><><><><><><><><><><><><><><><><><><><><><>
>>> > Like our page on facebook , Just follow below link
>>> > http://www.facebook.com/discussexcel
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>>> http://akoul.posterous.com/
>>> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>> Akhilesh Kumar Karna <akhiles...@gmail.com> Aug 10 11:51AM +0900 ^
>>>
>>> Your can probably use the following Code.
>>>
>>> Sub LockMacro()
>>>
>>>
>>> Dim dt As Date
>>>
>>> Dim i As Integer
>>> Dim nr As Integer
>>> Dim r As Range
>>> i = 6 'range->F
>>>
>>> While Cells(4, i) <> "" And Cells(1, i) < dt '---Row4
>>> i = i + 1
>>> Wend
>>>
>>> Set r = Range(Cells(1, 1), Cells(30, i - 1))
>>> r.Locked = True
>>> End Sub
>>>
>>> Akhilesh
>>>
>>>
>>>
>>>
>>>
>>> "dguillett1" <dguille...@gmail.com> Aug 10 07:49AM -0500 ^
>>>
>>> Attach a file with a better explanation and before/after examples
>>>
>>>
>>> -----Original Message-----
>>> From: AJ
>>> Sent: Tuesday, August 09, 2011 2:20 PM
>>> To: MS EXCEL AND VBA MACROS
>>> Subject: $$Excel-Macros$$ Locking cells based on conditions / todays date
>>>
>>> There are dates in calendar order stored in row 4, beginning in column
>>> F through column BR. How can I write a code so that it locks a
>>> certain amount of cells below the date if it occurs in the past. For
>>> example: January 14th is in cell O4. If todays date was January
>>> 14th, i would want to lock all cells within the range F4:O21
>>>
>>> Thanks in advance for the help,
>>>
>>> AJ
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Topic: Macro copy filter data in a new sheet
>>>
>>> Simran Singh <simran....@gmail.com> Aug 10 08:39AM +0530 ^
>>>
>>> Hello EXPERTS
>>>
>>> I have a workbook wherein there are thee sheets (Database, Mapping &
>>> Employee Name). In the Database sheet, I pull out the data from the tool
>>> and
>>> put that data in Database sheet. The mapping sheet consist a list of
>>> employee who are basically associated with one group or more than one
>>> groups. And in the last sheet Employee Name is the data for which i have
>>> to
>>> take out data from the Database sheet. So what I want basically is :-
>>>
>>>
>>> 1. Macro to go in the sheet Employee Name and check for the name for
>>> which it has to filter the data.
>>> 2. After taking the details from the Employee Name sheet it comes to the
>>> Mapping sheet and check for the group or groups a employee is associated
>>> with.
>>> 3. After this macro should come to the Database sheet and filter the data
>>> according to group or groups which it has got in the Mapping sheet.
>>> 4. After filter it should copy the Total Hours and Actual Hours data from
>>> there and paste in the Output sheet.
>>>
>>> Sorry I cannot give you the actual data, but I am attaching the dummy
>>> data
>>> for your reference.
>>>
>>> Thanks in advance
>>>
>>> Regards,
>>> Simran Singh
>>>
>>>
>>>
>>> "dguillett1" <dguille...@gmail.com> Aug 10 07:47AM -0500 ^
>>>
>>> What you want is doable with a macro. However, your “dummy” data does not
>>> give data for testing to see what you really want. Redo your data and give a
>>> better explanation of what you want. This to get you started
>>>
>>> Application.Goto Sheets(3).Range("a2")
>>> myname = Application.InputBox("Pick a cell Then click OK", Type:=8)
>>> MsgBox myname
>>>
>>>
>>> From: Simran Singh
>>> Sent: Tuesday, August 09, 2011 10:09 PM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Macro copy filter data in a new sheet
>>>
>>> Hello EXPERTS
>>>
>>> I have a workbook wherein there are thee sheets (Database, Mapping &
>>> Employee Name). In the Database sheet, I pull out the data from the tool and
>>> put that data in Database sheet. The mapping sheet consist a list of
>>> employee who are basically associated with one group or more than one
>>> groups. And in the last sheet Employee Name is the data for which i have to
>>> take out data from the Database sheet. So what I want basically is :-
>>>
>>>
>>> 1.. Macro to go in the sheet Employee Name and check for the name for
>>> which it has to filter the data.
>>> 2.. After taking the details from the Employee Name sheet it comes to the
>>> Mapping sheet and check for the group or groups a employee is associated
>>> with.
>>> 3.. After this macro should come to the Database sheet and filter the
>>> data according to group or groups which it has got in the Mapping sheet.
>>>
>>> 4.. After filter it should copy the Total Hours and Actual Hours data
>>> from there and paste in the Output sheet.
>>> Sorry I cannot give you the actual data, but I am attaching the dummy
>>> data for your reference.
>>>
>>> Thanks in advance
>>>
>>> Regards,
>>> Simran Singh
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> Topic: Notes : Help
>>>
>>> Chandra Shekar <chandrashekarb....@gmail.com> Aug 10 02:40PM +0200 ^
>>>
>>> Hi,
>>>
>>> In below code some times I could able to send attachments but some times
>>> its
>>> not taking attachment at all. Please let me know whats is the problem in
>>> the
>>> below code.
>>>
>>> Sub sendmail()
>>> '
>>> Dim UserName As String
>>> Dim MailDbName As String
>>> Dim Recipient As Variant
>>> Dim ccRecipient As String
>>> Dim Attachment1 As String
>>> Dim Maildb As Object
>>> Dim MailDoc As Object
>>> Dim AttachME As Object
>>> Dim AttachME2 As Object
>>> Dim AttachME3 As Object
>>> Dim AttachME4 As Object
>>> Dim AttachME5 As Object
>>> Dim Session As Object
>>> Dim EmbedObj1 As Object
>>> Dim EmbedObj2 As Object
>>> Dim EmbedObj3 As Object
>>> Dim EmbedObj4 As Object
>>> Dim EmbedObj5 As Object
>>> Dim stSignature As String
>>> With Application
>>> .ScreenUpdating = False
>>> .DisplayAlerts = False
>>> ' Open and locate current LOTUS NOTES User
>>> Set Session = CreateObject("Notes.NotesSession")
>>> UserName = Session.UserName
>>> MailDbName = Left$(UserName, 1) & Right$(UserName, (Len(UserName) -
>>> InStr(1,
>>> UserName, " "))) & ".nsf"
>>> Set Maildb = Session.GetDatabase("", MailDbName)
>>> If Maildb.IsOpen = True Then
>>> Else
>>> Maildb.OPENMAIL
>>> End If
>>> ' Create New Mail and Address Title Handlers
>>> Set MailDoc = Maildb.CREATEDOCUMENT
>>> MailDoc.Form = "Memo"
>>> stSignature =
>>> Maildb.GetProfileDocument("CalendarProfile").GetItemValue("Signature")(0)
>>> ' Select range of e-mail addresses
>>> Recipient = notes_id
>>> MailDoc.SendTo = Recipient
>>> MailDoc.Subject = "Test Mail "
>>> MailDoc.Body = "Hi," & vbCrLf & vbCrLf & "Please find attached schedule
>>> for
>>> the day " & vbCrLf & vbCrLf & "Regards" & vbCrLf & vbCrLf & "Chandru"
>>> ' Select Workbook to Attach to E-Mail
>>> MailDoc.SaveMessageOnSend = True
>>> Attachment1 = "C:\temp.bmp" ' Required File Name"
>>> If Attachment1 <> "" Then
>>> On Error Resume Next
>>> Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment1")
>>> Set EmbedObj1 = AttachME.EmbedObject(1454, "", Attachment1,
>>> "Attachment1")
>>> MailDoc.CREATERICHTEXTITEM ("Attachment1")
>>> On Error Resume Next
>>> End If
>>> MailDoc.PostedDate = Now()
>>> On Error GoTo errorhandler1
>>> MailDoc.SEND 0, Recipient
>>> Set Maildb = Nothing
>>> Set MailDoc = Nothing
>>> Set AttachME = Nothing
>>> Set AttachME2 = Nothing
>>> Set AttachME3 = Nothing
>>> Set AttachME4 = Nothing
>>> Set AttachME5 = Nothing
>>> Set Session = Nothing
>>> Set EmbedObj1 = Nothing
>>> Set EmbedObj2 = Nothing
>>> Set EmbedObj3 = Nothing
>>> Set EmbedObj4 = Nothing
>>> Set EmbedObj5 = Nothing
>>> .ScreenUpdating = True
>>> .DisplayAlerts = True
>>> Exit Sub
>>> End With
>>> errorhandler1:
>>> MsgBox Err.Description
>>> Set Maildb = Nothing
>>> Set MailDoc = Nothing
>>> Set AttachME = Nothing
>>> Set AttachME2 = Nothing
>>> Set AttachME3 = Nothing
>>> Set AttachME4 = Nothing
>>> Set AttachME5 = Nothing
>>> Set Session = Nothing
>>> Set EmbedObj1 = Nothing
>>> Set EmbedObj2 = Nothing
>>> Set EmbedObj3 = Nothing
>>> Set EmbedObj4 = Nothing
>>> Set EmbedObj5 = Nothing
>>> End Sub
>>>
>>>
>>>
>>> Topic: Job opening
>>>
>>> Venkat CV <venkat1....@gmail.com> Aug 10 03:05PM +0530 ^
>>>
>>> --------- Original message --------
>>> From:""Bhilwara Infotech Limited""< ma...@bhilwarainfo.com >
>>> Date: 10 Aug 11 13:15:46
>>> Subject: Job opening with Wipro for MIS Executive
>>> To:
>>>
>>> For Internal Use of Employer (Please don't delete or modify while
>>> replying
>>> to this email)Monster Resume ID: 33564079 Personal Folder ID: 10186337
>>> Dear Venkatesan,
>>>
>>> We have an urgent requirement from Wipro (CONTRACT) for Bangalore
>>> Location.
>>>
>>> CANDIDATE SHOULD JOIN WITHIN 15 DAYS
>>>
>>>
>>> JD
>>>
>>> MIS Executive
>>>
>>> inventory experience. Experience with information management, forecasting
>>> and vendor management required
>>>
>>> If you are really interested please revert back to this mail with your
>>> Cont.
>>> No and updated resume ASAP.
>>>
>>>
>>>
>>>
>>>
>>> This mail has been sent by one of the employers (Employer name: Bhilwara
>>> Infotech Limited) accessing the services of monsterindia.com and not by
>>> Monster. Monster is committed to protecting the privacy of our users and
>>> our
>>> “Terms of Use” prohibits any misuse including spamming. If you consider
>>> the
>>> contents of the mails inappropriate or as spam, please forward this mail
>>> to
>>> spam@monsterindia.comDouble your chances of getting the right job by
>>> keeping
>>> your resume updated.
>>> Update Resume now
>>>
>>> *Best Regards,*
>>> *Venkat *
>>> *Chennai*
>>> *
>>> *
>>> *
>>> *
>>>
>>>
>>>
>>> Topic: Email : Paste Object
>>>
>>> Chandra Shekar <chandrashekarb....@gmail.com> Aug 10 08:14AM +0200 ^
>>>
>>> Hi Ashish,
>>>
>>> Thanks for the reply. If u don't mind can u pls help me with the code
>>> which
>>> has in attached excel file, because I am little bit confused with both
>>> the
>>> codes.
>>>
>>> Thanks in advance.
>>>
>>>
>>>
>>>
>>> Topic: How to add a name column to scatter chart's data label?
>>>
>>> Stuart Redmann <dertop...@web.de> Aug 09 10:58PM -0700 ^
>>>
>>> On 6 Aug., Excel 009 wrote:
>>>
>>> > > > I want to put the values (a, b, c, d, e) from the Person
>>> > > > column next to the data point. For example, d for
>>> > > > the (1,5).
>>>
>>>
>>> On August 09, Stuart Redmann wrote:
>>>
>>> > > You can do the following workaround: Make the chart an ordinary
>>> > > XYScatter chart and add one series for each data point:
>>>
>>> > > Sub CreateChart()
>>>
>>> [snip]
>>>
>>>
>>> On 9 Aug., Rajan_Verma wrote:
>>> > I don't have a Very Good Experience with Charting with VBA and I
>>> > have tried this Macro Exist in trail mail, its giving an error
>>> > "Series Order Must be An Integer 0 to 255" , Can anybody explain this
>>>
>>>
>>> Most probably you have hit the limit of 255 series for a chart, since
>>> my macro tries to create a series for each row of the selected range.
>>> If this is a real problem, we would have to change the code in such a
>>> way that more multiple charts are created that are placed at the same
>>> location.
>>>
>>> However, I tried to create a chart with 400 series and the error
>>> message I am getting is more cryptic "Run-time Error 1004". So
>>> probably you have done something else. Could you post an example
>>> worksheet that shows this problem?
>>>
>>> Regards,
>>> Stuart
>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>
>>
>>
>> --
>> ThanX,
>> Chudheer Kumar
>
>
>
> --
> ThanX,
> Chudheer 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
Copy of disallow_characters-1.xlsm
Description: application/force-download
