Re: $$Excel-Macros$$ Rank Formula
One way using this array formula (entered using ctrl+shift+enter CSE) INDEX($C:$C,MATCH(LARGE(IF($F$5:$F$15<>"fail",$D$5:$D$15),ROW(A1)),$D:$D,0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Tuesday, September 04, 2012 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rank Formula -- 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$$ Rank Formula
Put in H5 and copy down =SUMPRODUCT(--($F$5:$F$14<>"fail"),--(D5<$D$5:$D$14))+1 Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: kumar Kishore Sent: Tuesday, September 04, 2012 7:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rank Formula hai..friends/Masters, i had applied formula in column G2 and i need same numer in H3 but while copying it shows only ref. Please tell how to do. Regards, Kishore -- 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. Rank Formula.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Please Help
I did NOT look at your attachment because you did not provide a meaningful subject line in your post and you did not explain your problem in the body of the email. I hope you explained, with examples, in the file. But, I didn’t look. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jeet singh Sent: Wednesday, September 05, 2012 11:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear All, plz find the attachment and help Regards Jeet -- 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$$ Fwd: Please Help
I did NOT look at your attachment because you did not provide a meaningful subject line in your post and you did not explain your problem in the body of the email. I hope you explained, with examples, in the file. But, I didn’t look Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jeet singh Sent: Thursday, September 06, 2012 6:01 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Please Help Dear All, plz find the attachment and help Regards Jeet -- 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: Please Help
ditto Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, September 06, 2012 6:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Please Help Have you read the "Forum Rules"? (Well, SOME are more of a "guideline".) 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. As an example: My Excel-Macros emails go to a special folder. I get anywhere from 10-100 emails in this folder daily. I sort that folder by Subject. Then delete all emails that say "Please Help", "URGENT", etc. I figure that if the person cannot take the time to describe what he/she needs, then I don't wish to donate MY time to study and research to determine what he/she needs. Just thought you should know. there are MANY intelligent people on this forum that would much rather spend their time helping someone that is considerate enough to present their issue well. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: jeet singh To: excel-macros@googlegroups.com Sent: Thu, September 6, 2012 6:59:56 AM Subject: $$Excel-Macros$$ Re: Please Help ANY UPDATE On Thu, Sep 6, 2012 at 10:28 AM, jeet singh wrote: Dear All, plz find the attachment and help Regards Jeet -- 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 t
Re: $$Excel-Macros$$ Please Help
well said. Hopefully these messages will do some good?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, September 06, 2012 7:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help Don, I did (look) He didn't (explain) He has 5 columns of data and looks like he wants to do a bunch of sumifs, but there's some "selection criteria" he has listed, but doesn't explain what it is or why. I decided that it would take too much effort to ASK for the answers to questions he should've provided in the request. As I told him, if he doesn't want to invest the time to ask an intelligent question, why should I? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ---- From: dguillett1 To: excel-macros@googlegroups.com Sent: Thu, September 6, 2012 8:37:44 AM Subject: Re: $$Excel-Macros$$ Please Help I did NOT look at your attachment because you did not provide a meaningful subject line in your post and you did not explain your problem in the body of the email. I hope you explained, with examples, in the file. But, I didn’t look. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jeet singh Sent: Wednesday, September 05, 2012 11:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear All, plz find the attachment and help Regards Jeet -- 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
Re: $$Excel-Macros$$ Sun IDM Developer in NY
6) Jobs posting is not allowed, Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Vinay Kumar Sent: Thursday, September 06, 2012 8:58 AM To: Vinay Kumar Subject: $$Excel-Macros$$ Sun IDM Developer in NY Req: Sun IDM Developer Location: NY Duration 12 months Required Skills Include: - Experienced in Sun Identity Manager 8.X (Oracle Waveset) and ability to work on workflow Customizations in PWC framework. - Experience on developing identity management entities like WorkFlow, WorkFlow Subprocess, UserForms, RuleLib, Rules and Java API calls. Good Knowledge in Xpress. - In depth knowledge and hands on experience in: - LDAP, SPML, Active Directory, J2EE, JAVA, DataBase - Oracle 9i and above version. - Ability to understand, debug and refine existing system/ client business requirements and non-stated requirements and implement it into a cost effective Solution Design. Vinay Kumar Diverse Lynx LLC. 300 Alexander Park, Suite # 200 Princeton, NJ 08540 Phone: 732-452-1006 ext 208 Fax: 732-452-0684 Email: vi...@diverselynx.com; www.diverselynx.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$$ Excel macro to add VBA password
Put in a workbook module to find another file to unlock vba
Option Explicit
'Your password goes here
Const gszProjPassword As String = "hello"
Public Sub UnlockMe()
Dim wbName As Variant
Dim wbBook As Workbook
Dim vbaProj As Object
Dim oWin As Object
Dim X As Integer
On Error GoTo ErrorHandler
'Select the workbook with the project to unlock
wbName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
'Open it, assign an object ref to it's vba project
Set wbBook = Workbooks.Open(wbName)
Set vbaProj = wbBook.VBProject
'Close any open code windows
For Each oWin In vbaProj.VBE.Windows
If InStr(oWin.Caption, "(") > 0 Then oWin.Close
Next oWin
Application.VBE.MainWindow.Visible = False
'Check to see if the VBA project is already unlocked
If vbaProj.Protection <> 1 Then
MsgBox "The VBA Project for the file you selected is already unlocked.", 0
Exit Sub
'We found the project to be locked
ElseIf vbaProj.Protection = 1 Then
On Error Resume Next
Do While X < 4
If vbaProj.Protection <> 1 Then
MsgBox "The VBA project for " & wbName & " was unprotected successfully", 64
Exit Do
End If
UnprotectVBProject wbBook, gszProjPassword
X = X + 1
Loop
On Error GoTo 0
End If
ErrorExit:
Set wbBook = Nothing
Set vbaProj = Nothing
Exit Sub
ErrorHandler:
Select Case Err.Number
Case 1004
wbBook.Close False
MsgBox "You will need to set the " & _
"{ TRUST ACCESS TO VISUAL BASIC PROJECT } setting" & vbNewLine & _
"When the dialog appears, go to the Trusted Sources tab, " & _
"check the setting, click OK, and rerun this code again", 64
SendKeys "%T", True
SendKeys "M", True
SendKeys "S", True
Case Else
MsgBox Err.Description
End Select
Resume ErrorExit
End Sub
Public Sub UnprotectVBProject(wb As Workbook, ByVal Password As String)
Dim vbProj As Object
On Error GoTo ErrorHandler
Application.ScreenUpdating = False
Set vbProj = wb.VBProject
'Check to see if VBA project is already unlocked
If vbProj.Protection <> 1 Then Exit Sub
'Activate chosen VBA Project
Set Application.VBE.ActiveVBProject = vbProj
'SendKeys is the only way
If Password = "^^" Or Password = "++" Then
Password = ""
Exit Sub
ElseIf Right(Password, 2) = "^^" Or Right(Password, 2) = "++" Then
Password = ""
Exit Sub
Else
SendKeys Password & "~~" & "{ESC}"
Application.VBE.CommandBars(1).FindControl(ID:=2578,
recursive:=True).Execute
End If
'Not the right password
If vbProj.Protection = 1 Then
SendKeys "%{F11}", True
End If
'Reset Password
Password = ""
Application.ScreenUpdating = True
Set vbProj = Nothing
Exit Sub
ErrorHandler:
MsgBox Err.Description, 64
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajan_Verma
Sent: Thursday, September 06, 2012 9:01 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Excel macro to add VBA password
Where you want to apply Password.
1) File Open ?
2) Worksheet Password ?
3) Workbook Password ?
4) VBA project Password ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancharla
Sent: 06 September 2012 12:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password
Hi,
thanks a lot your quick responce..
thanks,u
kiran
On 9/6/12, NOORAIN ANSARI wrote:
Kiran,
Before run macro, Pls check on Tools-Reference-Microsoft Scripting
Runtime under VBE editor.
On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI
wrote:
Dear Kiran,
Please try it..
Sub ProtectFiles()
Dim MyFile As File
Dim MyFolder As Folder
Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject
Set MyFolder = fso.GetFolder(YourFolderPath)
For Each MyFile In MyFolder.Files
MyFile.Password="abc"
Next
End Sub
On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla
wrote:
Hi,
Need help to create a macro to add VBA password to all the excel
files in a folder.
I am using excel 2003.
Request you help me on this.
--
Thanks & Regards,
Kiran
--
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
Re: $$Excel-Macros$$ Please Help
Your solution did not provide the proper answer and selections should have been removed. Here is the proper formula solution for all the parameters which assumes self adjusting defined named ranges for columns a:e =SUMPRODUCT((cola=I3)*((colb=$M$2)+(colb=$K$2))*((colc=$M$3)+(colc=$N$3)+(colc=$O$3))*((cold=$M$4)+(cold=$N$4)+(cold=$O$4))*cole) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Karan Singh Sent: Friday, September 07, 2012 12:12 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help Hi Jeet, I think you're not able to explain your problem. As all expert said at least you should explain your queries in Subject & then in your workbook. Anyways I'v done something (with recording), hope you need this. I'm not an expert I'm an excel learner :) Pfa. Rgds Karan Singh On Thu, Sep 6, 2012 at 7:49 PM, Rajan_Verma wrote: Same as don Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 06 September 2012 6:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help I did NOT look at your attachment because you did not provide a meaningful subject line in your post and you did not explain your problem in the body of the email. I hope you explained, with examples, in the file. But, I didn’t look. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jeet singh Sent: Wednesday, September 05, 2012 11:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear All, plz find the attachment and help Regards Jeet -- 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 al
Re: $$Excel-Macros$$ Collecting interest details only at the time of booking .
Please give a complete explanation of the logic Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: LAKSHMAN PRASAD Sent: Friday, September 07, 2012 1:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Collecting interest details only at the time of booking . Dear Expert , Plez see the attached file, I am unable collect interest details only at the time of booking head as like as sheet 2. Lakshman Prasad -- 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$$ pls help urgent- need data in the format as required
Please do not RE post at a later time. RUDE! And, VERY RUDE to use URGENT. Your request is NOT more urgent than anyone else. Since not all students would always have all years I would suggest a vba macro to do this. Is that OK. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Sara Lee Sent: Friday, September 07, 2012 12:06 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ pls help urgent- need data in the format as required example attached. i have multiple columns and rows. Please advise a formula to get the data in the attached format. -- 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$$ Urgent... Please Help... (place useless subject here)
me too.. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Friday, September 07, 2012 11:16 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here) Is it me? or does the use of this type of Subject line seem to be increasing lately? I think we (those that enjoy lending assistance) ought to each start a log file. In it, place the name of each person that says "Urgent", and "Please Help" or some other useless subject. Then, they'll received ONE "reminder". After that, if they do it again, we'll either ignore them or send some kind of equally useless response. Like: "66,000... all orange... hope this helps" (lol) I wonder if the site design would allow the "Forum Rules" to display at the TOP of the window when creating a "New Topic" I suspect that many people have found the Group through Google and have never bothered to read the rules. Although, IMHO they shouldn't NEED to read them, since they are really "common sense". I mean really: "If you want someone to help you, tell them what you need". (And please.. don't get upset if they cannot read your mind.) Is that so difficult? Paul S. -- 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$$ I want to Learn Array Formulas
Is there some reason you cannot “google” it yourself Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: maksood alam Sent: Friday, September 07, 2012 12:50 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I want to Learn Array Formulas Hi Rajan Please provide the link to download Excel function and formulas by Berend held On Fri, Sep 7, 2012 at 7:24 PM, Rajan_Verma wrote: Google and Download this book Excel function and formulas by Berend held Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: 07 September 2012 2:59 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ I want to Learn Array Formulas Hi All Members, I want to learn array formulas in excel 2007. Please send me some useful stuff or refer me any useful link to learn array formulas. thanx in advance. Regards, Waseem Saifi -- 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 mailto:excel-macros%2bunsubscr...@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)
Re: $$Excel-Macros$$ Question chart
Why is your request more URGENT than any other request?? When all else fails, "read the f___ing instructions" 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. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: PRAVESH KUMAR Sent: Thursday, September 06, 2012 11:18 PM To: excel-macros ; excelvbaclinic Subject: $$Excel-Macros$$ Question chart HI Team, please help me to solve this queston it's very urgent. solve asap. -- Thanks & Regards Pravesh Kumar -- 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$$ Merged Cell
YES Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Anjali . Sent: Saturday, September 08, 2012 5:57 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Merged Cell Mr. David, Is it the rule of this group??? if it is, then definitely i will describe it in the email. On Sat, Sep 8, 2012 at 3:19 PM, David Grugeon wrote: Hi Anjali I don't want to open your workbook until I know what your problem is. Please describe it in the email. Thanks. On 8 September 2012 18:26, Anjali . wrote: > > -- > 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 > mailto:excel-macros%2bunsubscr...@googlegroups.com. > > -- Regards David Grugeon -- 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 mailto:excel-macros%2bunsubscr...@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 po
Re: $$Excel-Macros$$ Required Revenue started from Date..
So that I do NOT have to waste time looking for the file, please provide the one you need solved. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Friday, September 07, 2012 3:14 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Required Revenue started from Date.. Hi Don, Thanks for your post, I was trying to understand the formula, if we use array formula then below highlighted cells also getting fixed and formula is not giving the proper result, =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0)) Can you please share the formula in excel file, to understand better. Regards,Anil Bhange IP Phone – 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, August 31, 2012 03:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Revenue started from Date.. This is an array formula that must be entered using ctrl+shift+enter =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kuldeep Singh Sent: Friday, August 31, 2012 7:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Revenue started from Date.. Hi Experts, I want to required Revenue started from Date. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com Please Consider the environment. Please don't print this e-mail unless you really need to. -- 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 "M
Re: $$Excel-Macros$$ Re: Required a search option in excel file
See attached for desired solution. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Prince Dubey Sent: Monday, August 27, 2012 11:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Required a search option in excel file Hi Praveen, Please see the attachment hope this will help you. regards prince On Monday, August 27, 2012 3:02:48 PM UTC+5:30, Pravin Gunjal wrote: Hello Friends, Need a help on the following issue. 1. I am having a file containing 318 products / rates in it. (file is attached for your reference) 2. I want to search a particular product or rate by typing it's initial letter in the cell : B2. Need a formula for this... 3. Once the letter / number is typed in cell B2 then only those search results should appear in the following rows instead of all products. 4. I know this can be done by auto filter option but it is quite difficult for me to use this option continuously. Hence this is the request. Hope to hear from you soon. Thank you. Regards Pravin Gunjal -- 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. FilterForPartialSAS_BothColums.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$
Your excel version is _)___ How did the cells become colored__ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: harshad shukla Sent: Sunday, September 09, 2012 1:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ dear all, I had a query where in i had to sum the values of cell based on cell colour.that is to add all numbers of a row whose cell colour is conditionally formatted to grren and yellow colours. please help for the same.Could not devise a formula or macro for differentiating cell based on cell colour. regards Harshad Shukla Follow Rediff Deal ho jaye! to get exciting offers in your city everyday. -- 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:
Or this to look in column A for the colors in column C
Sub sumcolormatchSAS()
Dim c As Range
Dim i As Long
Dim csum As Long
For Each c In Range("c2:c3")
c.Offset(, 1) = 0
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(i, 1).Interior.ColorIndex = c.Interior.ColorIndex Then _
c.Offset(, 1) = c.Offset(, 1) + Cells(i, 1)
Next i
Next c
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Prince Dubey
Sent: Sunday, September 09, 2012 10:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:
Hi Harshad,
Please see the attachment hope this will help you.
regards
prince
On Sunday, September 9, 2012 12:19:35 PM UTC+5:30, harshad shukla wrote:
dear all,
I had a query where in i had to sum the values of cell based on cell
colour.that is to add all
numbers of a row whose cell colour is conditionally formatted to grren and
yellow colours.
please help for the same.Could not devise a formula or macro for
differentiating cell based on
cell colour.
regards
Harshad Shukla
Follow Rediff Deal ho jaye! to get exciting offers in your city
everyday.
--
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:
I missed that part but did ask for clarification. This code simply responded to
the other code offered.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: David Grugeon
Sent: Sunday, September 09, 2012 2:14 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re:
Hi Don
The question said the colours are set by conditional formatting. This does not
affect interior.ColorIndex. AFAIK the only way to do it is to apply the same
test for the condition as you used in the conditional formatting.
On 10 September 2012 02:18, dguillett1 wrote:
Or this to look in column A for the colors in column C
Sub sumcolormatchSAS()
Dim c As Range
Dim i As Long
Dim csum As Long
For Each c In Range("c2:c3")
c.Offset(, 1) = 0
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(i, 1).Interior.ColorIndex = c.Interior.ColorIndex Then _
c.Offset(, 1) = c.Offset(, 1) + Cells(i, 1)
Next i
Next c
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Prince Dubey
Sent: Sunday, September 09, 2012 10:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:
Hi Harshad,
Please see the attachment hope this will help you.
regards
prince
On Sunday, September 9, 2012 12:19:35 PM UTC+5:30, harshad shukla wrote:
dear all,
I had a query where in i had to sum the values of cell based on cell
colour.that is to add all
numbers of a row whose cell colour is conditionally formatted to grren and
yellow colours.
please help for the same.Could not devise a formula or macro for
differentiating cell based on
cell colour.
regards
Harshad Shukla
Follow Rediff Deal ho jaye! to get exciting offers in your city
everyday.
--
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
mailto:excel-macros%2bunsubscr...@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
mailto:excel-macros%2bunsubscr...@googlegroups.com.
--
Regards
David Grugeon
--
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
Re: $$Excel-Macros$$ Required Revenue started from Date..
Send ME your file Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Monday, September 10, 2012 3:10 AM To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ Required Revenue started from Date.. Hi Don, Thanks for your post, I was trying to understand the formula, if we use array formula then below highlighted cells also getting fixed and formula is not giving the proper result, =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0)) Can you please share the formula in excel file, to understand better. Regards,Anil Bhange IP Phone – 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, August 31, 2012 03:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Revenue started from Date.. This is an array formula that must be entered using ctrl+shift+enter =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kuldeep Singh Sent: Friday, August 31, 2012 7:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Revenue started from Date.. Hi Experts, I want to required Revenue started from Date. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com Please Consider the environment. Please don't print this e-mail unless you really need to. -- 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@
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 6:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : Waiting for your response. Thanks. -- With regards, MaNgEsH -- 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 mailto:excel-macros%2bunsubscr...@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 mailto:excel-macros%2bunsubscr...@googlegroups.com. -- With regards, MaNgEsH -- 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 ques
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
As I said, I would simply use TTC Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 9:24 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Hi Guillett, I would like to know all possible ways of cutting the string into three parts. So please do needful by suggesting very simple formula for same. Thanks !!! On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 wrote: Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 6:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : Waiting for your response. Thanks. -- With regards, MaNgEsH -- 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 mailto:excel-macros%2bunsubscr...@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 mailto:excel-macros%2bunsubscr...@googlegroups.com. -- With regards, MaNgEsH -- 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
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Homework done...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Tuesday, September 11, 2012 4:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Its really Great Help Asa !!!
Thanks a ton !!!
On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff wrote:
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis to
provide a more complex or difficult solution to a given problem when simple
solutions exist. Also in business, the simplest solution is the best value.
But I understand that in learning all aspects of a program, sometimes the
exercise of solving a problem in various ways is useful.
I will provide a formula solution for you. Although it could be solved
several ways, I prefer using an array formula, since it can be written in such
a way that it can handle a string of text with any number of commas, whereas
non-array solutions would be limited to a set maximum. However, even with the
array solution, and even though the array will contain all of the parts of the
text string, you will only see on your spreadsheet as many parts as there are
cells in the area you place the array formula (there are ways to use array
formulas with "too large of arrays" to display on your spreadsheet ,as part of
other formulas, that are useful; for example extracting certain values matching
a condition, or summarizing the data (in your data, you might want to know how
many "Mumbai"s there are, how many "32145"s, etc.), without actually displaying
in multiple columns all the split data.
·Select any cell on row 2 of your spreadsheet, then create the
following defined names using the Name Manager (formulas tab in Excel 2007+).
I recommend making them Sheet-level names rather than the default
Workbook-level.
1. Name
=$A2
2. _Name.Terminated
=Name&","
3. _Name.ColumnIdx
=TRANSPOSE(ROW(INDIRECT("1:"&LEN(_Name.Terminated)-LEN(SUBSTITUTE(_Name.Terminated,",","")
4. _Name.StartPositions
=IF(Name.ColumnIdx>1,FIND(CHAR(1),SUBSTITUTE(Name,",",CHAR(1),_Name.ColumnIdx-1)))+1
5. _Name.StopPositions
=FIND(CHAR(1),SUBSTITUTE(_Name.Terminated,",",CHAR(1),_Name.ColumnIdx))-1
6. Name.Columns
=MID(Name,_Name.StartPositions,_Name.StopPositions-_Name.StartPositions+1)
The purpose of using the defined names is to simplify the formula by breaking
it into steps. Insofar as the steps are referred to more than once in the
formula, it should make the formula faster to evaluate too. Name.Columns is
the culmination of our calculation and results in an array containing each
comma-separated value from column A, divided into separate columns.
·To display the column-separated values on your spreadsheet, enter
the following formula in B2:
=Name.Columns
·Then highlight from B2 to the furthest column on row 2 needed to
display the maximum number of values ever expected. For a maximum of 3 values,
highlight B2:D2, or for maximum of 10, B2:K2, etc.
·Then hit F2 (edit cell) and Ctrl-Shift-Enter (confirm array
formula). This confirms a multi-cell array formula over the selected cells.
·Copy the array-entered range from row 2 (e.g. B2:D2) to every other
row in your table.
Hope this is of interest,
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Vimay
Sent: Monday, September 10, 2012 4:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Friends,
I need your help to divide the string into three parts.
The description and sample is given below :
Waiting for your response.
Thanks.
--
With regards,
MaNgEsH
--
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 th
Re: $$Excel-Macros$$ Re: Unique from Multiple sheet
Since op did not indicate version your solution would not work prior to xl2007 and you have unnecessary and undesirable SELECTIONS. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Vabz Sent: Tuesday, September 11, 2012 2:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Unique from Multiple sheet Hi PFA file You have to Run Macro from Sheet5 only. Cheerz.. Rgds//Vabz On Tuesday, September 11, 2012 11:44:27 AM UTC+5:30, Sundarvelan wrote: Dear Frineds, Please help me to get the unique from Multiple sheets Thanks N.Sundarvelan 9600160150 -- 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$$ Fwd: PDF to excel table
I suggest NOT receiving in PDF format Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SAGAR KASANGOTTUWAR Sent: Tuesday, September 11, 2012 12:38 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: PDF to excel table 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 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 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 mailto:excel-macros%2bunsubscr...@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: Unique from Multiple sheet
Good thinking. My solution was simple and also took only 3-4 seconds AND it changed to numbers. Try it. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Tuesday, September 11, 2012 9:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Unique from Multiple sheet Don, "technically"... N.Sundarvelan (the originator) included a file in .xlsx format. Which implies he has either xl2007 or xl2010... But.. yes, this solution seems to have LOTS of selections. and other "jumping around" that is a lot of "wasted motion". any time the display is updated, the run time is increased. My solution (using a Dictionary Object) looked through all 12,000+ userids and generated the list of 5000 unique id's in less than 5 seconds... (no sheet jumping required) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ---- From: dguillett1 To: excel-macros@googlegroups.com Sent: Tue, September 11, 2012 9:32:59 AM Subject: Re: $$Excel-Macros$$ Re: Unique from Multiple sheet Since op did not indicate version your solution would not work prior to xl2007 and you have unnecessary and undesirable SELECTIONS. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Vabz Sent: Tuesday, September 11, 2012 2:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Unique from Multiple sheet Hi PFA file You have to Run Macro from Sheet5 only. Cheerz.. Rgds//Vabz On Tuesday, September 11, 2012 11:44:27 AM UTC+5:30, Sundarvelan wrote: Dear Frineds, Please help me to get the unique from Multiple sheets Thanks N.Sundarvelan 9600160150 -- 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, fo
Re: $$Excel-Macros$$ Re: Unique from Multiple sheet
Looks like the best solution which also should sort
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Tuesday, September 11, 2012 9:14 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Unique from Multiple sheet
Sub GetUnique()
Dim wksSheet As Worksheet
Dim VarArr
Dim lngCOunt As Long
With CreateObject("Scripting.Dictionary")
For Each wksSheet In ThisWorkbook.Worksheets
VarArr = wksSheet.Range("A1").CurrentRegion
For Each kk In VarArr
.Item(kk) = 0
Next kk
Next wksSheet
VarArr = Application.Transpose(.keys)
End With
Set wksSheet = ThisWorkbook.Worksheets.Add
wksSheet.Range("A1").Resize(UBound(VarArr)).Value = VarArr
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Vabz
Sent: 11 September 2012 12:44
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Unique from Multiple sheet
Hi
PFA file
You have to Run Macro from Sheet5 only.
Cheerz..
Rgds//Vabz
On Tuesday, September 11, 2012 11:44:27 AM UTC+5:30, Sundarvelan wrote:
Dear Frineds,
Please help me to get the unique from Multiple sheets
Thanks
N.Sundarvelan
9600160150
--
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$$ Copy Two sheet of one Workbook to other Workbooks
As Paul said, there is a better way. Provide a file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SridharBL Sent: Wednesday, September 12, 2012 4:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks Hi Experts, I am working as a analyst and I do publish the review files to Leaders. I have one Base excel file, which has two sheets "Basesheet" & "Pipeline" sheets. I have to publish 15 review reports to different leaders. So I should be manually copy "Basesheet" & "Pipeline" to all the 15 excel files. Later I filter and delete unwanted data's in these sheets in those 15 files. So, is there a VBA code to copy the "Basesheet" & "Pipeline" to all the 15 files of different names. -- 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$$ Excel sheet wise restrictions required for end users
All I had to do was unhide the sheet. and the code was not protected (easily defeated) . Even if you had hidden with xlVERYHIDDEN code could unhide. Although more trouble, you may want to use separate protected workbooks where security is higher for most users. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Krishnaraddi V. Madolli Sent: Wednesday, September 12, 2012 8:08 AM To: excel-macros@googlegroups.com Cc: Subramani P N Subject: RE: $$Excel-Macros$$ Excel sheet wise restrictions required for end users Hi Pravin, Please find the attached document prepared as per your requirement. Column B will give password for each sheet. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.com | The leader in innovative claims and productivity management solutions Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. Please consider the environment before printing this message From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 09/12/2012 14:29 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel sheet wise restrictions required for end users Dear Masters, In the attached file there are six working sheets in it. The concerned person will send a mail of this file to his down level for their working/use. Sheet 1 is made for the master (which can be seen to all end users). While others - sheet 2 to sheet 7 (i.e. ASM to SO5) are created for individual details. I have used a hyperlink to go to the sub sheets. >From ASM to SO5 working sheets : the end users are individuals and one should >not see the others data (it should be password protected or any other >restriction may be given). For an example : If I am a SO4 user then when I click on SO4 button in the sheet1 before following the link the system should ask a password to open the SO4 sheet. Otherwise it can be restricted for use. Please help me out on this issue. If you require any other information from me please write to me. Thanks a lot ! With regards, Pravin Gunjal -- 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, a
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
That's precisely the point!
Because he's wanting to do this with formulas, he's making the solution more
complex than necessary.
A VBA solution would be very neat and tidy (use split to load an array, and
display the array elements in the cells)
A "manual" solution using text-to-Columns is also pretty simple.
However, he INSISTS on an Excel Formula.
Personally, if I needed Excel formulas, would try something like:
Column "B" = LEFT($A1,FIND(",",$A1)-1)
Column "D" =MID($A1,FIND(",",$A1)+1,2)
Column "E" =MID($A1,FIND(",",SUBSTITUTE($A1,",","",1))+2,50)
But I'd prefer to use VBA.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Vabz
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 8:59:52 AM
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote:
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis to
provide a more complex or difficult solution to a given problem when simple
solutions exist. Also in business, the simplest solution is the best value.
But I understand that in learning all aspects of a program, sometimes the
exercise of solving a problem in various ways is useful.
I will provide a formula solution for you. Although it could be solved
several ways, I prefer using an array formula, since it can be written in such
a way that it can handle a string of text with any number of commas, whereas
non-array solutions would be limited to a set maximum. However, even with the
array solution, and even though the array will contain all of the parts of the
text string, you will only see on your spreadsheet as many parts as there are
cells in the area you place the array formula (there are ways to use array
formulas with "too large of arrays" to display on your spreadsheet ,as part of
other formulas, that are useful; for example extracting certain values matching
a condition, or summarizing the data (in your data, you might want to know how
many "Mumbai"s there are, how many "32145"s, etc.), without actually displaying
in multiple columns all the split data.
·Select any cell on row 2 of your spreadsheet, then create the
following defined names using the Name Manager (formulas tab in Excel 2007+).
I recommend making them Sheet-level names rather than the default
Workbook-level.
1. Name
=$A2
2. _Name.Terminated
=Name&","
3. _Name.ColumnIdx
=TRANSPOSE(ROW(INDIRECT("1:"& LEN(_Name.Terminated)-LEN(
SUBSTITUTE(_Name.Terminated,", ","")
4. _Name.StartPositions
=IF(Name.ColumnIdx>1,FIND( CHAR(1),SUBSTITUTE(Name,",",
CHAR(1),_Name.ColumnIdx-1)))+1
5. _Name.StopPositions
=FIND(CHAR(1),SUBSTITUTE(_ Name.Terminated,",",CHAR(1),_ Name.ColumnIdx))-1
6. Name.Columns
=MID(Name,_Name. StartPositions,_Name. StopPositions-_Name. StartPositions+1)
The purpose of using the defined names is to simplify the formula by breaking
it into steps. Insofar as the steps are referred to more than once in the
formula, it should make the formula faster to evaluate too. Name.Columns is
the culmination of our calculation and results in an array containing each
comma-separated value from column A, divided into separate columns.
·To display the column-separated values on your spreadsheet, enter
the following formula in B2:
=Name.Columns
·Then highlight from B2 to the furthest column on row 2 needed to
display the maximum number of values ever expected. For a maximum of 3 values,
highlight B2:D2, or for maximum of 10, B2:K2, etc.
·Then hit F2 (edit cell) and Ctrl-Shift-Enter (confirm array
formula). This confirms a multi-cell array formula over the selected cells.
·Copy the array-entered range from row 2 (e.g. B2:D2) to every other
row in your table.
Hope this is of interest,
Asa
From: excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] On
Behalf Of Mangesh Vimay
Sent: Monday, September 10, 2012 4:04 AM
To: excel-...@googlegroups.com
Subject: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Fri
Re: $$Excel-Macros$$ find the latest date
=SUMPRODUCT(MAX((A2:A10=g2)*(E2:E10))) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Sundarvelan N Sent: Friday, September 14, 2012 6:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ find the latest date Dear Friends, Please help me to find the latest date of a student. Thanks N.Sundarvelan 9600160150 -- 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$$ Locking Only Selected Cell
Unlock ALL cells and use a worksheet_selectionchange event to lock it>then protect sheet Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: sharad jain Sent: Friday, September 14, 2012 6:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Locking Only Selected Cell Dear Experts, Can someone please let me know how to lock only selected cell? Thanks, Sharad -- 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$$ hide column VBA
or one line
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then columns(i).Hidden = True
next i
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: ashish koul
Sent: Sunday, September 16, 2012 5:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ hide column VBA
Sub sample()
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then
Cells(1, i).EntireColumn.Hidden = True
End If
Next
End Sub
On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski wrote:
Hi All,
I wonder if you can help me, I'd like to hide all columns if the value in row
1 is equal "1", I've written code but something is not working. I'm new to VBA
so if you can help me. Code is below:
Sub HideColumn()
Dim a As Integer
Range("a1").Select
For a = a + 1 To 10
If ActiveCell.Cells(1, a).Value = 1 Then
ActiveCell.Columns(1, a).Hidden = True
End If
Next a
End Sub
--
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
mailto:excel-macros%2bunsubscr...@googlegroups.com.
--
Regards
Ashish Koul
Visit
http://www.excelvbamacros.com/
http://www.accessvbamacros.com/
P Before printing, think about the environment.
--
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$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
Does this give the same result? In the data provided, a NEVER matches e Option Explicit Sub checksyssystemsas() Dim r As Long For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row If Cells(r, "a") = Cells(r, "e") And Cells(r, "c") = Cells(r, "g") Then ‘msgbox r ONLY one match at row 1129 Cells(r, "f") = Cells(r, "b") Cells(r, "h") = Cells(r, "d") End If Next r End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Siraj Momin (BTG) Sent: Sunday, September 16, 2012 8:23 AM To: Prince Dubey Cc: excel-macros@googlegroups.com Subject: RE: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Hi Prince Thank you for the reply, I am sending the attachment on your personal email id also, I reduced the data but still it taking time I have more data than this to update, I am not familiar with array formulas that is the problem Can you help me out in this Thanks Siraj From: Prince Dubey [mailto:prince141...@gmail.com] Sent: Sunday, September 16, 2012 3:42 PM To: excel-macros@googlegroups.com Cc: Siraj Momin (BTG) Subject: Re: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Hi Siraj, As i saw u r using loop on the rang which runs fine on small amount of data but in case of large amount of data it will take huge time to process so do one thing instead of looping on the range get all data in an Array then apply same logic as u r doing one the range. Or Please share ur workbook with us. regards Prince On Sunday, September 16, 2012 3:10:57 PM UTC+5:30, Siraj Momin (BTG) wrote: ANY SOLUTION POSSIBLE SIRAJ From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On Behalf Of Siraj Momin (BTG) Sent: Monday, September 10, 2012 5:41 PM To: excel-...@googlegroups.com Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row For r1 = 2 To Cells(Rows.Count, "g").End(xlUp).Row If Cells(r, "a") = Cells(r1, "e") And Cells(r, "c") = Cells(r1, "g") Then Cells(r1, "f") = Cells(r, "b") Cells(r1, "h") = Cells(r, "d") If Cells(r, "a") = "" Then Exit For End If End If Next r1 Next r End Sub -- 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@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 M
Re: $$Excel-Macros$$ Re: Excel Formula challenge
Put this function in a REGULAR module. Then =myfunc(a1) Function myfunc(xx) Dim nodupes As New Collection arr = Split(xx, "|") For i = LBound(arr) To UBound(arr) On Error Resume Next nodupes.Add arr(i), arr(i) On Error GoTo 0 Next i For i = 1 To nodupes.Count holder = holder & nodupes(i) & "|" Next i myfunc = Left(holder, Len(holder) - 1) End Function Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: in.vaib...@gmail.com Sent: Saturday, September 15, 2012 12:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Excel Formula challenge It workz for the given case but if more txt is der den formula wil run for milez :p I'm figuring formula dat wl work for all cases. Rgds From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 22:38:16 +0530 To: ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Excel Formula challenge Nicely done Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 15 September 2012 10:04 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Excel Formula challenge Hi PFA Cheerz.. Rgds//Vabs On Wednesday, August 8, 2012 9:33:25 PM UTC+5:30, Rajan_Verma wrote: Hi group, Hope you will post an excellent solution here : Let suppose you have a string like below : A|A|A|B|B|C|A|B|C|D As you can see the characters are being repeat in this string output should be : A|B|C|D I don’t think helper column is required J You can comment here also http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/ Regards Rajan verma +91 7838100659 [IM-Gtalk] -- 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.
Re: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
My misunderstanding. In that case, perhaps try to get the uniques in col A and col C and work from there. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Siraj Momin (BTG) Sent: Sunday, September 16, 2012 11:02 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Hi Don Dear members Actually I want to match the values of col A and Col C with Col E and Col G ( the values can be in any row in Col. E and Col. G NOT ON THE SAME ROW) and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Thanks Siraj From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, September 16, 2012 6:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Does this give the same result? In the data provided, a NEVER matches e Option Explicit Sub checksyssystemsas() Dim r As Long For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row If Cells(r, "a") = Cells(r, "e") And Cells(r, "c") = Cells(r, "g") Then msgbox r ONLY one match at row 1129 Cells(r, "f") = Cells(r, "b") Cells(r, "h") = Cells(r, "d") End If Next r End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Siraj Momin (BTG) Sent: Sunday, September 16, 2012 8:23 AM To: Prince Dubey Cc: excel-macros@googlegroups.com Subject: RE: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Hi Prince Thank you for the reply, I am sending the attachment on your personal email id also, I reduced the data but still it taking time I have more data than this to update, I am not familiar with array formulas that is the problem Can you help me out in this Thanks Siraj From: Prince Dubey [mailto:prince141...@gmail.com] Sent: Sunday, September 16, 2012 3:42 PM To: excel-macros@googlegroups.com Cc: Siraj Momin (BTG) Subject: Re: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Hi Siraj, As i saw u r using loop on the rang which runs fine on small amount of data but in case of large amount of data it will take huge time to process so do one thing instead of looping on the range get all data in an Array then apply same logic as u r doing one the range. Or Please share ur workbook with us. regards Prince On Sunday, September 16, 2012 3:10:57 PM UTC+5:30, Siraj Momin (BTG) wrote: ANY SOLUTION POSSIBLE SIRAJ From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On Behalf Of Siraj Momin (BTG) Sent: Monday, September 10, 2012 5:41 PM To: excel-...@googlegroups.com Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row For r1 = 2 To Cells(Rows.Count, "g").End(xlUp).Row If Cells(r, "a") = Cells(r1, "e") And Cells(r, "c") = Cells(r1, "g") Then Cells(r1, "f") = Cells(r, "b") Cells(r1, "h") = Cells(r, "d") If Cells(r, "a") = "" Then Exit For End If End If Next r1 Next r End Sub -- 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 copyrighte
Re: $$Excel-Macros$$ How can we hide the excel sheets with password(s)
And then send the file to some of us to break the password. I would suggest different workbooks with the workbook protected. Safer. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Monday, September 17, 2012 7:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How can we hide the excel sheets with password(s) Dear Pravin, Please find attached sample for your reference. Hope it help to you regarding your query. On Mon, Sep 17, 2012 at 3:22 PM, Pravin Gunjal wrote: Dear Friends, I have an excel file and would like to hide it's second & third sheets with different passwords. When we go for open it by clicking the hyperlinks on main sheet, the system should ask password for open. I have attached herewith the same file for your reference. There are three sheets in this file one is main and other two are it's sub sheets. I have just protected all the sheets without giving any password. Please help me on this subject. Regards Pravin Gunjal -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http://noorainansari.com http://excelvbaclinic.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$$ Fw : Search tool in Excel sheet
looks a lot like one of mine..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Monday, September 17, 2012 10:57 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fw : Search tool in Excel sheet
In attached file you can use this code.. it was an old thread on group and can
match with your quary.
Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.AutoFilterMode = False
If Target.Address <> Sheet1.Range("a2").Address Then Exit Sub
Sheet1.Range("A4").AutoFilter 1, "*" & Target.Value & "*"
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Pravin Gunjal
Sent: 06 September 2012 12:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Required a correct VB code for search option
Hello,
I have attached an excel file which is having search option in it.
The VB code is gathering the data only from 1st column and it is not applied
for second column of the file.
I need to search some record which may have in any of the columns (display name
or e-mail id). Kindly help me out on this.
Thank you,
Pravin Gunjal
--
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$$ Substitute a value of a cell in to a cell reference of a vba code
Option Explicit
‘puts all as 8000 and then changes for marrieds.
Sub FilterforMarriedSAS()
Dim lr As Long
Dim c As Range
lr = Cells(Rows.Count, "e").End(xlUp).Row
Cells(3, "f").Resize(lr - 2).Value = 8000
Range("$B$2:$F$" & lr).AutoFilter Field:=4, Criteria1:="Married"
lr = Cells(Rows.Count, "e").End(xlUp).Row
For Each c In Range("e3:e" & lr).SpecialCells(xlCellTypeVisible)
c.Offset(, 1) = 11000
Next
Selection.AutoFilter
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva
Sent: Wednesday, September 19, 2012 4:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Substitute a value of a cell in to a cell reference
of a vba code
Hi,
Refer attached sheet(format 1). I want to fill the cells in one column(Basic
Salary) depend on cells value of a another column(Status). It means if cell E1
has “single” then F1 should be 8000 and if cell E1 has “Married” then F1 should
be 11000.( I don’t want to use formulas)
I wrote the below code to do that.
Private Sub salary()
Dim r As Double
For r = 1 To 20
If Cells(r, "E") = "Single" Then
Cells(r, "F") = "8000"
Else
If Cells(r, "E") = "Married" Then
Cells(r, "F") = "11000"
End If
End If
Next
End Sub
Now the columns are not always constant. It means Columns for “Status” are E
and D in format1 and format2 respectively.
I want to use value of cell I1 and I2 for “Status and “Basic salary”
respectively. I will manually enter the column label for cell I1 and I2.
I wrote below macro, but it is not working. I think the way I referred the
values of cell I1 and I2 is not correct.
Please guild me to write this code perfectly.
I’m not expert in macro, therefore there may be more easy methods to do this
task. However I want to do on this way since I’m can understand this types of
Codes well.
Private Sub salarynew()
Dim r As Double
For r = 1 To 20
' Earlier E now should be value of cell I1
' Earlier F now should be value of cell I2
If Cells(r, "cells(1,"I")") = "Single" Then
Cells(r, "cells(2,"I")") = "8000"
Else
If Cells(r, "cells(1,"I")") = "Married" Then
Cells(r, "cells(2,"I")") = "11000"
End If
End If
Next
End Sub
Thanks,
Regards,
Dilan
--
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$$ How to put sum formula automatically - seems easy but not so
Use this INSTEAD
Sub GetSumsSAS()
dim lr as long
Dim c As Range
Dim ms As String
Application.ScreenUpdating = False
lr=cells.specialcells(xlcelltypelastcell).row
With Worksheets(1).Range("f10:f" & lr)
Set c = .Find("site charge", LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext)
If Not c Is Nothing Then
firstAddress = c.Address
Do
fr = c.End(xlUp).Row
'MsgBox fr & " " & c.Row
ms = Application.Sum(Range(Cells(fr, "i"), Cells(c.Row - 1,
"i")))
'MsgBox ms
Cells(c.Row, "i").Value = ms
Cells(fr - 1, "i").Value = ms
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
Application.ScreenUpdating = True
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jai Deep
Sent: Wednesday, September 19, 2012 5:36 AM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Rajan/Swapnil,
Thanks a lot for your code…. I need one more help in the same macro…
I tried but did not work…. I have highlighted site totals in yellow
and green colour and also put callouts.
Now I need to edit the macro so that it will also give me formulas in
yellow cells so that if there is any change in site total (green cell)
then yellow cell gets updated.
Thanks,
Jaideep
--
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$$ How to put sum formula automatically - seems easy but not so
If speed is a consideration with a LARGE database, you will find that my
solution is much faster, And, why go to the trouble of using a macro to add
the sums and then leave the formula??? However, mine could easily be changed
to do it the inefficient way.
I thought these forums were designed to help you learn to use excel
efficiently??
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jaideep Panchal
Sent: Wednesday, September 19, 2012 1:44 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Don,
Thanks a lot but this code is doing the sum and pasting it values which
I don't need however, Rajan provided the solution what I wanted...
Thanks a ton for your response and support...
Regards.
Jai
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Wednesday, September 19, 2012 8:20 PM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Use this INSTEAD
Sub GetSumsSAS()
dim lr as long
Dim c As Range
Dim ms As String
Application.ScreenUpdating = False
lr=cells.specialcells(xlcelltypelastcell).row
With Worksheets(1).Range("f10:f" & lr)
Set c = .Find("site charge", LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext)
If Not c Is Nothing Then
firstAddress = c.Address
Do
fr = c.End(xlUp).Row
'MsgBox fr & " " & c.Row
ms = Application.Sum(Range(Cells(fr, "i"), Cells(c.Row - 1,
"i")))
'MsgBox ms
Cells(c.Row, "i").Value = ms
Cells(fr - 1, "i").Value = ms
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
Application.ScreenUpdating = True
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jai Deep
Sent: Wednesday, September 19, 2012 5:36 AM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Rajan/Swapnil,
Thanks a lot for your code.. I need one more help in the same macro.
I tried but did not work.. I have highlighted site totals in yellow
and green colour and also put callouts.
Now I need to edit the macro so that it will also give me formulas in
yellow cells so that if there is any change in site total (green cell)
then yellow cell gets updated.
Thanks,
Jaideep
--
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@
Re: $$Excel-Macros$$ Need help for Hardest formula solution
Are you saying that you want to HIDE COLUMNS??? Please define your problem with examples if possible. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, September 20, 2012 1:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help for Hardest formula solution Hi All Champs, Anybody help me regarding tup formula solution. Q: I want to see Sector wise promotor,FII & so on (From Dec04-Jun05) in one shot.When I click sector & then Click promoter then show all promotor (From Dec04-Jun05) & so on.And also same for company wise also.Bcos I have data from Dec-04 to Jun12 Appreciate the help. Let us know in case of any further assistance. Thank you in advance for your help! Amar -- 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$$ How to put sum formula automatically - seems easy but not so
Let them make the changes and click the button. OR, assign it to a
worksheet_change event to do it automatically. It could even be designed to
ONLY recalculate for the BLOCK effected automatically.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jaideep Panchal
Sent: Wednesday, September 19, 2012 10:09 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
I agree with you Don,
However, there are around 2500 sites and I need to put SUM formula to each
site manually. Then I have to send it to customer to validate and they make
some changes in any line item and may also delete or add new amounts. So I
need to formula to pick those changes. thats it.
And I came to learn new ideas in coding which I will use for some other
file...
Thanks,
Jaideep
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Thursday, September 20, 2012 12:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
If speed is a consideration with a LARGE database, you will find that my
solution is much faster, And, why go to the trouble of using a macro to add
the sums and then leave the formula??? However, mine could easily be changed
to do it the inefficient way.
I thought these forums were designed to help you learn to use excel
efficiently??
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jaideep Panchal
Sent: Wednesday, September 19, 2012 1:44 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Don,
Thanks a lot but this code is doing the sum and pasting it values which
I don't need however, Rajan provided the solution what I wanted...
Thanks a ton for your response and support...
Regards.
Jai
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Wednesday, September 19, 2012 8:20 PM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Use this INSTEAD
Sub GetSumsSAS()
dim lr as long
Dim c As Range
Dim ms As String
Application.ScreenUpdating = False
lr=cells.specialcells(xlcelltypelastcell).row
With Worksheets(1).Range("f10:f" & lr)
Set c = .Find("site charge", LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext)
If Not c Is Nothing Then
firstAddress = c.Address
Do
fr = c.End(xlUp).Row
'MsgBox fr & " " & c.Row
ms = Application.Sum(Range(Cells(fr, "i"), Cells(c.Row - 1,
"i")))
'MsgBox ms
Cells(c.Row, "i").Value = ms
Cells(fr - 1, "i").Value = ms
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
Application.ScreenUpdating = True
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jai Deep
Sent: Wednesday, September 19, 2012 5:36 AM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Rajan/Swapnil,
Thanks a lot for your code.. I need one more help in the same macro.
I tried but did not work.. I have highlighted site totals in yellow
and green colour and also put callouts.
Now I need to edit the macro so that it will also give me formulas in
yellow cells so that if there is any change in site total (green cell)
then yellow cell gets updated.
Thanks,
Jaideep
--
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
Re: $$Excel-Macros$$ All time high Price
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
Sent: Thursday, September 20, 2012 10:57 AM
To: excel-macros
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.
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" Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 14:13:37 -0500 To: ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * This message is eligible for Automatic Cleanup! (dguille...@gmail.com) Add cleanup rule | More info -- 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
Nott quite that easy
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: B.N.Chethan Kumar
Sent: Thursday, September 20, 2012 3:21 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ All time high Price
Use max function
On Sep 21, 2012 12:43 AM, "dguillett1" 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
Sent: Thursday, September 20, 2012 10:57 AM
To: excel-macros
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
mailto:excel-macros%2bunsubscr...@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
mailto:excel-macros%2bunsubscr...@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
Re: $$Excel-Macros$$ All time high Price *
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" Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 15:04:40 -0500 To: 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" Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 14:13:37 -0500 To: ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * This message is eligible for Automatic Cleanup! (dguille...@gmail.com) Add cleanup rule | More info -- 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
Re: $$Excel-Macros$$ All time high Price * *
Send me you file as you have it now and I’ll give you a nice solution. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: resp...@gmail.com Sent: Friday, September 21, 2012 3:02 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * * Hi Don Thanks a ton. I have figured a way around it. I found the max of all the equities ie max of say ACI across the years and dragged it across all the other equities and used index and match to find which equity I have selected ie if I select a particular equity its going to give me the max price of that equity. What I meant by dynamic Ȋ̝̊̅§ with macros Ʊ mostly need to activate a button to retrieve a solution but with formulas once you select the parameters it gives Ʊ and answr without activatin antthing. Sent from my BlackBerry® smartphone from Airtel Ghana From: "dguillett1" Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 17:01:21 -0500 To: ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * * This message is eligible for Automatic Cleanup! (dguille...@gmail.com) Add cleanup rule | More info -- 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$$ Formula not being copied down
saving file will CALCULATE Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: johnson john Sent: Friday, September 21, 2012 7:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula not being copied down Hellow Guys, While copying formula in my excel work book, formula is taking fixed reference but not the relative reference. while saving the file, it gets automatically corrected. Pls. clarify what is the issue here? thanks in advance regds., Johnson -- 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$$ Required help in Work Allocation VBA based excel file.
And my question is why have 200 files. Provide a sample master file and a sample slave file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Saturday, September 22, 2012 9:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks & Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma wrote: How you want to Update this file? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 22 September 2012 7:13 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. Hi All, I wanna a create Work Allocation VBA based excel file, here-under is my requirement. 1. There should a single Work allocation file through which I can allocate almost 200 people to there respective work. 2. After completing everyone update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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 mailto:excel-macros%2bunsubscr...@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 an
Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer
Try this
Sub MakeCenterHeaderSAS()
mc = 1
For Each objFilterPart In ActiveSheet.AutoFilter.Filters
If objFilterPart.On Then
ms = ms & " " & ActiveSheet.AutoFilter.Range.Columns(lngcount).Column
End If
mc = mc + 1
Next
With ActiveSheet.Range("$A$2:$A" & Range("A" & Rows.Count).End(xlUp).Row)
If Left(ms, 2) = 4 Then
mf = " from " & .Offset(1, 4).SpecialCells(xlCellTypeVisible)
Else
mf = ""
End If
myheader = .Offset(1, 6).SpecialCells(xlCellTypeVisible) & " Members" & mf
'MsgBox myheader
ActiveSheet.PageSetup.CenterHeader = myheader
End With
End Sub
From: Steve May
Sent: Tuesday, September 13, 2011 1:19 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer
Dear Noorain,
Thank you very much for your quick respose.
I am attaching a modified file from excel-macros@googlegroups.com, with my
request.
Thank you once again.
On Tue, Sep 13, 2011 at 10:55 PM, NOORAIN ANSARI
wrote:
Dear Steve,
Can you u provide excel sheet with Example..
On Tue, Sep 13, 2011 at 10:21 PM, Steve May wrote:
Dear Friend,
I have table with many columns. If one of them is gender and it contains
either 'Boy' or 'Girl'.
1. If I filter only 'Boy' then the Header or Footer must have "Boy" in it.
2. Further before printing excel must ask what should be there in the
header or footer.
3. Automatically it must add a word or words related to the filtered word.
eg. If I filter 'Boy' then can it have a "Boys Only"
Thanking you in Advance.
Bye for now
Steve
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Thanks & regards,
Noorain Ansari
http://excelmacroworld.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
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ how to consalidate from more sheets to one sheet
Try this without selections
Option Explicit
Sub consolidateSAS()
Dim ns As Long
Dim slr As Long
Dim dlr As Long
Dim i As Long
Application.ScreenUpdating = False
ns = Sheets.Count
Sheets.Add After:=Sheets(ns)
With ActiveSheet
.Name = "Consolidated Sheet"
.Range("A1") = "Name"
.Range("B1") = "Result"
.Range("C1") = "%Marks"
For i = 1 To ns
slr = Sheets(i).Cells(Rows.Count, 1).End(xlUp).Row
dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1
Sheets(i).Rows(2).Resize(slr).Copy .Cells(dlr, 1)
Next i
.Columns.AutoFit
End With
Application.ScreenUpdating = True
End Sub
-Original Message-
From: naresh v
Sent: Wednesday, September 14, 2011 4:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ how to consalidate from more sheets to one sheet
Hi Team,
I have a query, can you please tell me…
Q: How to link data from different sheets to one sheet ?
Ex: In attached excel there are 6 sheets.
Sheet1, Sheet2, Sheet3, Sheet4, Sheet5 and consolidated sheet.
I want to pull data into consolidate sheet from sheet1 to sheet5.
I have shown in the attached excel.
Thanks and 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
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post 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$$ Fwd: Finding Merged cells in excel
Or, if you just want to remove, try
Sub unmergecells()
Cells.MergeCells = False
End Sub
From: NOORAIN ANSARI
Sent: Thursday, September 15, 2011 6:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Finding Merged cells in excel
Dear Amit,
Please try it.
Sub findmerged_cell()
Dim str As String
Dim stri As String
For Each c In Selection
If c.MergeCells Then
str = c.Address
stri = stri & "," & str
End If
Next
stri = "(" & Mid(stri, 2, 1000) & ")"
Range(stri).Select
End Sub
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Thu, Sep 15, 2011 at 1:15 PM, Amit Gandhi wrote:
Hi Folks
I am finding some problem in excel data. Pls help me here. I have a excel
data in 10 columns and 2 rows. There are some MERGED CELLS in this data. I
am applying filters and its not working due to merged data. Is there any way in
Excel to find merged cells automatically.
Pls help me here.
Regards
Amit
--
--
Thanks & regards,
Noorain Ansari
http://excelmacroworld.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
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post 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$$ Navigate worksheet from Dropdown list
’makes a list, in column 1 of all sheets>names the range>sets up data validation
option explicit
Sub makesheetlistSAS()
Dim i As Long
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
Cells(1).Resize(Cells(Rows.Count, 1).End(xlUp).Row) _
.Name = "SheetList"
Range("b1").Validation.Add Type:=xlValidateList, _
AlertStyle:=xlValidAlertStop, Formula1:="=sheetlist"
End Sub
From: Ananta Sapkota
Sent: Friday, September 16, 2011 1:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Navigate worksheet from Dropdown list
Hi Friends
I have more than 100 worksheets in workbook. I used to open these worksheets by
using input box. But there is problems to remember many worksheets. That is why
I'm trying to navigate worksheet from drop down list. Please help me how we can
navigate worksheet from drop down list.
Ananta
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Anyone like to take a project and challenge in excel
You may?? not find too many anxious to help telemarketers -Original Message- From: Mayank Sent: Sunday, September 18, 2011 12:03 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Anyone like to take a project and challenge in excel Need urgent help in excel project Process flows as follows Call center make appointments Generate the appointment file by clicking export button & send the file to call centre Call center manger receive all the files from tele marketers and do quality check ( approved , rejected , reschduled ) rejected appoints goes to tele back *** approved & re-schedule appointment send to sales manager Sales manger assign the app to the sales rep Export the file ( which auto creates in name of sales rep he assigned the job , easy to email directly) the sales guy import to its screen and leave feedback after attending the appointment ( signed, not inetrested, pipeline(need to meet again) ) all the signed sales then open a form which he need to fill with all the details provided in the form. after all the signed forms filled up which auto creates the file in clients name, then he send the details to operations operations import the file and check all details & then go by 6 steps which is y/n paperwork completed. processed approved delivered activated claw back that's whole process apart from that few more sheets to be made which can be edited by mangement anytime like User create user details , pay structure , targets etc Note: if we can make the whole as master file and when user created it also auto cretae the sheets specified for the user so he can work and just export/import data for inetrface Product all the plans , handset given on each plan commissions for plans , bonus eligibility Generate pipeline of all reps with their names in single sheets ( attchemnts given for reference) Reports Pay file and print preview rest we can discuss on later I am happy to give some amount in return for that as well Contact me at trulyb...@gmail.com Thanks Mayank -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ *Macro Code Request*
A very easy way is to put your formula in cell c2 and then DOUBLE click the fill handle (lower right corner) From: Prabhu Sent: Tuesday, September 20, 2011 12:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ *Macro Code Request* Hi Friends, Column A & B contains some values and In Column "C" i want to add A & B value. In cell "C2" i put formula as =A2+B2 Now i want to copy the formula from cell "C2" till the last cell i.e Range should be equal to column "A" Can any one help me to know the VBA code to select range as smiler to previous columns and paste the copied cell(C2). Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ *Macro Code Request*
If you want a macro just use this
Sub FillDownSAS()
With Range("c2")
.Formula = "=a2+b2"
.AutoFill Destination:=Range("C2:c" & Cells(Rows.Count, "a").End(xlUp).Row)
End With
End Sub
if you already have the formula in c2
Sub FillDownSAS()
range(“c2”).AutoFill Destination:=Range("C2:c" & Cells(Rows.Count,
"a").End(xlUp).Row)
End Sub
From: Prabhu
Sent: Tuesday, September 20, 2011 12:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ *Macro Code Request*
Hi Friends,
Column A & B contains some values and In Column "C" i want to add A & B value.
In cell "C2" i put formula as =A2+B2
Now i want to copy the formula from cell "C2" till the last cell i.e Range
should be equal to column "A"
Can any one help me to know the VBA code to select range as smiler to previous
columns and paste the copied cell(C2).
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
Can you provide an AFTER example -Original Message- From: Rohan Young Sent: Thursday, September 22, 2011 2:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help -- Forwarded message -- From: Rohan Young Date: Tue, Jul 26, 2011 at 2:22 PM Subject: Required Latest No. of Drawing - Help To: excel-macros@googlegroups.com Dear Experts I want to make a list drawing in which i required only latest revision of drawings it can be R3, R5, i need only latest version rest of previous i do not required in that list please help me out with any formula or vba code (see attachment) Thanks & Regds, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Export Data
I would copy the sheet to the desktop and save as and close
Sub CopyDetailsToDesktopSAS()
mydesktop = Environ("userprofile") & _
Application.PathSeparator & "Desktop" & _
Application.PathSeparator
mypath = ActiveWorkbook.Path
With Sheets("Details")
.Copy
newname = .Name & " - " & Format(Date, "mm-dd-yy")
With ActiveWorkbook
.SaveAs Filename:=mydesktop & newname & ".xls"
.Close
End With
End With
ChDir mypath
End Sub
From: Mr Excellent
Sent: Thursday, September 22, 2011 12:29 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Export Data
Hi Group
I have a spread sheet which has 3 TABS and the last tab is saved with the
required information and i need a VBA code for exporting only the TAB named as
"Details" to be exported on my desktop with xls format and file which has to be
saved should be named as "Details - Present Date( DD-MM-).xls"
Could anyone help me on this.
Thanks
Prasad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Find the month of sales cross the target
How about a nice macro to populate col K and color the month within the row. Option Explicit Sub crossmonthSAS() Dim i As Long Dim j As Double Dim ms As Long For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row ms = 0 For j = 2 To 8 ms = ms + Cells(i, j) If ms < 100 Then Cells(i, "k") = "Not Qualified" Else 'MsgBox Cells(1, j - 1) Cells(i, "K") = Cells(1, j) Cells(i, j).Interior.ColorIndex = 4 Exit For End If Next j Next i End Sub -Original Message- From: Deepak Rawat Sent: Friday, September 23, 2011 4:34 AM To: excel-macros Subject: $$Excel-Macros$$ Find the month of sales cross the target Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as "Not Qualify" Pls Help!! Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ columns data need to be in reverse order
Try in a macro enabled workbook (.xls or .xlsm) Sub CustomSortSAS() 'converts to values Rows(3).Clear x = Application.Match(Application.Min(Rows(2)), Rows(2)) y = Application.Match(Application.Max(Rows(2)), Rows(2)) Cells(3, y - x + 2).Resize(, x - 1).Value = _ Cells(2, 1).Resize(, x - 1).Value Cells(3, 1).Resize(, y - x + 1).Value = _ Cells(2, x).Resize(, y - x + 1).Value Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight End Sub ‘or Sub CustomSortSAS1() 'copies x = Application.Match(Application.Min(Rows(2)), Rows(2)) y = Application.Match(Application.Max(Rows(2)), Rows(2)) Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2) Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1) Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight End Sub From: shivashankar katageri Sent: Friday, September 23, 2011 1:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ columns data need to be in reverse order Dear all, Any body help in this matter,please have luk of the attachement, I have lot of columns data,Now I want all the data with formula in reverse manner -- Thanks & Regards Shivashankar.C.Katageri 9945800300 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent------Fill in 1 column
To me, all non customer requests are treated the same and I even sometimes ignore those who say it is “URGENT” From: Brajesh Kumar Porwal Sent: Friday, September 23, 2011 5:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent--Fill in 1 column Hi Expert, Find attached two excel files for top members across stores (File 1 –top members and File 2 – Workings). We need to fill Column M highlighted in Yellow in “Top members” file. To fill this please refer columns D to G in “Workings” file. Information for 02 is filled in the “top members” file. You can use that as a sample to fill for all other stores in the file. Do let us know in case you have any queries on the same. So please give good solution. Regards, Brajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria
Assuming data in columns b:d and requests in cols f&g, This is an ARRAY
formula that must be entered using ctrl+shift+enter
=DAY(G2) & "
("&TEXT(MIN(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")& " | "
&TEXT(MAX(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")&")"
From: vickey
Sent: Sunday, September 25, 2011 5:33 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup for two same value in acceding order with two
Criteria
can I get values (time) of two same values in accedning order with two
Criteria. for example I have employee code / date & time
now employee code repeates two or more times in a day with diffrent times. now
what I want if I select parcticular date with particular empoyee ID then time
of that particuar date or day should reflect in acceding order in single cell.
EMPCodeDateTime
525/09/11 09:15:30
525/09/11 12:30:00
525/09/11 18:30:45
taking above table as an example I want result in following format.
EmpCode - 5
Date - 25/09/11
25 (09:15:30 | 18:30:45)
means start time and end time for the day or date should reflect.
the idea behind is to creat a caleder for attendence with time for employee, on
the basis of data which is imported from biomatix system.
kindly help me out
vikas daiya
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Max Value Required for Each half hour
If you are actually looking the highest value within the time frame, use this array formula that must be entered using ctrl+shift+enter =MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Max Value Required for Each half hour
I deleted your original but here is a sample From: Ahmed Honest Sent: Sunday, September 25, 2011 9:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Max Value Required for Each half hour Dear Dguilett, the formula is not working please can you see in the attachment and do it for me pleas. Regards Ahmed Bawazir On Sun, Sep 25, 2011 at 5:12 PM, dguillett1 wrote: If you are actually looking the highest value within the time frame, use this array formula that must be entered using ctrl+shift+enter =MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post 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 -- 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 maxperhalfhour.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria
I sent a solution to what I thought was your request. Now, you have an entirely different question. Please give examples and clear logic on how to get the result. From: vickey Sent: Sunday, September 25, 2011 9:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample file attached. Pleaes have a sample copy of the idea which I want to execute. Thanks again. Vikas | -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria
It appears that you properly understood the question. From: Deepak Pal Singh Sent: Sunday, September 25, 2011 10:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Try this one... :-) On Sun, Sep 25, 2011 at 8:36 PM, dguillett1 wrote: I sent a solution to what I thought was your request. Now, you have an entirely different question. Please give examples and clear logic on how to get the result. From: vickey Sent: Sunday, September 25, 2011 9:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample file attached. Pleaes have a sample copy of the idea which I want to execute. Thanks again. Vikas | -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria
Another way without the need for the start/stop column. ARRAY formula entered with ctrl+shift+enter =MIN(IF(($A$2:$A$5000=$H$11)*($B$2:$B$5000=H$13),$C$2:$C$5000)) =Max(IF(($A$2:$A$5000=$H$11)*($B$2:$B$5000=H$13),$C$2:$C$5000)) From: Deepak Pal Singh Sent: Sunday, September 25, 2011 11:09 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Sure. :-) On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote: Yes, great its working can I raise more query/issues in case I face during the operation... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ columns data need to be in reverse order
You guys apparently missed a stated
x y z
===
instead of zyx, so I offered 2 varieties
Sub CustomSortSAS() 'converts to values
Rows(3).Clear
x = Application.Match(Application.Min(Rows(2)), Rows(2))
y = Application.Match(Application.Max(Rows(2)), Rows(2))
Cells(3, y - x + 2).Resize(, x - 1).Value = _
Cells(2, 1).Resize(, x - 1).Value
Cells(3, 1).Resize(, y - x + 1).Value = _
Cells(2, x).Resize(, y - x + 1).Value
Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
End Sub
Sub CustomSortSAS1() 'copies
x = Application.Match(Application.Min(Rows(2)), Rows(2))
y = Application.Match(Application.Max(Rows(2)), Rows(2))
Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1), Order1:=xlDescending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
End Sub
From: Sam Mathai Chacko
Sent: Sunday, September 25, 2011 11:53 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ columns data need to be in reverse order
Also, on second thought, the column count should be more sure than the value
count. So
=INDEX($A$2:$M$2,COLUMNS(A2:$M$2)) would be better than
=INDEX($A$2:$M$2,COUNTA(A2:$M$2))
Regards,
Sam Mathai Chacko (GL)
On Sun, Sep 25, 2011 at 10:20 PM, Sam Mathai Chacko wrote:
Here's the working example.
Regards,
S
On Sun, Sep 25, 2011 at 10:18 PM, GoldenLance wrote:
This short and simple macro should reverse the range for you
Sub RangeReverser()
Dim rngCell As Range
Dim rngCells As Range
Dim lngCounter As Long
Const lngOffsetRow As Long = 6 'How many rows below you want the
reversed range
Set rngCells = Range("A2:M2")
For Each rngCell In rngCells
rngCell.Copy rngCell.Offset(lngOffsetRow,
(rngCells.Cells.Count - ((lngCounter * 2) + 1)))
lngCounter = lngCounter + 1
Next rngCell
End Sub
OR, you could use a formula to reverse it too
Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right
Regards
Sam Mathai Chacko (GL)
On Sep 23, 8:54 pm, "dguillett1" wrote:
> Try in a macro enabled workbook (.xls or .xlsm)
>
> Sub CustomSortSAS() 'converts to values
> Rows(3).Clear
> x = Application.Match(Application.Min(Rows(2)), Rows(2))
> y = Application.Match(Application.Max(Rows(2)), Rows(2))
>
> Cells(3, y - x + 2).Resize(, x - 1).Value = _
> Cells(2, 1).Resize(, x - 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Value = _
> Cells(2, x).Resize(, y - x + 1).Value
>
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
Order1:=xlDescending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlLeftToRight
> End Sub
> ‘or
> Sub CustomSortSAS1() 'copies
> x = Application.Match(Application.Min(Rows(2)), Rows(2))
> y = Application.Match(Application.Max(Rows(2)), Rows(2))
> Cells(2, 1).Resize(, x - 1).Copy Cells(3, y - x + 2)
> Cells(2, x).Resize(, y - x + 1).Copy Cells(3, 1)
> Cells(3, 1).Resize(, y - x + 1).Sort Key1:=Cells(3, 1),
Order1:=xlDescending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlLeftToRight
> End Sub
>
> From: shivashankar katageri
> Sent: Friday, September 23, 2011 1:21 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ columns data need to be in reverse order
>
> Dear all,
>
> Any body help in this matter,please have luk of the attachement,
>
> I have lot of columns data,Now I want all the data with formula in
reverse manner
>
> --
>
> Thanks & Regards
>
> Shivashankar.C.Katageri
>
> 9945800300
>
> --
>
--
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
:http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
linkhttp://www.facebook.com/
Re: $$Excel-Macros$$ Need Help
Simply deleting the un-needed rows and columns reduced the file by one half. Combining like sheets with an extra column and using autofilter would help. Etc. From: syed aliya raza hashim Sent: Sunday, September 25, 2011 1:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help Hi , I need help can we be automize the attached report more to look more attaractive i want there are so many sheets but can we add button option to choose sheet tab and also can we small the size of file -- syed aliya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
Can you show us an AFTER example(s) of what you want this to look like.. -Original Message- From: Rohan Young Sent: Monday, September 26, 2011 2:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help On Thu, Sep 22, 2011 at 6:04 PM, dguillett1 wrote: Can you provide an AFTER example -Original Message- From: Rohan Young Sent: Thursday, September 22, 2011 2:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help -- Forwarded message -- From: Rohan Young Date: Tue, Jul 26, 2011 at 2:22 PM Subject: Required Latest No. of Drawing - Help To: excel-macros@googlegroups.com Dear Experts I want to make a list drawing in which i required only latest revision of drawings it can be R3, R5, i need only latest version rest of previous i do not required in that list please help me out with any formula or vba code (see attachment) Thanks & Regds, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria
See attached to do as desired From: vickey Sent: Monday, September 26, 2011 10:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Thanks, It worked, but there is one argument, if there are more then three entries in a particular day i.e. on 1st of sept there are three diffrent times mentioned or more than that, then very first and very last time should reflects. (means in time of morning and out time of evening) I have highligthed cell in attached format. the argument is that in a single day more than two entries could be enter. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post 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 attensolutionvkey.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Create report & print based on cell value
Attach your file -Original Message- From: JMac Sent: Monday, September 26, 2011 7:32 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Create report & print based on cell value I have a list that is used to track when people are issued uniforms. I'd like to create a macro that can look at the date in the cell that indicates when they get their next set and prints out a list of all employees where that date is past the current date. My sheet has 4 columns - Employee Name/number, Hire Date, Last Issued Date, Next Issue Date. Based on the results of this, I then want to print out a pre-defined order form for each employee on the list. Any suggestions/help would be appreicated. Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Create worksheet from list
I didn’t see a “like the above” and I answer many emails so please refresh my memory and attach the file. From: Mr excel Sent: Monday, September 26, 2011 10:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Create worksheet from list Mr.guillet..thanks for that great macro.i had a situation same like the above. A little change is that u had given example for a worksheet with data. i want to update all the worksheets as and when i enter new data into the main sheet.i think it can be done using the On_enter worksheet event.can u give me the same for my requirement. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Create report & print based on cell value
Send me the file and I’ll take a look
From: Jeff
Sent: Tuesday, September 27, 2011 12:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that can look at the date in the cell that
indicates when they get their next set and prints out a list of all
employees where that date is past the current date.
My sheet has 4 columns - Employee Name/number, Hire Date, Last Issued
Date, Next Issue Date.
Based on the results of this, I then want to print out a pre-defined
order form for each employee on the list.
Any suggestions/help would be appreicated.
Thanks
ReplyReply to author Forward
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "$$Excel-Macros$$ Create
report & print based on cell value" by dguillett1
dguillett1View profile Translate to Translated (View
Original)
More options Sep 27, 9:41 am
From: "dguillett1"
Date: Tue, 27 Sep 2011 08:41:42 -0500
Local: Tues, Sep 27 2011 9:41 am
Subject: Re: $$Excel-Macros$$ Create report & print based on cell value
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Attach your file
- Hide quoted text -
- Show quoted text -
-Original Message-
From: JMac
Sent: Monday, September 26, 2011 7:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that can look at the date in the cell that
indicates when they get their next set and prints out a list of all
employees where that date is past the current date.
My sheet has 4 columns - Employee Name/number, Hire Date, Last Issued
Date, Next Issue Date.
Based on the results of this, I then want to print out a pre-defined
order form for each employee on the list.
Any suggestions/help would be appreicated.
Thanks
--
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Format to be Changed!$$$$$$$$$
This macro will do it
option explicit
Sub TransposeEmSAS()
Dim r As Long
Application.ScreenUpdating = False
Columns("J").Resize(, 2).Insert
r = 2
doit:
If Cells(r + 1, 1) = "" Then GoTo deletecolumns
Rows(r + 2).Resize(4).Insert
'copy colors
Range("L2:P2").Copy
Cells(r + 1, "j").PasteSpecial Paste:=xlPasteAll, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=True
'copy values
Cells(r + 1, "L").Resize(, 5).Copy
Cells(r + 1, "k").PasteSpecial , Transpose:=True
'do the next set
r = r + 5
GoTo doit
deletecolumns:
Columns("l:z").Delete
Application.ScreenUpdating = True
End Sub
From: shashank bhosle
Sent: Wednesday, September 28, 2011 12:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Format to be Changed!$
Hello Friends,
I have attach the sheet which included two table
T1
T2
i want to change the T1 data to T2
Please help
Regards
Shashank
9422927499
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Computer moving average hrs of play per day
Send your file with a complete explanation and before/after examples to dguille...@gmail.com -Original Message- From: Ken Sent: Wednesday, September 28, 2011 1:03 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Computer moving average hrs of play per day I have a spreadsheet where I track my Poker play. I play a few times per week. The amount of play varies a lot. Each time I play I add a row to a sheet with the date, hrs played, loss, win, etc and computer various values; cash flow, win / loss ratio, best day of week to play, best game, etc. e.g. Friday and Saturday are very good days to play and win I would like to calculate a moving average of the hours I am playing per day based on the last say 50 calendar days of play. I can do the last 50 plays; but I am interested in the last 50 days of the calender to see how many hours I am averaging over the last 50 days. Reason: I take breaks in the play and a 50 play average will not show that data only a calculation based on the calendar. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ find doubling
This will remove the duplicates. If you have xl2007 you could use the remove
duplicates
Sub advancedfilterunique()
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("A1:A49")
.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("b1"), Unique:=True
.Delete Shift:=xlUp
End With
Columns(1).Delete
Columns(1).AutoFit
End Sub
From: Suman
Sent: Thursday, September 29, 2011 1:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ find doubling
Hi, Anil
Please find the attached sheet if it helps you.
On Thu, Sep 29, 2011 at 10:54 AM, anil kumar wrote:
Hello sir,
frist of all thanks for reply. I used your formula but it is not work
according to my data. I have attched that file. plz see that.
Thanks & Regards
Anil
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
«•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
«´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
«•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»
Mob: +91 9810333884
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>
Re: $$Excel-Macros$$ FW: How to remove the duplicate value
Save file as an xlsM file and enable macros and use Option Explicit Sub nodupesperitemSAS() Dim i As Long For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If Cells(i, "d") = Cells(i - 1, "d") Then Rows(i - 1).Delete Next i End Sub From: Neeraj Chauhan Sent: Thursday, September 29, 2011 2:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ FW: How to remove the duplicate value Dear Experts, I have a data, which have duplicate Indus id but each Indus id has a unique date, I want to know how can I put the Indus id of the last date. And want to remove the another Indus id. Kindly find the data Thanks & Regards Neeraj Chauhan MIS Executive. b4S Solutions (P) Ltd. 169/1 Mangal Pandey Nagar Meerut UPW 251 Mob. +91-9756706882 email-neerajchauhan...@gmail.com From: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] Sent: Thursday, September 29, 2011 11:47 AM To: 'excel-macros@googlegroups.com' Subject: How to remove the duplicate value Dear Experts, I have a data, which have duplicate Indus id but each Indus id has a unique date, I want to know how can I put the Indus id of the last date. And want to remove the another Indus id. Kindly find the data Thanks & Regards Neeraj Chauhan email-neerajchauhan...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Create worksheet from list
Haven’t followed this so
Send your file with a complete explanation and before/after examples to
dguille...@gmail.com
From: Mr excel
Sent: Thursday, September 29, 2011 4:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Macro 1:
Option Explicit
Sub ExtractReps()
Dim ws1 As Worksheet
Dim wsNew As Worksheet
Dim rng As Range
Dim r As Integer
Dim c As Range
Set ws1 = Sheets("Sheet1")
Set rng = Range("Database")
'extract a list of Sales Reps
ws1.Columns("C:C").AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Range("J1"), Unique:=True
r = Cells(Rows.Count, "J").End(xlUp).Row
'set up Criteria Area
Range("L1").Value = Range("C1").Value
For Each c In Range("J2:J" & r)
'add the rep name to the criteria area
ws1.Range("L2").Value = c.Value
'add new sheet and run advanced filter
Set wsNew = Sheets.Add
wsNew.Move After:=Worksheets(Worksheets.Count)
wsNew.Name = c.Value
rng.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Sheet1").Range("L1:L2"), _
CopyToRange:=wsNew.Range("A1"), _
Unique:=False
Next
ws1.Select
ws1.Columns("J:L").Delete
End Sub
Macro 2:
Option Explicit
Sub MakeRepSheetsSAS()
Dim c As Range
Dim lr As Long
Dim slr As Long
Application.ScreenUpdating = False
With Sheets("sheet1")
.Columns("C:C").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("J1"), Unique:=True
lr = .Cells(Rows.Count, 1).End(xlUp).Row
slr = .Cells(Rows.Count, "j").End(xlUp).Row
For Each c In Range("j2:j" & slr)
.Range("A1:G1").AutoFilter
Sheets.Add After:=Sheets(Sheets.Count)
.Range("A1:G" & lr).AutoFilter Field:=3, Criteria1:=c
.Columns("a:g").Copy Range("a1")
ActiveSheet.Name = c
'.Range("A1:G" & lr).AutoFilter
Next c
.Range("A1:G" & lr).AutoFilter
End With
End Sub
These are the macros in the example quoted earlier in this post.My Request is
that, how would i modify the macro to suit my needs
My requirements:
1.On entering the data in the main sheet.(sheet1) here.Worksheets to be
generated basing on the new reps added.
2.after the new data is added to the sheet, Rows should be updated on entry to
the respective sheets based on reps.
Everything is same but only the macro is run with the data in the main sheet in
the actual scenario.but whereas,in my requirement i need the data to be updated
immediately on entry in the main sheet.
Hope i had explained it better..Thanks in advance for sparing time...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post 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
=(D2-C2)*24 From: John A. Smith 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
Re: $$Excel-Macros$$ date format in Excel
If ??? I understand, simply CUSTOM format the cell as "dd-mm- From: Sanjib Chatterjee Sent: Friday, September 30, 2011 12:33 AM To: excel-macros Subject: $$Excel-Macros$$ date format in Excel Dear I like to put the date format in Excel as "dd/mm/", and like to get the output as "dd-mmm-" thank you in Advance sanjib -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel <>
Re: $$Excel-Macros$$ Create worksheet from list
I don't see all of my original code here but
also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row "
Excel is looking in col J for the bottom most cell, ie 22
Range("J2:J" & r) in above code.
Excel is using range("j2:j22")
makes little difference what r is called. could be lastrow or x or many
things as you desire
-Original Message-
From: airen
Sent: Thursday, September 29, 2011 9:00 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Hi dguillett,
I am a learner, could you please tell me meaning of "& r" in
Range("J2:J" & r) in above code.
Thanks
Akhilesh Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ find doubling
Just modify my code to this. You could also sort by site ascending with
descending date>advance filter to unique>copy but this is easier.
Option Explicit
Sub CopyLastDatetoothersheeetSAS()
'run from source sheet
Dim i As Long
Dim dlr As Long
On Error Resume Next
For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row + 1
If Cells(i, "d") <> Cells(i - 1, "d") Then
With Sheets("sheet2")
dlr = .Cells(.Rows.Count, 1).End(xlUp).Row + 1
Rows(i - 1).Copy .Cells(dlr, 1)
.Columns.AutoFit
End With
End If
Next i
End Sub
From: anil kumar
Sent: Friday, September 30, 2011 3:43 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ find doubling
Dear dguillett and noorani,
I don't want to remove double I want show that and copy in other sheet. for
removing I use Alt +AM
Thanks & Regards
Anil
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel expert required .
I can do it from Texas at $75 hourly -Original Message- From: Jattin Agarwal Sent: Friday, September 30, 2011 3:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel expert required . Dear Excel experts I would request that if any VBA expert can help in automating some reports . fees can be discussed over meeting . we are based in Mumbai Regards Jatin Agarwal 09322335208 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ TRIM FUNCTION
=SUBSTITUTE(F9," ","") From: big smile Sent: Friday, September 30, 2011 6:54 AM To: EXCEL MACRO GROUP Subject: $$Excel-Macros$$ TRIM FUNCTION Respcted Sir & group members. I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v --- now i want the same cell to trimed as look as --- 25989599vvv [ i want to remove the space in between] is it possible with excel function. Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Splitting of files
This is easy enough to do with a macro. However, please consider leaving all in one file and simply use data>filter>autofilter. -Original Message- From: Chidurala, Shrinivas Sent: Saturday, October 01, 2011 6:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Splitting of files Dear All, I have dump file of 3 sheets which contain the data of some clients in each sheet, I want to split the files into client wise and also note the client name is all sheet is in column A. Please advise me to create macro. Find attached sample of dump file and client file for your reference. Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..
As an M$ Excel MVP, I also welcome him to the group From: NOORAIN ANSARI Sent: Sunday, October 02, 2011 10:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times).. 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://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST
Suggest you try this instead as the formula for currsheet. It will work for all. Notice there is NO sheet name in the formula, just the ! =OFFSET(!$A$1,1,0,COUNT(!$A:$A),5) From: Haseeb Avarakkan Sent: Sunday, October 02, 2011 6:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST Hi Sourabh, See the attached. Used a dynamic named range. Always use same format for the sheet name. As you used mmmyy format (First 3 letter in the month & 2 digits in year). Do not use a space in sheet names. HTH Haseeb -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Update sheets on Enter
I suggest, instead that you use ONLY one sheet and filter as desired. See attached and filter by region and then by date. to clear filters use data>filter>show all From: Mr excel Sent: Monday, October 03, 2011 4:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Update sheets on Enter Hi group, I had been struggling with a solution for a problem from many days.. Recently i had seen a macro in this group which is very much nearer to my problem.The sample data is taken from one of the previous examples given by guillet. Going by the same sample data : the main sheet contains the following columns with data underneath it. Date Region Rep Item Units Cost Total I want sheets to be added & updated based on each Region and with the date in the chronological order. If a sheet exists already with the REGION NAME there is no need to add the sheet with the same name instead new data should be added from the main sheet to the respective sheets (REGION wise) I had attached the worksheet for reference.Kindly help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post 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 UPDATE SHEETS_SAS.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Update sheets on Enter
I don’t understand what you need There is a master sheet and no sample sheet for your desires. My macro and the other do essentially the same thing. From: Mr excel Sent: Monday, October 03, 2011 10:54 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update sheets on Enter Sorry, guillet.the solution u had provided is not what i m looking for I need a vba macro as in the example sheet attached here.its my fault that i had not given the full details...Very sorry for that... i need the solution very much similiar to the attached makelist example sheet.In that example you had created sheets from the REP cell. I need to update all the sheets when new data is entered in the main sheet.. Thanks in advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Update sheets on Enter
OK. I now see what you wanted which means a slight modification to my macro. However, I also posted a STRONG suggestion to just use filters. From: Mr excel Sent: Monday, October 03, 2011 4:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Update sheets on Enter Hi group, I had been struggling with a solution for a problem from many days.. Recently i had seen a macro in this group which is very much nearer to my problem.The sample data is taken from one of the previous examples given by guillet. Going by the same sample data : the main sheet contains the following columns with data underneath it. Date Region Rep Item Units Cost Total I want sheets to be added & updated based on each Region and with the date in the chronological order. If a sheet exists already with the REGION NAME there is no need to add the sheet with the same name instead new data should be added from the main sheet to the respective sheets (REGION wise) I had attached the worksheet for reference.Kindly help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Update sheets on Enter
I, or some of the others can amend my code to do as desired. However, again, I suggest you try this where you simply use filters on ONE sheet. From: Mr excel Sent: Monday, October 03, 2011 11:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update sheets on Enter huhh..My COmmunication is sucking day by day...sorry guillet.i could not communicate to you properlyHope this time i could make it clear >From the Worksheet MAKESHEETS example given by you.You are adding/creating >sheets based on the REP cell...Here the macro starts only when it is run >manually. Instead,i want the same type of solution.I.e. adding/creating sheets when a new row with new data is entered into the main sheet. To elaborate more in detail,when a new row is entered after the 44th row in row 45.the macro needs to be run automatically adding new worksheet based on the column REP. If all the sheets are added to the workbook previously the REP in the new row should be added to the existing worksheet which was added before the present row.The new row should be added to the worksheet underneath the previous row. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post 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 UPDATE SHEETS_SAS.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed!
It would be helpful if you would post examples of what you want From: shaneallen Sent: Tuesday, October 04, 2011 7:24 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed! Hi Good Day I trust someone will be able to assist me with my quest to get the total number of learners/students per code per subject in each class but preferably for the whole grade in other words for all the classes in one grade together -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Update sheets on Enter
What is the reason that you do not like my idea of filtering? From: Mr excel Sent: Tuesday, October 04, 2011 8:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update sheets on Enter any help from anybody please? On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote: I, or some of the others can amend my code to do as desired. However, again, I suggest you try this where you simply use filters on ONE sheet. From: Mr excel Sent: Monday, October 03, 2011 11:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update sheets on Enter huhh..My COmmunication is sucking day by day...sorry guillet.i could not communicate to you properlyHope this time i could make it clear From the Worksheet MAKESHEETS example given by you.You are adding/creating sheets based on the REP cell...Here the macro starts only when it is run manually. Instead,i want the same type of solution.I.e. adding/creating sheets when a new row with new data is entered into the main sheet. To elaborate more in detail,when a new row is entered after the 44th row in row 45.the macro needs to be run automatically adding new worksheet based on the column REP. If all the sheets are added to the workbook previously the REP in the new row should be added to the existing worksheet which was added before the present row.The new row should be added to the worksheet underneath the previous row. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help
Not clear as to what you want. Pls provide sample sheet and urls and what you need. From: syed aliya raza hashim Sent: Monday, October 03, 2011 11:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help Can excel file such as reports be access from web or can be acccess as web pages suppose we have 10 sheets but from some url we want to see the reports -- syed aliya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed!
Can you attach your file? From: shaneallen Sent: Tuesday, October 04, 2011 1:11 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed! https://docs.google.com/viewer?a=v&pid=forums&srcid=MTI3OTgyMTkwNDM5NTM5NjQ5MzEBMTM0MzYwODk4NTMzNDg3MTc0MTEBMTgwMzYxMDQuMjM5LjEzMTc2NzA2NTg1NTkuSmF2YU1haWwuZ2VvLWRpc2N1c3Npb24tZm9ydW1zQHByZmIxMgE0AQ&authuser=0 Hi Thanx for your interest ,I feel more positive now that help is on its way as I am desperate to get these stats in a very accurate way, if u ask the teachers to do it, they all make invariably some mistake. As you can see in the example sheet I posted of the grade 9's each learner gets a certain percentage for each subject, what I want is to know how many students(learners as they are called here) has which code for each subject. In other words - instead of asking how many code 1's or code 4's are there per subject I can also as how many leaners got a percentage between 20-29 or 40-49. As you can see it is easier to just use the codes as the report as well as the schedule gives the percentage as well as the code for each learner/student shaneallen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ I need help
Can you simply use data>validation as shown in the attached From: Ahmed Emam Sent: Tuesday, October 04, 2011 1:16 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I need help Here it's attached On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote: Dear Ahmed, if possible, Can you share Sample sheet with group.. On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote: Hi all members, I need an Excel sheet that contains check list for about 20 items , and that will be as a to-do note. Can anyone help me? Thanks in advance -- === Ahmed Abu Al magd Al emam General Accountant Al-Amana Technology Est. for Contracting Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia P.O. Box 331240 Riyadh 11373 Tel : +966-1- 423 9742 Fax : +966-1- 423 9734 Mobile : +966-530722135 E-mail : audi...@alamana-tech.com www.alamana-tech.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 -- Thanks & regards, Noorain Ansari http://excelmacroworld.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 -- === Ahmed Abu Al magd Al emam General Accountant Al-Amana Technology Est. for Contracting Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia P.O. Box 331240 Riyadh 11373 Tel : +966-1- 423 9742 Fax : +966-1- 423 9734 Mobile : +966-530722135 E-mail : audi...@alamana-tech.com www.alamana-tech.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel New Работен лист на Microsoft Excel.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Thanks everyone.
You should never “hijack” a thread to ask a question. Instead, start your own with a new subject line. However, can you not use data>autofilter>custom>ends with DR? From: P.VIJAYKUMAR Sent: Tuesday, October 04, 2011 8:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Thanks everyone. Dear Ayush , Congrats on your second achievement, I have a problem with excel.Generally I work with Tally and Excel.When I export accounting Data into excel, I am getting the data with debit and credit along with the number i.e I am getting the data in custom format ( 0.00 Dr). It is not possible to select only debit(dr) or only Credit (Cr)figures at one shot. As it is not possible to select by conditional formatting or by other mode we are selecting the required numbers using filters but that to is a very time consuming and tedious task as the data could range into thousands of numbers and selecting each one using a filter is atime consuming task.I would be truly grateful to you and the group members if any helpis offered in this regard. Regards, VIJAY 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
