Re: $$Excel-Macros$$ Screen Updating
Ok. Tx Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: vba v...@vabs.in Sender: excel-macros@googlegroups.com Date: Wed, 14 Aug 2013 10:32:51 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Screen Updating This message is eligible for Automatic Cleanup! (v...@vabs.in) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DN0dRu4E8tIdHgwkHw3NJPNydUWGgERc6j1Ww2haXdsT1rUT6Ro%252BQwYdkJI9Xb3VWatn6TjVDhoHVhON4V4UPxuUpB518NwVz%252Frxs7LAXfA0QUlo9CUNICG5zAmCekam1%26key%3DJHRaCSO1ccOyABuw5n0VZh5ARbX36W4g1t%252BEgT41s%252FY%253Dtc_serial=14870370464tc_rand=1348348537utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14870370464tc_rand=1348348537utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Auto Sum in Macro Recording
Ooh Vabs you rock. One more request. Can I have a portion of your brains that works the VBA solutions. Jus a lil part. Thanks mate. Excellent work Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: vba v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 5 Aug 2013 19:32:40 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Auto Sum in Macro Recording This message is eligible for Automatic Cleanup! (v...@vabs.in) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DBSHBhKnOI7sx9OBclEwsFJzuXMwVyL%252F6mgjpePFWLgOIG0dmzPjtFljK8qBF3bBcCH8WrtPt6PG%252FIi3cRSyLB4NJAp9MS%252BYIsh5D3D7j4u7Pc%252Fpu5rgBW8q3XdgTRyBo%26key%3DoDnrwgUrUEaLYdkrtasOe1zf3vLfHOqAzGC0Prz%252FsdM%253Dtc_serial=14800635915tc_rand=1830461256utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14800635915tc_rand=1830461256utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Auto Sum in Macro Recording
Hi bosses Any assistance with this? Cheers Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 2 Aug 2013 12:40:20 To: excel-macrosEXCEL-MACROS@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Auto Sum in Macro Recording This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D8pTJ7bkaLzwvlrpio1MPCadWc7daEMLKgZP33IOBgnu9UGQrCueEhqSyC1vXOhFODKs22yX5qIlAsyRwcFZ4KO9y2wO4AnRZ5IKJC5g1TS6fIEOaUVmrgPyEuYxyOKvUsNJ%252FNNeqOlM%253D%26key%3DfH4PpafQ1laM3ImKFCBcDZ15UiFE3z4O8%252Fm16rl05R8%253Dtc_serial=14778941856tc_rand=291917433utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14778941856tc_rand=291917433utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ 9e+307
Its the biggest number excel knows. Assuming you have a list of numbers in column A and you always want excel to deliver the last number in the row to you anytime you update the row. You can use lookup(9e+307,a:a). Your way of telling excel look for the last number in column A or any range where your data Ȋ̝̊̅§. If your data Ȋ̝̊̅§ text then we have to modify this bcause it only deals with numbers. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: santosh subudhi santoshkumar.subu...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 24 Jul 2013 15:39:47 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ 9e+307 This message is eligible for Automatic Cleanup! (santoshkumar.subu...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DXfp%252FQ%252FSEu%252F0RZmoIQm6hN9FxOhud2VhF7Q7YNT9qDbU%252FXLEm9NCsuEny5dLtnBM4bt%252BxdwOQYMkVszMatZF12DOjlVlMUv5aP4v2Q4KBfiQkgTpd%252F9dldhHm5SOkd68JWD5nmi78Tsnhq1lJ2sUtUn51SGYQUHU8%26key%3DipZ4oVjMVkNIGRMjn1YI3ubSeHU%252FbyjPgJEzSs8tgfU%253Dtc_serial=14709796471tc_rand=673744494utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14709796471tc_rand=673744494utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Index Match Not working in VBA
Hello Experts Pls can someone assist on ♍Ɣ request below. If ♍Ɣ requirement explanation Ȋ̝̊̅§ not properly understood pls let me know. Cheers Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 19 Jul 2013 10:39:21 To: excel-macrosEXCEL-MACROS@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Index Match Not working in VBA This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DbY3ef6jNUWOW6du0QcVSDs3AtfBO8peunE82B06CpSMG%252BX9WGb7pyvPEXgpvoDGqo9z%252Fl4lfdCR7d34hP6Klp5bOJotR0dHVOVk26p%252B16Ep30q5a3bIq8MW%252Bx1NlW0q%252BEBdSNYWylmY%253D%26key%3DclgyKno%252FzVGe%252Bne07APeJMupbSxw%252BMv4jfm8FMxY6T0%253Dtc_serial=14666928657tc_rand=1645071397utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14666928657tc_rand=1645071397utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Amazing Excel Charts
Great collection. Thanks Ashish Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: ashish koul koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 12 Jul 2013 21:08:44 To: excel-macrosexcel-macros@googlegroups.com; excelvbamacrosexcelvbamac...@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Amazing Excel Charts This message is eligible for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D2t%252BUyZ%252BJu517aqoqtaYb7unGiUpIExPr9AQB8dhB%252FuRrq%252FVLcoj88eNRcpPBWrWVgJqAm5APoqnK0KAwgsf8hTJWxMZZ2vmGQZzTNAkJbxHU%252FFx6BJRvoFrYg%252F5SiO6fKSo1Fi%252FvI1THxWm7J2ohNA%253D%253D%26key%3DvKR6B9s1OdL7Ryn32SafSRZRY%252FISy8XxEmxVBoqrg9I%253Dtc_serial=14609952710tc_rand=1887353944utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14609952710tc_rand=1887353944utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ How to get the Month end date from a list of dates
I love your solution. Really cool formula. Bravo and thanks a lot. Its perfect. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: De Premor d...@premor.net Sender: excel-macros@googlegroups.com Date: Sat, 22 Jun 2013 08:38:40 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to get the Month end date from a list of dates This message is eligible for Automatic Cleanup! (d...@premor.net) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DQQfDjw1jYXl%252Fg9yrkNIgZGp%252FKrnZKhGEf20MhD5bcW9rAclTwbS7oXq70o5CmqG6wyLji14C%252FZwqmyhi7wUifBxv%252B590PsnKZwhXwTHsDAcBYtziHsj7RmMFW4AuU6b1TzQL468x7zA%253D%26key%3DfIrNBoQNmIZfH3u2BE5ZRxfTolxEwfMvcb5i6HqzU%252Fs%253Dtc_serial=14440354789tc_rand=1357978598utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=14440354789tc_rand=1357978598utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Extract Unique Values with VBA
Excellent. Its perfect. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: VBA VABZ v...@vabs.in Date: Wed, 19 Jun 2013 23:42:22 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Cc: resp...@gmail.com Subject: Re: $$Excel-Macros$$ Extract Unique Values with VBA PFA. HTH//Vabs On Wed, Jun 19, 2013 at 10:27 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts I have attached a file where i need to extract unique values based on a criteria with VBA. I have demonstrated it with excel formula. i need assistance with a vba solution. kindly assist with code. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Vba Code to extract Data from one sheet to another
Perfect. Lalit. Thanks so muche Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey mohan.pande...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 29 Mar 2013 02:30:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosEXCEL-MACROS@googlegroups.com Subject: $$Excel-Macros$$ Re: Vba Code to extract Data from one sheet to another Hi Hilary, Below code will help you Option Explicit Sub Copy_Visited_Client_Data() Dim wksModule As Worksheet Dim wksDashBoardAs Worksheet Dim wksUserSht As Worksheet Dim rngDataRangeAs Range Dim rngDstRange As Range Dim objDropDown As DropDown Dim varData() As Variant Dim lngCountAs Long Const strDataStartCell As String = C2 Const strDestinationCellAs String = J1 Const strUserControlListNameAs String = Drop Down 2 With ThisWorkbook Set wksModule = .Worksheets(Module) Set wksDashBoard = .Worksheets(Dashboard) End With With wksDashBoard Set objDropDown = .DropDowns(strUserControlListName) End With With ThisWorkbook Set wksUserSht = Nothing On Error Resume Next Set wksUserSht = .Worksheets(objDropDown.List(objDropDown.ListIndex)) On Error GoTo -1: On Error GoTo 0: Err.Clear End With If Not wksUserSht Is Nothing Then With wksUserSht Set rngDataRange = Nothing On Error Resume Next Set rngDataRange = .Range(strDataStartCell) Set rngDataRange = rngDataRange.Resize(.Cells(.Rows.Count, rngDataRange.Column).End(xlUp).Row, 1) If rngDataRange.Rows.Count 1 Then Set rngDataRange = Intersect(rngDataRange, rngDataRange.Offset(1)) Else Set rngDataRange = Nothing End If On Error GoTo -1: On Error GoTo 0: Err.Clear End With If Not rngDataRange Is Nothing Then If rngDataRange.Rows.Count 0 Then lngCount = 0 Erase varData For Each rngDstRange In rngDataRange If rngDstRange.Value Then lngCount = lngCount + 1 ReDim Preserve varData(1 To lngCount) varData(lngCount) = rngDstRange.Value End If Next rngDstRange With wksModule Set rngDstRange = .Range(strDestinationCell) Set rngDstRange = rngDstRange.Resize(.Cells(.Rows.Count, rngDstRange.Column).End(xlUp).Row, 1) With rngDstRange If .Rows.Count 1 Then .Offset(1).ClearContents End If If lngCount 0 Then .Offset(1).Resize(UBound(varData)).Value = Application.Transpose(varData) End If End With End With End If End If End If Set wksModule = Nothing Set wksDashBoard = Nothing Set wksUserSht = Nothing Set rngDataRange = Nothing Set rngDstRange = Nothing Set objDropDown = Nothing Erase varData lngCount = Empty End Sub On Thursday, 28 March 2013 17:41:33 UTC+5:30, hilary lomotey wrote: Hi Experts i have attempted to write a VBA code to extract data from one sheet to another but am getting a debug error, kindly assist. What am trying to achieve is if i select a name from the list of users in the dashboard, that name is always a sheet name, i want to copy all the list of institution visited from the selected sheet name (or member of the user list) and paste in the module sheet range J2, but this has to be automatic ie when i select a user it shd run the code and paste it in that range. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are
Re: $$Excel-Macros$$ Re: Macro to be added to new sheets when createdfrom a template *
Thanks Boss very helpful Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Shekhar shekhar.rai...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 20 Mar 2013 05:29:03 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosEXCEL-MACROS@googlegroups.com Subject: $$Excel-Macros$$ Re: Macro to be added to new sheets when createdfrom a template * This message is eligible for Automatic Cleanup! (shekhar.rai...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DRDO74BOSCUfK5%252FKZUQ68x%252FO2yXnqkGjDzjzsXbroFl1i34tcwDKeNUU7CE4lZPV%252BV68QVis7J97%252B9j04xdJsOQ%252F%252FrrPylJ0KLuuJalaJM8grFHh5dJmKaS6wie0s3N4M0566I2fhTEtJugxBVPrb8A%253D%253D%26key%3DkBGEA3%252FWl1Jj616W65r30j78hjHnCDcaut9XZwZ1IZU%253Dtc_serial=13788555734tc_rand=1398764356utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=13788555734tc_rand=1398764356utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Unhide some sheets starting from a specific sheet number
Hello experts Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet up to the last sheet Kindly help with vba code to do that. So technically every sheet from the first sheet Ȋ̝̊̅§ hidden. Any sheet that Ȋ̝̊̅§ after the 10th sheet shd bE unhidden. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Unhide some sheets starting from a specific sheet number
Hello Dave I get a compile error type mismatch on sh E Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: David Grugeon da...@grugeon.com.au Sender: excel-macros@googlegroups.com Date: Sun, 3 Feb 2013 22:24:27 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unhide some sheets starting from a specific sheet number Untested air code Dim sh as worksheet For sh = 7 to sheets.count Sheets(Sh).visible= true Next sh On Sunday, 3 February 2013, wrote: Hello experts Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet up to the last sheet Kindly help with vba code to do that. So technically every sheet from the first sheet Ȋ̝̊̅§ hidden. Any sheet that Ȋ̝̊̅§ after the 10th sheet shd bE unhidden. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com javascript:;. To post to this group, send email to excel-macros@googlegroups.comjavascript:; . Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards David Grugeon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Unhide some sheets starting from a specificsheet number *
Thanks prince its working nicely except that for the purpoze of what I want to do I don't want an input box but want to hard code the number instead in the code. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prince prince141...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 3 Feb 2013 08:34:46 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: resp...@gmail.com Subject: $$Excel-Macros$$ Re: Unhide some sheets starting from a specificsheet number * This message is eligible for Automatic Cleanup! (prince141...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dch6qhW7m4tz7%252FQYLN2NxafKiBZj%252BAUE1SD%252B1%252FAhAT2fRIfIf4tySVyCiFl96w3Vrw3%252BN1dk6gdFu%252Fn2BBOS%252FQnE8sJsY1rDCXwTUUMRDqGEHvyII%252FucumdkoDvYqunRdY2tjYTTr12vhSUq1nhC6LA%253D%253D%26key%3Db%252F7z0OKC7EDznGOimvCtbuYldl39kkC15Mog8kwBzFY%253Dtc_serial=13485164536tc_rand=1008687712utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=13485164536tc_rand=1008687712utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13
Bravo again ♍Ɣ friend well done and thanks for your massive and valuable support. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 2 Feb 2013 11:49:07 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: prince141...@gmail.com Subject: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13 Dear members, Prince Kumar has been selected as 'Most Helpful Member' for the month of Jan'13. He has posted 103 posts last month and helped forum members through his excel expertise. I truly appreciate his technical knowledge, consistency and commitment to the group. He has been consistently contributing in the forum since last 7 months and has been recognized most helpful member consecutively. *Prince, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your commitment. We are honored to have you in this forum. * Thanks everyone for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ . -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: VBA Code -Slide Show
Say sheet 1 has several picture placed in there so I want a code to preview the slide show in the excel file. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prince prince141...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 23 Jan 2013 07:32:18 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosEXCEL-MACROS@googlegroups.com Subject: $$Excel-Macros$$ Re: VBA Code -Slide Show Hi Hilary, Do you want whatever pictures are there on your excel sheet must be converted into PPT for slid show or anything else please help me to understand the problem. Regards Prince On Wednesday, January 23, 2013 7:54:42 PM UTC+5:30, hilary lomotey wrote: Hello Experts, i need assistance with a vba code to show pictures in slide show mode in excel. any help will be appreciated. ie if i insert a number of pictures in excel, i want a code that will show the pictures in slide show mode. thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Slow processing of Data
Hello Big Bosses I have a data am preparing which currently has no VBA actions only formulas. But anytime I click enter on any action or check a button calculation processing starts from 58% to 100% before it completes the action. If I get to the formula tab and set calculation to manual ♍Ɣ formulas don't get updated and this Ȋ̝̊̅§ slowing down everything am doing. Any advice will be much appreciated. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Slow processing of Data
Thanks Anil but if I paste the formula as values it won't solve ♍Ɣ problem as the data will be static. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: अनिल नारायण गवली gawlianil8...@gmail.com Date: Thu, 3 Jan 2013 15:03:04 To: excel-macros@googlegroups.com; Hilary Lomoteyresp...@gmail.com Reply-To: gawlianil8...@gmail.com Subject: Re: $$Excel-Macros$$ Slow processing of Data Hi Hilary, As u r insered too-much formula it will hang the pc, because if u change any cells value of simply edit that cell the processor calculate all the fomula cell and hangsup. simple way is to copy the formula values and paste it as simple values. but from this it will not change the calculations as u change the value of non formula cell. Regards, Gawli Anil On Thu, Jan 3, 2013 at 2:53 PM, resp...@gmail.com wrote: Hello Big Bosses I have a data am preparing which currently has no VBA actions only formulas. But anytime I click enter on any action or check a button calculation processing starts from 58% to 100% before it completes the action. If I get to the formula tab and set calculation to manual ♍Ɣ formulas don't get updated and this Ȋ̝̊̅§ slowing down everything am doing. Any advice will be much appreciated. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Slow processing of Data *
This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of data I can send as ♍Ɣ file Ȋ̝̊̅§ about 6mg. So I can't send the file but can you let me have the VBA code to do this or any option to send the file to you. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prajakt Pande prajakt.pa...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 3 Jan 2013 14:28:42 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Slow processing of Data * This message is eligible for Automatic Cleanup! (prajakt.pa...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DgeNjsaRJOT4QNvh70DFfe4Z3K84o%252FHM8Ih8kI1D5X8YcIUYw1W%252Fm8f7LM%252FsLuTdwyMc3X1efnmRcpdtlEKkGIaqY4PHmKvWkwzMZipWq%252FrB71V0Kq5oPArU%252FbZWjzEQU8idLTADZwqgPBKt%252F1x8dGw%253D%253D%26key%3DpE5ifWbEQl0Yq1dvS943H%252BnVM9VtuFWVuxzvOMLYxFc%253Dtc=13269054966_1226933075 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13269054966_1226933075 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Slow processing of Data * *
Thanks will do Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prajakt Pande prajakt.pa...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 3 Jan 2013 14:49:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Slow processing of Data * * This message is eligible for Automatic Cleanup! (prajakt.pa...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DunZU0Rs9xuobL8bved8s28JQYrPFdXDttIr5TZTPOd5KjVNL8muLYMIp77FbOLBx4LxvmtA%252BAz7Df%252FmI3zi7mINgBqg1GFbuy7eVNHRyFmbT4t34sN%252BASHH19J0qeccVlQu6LUCds25aLHwBrA%252F5rQ%253D%253D%26key%3DJTDtTNKKnrOAyTvWxFoQVAcK4KK84ihY%252FUaKMd%252FvVAE%253Dtc=13269186118_872809673 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13269186118_872809673 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Happy b'day Noorain Ansari
Happy Birthday big bro Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 1 Jan 2013 18:43:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Happy b'day Noorain Ansari Happy b'day Noorain Ansari Regards Ashish Koul Sent on my BlackBerry® from Vodafone -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Data collection - Problem *
Hi your requirement Ȋ̝̊̅§ not too clear. What do you want to copy and where do you want it pasted. Can you explain a bit more. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Bhaity Koneng bhaity.kon...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 27 Dec 2012 13:18:37 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Data collection - Problem * This message is eligible for Automatic Cleanup! (bhaity.kon...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dqj8lgvyJK%252BJ6snk5YrkK9Lv3A2%252FoScwqjU8duPsXODRyKLnEZfnAorFQtLYAZomjGPPeEC5zRizfgSLDdDiPBgAGfqvL%252B0SXspij0oLd%252Bi12gWfcIuiexZeQQ6Sua9Q72MWoxzAeepDQEFgnyL50NA%253D%253D%26key%3DfaGKaiGue5QmPcylpaJ91FiEHL6CSFmmILD0oK1z8S4%253Dtc=13217195517_1131430095 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13217195517_1131430095 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year *
FORUM RULES 2) Don't post a question in the thread of another member Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: rohit tharwani tharwani.ro...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 26 Dec 2012 15:52:18 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year * This message is eligible for Automatic Cleanup! (tharwani.ro...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DUZ3PFWTLuUjmJQWr7tJnyYq953SCC%252B1qkPScBs75cj9EnR6hmoOF6Aj%252Fy8xCgCPYxd2IuJoWO6Ys6tFEU1HdMNv%252Ba93tsEP1OCp%252BwNQMYPHuCVf%252B4lFX00yu9CBxs%252Fa1gmiQNrjbA17knzH45vPCzw%253D%253D%26key%3D0xqOBXB3cE14jtAmSjo9apUIFIEK02X37RSTW1Vgizs%253Dtc=13210565079_1043226684 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13210565079_1043226684 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year *
Merry Christmas Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey mohan.pande...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 24 Dec 2012 22:00:48 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Merry Christmas Happy New Year * Automatic Cleanup: keep last 1 emails (mohan.pande...@gmail.com) Edit rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DB69qPqG7RgIY9J5xfcyMGbV790l1bit8nq%252BFK5%252F%252F77j%252B5gKhcReTQy8vB2rNiAj337g212mcFA7m07d%252BWICIanQp%252Bdv0PAGAUC6hWpHcM3qFw9yi9AWBM9ip6sBLMuzQ0Ck4CuivGBvis%252BXGvXacIg%253D%253D%26key%3DZNQhiDQ1DYt%252FCpKNnQKwxvsJUgOvW0Tz3Tg3hfbjNGg%253Dtc=13201634953_1016389061 Delete rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DB69qPqG7RgIY9J5xfcyMGbV790l1bit8nq%252BFK5%252F%252F77j%252B5gKhcReTQy8vB2rNiAj337g212mcFA7m07d%252BWICIanQp%252Bdv0PAGAUC6hWpHcM3qFw9yi9AWBM9ip6sBLMuzQ0Ck4CuivGBvis%252BXGvXacIg%253D%253D%26key%3DZNQhiDQ1DYt%252FCpKNnQKwxvsJUgOvW0Tz3Tg3hfbjNGg%253Dtc=13201634953_1016389061 Mark important: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DB69qPqG7RgIY9J5xfcyMGbV790l1bit8nq%252BFK5%252F%252F77j%252B5gKhcReTQy8vB2rNiAj337g212mcFA7m07d%252BWICIanQp%252Bdv0PAGAUC6hWpHcM3qFw9yi9AWBM9ip6sBLMuzQ0Ck4CuivGBvis%252BXGvXacIg%253D%253D%26key%3DZNQhiDQ1DYt%252FCpKNnQKwxvsJUgOvW0Tz3Tg3hfbjNGg%253D%26emlId%3D27910203524%26important%3Dtruetc=13201634953_1016389061 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey mohan.pande...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Dec 2012 00:06:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * This message is eligible for Automatic Cleanup! (mohan.pande...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users *
Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so I haven't been able to access this. Kindly provide the user name. But it looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey mohan.pande...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 20 Dec 2012 07:20:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosEXCEL-MACROS@googlegroups.com Subject: $$Excel-Macros$$ Re: Vba code to Check authorised users * This message is eligible for Automatic Cleanup! (mohan.pande...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DtF4MQIKNtgo4Q7D0l8cASqNpuYJsw%252Fu83%252FmZqFngi1PBTlxAvaWDQJIjpn4UiKuDQylKoQaMVN7QkSvXQ2l4dBDvdZ1mqb1Rc5kdXjW9U%252FAq6L%252FUCd%252BXKZDXfyaXJ28n9JkaBA5iJgF0gVDzGD6wEw%253D%253D%26key%3D0BCS6OGHPq9HhCGrAhZRQyrbD0cxDtBm17EisDMZFog%253Dtc=13167949549_680277595 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13167949549_680277595 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *
Can we see all the calenders of participants? Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Paul Schreiner schreiner_p...@att.net Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 11:11:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. * This message is eligible for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DEVXLAcPVdMjj5Lil%252B%252FkTlcBp2naSfzrDPID0gyDvsrM8qBgcTjrbLwok%252Fncl1bOpbkFkHkDSAzpIFIHbmTJ595%252BtBOQyhUlg4rh5MU6PeZIRBlRzQGaOLIY1hHb8P1XIr%252B7vlP1xn8PkbBKsSRMKSA%253D%253D%26key%3DqGFzJqH8aJGpJbzoqmcw8hDOg5h%252BSNv7R00may8IRA0%253Dtc=13114449838_1569401401 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13114449838_1569401401 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *
Congratulations to the winners Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Paul Schreiner schreiner_p...@att.net Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 11:11:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. * This message is eligible for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DEVXLAcPVdMjj5Lil%252B%252FkTlcBp2naSfzrDPID0gyDvsrM8qBgcTjrbLwok%252Fncl1bOpbkFkHkDSAzpIFIHbmTJ595%252BtBOQyhUlg4rh5MU6PeZIRBlRzQGaOLIY1hHb8P1XIr%252B7vlP1xn8PkbBKsSRMKSA%253D%253D%26key%3DqGFzJqH8aJGpJbzoqmcw8hDOg5h%252BSNv7R00may8IRA0%253Dtc=13114449838_1569401401 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13114449838_1569401401 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Add a new sheet and named based on last item ina row *
Thanks prince but I get a debug error on the Strtname =sheets(1).range(a1 rows.count).end(xlup) Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prince prince141...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 6 Dec 2012 03:51:53 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: resp...@gmail.com Subject: $$Excel-Macros$$ Re: Add a new sheet and named based on last item ina row * This message is eligible for Automatic Cleanup! (prince141...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DwjllUQNBKLY764%252FddsPpfq9EfGBswt0msCubY4omtUFxqydJmBuEbNXBSMYtK0K1y3nMPzMI07x19h7b%252Fi6tGCGVq%252BgcmGFJPq6AGWEesQrx5xxXS%252BxIXT0e%252BZ4iAL%252BZouojSfucQT8GyhMjqb3fCA%253D%253D%26key%3DkZDj0s%252FZATy419PaeSBouFyX1C0gqJtPD1Szf4rP%252Fec%253Dtc=13058181434_576394978 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13058181434_576394978 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Hi experts I have been able to amend the code to pick any new sheet name that Ȋ̝̊̅§ created. What I kindly request Ȋ̝̊̅§ the format from the first sheet to the new sheet. See ♍Ɣ new code below. Sub copydata() Dim ws1 as worksheet Dim ws2 as worksheet Dim strtname as string strName = Sheets(3).Range(Arows.count).end(xlup) Set ws1 = thisworkbook.sheets(sheet1) Set ws2 = thisworkbook.sheets(strtname) Ws2.range(a1:ak132).value = Ws1.range(a1:ak132).value End sub Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 6 Dec 2012 13:16:02 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in a row * Thanks again Prince for your help earlier on this. Additional request The code below enables me to copy data from sheet one to sheet two. The problem I have Ȋ̝̊̅§ One. It doesn't copy the format in sheetone to sheet two. Kindly help with the code Two. This other code addsheets that creates a name from the last item in a row strName = Sheets(3).Range(Arows.count).end(xlup) I need help such that in the copydata code ws2 will be equal to the value of strName = Sheets(3).Range(Arows.count).end(xlup) Thanks Sub copydata() Dim ws1 as worksheet Dim ws2 as worksheet Set ws1 = thisworkbook.sheets(sheet1) Set ws2 = thisworkbook.sheets(sheet2) Ws2.range(a1:ak132).value = Ws1.range(a1:ak132).value End sub Sub AddSheet() Dim strName As String strName = Sheets(3).Range(Arows.count).end(xlup) Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = strNameEnd Su Sent from my BlackBerry® smartphone from Airtel Ghana -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Used Macro recording to achieved ♍Ɣ purpose thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 6 Dec 2012 13:16:02 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in a row * Thanks again Prince for your help earlier on this. Additional request The code below enables me to copy data from sheet one to sheet two. The problem I have Ȋ̝̊̅§ One. It doesn't copy the format in sheetone to sheet two. Kindly help with the code Two. This other code addsheets that creates a name from the last item in a row strName = Sheets(3).Range(Arows.count).end(xlup) I need help such that in the copydata code ws2 will be equal to the value of strName = Sheets(3).Range(Arows.count).end(xlup) Thanks Sub copydata() Dim ws1 as worksheet Dim ws2 as worksheet Set ws1 = thisworkbook.sheets(sheet1) Set ws2 = thisworkbook.sheets(sheet2) Ws2.range(a1:ak132).value = Ws1.range(a1:ak132).value End sub Sub AddSheet() Dim strName As String strName = Sheets(3).Range(Arows.count).end(xlup) Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = strNameEnd Su Sent from my BlackBerry® smartphone from Airtel Ghana -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Yes that Ȋ̝̊̅§ what I did. The effect of that being 3 different macros One to create a new sheet and name the sheet by the name item Second to copy data from a particular sheet and paste it in the sheet created above The last one Ȋ̝̊̅§ to copy the format in that particular sheet and paste it in the sheet created above Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prince prince141...@gmail.com Date: Thu, 6 Dec 2012 08:38:37 To: excel-macros@googlegroups.com Cc: resp...@gmail.com Subject: Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row * Hi Hilary, Your first query solution is: Ws1.range(a1:ak132).copy Ws2.range(a1:ak132).pastespecial xlall application.cutcopymode=false for Query 2: do you want set ws2 name should be strName ? regards prince On Thursday, December 6, 2012 8:52:37 PM UTC+5:30, hilary lomotey wrote: Used Macro recording to achieved ♍Ɣ purpose thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: res...@gmail.com javascript: Sender: excel-...@googlegroups.com javascript: Date: Thu, 6 Dec 2012 13:16:02 To: excel-...@googlegroups.com javascript: Reply-To: excel-...@googlegroups.com javascript: Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in a row * Thanks again Prince for your help earlier on this. Additional request The code below enables me to copy data from sheet one to sheet two. The problem I have Ȋ̝̊̅§ One. It doesn't copy the format in sheetone to sheet two. Kindly help with the code Two. This other code addsheets that creates a name from the last item in a row strName = Sheets(3).Range(Arows.count).end(xlup) I need help such that in the copydata code ws2 will be equal to the value of strName = Sheets(3).Range(Arows.count).end(xlup) Thanks Sub copydata() Dim ws1 as worksheet Dim ws2 as worksheet Set ws1 = thisworkbook.sheets(sheet1) Set ws2 = thisworkbook.sheets(sheet2) Ws2.range(a1:ak132).value = Ws1.range(a1:ak132).value End sub Sub AddSheet() Dim strName As String strName = Sheets(3).Range(Arows.count).end(xlup) Sheets.Add After:=Sheets(Sheets.Count)ActiveSheet.Name = strNameEnd Su Sent from my BlackBerry® smartphone from Airtel Ghana -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript:. To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *
I couldn't agree more. Thumbs up Paul. Great to be associated with you. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 * This message is eligible for Automatic Cleanup! (jainayus...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DUZAoCxeohBFcb%252FrM8x3rkNKuNIZuTCZhaalJJwHxJ2%252B60f64UF3kzBXvkA4gdJ0yL%252FEDSBRXWqKhWGxdQGK2oqJRmsgWWepg8dwkGJ3%252FPKAO%252FNiOe%252FGRHAbaSzVf7tU9aR6dWvmMPUqBG4%252Fd%252FQvVYA%253D%253D%26key%3DfQZQR0JjX8j%252FHjRK79IMZaUczuM8GivPkGd7t2COSzM%253Dtc=13036043567_713202469 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13036043567_713202469 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Fw: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule *
Hello Gurus i am trying to develop a very dynamic Fixed Asset depreciation schedule but facing a slight formula or logic challenge and as usual seeking your expert advice. Basically what this current schedule does is assuming you want to depreciate your asset for say 5 years, starting from 2013 you will see information for only the five years ending 2017 so at the end of the 5th year, the asset would have been fully depreciated, assuming however in 2014 you acquired another asset and you expert to depreciate it for 5 years also, it means by the end of 2018 you should have depreciated the 2nd acquisition fully, The Scenario in cell B9, i have entered the no of years for depreciation for the first asset purchased in 2013 and am using the formula IF($B$9=COLUMN(A1),,B11+1) in cell c11 to be able to cut off years after 2017 ( ie 5 years), The Problem however if i enter the new purchase of asset in cell B27, then i would have to enter the no of yrs for deprn for this asset in cell c9, then i expert this formula to be modified IF($B$9=COLUMN(A1),,B11+1) so that the cut off year will be in 2018, it has to be dynamic such that if i enter say a new purchase in csll D27 and i enter say a the no of yr for deprn for this asset in cell E9 the cut off year would be 2020 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 29 Nov 2012 17:31:58 To: excel-macrosEXCEL-MACROS@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule * This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DkyH0VhaRJnkrdHRLFNuNEqqpQr6%252BXSlKZuxuwiVdzN713QHEvj1c0Atc%252Bczign77T4KpMTzBuVHwQ3kdKNHwDcdELDg5sLGisTOz53dS2nSrRc6%252Bs4Bb1t396sEeXjfhFeoe68yRhgE%253D%26key%3Di2U6CianDR%252FtCgspNcaSLcOeF%252F1CQBbIfGc5YzNmp%252BE%253Dtc=13009448229_93838451 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13009448229_93838451 Depreciation Schedule.xlsb Description: Binary data
Re: $$Excel-Macros$$ Masking Password in input box * * *
Hi Paul Thnks noted Pls can Ʊ exactly suggest what I have to do. When I adjust the code to Only frd_show it pops up correctly. However I am left with connecting the correct password to the userform form ie when I type password into the textbox1. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Paul Schreiner schreiner_p...@att.net Sender: excel-macros@googlegroups.com Date: Thu, 25 Oct 2012 10:09:53 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Masking Password in input box * * * This message is eligible for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DaUUAiT9IHlWSjiVgasShmfxZXYUsCONgE8U12NdjzY61EpYi5u0bjrq3Bhw4ewLbgPShq6QaF6996RJ2imkeDP6V8TyGWs8yptz197MTyKK6WTIwAYuoAf7bQU8GiX5UwuHhORGOCrsw4Pz1dMy2dw%253D%253D%26key%3DbNpR8PHzrdsw69fp098Un%252F3zfhlOhQqu%252F0qiHj3iwXk%253Dtc=12751363784_61160080 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12751363784_61160080 -- 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 *
Thanks Don. Really appreciate. Pls can you assist with an excel formula as well? Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 14:13:37 To: excel-macros@googlegroups.com Reply-To: 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: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dfp6Uq9cjZpOIDX6rjkOHwCP%252BlPjwplqHSLTo%252FBDzPV1humc%252FBixYwYPuQ8BZty5GzNkmwhz3d84KKBdTYw2GVqA4mdY9bC32%252FuHKcrLaLF%252FlBPLdSes%252FPkONziRm%252F6wl0G1hFXO%252FLL0%253D%26key%3DznyqkERaXQb8uDHU3hOwyUUS5cAonuSymqGbdgVOIbw%253Dtc=12446925854_493039259 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12446925854_493039259 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 15:04:40 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * Why use a complicated formula that can inadvertently be deleted when the macro is automatic? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: resp...@gmail.com Sent: Thursday, September 20, 2012 2:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * Thanks Don. Really appreciate. Pls can you assist with an excel formula as well? Sent from my BlackBerry® smartphone from Airtel Ghana From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 14:13:37 -0500 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ All time high Price * 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 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$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
Hi KSAGAR If one doesn't have an understanding of the domain area you can't design a dashboard for it. I don't hv much operating knowledge of what you are describing. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 28 Aug 2012 10:01:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD Dear Hilary, I want to make dashboard for share accounting and calculations for income tax. Kindly help me for the same. Thanks Regards, KSAGAR On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Nice Creativity HilaryThanks to sharing with us. On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey resp...@gmail.com wrote: Hi Guys, i just completed an upgrade of my stock market dashboard, pls use as you will. cheers -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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
Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
You asked of DB for share accounting and calculations for income tax. That is the domain area am referrin to Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 28 Aug 2012 13:20:24 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD Dear Hilary, Can you give some material for understanding DOMAIN area.? That will help me a lot... Thanks Regards, Sagar Kasangottuwar On Tue, Aug 28, 2012 at 1:13 PM, resp...@gmail.com wrote: ** Hi KSAGAR If one doesn't have an understanding of the domain area you can't design a dashboard for it. I don't hv much operating knowledge of what you are describing. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Tue, 28 Aug 2012 10:01:08 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD Dear Hilary, I want to make dashboard for share accounting and calculations for income tax. Kindly help me for the same. Thanks Regards, KSAGAR On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Nice Creativity HilaryThanks to sharing with us. On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey resp...@gmail.comwrote: Hi Guys, i just completed an upgrade of my stock market dashboard, pls use as you will. cheers -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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)
Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
Hi Amar I built the dashboard in 2007 and 2010 environment. Am not sure why you can't view in 2003. Maybe Most of the functions I used are not in 2003 so Ʊ may probably get an error. Ʊ can upgrade your 2003 to 2007 or 10. 2010 also has 2003 environment so if Ʊ prefer that you can stick to that envt and work. With 2007 you can apply an addin function to get 2003 envt. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: amar takale amartak...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 25 Aug 2012 10:43:25 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD Hi Hilary I used Excel 2003 Then how to see it On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey resp...@gmail.com wrote: Hi Guys, i just completed an upgrade of my stock market dashboard, pls use as you will. cheers -- 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$$ BullsEye Chart
Thanks Raj Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 11 Aug 2012 16:49:30 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ BullsEye Chart Hi Group, Just sharing the bulls Eye chart. Bulls Eye chart can be used to see weather parameter is in its desired range or not . I have created this chart by using Radar and PIE , hope you can make use of it .. All Suggestion and comments are welcome ! J 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.
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
Congrats Boss. Keep up the momentum Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 3 Aug 2012 23:10:25 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012 Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: ♍Ɣ President is Dead
Thanks man. He was elected in 2009 and was going to run for the 2nd term in Dec this year The vice president has just been sworn in as President Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: bpascal123 bpascal...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 24 Jul 2012 12:57:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: resp...@gmail.com Subject: $$Excel-Macros$$ Re:President is Dead He was elected a year ago I think... Should he rest in peace! -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Fwd: Visualize Excel Salary Data You could win XBOX 360 + Kinect Bundle [Contest] (chandoo.org)
Nice I will join the contest Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: yogananda muthaiah yogananda.mutha...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 27 Jun 2012 22:17:47 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Visualize Excel Salary Data You could win XBOX 360 + Kinect Bundle [Contest] (chandoo.org) Guys, have ur neck out on below mail ... its a time to face a contest. Keep Winning. -- Forwarded message -- From: Chandoo.org - Learn Excel Charting Online chando...@gmail.com Date: Mon, Jun 25, 2012 at 9:56 PM Subject: Visualize Excel Salary Data You could win XBOX 360 + Kinect Bundle [Contest] (chandoo.org) To: yogananda.mutha...@gmail.com ** Visualize Excel Salary Data You could win XBOX 360 + Kinect Bundle [Contest] (chandoo.org) http://chandoo.org/wp http://fusion.google.com/add?source=atgsfeedurl=http://feeds.feedburner.com/PointyHairedDilbert [image: Link to Chandoo.org - Learn Excel Charting Online] http://chandoo.org/wp -- Visualize Excel Salary Data You could win XBOX 360 + Kinect Bundle [Contest]http://feedproxy.google.com/~r/PointyHairedDilbert/~3/PuelD0v6xXU/?utm_source=feedburnerutm_medium=email Posted: 25 Jun 2012 01:25 AM PDT *Its contest time again! Put on your creative hats bring your Excel skills to the game.* Analyze more than 1900 survey responses present your results in a stunning fashion, and you could walk away with an XBOX 360 + Kinect Sports Bundlehttp://www.amazon.com/gp/product/B003O6EE4U/ref=as_li_ss_tl?ie=UTF8tag=poinhairdilb-20linkCode=as2camp=1789creative=390957creativeASIN=B003O6EE4U(valued at $299). Sounds interesting? Read on. The contest 1. Step 1: Download Excel Salary Survey raw datahttp://img.chandoo.org/contests/salary-data-for-contest.xlsx . 2. Step 2: Analyze it and present your analysis using Excel charts (refer to rules below) 3. Step 3: *Submit your output by end of 6th of July (Friday)* 4. Step 4: If your output is mind-blowingly awesome, you could win XBOX 360 + Kinect Bundle Goals for analysis: While you are free to analyze the data in any way, your output must meet these goals - Help us understand how much Excel professionals make all over the world - Help us understand relationship between salary and role, experience, country hours of Excel work. How to send your entries Once you are ready to send your entry, 1. Check the rules (below) and make sure you have followed all of them. 2. *Email your workbooks to chandoo.d @ gmail.com* with subject “*Salary Survey Contest*“ 3. Please include your name best email address(es) so that we can reach you if there is any clarification needed. 4. *Please send in your entries before end of 6th July (Friday).* The Rules - You can make a dashboard or 1 page report - You can make several individual charts (or tables) too as long as they all fit in to one window. - You can make interactive or static charts - You can also use VBA to add interaction to the charts. - Even though you can use add-ins to make your report, user should be able to view your output without installing any add-ins - You can use Excel 2010, 2007 or 2003. Please note that this contest requires use of Excel. - You can submit more than one entry. - Your files must be unlocked any macros you use must have enough comments so that others can learn. - You can add data to this dataset (for example, PPP adjusted salaries, established salary benchmarks from public sources like govt. databases or websites) The Prizes The winner of this contest will receive 1 XBOX 360 (4GB) + Kinect Sports bundlehttp://www.amazon.com/gp/product/B003O6EE4U/ref=as_li_ss_tl?ie=UTF8tag=poinhairdilb-20linkCode=as2camp=1789creative=390957creativeASIN=B003O6EE4U(valued $299). We have 2 consolation prizes too. For the 2nd best entry, you get a Amazon Kindle Firehttp://www.amazon.com/gp/product/B0051VVOB2/ref=famstripe_kftag=poinhairdilb-20 and for 3rd best entry, you get a Kindle Touchhttp://www.amazon.com/gp/product/B005890G8Y/ref=famstripe_kttag=poinhairdilb-20($99 option). So there you go. 3 gorgeous gadgets up for grabs. [image: Excel Salary Survey - Prizes] Note: Since prizes are delivered thru Amazon.com, in case they cannot ship the item to your location, you will be offered $ amount. How do we pick the winners? Once all the entries are received, then we will open voting. 1. All entries will be published on Chandoo.org and you can vote for winner. 2. A panel of judges (names to be revealed later) will also vote. Judges votes carry higher weight. 3. The entries with highest votes will be winners. PS: If we get a lot of entries, we may eliminate a few during voting stage. So what are you waiting for? Go ahead and download the
Re: $$Excel-Macros$$ Re: MY NEW EXCEL DASHBOARD PROJECTS
Hi Core Kindly read ♍Ɣ email you would realize I was very specific in providing the password to the file. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: CoRe neculae.vale...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 26 Jun 2012 00:42:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosEXCEL-MACROS@googlegroups.com Subject: $$Excel-Macros$$ Re: MY NEW EXCEL DASHBOARD PROJECTS Thank you Hilary for sharing those templates with us , but would be very useful ,not just looking how it looks but to be customizable as well. What is the point sharing with us protected files , not that i cannot find a password breaker but like i sayd would be more useful if protection is off on sheet / VBE On Monday, June 25, 2012 5:11:45 PM UTC+3, hilary lomotey wrote: Hello Guys i just completed my two excel projects and want to share. The first one is like an accounting system where you can enter clients information as well as transactions and post it to a database and also able to retrieve the information. Since i am not good with VBA , i used macro recording techniques to achieve these as well as of course formula's. Try it out and have fun and hope someone can improve upon it and give feedback. the pass word on the file is 'kiss The second is a fixed income dashboard, its easy to understand when you test how it works, keep excelling cos excel is fun, have a great day. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Introduce Yourself !!
Hilary from Ghana. A stockbroker. Interest is excel and football. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 8 Jun 2012 12:21:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Introduce Yourself !! Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks Raj. Will try this as well
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 12:33:08
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance
=INDEX($A$1:$B$10,MAX(--($A$1:$A$10=A2)*ROW($A$1:$A$10)),2) with CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: 01 June 2012 1:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks Asa
Attached is what i attempted doing, but after testing my formula this
morning with other examples i realised, its doesnt work for all, i will try
your now. thanks
On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Hilary,
Mind sharing your solution with the group?
What came to mind for me was an array solution that uses small/row to
identify the second smallest row number for the matching name, and index to
retrieve the reference to the cell.
Here's a formula using that approach:
{
=INDEX(NamesRange,SMALL(IF(NamesRange=NameToFind,ROW(NamesRange)),OccurenceN
umber)-ROW(INDEX(NamesRange,1))+1)
}
If you were going to use many of these formulas, NamesRange was large, and
often there was not going to be a match (for example there was only one
occurrence and you were looking for the second), you could speed up the
formulas by use the following version that checks the count (using countif)
of matching names, and if the count is OccurenceNumber (2 in your stated
question) it will skip the array formula and just return an error. If there
will usually be a match, this would actually be slower since it has the
added countif.
{
=IF(COUNTIF(NamesRange,NameToFind)OccurenceNumber,#NUM!,INDEX(NamesRange,SM
ALL(IF(NamesRange=NameToFind,ROW(NamesRange)),OccurenceNumber)-ROW(INDEX(Nam
esRange,1))+1))
}
Upon a little more thought, here is a non-array solution for finding exactly
the 2nd occurrence (the array version would work for finding any specific
occurrence). It uses match to find the first occurrence, then another match
to find the next occurrence. It should be faster---it has less work to do.
If there is no match it either returns an NA error or if the only match was
on the very last row of the range, a REF error.
=INDEX(NamesRange,MATCH(NameToFind,NamesRange,0)+MATCH(NameToFind,INDEX(Name
sRange,MATCH(NameToFind,NamesRange,0)+1):INDEX(NamesRange,ROWS(NamesRange)),
0))
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of resp...@gmail.com
Sent: Thursday, May 31, 2012 2:01 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks guys I have figured it out with index and match and countif. Thanks
Sent from my BlackBerryR smartphone from Airtel Ghana
-Original Message-
From: mailto:resp...@gmail.com resp...@gmail.com
Sender: mailto:excel-macros@googlegroups.com
excel-macros@googlegroups.com
Date: Thu, 31 May 2012 19:42:32
To: mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com
Reply-To: mailto:excel-macros@googlegroups.com
excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Lookup and return 2nd occurrance
Hello Excel Masters
if I have a list if names like below in column A and say I have
corresponding different figures in column B.
Hilary
Rajan
Maries
Noorain
Hilary
Rajan
Don
Kris
Asa
And so on and I want to return for instance the second occurance of hilary
with its corresponding figure. Kindly help with formula. Thanks.
Sent from my BlackBerryR smartphone from Airtel Ghana
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to mailto:excel-macros@googlegroups.com
excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros+unsubscr...@googlegroups.com
excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already
Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks for the explanation. What I like abt this formula is it actually picks
not only the 2nd occurance but the last occurance which I think might be useful
going forward. Thanks again
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 02:42:58
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance
Hi Hilary,
INDEX(NamesRange,1) returns the first row of the range (which is a single
cell since the range is only one column wide).
Put that inside a ROW() function and you get the first row number.
Equally effective would be specifying the first cell in NamesRange instead:
ROW(FirstCellInNamesRange)
For example, if NamesRange is $A$2:$A$13:
INDEX(NamesRange,1) is $A$2
ROW(Index(NamesRange,1)) is ROW($A$2) which is 2.
You might be confused if you think INDEX returns the value of a cell. If
INDEX(NamesRange,1) refers to $A$2 and cell A2 contains Hilary, then you
might expect ROW(INDEX(NamesRange,1)) to be equivalent to ROW(Hilary).
which clearly would not work.
The reason ROW(INDEX(NamesRange,1)) is equivalent to ROW($A$2) instead is
because INDEX is one of the three main functions that can return cell
references, and can be used in place of cell references anywhere cell
references are expected (the other two are OFFSET and INDIRECT). In a
formula result, a cell reference is displayed on the worksheet by the value
of the referenced cells, so the end result is sometimes the same.
The reason I used Row(Index(NamesRange,1)) in the formula instead of
Row($A$2) or Row(FirstCellInNamesRange) was primarily that it would allow
you to use defined names for your ranges without any changes to the formula,
or a redundant defined name to refer to the first cell/first row in
NamesRange.
No, I'm not a lectururer. I like teaching (informally), and I like words,
though. I take it as a complement that you might think so, thanks :). I'm
impressed with your dashboards and workbooks that I've seen so far. I only
wish I was involved in finance -- I'd ask to use them myself.
Two of my previously suggested formulas, with range references substituted
for range names:
1. Standard formula (faster than the array formula, also it will work
with wildcards):
=INDEX($B$2:$B$13,MATCH($A$17,$A$2:$A$13,0)+MATCH($A$17,INDEX($A$2:$A$13,MAT
CH($A$17,$A$2:$A$13,0)+1):INDEX($A$2:$A$13,ROWS($A$2:$A$13)),0))
2. Array formula:
=INDEX($B$2:$B$13,SMALL(IF($A$2:$A$13=$A$17,ROW($A$2:$A$13)),2)-ROW($A$2)+1)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Friday, June 01, 2012 1:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Hi Asa
Your formula is working to perfection, thanks a lot, just two quick
questions
Kindly explain this bit of the formula taking out ROW(INDEX(NamesRange,1)
from the entire formula
Are a Lecturer or some sort?, i always look at the way you explain every
problem that you tackle, its like a lecturer,
thanks
On Fri, Jun 1, 2012 at 8:21 AM, hilary lomotey resp...@gmail.com wrote:
Thanks Asa
Attached is what i attempted doing, but after testing my formula this
morning with other examples i realised, its doesnt work for all, i will try
your now. thanks
On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Hilary,
Mind sharing your solution with the group?
What came to mind for me was an array solution that uses small/row to
identify the second smallest row number for the matching name, and index to
retrieve the reference to the cell.
Here's a formula using that approach:
{
=INDEX(NamesRange,SMALL(IF(NamesRange=NameToFind,ROW(NamesRange)),OccurenceN
umber)-ROW(INDEX(NamesRange,1))+1)
}
If you were going to use many of these formulas, NamesRange was large, and
often there was not going to be a match (for example there was only one
occurrence and you were looking for the second), you could speed up the
formulas by use the following version that checks the count (using countif)
of matching names, and if the count is OccurenceNumber (2 in your stated
question) it will skip the array formula and just return an error. If there
will usually be a match, this would actually be slower since it has the
added countif.
{
=IF(COUNTIF(NamesRange,NameToFind)OccurenceNumber,#NUM!,INDEX(NamesRange,SM
ALL(IF(NamesRange=NameToFind,ROW(NamesRange)),OccurenceNumber)-ROW(INDEX(Nam
esRange,1))+1))
}
Upon a little more thought, here is a non-array solution for finding exactly
the 2nd occurrence (the array version would work for finding any specific
occurrence). It uses match to find the first occurrence, then another match
to find the next occurrence. It should be faster---it has less work
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congratulation Raj. Proud of you. Lunch for you tommorrow. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 23:12:31 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of May'2012 He has posted 147 posts in May 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job God bless you :) Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Trust me, It requires big heart to help others voluntarily and thanks to everyone who is supporting this forum. Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Lookup and return 2nd occurrance
Hello Excel Masters if I have a list if names like below in column A and say I have corresponding different figures in column B. Hilary Rajan Maries Noorain Hilary Rajan Don Kris Asa And so on and I want to return for instance the second occurance of hilary with its corresponding figure. Kindly help with formula. Thanks. Sent from my BlackBerry® smartphone from Airtel Ghana -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 31 May 2012 19:42:32 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Lookup and return 2nd occurrance Hello Excel Masters if I have a list if names like below in column A and say I have corresponding different figures in column B. Hilary Rajan Maries Noorain Hilary Rajan Don Kris Asa And so on and I want to return for instance the second occurance of hilary with its corresponding figure. Kindly help with formula. Thanks. Sent from my BlackBerry® smartphone from Airtel Ghana -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA
Why do you keep sending this ad over and over again. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: sai girish saigiris...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 May 2012 22:42:19 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA *Hi,* *This is Thomas Fedrick, - Recruitment and Resources from SancroSoft USA Inc.* We have an urgent requirement as follows: Please reply to this email with the latest copy of your resume in MS-Word Format with the following details to *tho...@sancrosoftusa.com*tho...@sancrosoftusa.com Full Name : Location : Contact Number : Email : Availability : Rate / Hour : Visa Status : *Requirement Details** :--** * *Java Developer* Work Location: Palo Alto, CA Duration: 6 months Contract (possible extension) Rate : Market We need to look for a person who is more well-rounded, with both backend (J2EE experience) and GUI experience. - JAVA, J2EE, Web services, JPA/Hibernate, Spring (higher priority) Also the candidates need to have experience in big scale development/high volume/scalability projects, and with experience with small scale development... It is a big plus if the candidate has big scale development experience. We would like someone who is primarily stronger on the Java back-end side *Thanks Regards* *Thomas Fedrick** **Recruiting Specialist IT Services* *[image: Description: Description: Description: Description: Description: Description: cid:image001.jpg@01CD14F0.B169F430] [image: Description: Description: Description: Description: Description: Description: cid:image002.jpg@01CD14F0.B169F430] * * **The power of focus* *SancroSoft USA INC* *4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628 Phone : 916-671-5559* ||* 916-671-5584 *||* Fax: 916-200-0305* *E-Mail :* *tho...@sancrosoftusa.com* tho...@sancrosoftusa.com || * www.sancrosoftusa.com* http://www.sancrosoftusa.com/ * We place professionals in contract, contract-to-hire and full-time employment positions * *across all IT and Engineering disciplines, **nationwide* Stay Connected: [image: Description: Description: Description: Description: Description: Description: cid:image003.png@01CD14F0.B169F430]http://www.linkedin.com/in/Thomasfedrick [image: Description: Description: Description: Description: Description: Description: cid:image004.png@01CD14F0.B169F430]http://www.facebook.com/people/Thomas-Fedrick/10156958548 [image: Description: Description: Description: Description: Description: Description: cid:image005.png@01CD14F0.B169F430]https://twitter.com/#%21/thomasfedrick99 For More Job Openings , Please Visit my blog [image: Description: Description: Description: Description: Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcTtrxGMSDzmqNcd78ZgJEjlJHrdvfl3wZ7N2W02bC6UwOEQJQUO]http://thomassancrosoftusa.blogspot.in/ The information contained in this email message is intended only for the personal and confidential use of the recipient(s) named above. The message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by email and delete the original message. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5)
Re: $$Excel-Macros$$ Link Check Box many times
Thanks Asa Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Asa Rossoff a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Wed, 16 May 2012 16:08:09 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Link Check Box many times Hi Hilary, You could use a character with a check box, and a Worksheet.Click event to place and remove the checks. You can use the Windows Character Map utility (charmap.exe) to browse your fonts. Unicode includes a Ballot Box character (☐), Ballot Box with Check (☑) and Ballot Box with X (☒). If you browse the Symbols and Dingbats Unicode subrange you can find these and similar symbols. You can also do the same with a symbol font, even non-Unicode, such as Wingdings. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Wednesday, May 16, 2012 7:06 AM To: excel-macros Subject: $$Excel-Macros$$ Link Check Box many times Hello Gurus, i am trying to create a call report in the format attached. i however need to replicate the format like 2000 times, i can simply drag down the format to the number of rows i want however, i need to link these check boxes to the and i dont think doing it one by one is very helpful, is there a simple way to achieve this. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Financial Analysis Dashboard
Not at all. Pls feel free to share Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ashish Pradhan ashlyprad...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 15 May 2012 13:58:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Financial Analysis Dashboard Hello Sanjib, I have managed to download the file. Will email the same to you directly to your email id. I believe the file size is more than 4mb and possibly cannot be sent through the group. I hope Hilary / Group Members / Group Admin do not have any objections to the file being sent directly to Sanjib. Thanks Ashish Pradhan On 15-05-2012 13:54, Sanjib Chatterjee wrote: The file is blocking by the antivirous for suspecting virus. regds, Sanjib On Mon, Apr 30, 2012 at 10:07 PM, hilary lomotey resp...@gmail.com mailto:resp...@gmail.com wrote: Hi Guys, i just completed my Financial Analysis Dashboard, pls have a look at it at the address below cheers http://www.sendspace.com/file/tlim30 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com -- - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Date Problem
Alright now makes meanin. Thanks Sam Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 13:00:14 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Because today is the 5th month. And the value of 5 is actually equivalent to 5 days starting from day zero. In other words, it is just the 5th of January 1900. And the month of 5th January 1900 is Jan of course. Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:33 AM, resp...@gmail.com wrote: ** Thanks for this as well Noorain. But can you explain why excel was returning Jan when I tried ♍Ɣ earlier formula? Just for ♍Ɣ information. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * NOORAIN ANSARI noorain.ans...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Tue, 8 May 2012 23:58:01 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Date Problem Another approach.. * =CHOOSE(MONTH(TODAY()),Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec) * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 11:32 PM, hilary lomotey resp...@gmail.com wrote: Hello Pls i want to get the month of today such as May but if i use this formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why am i getting Jan, when i add the text fucntion. i need it to be dynamic, thats why i want to use today -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data
Re: $$Excel-Macros$$ Date Problem
Thanks Ross Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Asa Rossoff a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 16:33:57 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Date Problem hilary, Instead of TEXT(MONTH(TODAY()),mmm), I think you were aiming for TEXT(TODAY(),mmm). You could also use =TODAY() with a cell format of mmm to have it displayed as Jan/Feb/etc. but still hold a dateserial as the underlying value of the cell. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Tuesday, May 08, 2012 1:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Because today is the 5th month. And the value of 5 is actually equivalent to 5 days starting from day zero. In other words, it is just the 5th of January 1900. And the month of 5th January 1900 is Jan of course. Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:33 AM, resp...@gmail.com wrote: Thanks for this as well Noorain. But can you explain why excel was returning Jan when I tried ♍Ɣ earlier formula? Just for ♍Ɣ information. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana _ From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 23:58:01 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Another approach.. =CHOOSE(MONTH(TODAY()),Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec) -- Thanks regards, Noorain Ansari www.noorainansari.com http://www.excelmacroworld.blogspot.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 11:32 PM, hilary lomotey resp...@gmail.com wrote: Hello Pls i want to get the month of today such as May but if i use this formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why am i getting Jan, when i add the text fucntion. i need it to be dynamic, thats why i want to use today -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
Re: $$Excel-Macros$$ Date Problem
Thanks Sam for the quick response. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 11:20:37 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Just Use =TEXT(TODAY(),mmm) Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:02 AM, hilary lomotey resp...@gmail.com wrote: Hello Pls i want to get the month of today such as May but if i use this formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why am i getting Jan, when i add the text fucntion. i need it to be dynamic, thats why i want to use today -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Date Problem
Thanks for this as well Noorain. But can you explain why excel was returning Jan when I tried ♍Ɣ earlier formula? Just for ♍Ɣ information. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 23:58:01 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Another approach.. * =CHOOSE(MONTH(TODAY()),Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec) * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 11:32 PM, hilary lomotey resp...@gmail.com wrote: Hello Pls i want to get the month of today such as May but if i use this formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why am i getting Jan, when i add the text fucntion. i need it to be dynamic, thats why i want to use today -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Congrats Raj. Proud of you Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 May 2012 21:30:32 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012 Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012 He has posted 185 posts in April 2012 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition many times. Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Creation of dashboard
Hi Deba Asa is spot on with Chandoos site. Gives very basic info wrt Dashboard. What I would like to also say is that with Dashboard creation, you have a lot of lookup situations. Index and Match function is you best Friend for this,Choose function will be your sister.Rows and Columns will be your brothers. Just study how the various lookup functions combine and work together. Study how to use data validation or combo box for the basics. Graphs shd be your roommate. No software needed. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Asa Rossoff a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Mon, 16 Apr 2012 22:59:16 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Creation of dashboard Hi Deba, Perhaps some of Chandoo's dashboard resources are of interest. He also offers online classes and seminars at various real worl locations: http://chandoo.org/wp/excel-dashboards/ Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: Monday, April 16, 2012 9:05 PM To: excel-macros@googlegroups.com Cc: hilary lomotey Subject: $$Excel-Macros$$ Re: Creation of dashboard Hi hilary, That is same what i expect, Very Thanks for that, Can you please tell me is there any software or tricks to learn all those things ? Thank you very much. !! Thanks Regards, Deba Ranjan P On Mon, Apr 16, 2012 at 7:15 PM, hilary lomotey resp...@gmail.com wrote: hi Deba The file is to big to send to group mail, but i hope this is what you want. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Creation of dashboard
Hi Deba Am currently on .BB () only so you have to go thru this process yourself. If you want the % of total billing against bal of billing to achieve then 1. In the Dashboard sheet divide cell F8 by cell G8. Give it a label and then next to it type a 100% and label that also 2. Copy the graph for the % of target achieved and paste it anywhere. 3. Select the copied graph and right click and choose select data ,It will take you to the previous data of the % of target achieved. You have to reselect the data by choosing the new figures you computed. If the graph shows you too bars, right click on the bars and choose format data series And in the seris option make the overlap a 100%. Choose No fill for the 100%. Hope this helps. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Deba Ranjan drdeva...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 17 Apr 2012 14:03:58 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Creation of dashboard *Hi Experts, Can you please create for me please. Please find the attached file, there is clearly explain which need to be added chart. thanks in advance * Thanks Regards,* * *Deba Ranjan P*** MIS - Operation On Tue, Apr 17, 2012 at 12:59 PM, Deba Ranjan drdeva...@gmail.com wrote: *Hi Experts, Can you please create for me please. Please find the attached file, there is clearly explain which need to be added chart. thanks in advance * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
Hurray Don. 76 ?wow Congrats and a very Happy birthday. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Mohammed Muneer mmun...@ccc.com.qa Sender: excel-macros@googlegroups.com Date: Sun, 15 Apr 2012 16:13:27 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett Happy Birthday Mr. Don, May God Bless you with Long Life Happy Future. At the same time enrich your knowledge with more talents. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem
Thanks really appreciate it. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Asa Rossoff a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Thu, 5 Apr 2012 11:22:28 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem Hi Hilary, You seem to already have the answer :) If you assign the following macro to your listbox, the text in the callout will be updated correctly: Sub ListBox1_Change() Dim wb As Workbook Set wb = ThisWorkbook With wb.Worksheets(Ratio) .Shapes(Rectangular Callout 1).TextFrame.Characters.Text = _ wb.Worksheets(interpretation).Cells(.Cells(1, 1).Value, 1).Value End With Set wb = Nothing End Sub Best to remove the cell link fro mthe shape, and there is now no need for the formula at interpretation!A14. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Thursday, April 05, 2012 8:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem I have seen the code he used, i think its Sub ListBox1_Change() Sheet2.Shapes(shpMyShape).TextFrame.Characters.Text = Sheet1.Range(A24) End Sub On Thu, Apr 5, 2012 at 3:20 PM, dguillett1 dguille...@gmail.com wrote: How? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajan_Verma mailto:rajanverma1...@gmail.com Sent: Thursday, April 05, 2012 8:03 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem Hi please find the attached sheet Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Apr/Thu/2012 05:21 To: excel-macros Subject: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem Good Afternoon Experts In the file attached, i am trying to achieve a situation where if i click one of the members in the list box , the interpretation of the of the word would appear in the rectangular shape box. the problem is that , i cant seem to see all the explanation in the rectangular shape box when i click the word. i tried to reduce the font but without success. is there a way to have all the explanation of the word appear in the box? thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this
Re: $$Excel-Macros$$ Re: Delivery Status Notification (Failure)
Genius and Thanks Maries exactly what I wanted Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Maries talk2mar...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 31 Mar 2012 09:13:04 To: hilary lomoteyresp...@gmail.com; excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Delivery Status Notification (Failure) HI, PFA. Regards, MARIES. On Fri, Mar 30, 2012 at 4:46 PM, hilary lomotey resp...@gmail.com wrote: Hi Maries i keep sending to group but it bounces can you help? pls how do you trim an excel sheet such as done in the attached file(screen shot). ie if you look at Menuerror legal sheet, you realise that the whole sheet is trimmed except for the portion that contains text. thanks -- Forwarded message -- From: Mail Delivery Subsystem mailer-dae...@google.com Date: Fri, Mar 30, 2012 at 12:37 PM Subject: Delivery Status Notification (Failure) To: resp...@gmail.com Hello hilary lomotey resp...@gmail.com, The message you are sending is too large. All messages must be less than 0.10 MBytes. The max size was set by the owners of this list ( excel-macros+ow...@googlegroups.com). If you have questions related to this or any other Google Group, visit the Help Center at http://groups.google.com/support/?hl=en. Thanks, Google Groups - Original message - Received: by 10.224.108.68 with SMTP id e4mr1840344qap.4.1333111060840; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Received: by 10.224.108.68 with SMTP id e4mr1840343qap.4.1333111060777; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Return-Path: resp...@gmail.com Received: from mail-qa0-f44.google.com (mail-qa0-f44.google.com [209.85.216.44]) by gmr-mx.google.com with ESMTPS id b22si3860435qcs.3.2012.03.30.05.37.40 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Received-SPF: pass (google.com: domain of resp...@gmail.com designates 209.85.216.44 as permitted sender) client-ip=209.85.216.44; Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of resp...@gmail.com designates 209.85.216.44 as permitted sender) smtp.mail=resp...@gmail.com; dkim=pass header.i=@gmail.com Received: by qadc14 with SMTP id c14so487795qad.3 for EXCEL-MACROS@googlegroups.com; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=/gXdJjbgSc4JzBp1ckRe1P8w8ULq+yrlbqSfh59wzks=; b=gxew3dU442c17UYGX5chu6Gyxi1KbvTZs8LX/8AlyQ/Z+r2ChcOSRQWUq0B+ZQr3Gq 29tR/Vp8cAsk9U6kCj83JQ4Fu9Zf56Nx5OWR6ma+DQAunx0EBEvEqY74e+UR9I9QRa4E HsO3cGigifYb05kvg5xUXNYVlC7ZfQdtqvhhJI/HtFm1S3+ChGQhzPY+eW2STOe7iI04 HSuwJZmYpOQFjjBerxYZO7z47LcTc26Ve+v/Fl/9cO1ecAVkzq7lcTyTaKZ+PLYm0c46 c2WCO2z/b3aQEMiGqdUD2ZBw8UjOoSoIg3kdGqJ0h8n5FGHNYc3MZXwRK3R0i2nxTp9e EFQA== MIME-Version: 1.0 Received: by 10.229.137.8 with SMTP id u8mr765793qct.21.1333111060634; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Received: by 10.229.50.212 with HTTP; Fri, 30 Mar 2012 05:37:33 -0700 (PDT) Date: Fri, 30 Mar 2012 12:37:33 + Message-ID: CAOeJvQituTVXzpYC82ngxWC7Q9xdTng3= zyn1pbir-rbl7p...@mail.gmail.com Subject: trimming of excel sheet From: hilary lomotey resp...@gmail.com To: excel-macros EXCEL-MACROS@googlegroups.com Content-Type: multipart/mixed; boundary=00235452e6b0371e0504bc751be4 Hi Experts pls how do you trim an excel sheet such as done in the attached file(screen shot). ie if you look at Menuerror legal sheet, you realise that the whole sheet is trimmed except for the portion that contains text. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking
Re: $$Excel-Macros$$ Excel formula help needed
Thanks Kris for the quick reply
A little bug in the formula
If you include the named range matchcol in the formula. The figures don't
update when you select another year.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris krishnak...@gmail.com
Date: Fri, 23 Mar 2012 21:50:49
To: excel-macros@googlegroups.com
Cc: resp...@gmail.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed
Hi
In B3 on Sheet1
=IFERROR(MATCH('PL
(2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2)
Define B3 '*MatchCol'*
*
*
Now in B12 and copy down across,
=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel formula help needed
Hi Kris
Kindly select start year as 2012 or 2013. You will realize that these two yrs
do not hv any data but if you select them its populates the data from 2006
onward instead of blank.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris krishnak...@gmail.com
Date: Sat, 24 Mar 2012 00:56:33
To: excel-macros@googlegroups.com
Cc: Kriskrishnak...@gmail.com; resp...@gmail.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed
PFA
Kris
On Saturday, 24 March 2012 12:51:10 UTC+5:30, Kris wrote:
It does. Set your calculation to automatic.
Kris
On Saturday, 24 March 2012 12:43:42 UTC+5:30, hilary lomotey wrote:
Thanks Kris for the quick reply
A little bug in the formula
If you include the named range matchcol in the formula. The figures don't
update when you select another year.
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From: * Kris krishnak...@gmail.com
*Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT)
*To: *excel-macros@googlegroups.com
*Cc: *resp...@gmail.com
*Subject: *Re: $$Excel-Macros$$ Excel formula help needed
Hi
In B3 on Sheet1
=IFERROR(MATCH('PL
(2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2)
Define B3 '*MatchCol'*
*
*
Now in B12 and copy down across,
=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel formula help needed
Hi Kris
Pls why is it that when you select ALL YEAR from cell H4 it seem to give a
error?
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris krishnak...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 23 Mar 2012 08:52:30
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed
OK. In B12 and copied down across,
=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MATCH($H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0)+COLUMNS($B12:B12)-1),)
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW
Its just historical stock market information for the Ghana stock exchange and major mkt indicators. But its the idea behind in tht u can picture any report you want to generate and design it along side Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Liyakath Khan liyakath1...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 9 Feb 2012 21:14:26 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW Hi bro, It was very superb, Could you please explain me basic information about same. Thanks Liyakath Ali Khan Mob:09844577212 On 2/9/12, hilary lomotey resp...@gmail.com wrote: DA I just completed a dashboard for stock market review and wanted to share it to the group,( i got a lot of inputs from this group), i have hidden the all the working sheets except for the dashboard. U can unhide to see how it was prepared. i hope you like it. i would be glad to also get other dashboard from anyone who has similar. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
Thanks boss Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 6 Feb 2012 09:50:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM See attached Don Guillett SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Monday, February 06, 2012 9:15 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ TEXT FUNCTION PROBLEM Hi Experts I am trying to have a currency symbol in front of a value anytime i select the currency as demonstrated below (file attached also), the problem is am able to achieve that however, i get so many decimal places so i tried using the text function to reduce it to two d. places, but when i insert the text formula, i dont get the symbol anymore, can anyone pls help on this , thanks 3 C. SYMBOL CURRENCY AVERAGE BUYING SELLING 2.6241 $ DOLLAR($) 1.66385 1.6467 1.681 € EURO(€) 2.17605 2.1541 2.198 £ POUND(£) 2.6241 2.5968 2.6514 GH¢ CEDI(GH¢) 1. 1. 1. POUND(£) Equivalent 200,000.00 £76216.6075987958 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
Thanks Sam.you guys are genius. VEry grateful Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 7 Feb 2012 00:40:37 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM The text can be formatted by having the space *within* the format =CHOOSE(A1,C2,C3,C4,C5)TEXT(C10/I1, 0,0.00) or using Don's suggestion =INDEX(C2:C5,MATCH(D12,D2:D5))TEXT(C13/INDEX(E2:E5,MATCH(D12,D2:D5)), 0,0.00) Regards, Sam Mathai Chacko On Mon, Feb 6, 2012 at 10:31 PM, resp...@gmail.com wrote: Thanks boss Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * dguillett1 dguille...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 6 Feb 2012 09:50:15 -0600 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM See attached Don Guillett SalesAid Software dguille...@gmail.com *From:* hilary lomotey resp...@gmail.com *Sent:* Monday, February 06, 2012 9:15 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ TEXT FUNCTION PROBLEM Hi Experts I am trying to have a currency symbol in front of a value anytime i select the currency as demonstrated below (file attached also), the problem is am able to achieve that however, i get so many decimal places so i tried using the text function to reduce it to two d. places, but when i insert the text formula, i dont get the symbol anymore, can anyone pls help on this , thanks 3 C. SYMBOL CURRENCY AVERAGE BUYING SELLING 2.6241 $ DOLLAR($) 1.66385 1.6467 1.681 € EURO(€) 2.17605 2.1541 2.198 £ POUND(£) 2.6241 2.5968 2.6514 GH¢ CEDI(GH¢) 1. 1. 1. POUND(£) Equivalent 200,000.00 £76216.6075987958 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3)
Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari
Congrats NOORAIN ANSARI Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: xlstime xlst...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:17:19 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARInoorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Congratulation Brother !! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Jan'12 He has posted 175 posts in Jan'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru , Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com noorain.jpg
