$$Excel-Macros$$ Query for Code
Notes :- The workbook will contain close to 200 individual sheets and one summary sheet. The data in the summary sheet will be given to me by individual teams and I will need to look at the summary sheet. Requirements :- ns-serif size=2 style=font-size:10pt; color=#00 Notes :- The workbook will contain close to 200 individual sheets and one summary sheet. The data in the summary sheet will be given to me by individual teams and I will need to look at the summary sheet. Requirements :- 1) User selects month of start on the summary sheet. ns-serif size=2 style=font-size:10pt; color=#00 Notes :- The workbook will contain close to 200 individual sheets and one summary sheet. The data in the summary sheet will be given to me by individual teams and I will need to look at the summary sheet. Requirements :- 1) The Data from all sheets in which the start month is same as selected by the user in the summary sheet should be added to reflect in the summary sheet. I understand that my requirement is achievable with a formula however since the workbook will contain a lot of individual sheets I am not sure if the formula will work out. please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value
its perfect! thanks a lot... :) Sent by Outlook for Android On Mon, Jul 27, 2015 at 5:02 AM -0700, ashish koul koul.ash...@gmail.com wrote: use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote: Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell k2. What I want is to run the code only once when a user selects “yes” and once when the user selects “no”, how can I code to terminate the process after the first run. Also I realized that the code runs if I change any cell on the sheet and not just K2 , how can this be fixed ? Codes below :- Private Sub Worksheet_Change(ByVal Target As Range) If (Range(k2) = Yes) Then Call inthousand End If End Sub Sub inthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell * 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub Sub notinthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell / 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any
Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Cells.Count = 1 Then If Target.Address = $K$2 Then ' ADD UR CODE HERE End If End If Application.EnableEvents = True End Sub On Mon, Jul 27, 2015 at 5:54 PM, garge...@hotmail.com wrote: Hello, i just realized that it also runs the code when i change some other cell on the sheet e.g i use some other validation on the sheet or calculate something elsewhere , why would that happen. i want it to run the code only when cell k2 is changed to a yes or no. thanks again. Sent by Outlook http://taps.io/outlookmobile for Android On Mon, Jul 27, 2015 at 5:13 AM -0700, garge...@hotmail.com wrote: its perfect! thanks a lot... :) Sent by Outlook http://taps.io/outlookmobile for Android On Mon, Jul 27, 2015 at 5:02 AM -0700, ashish koul koul.ash...@gmail.com wrote: use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote: Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell k2. What I want is to run the code only once when a user selects “yes” and once when the user selects “no”, how can I code to terminate the process after the first run. Also I realized that the code runs if I change any cell on the sheet and not just K2 , how can this be fixed ? Codes below :- Private Sub Worksheet_Change(ByVal Target As Range) If (Range(k2) = Yes) Then Call inthousand End If End Sub Sub inthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell * 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub Sub notinthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell / 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit
Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value
absolutely perfect now. thanks a lot. :) :) Sent by Outlook for Android On Mon, Jul 27, 2015 at 5:27 AM -0700, ashish koul koul.ash...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Cells.Count = 1 Then If Target.Address = $K$2 Then ' ADD UR CODE HERE End If End If Application.EnableEvents = True End Sub On Mon, Jul 27, 2015 at 5:54 PM, garge...@hotmail.com wrote: Hello, i just realized that it also runs the code when i change some other cell on the sheet e.g i use some other validation on the sheet or calculate something elsewhere , why would that happen. i want it to run the code only when cell k2 is changed to a yes or no. thanks again. Sent by Outlook http://taps.io/outlookmobile for Android On Mon, Jul 27, 2015 at 5:13 AM -0700, garge...@hotmail.com wrote: its perfect! thanks a lot... :) Sent by Outlook http://taps.io/outlookmobile for Android On Mon, Jul 27, 2015 at 5:02 AM -0700, ashish koul koul.ash...@gmail.com wrote: use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote: Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell k2. What I want is to run the code only once when a user selects “yes” and once when the user selects “no”, how can I code to terminate the process after the first run. Also I realized that the code runs if I change any cell on the sheet and not just K2 , how can this be fixed ? Codes below :- Private Sub Worksheet_Change(ByVal Target As Range) If (Range(k2) = Yes) Then Call inthousand End If End Sub Sub inthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell * 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub Sub notinthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell / 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to
Re: $$Excel-Macros$$ Find string, copy, paste
Thank you, Jayaraju.M! Your code works great! Thank you again, I appreciate you help. The Best, MikeB On Sunday, July 26, 2015 at 3:09:44 AM UTC-5, Jayaraju Metta wrote: Hi Mike, Below is the code to find string and paste it into desired cell. Please find the attached excel file. 'Code was written by Jayaraju Metta Sub matchsting() i = 1 While (ThisWorkbook.Sheets(Sheet1).Cells(i, 1).Value ) ColoumnAstring = Left(Trim(Sheets(Sheet1).Cells(i, 1).Value), 5) ColomnCstring = Left(Trim(Sheets(Sheet4).Cells(i, 3).Value), 5) If ColoumnAstring = ColomnCstring Then Sheets(Sheet1).Cells(i, 2).Clear Sheets(Sheet1).Cells(i, 2).Value = Sheets(Sheet4).Cells(i, 3).Value ActiveSheet.Columns.AutoFit Else Sheets(Sheet1).Cells(i, 2).Clear Sheets(Sheet1).Cells(i, 2).Interior.Color = 255,0,0 End If i = i + 1 Wend MsgBox (Done Successfully) ThisWorkbook.Save ThisWorkbook.Worksheets(Sheet1).Activate End Sub On Sat, Jul 25, 2015 at 8:27 AM, Mike B mike...@gmail.com javascript: wrote: I would appreciate any help with the following. I have a column A of data containing shortened names in sheet 1 and another column C containing the same names but in a much longer version on sheet 4; I was thinking that perhaps I could somehow use the first five characters of the short name in column A of sheet 1 to find the first five characters in column C sheet 4 of the longer names and copy the longer names and paste them in column B of sheet 1. Does anyone know if this can be done? I am new to VBA and struggling with how to go about it if it is possible and to what code to use. Thank you for any help. MikeB -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards, Jayaraju.M +91-9492162134 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Direct Client in Austin ,TX-Business Analyst(Healthcare ) --LOCALS PREFERED
Hi Partner, Please send resume to ma...@genuineitllc.com *Title : Business Analyst* *Location : Austin , TX—LOCALS * *Minimum Requirements:* Years Skills/Experience 8 Experience in Information Technology (IT) within the *Healthcare* business domain. 7 Experience as a business analyst for a large software development or data warehousing project. 5 Hands-on experience in business/systems analysis in the technology industry, including writing requirements documents. 5 Demonstrated ability to work on complex business problems, analyzing and evaluating current business methods and procedures for improvements. 5 Experience visualizing, diagramming and explaining As-Is / To-Be business process flows. 3 Experience with reengineering workflow and data management processes to maximize efficiency. 3 Proficient with data modeling and business process mapping tools (e.g., ERwin, Visio). 3 Demonstrated ability to act in a consultative role to understand functional business processes, related IT needs and to develop solutions and delivery proposals. 3 Proven ability to work successfully with technical and non-technical groups, and manage multiple responsibilities. Strong Excellent analytical and problem-solving skills. Strong Technical writing skills. Strong Excellent oral and written communication skills. Strong Good team-playing skills. Degree or Equivalent Bachelor’s degree in Computer Science, Information Systems, Business, or equivalent experience. 3 Experience working with Texas *MMIS* data. 3 Experience with Master Data Management and Metadata Management. 3 Experience as a Business Analyst for an enterprise data warehousing project. 3 Experience working with the complete project management lifecycle (PMLC). 3 Experience working with the full system development lifecycle (SDLC). 2 Experience facilitating productive meetings to formulate business requirements and translate client needs into actionable system requirements. 2 Demonstrated ability to conduct data and/or requirements gathering meetings – adherence to meeting agenda, documentation of meeting outcomes, and the ability to drive to closure Action items --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as Spam as we have included the contact information. If you wish to be removed from our mailing list, please respond with remove in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value
use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote: Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell k2. What I want is to run the code only once when a user selects “yes” and once when the user selects “no”, how can I code to terminate the process after the first run. Also I realized that the code runs if I change any cell on the sheet and not just K2 , how can this be fixed ? Codes below :- Private Sub Worksheet_Change(ByVal Target As Range) If (Range(k2) = Yes) Then Call inthousand End If End Sub Sub inthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell * 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub Sub notinthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell / 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Direct client in Austin, TX-- Project Manager---LOCALS PREFERED
Hi Partner, Please send resume to ma...@genuineitllc.com *Title : Project Manager* *Location : Austin, TX---LOCALS PREFERED* Years Skills/Experience 4 Applying queuing theory to business processes 4 Conducting business process improvement projects 3 Executive Decision Support 3 Data Analysis and Reporting --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as Spam as we have included the contact information. If you wish to be removed from our mailing list, please respond with remove in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value
Hello, i just realized that it also runs the code when i change some other cell on the sheet e.g i use some other validation on the sheet or calculate something elsewhere , why would that happen. i want it to run the code only when cell k2 is changed to a yes or no. thanks again. Sent by Outlook for Android On Mon, Jul 27, 2015 at 5:13 AM -0700, garge...@hotmail.com wrote: its perfect! thanks a lot... :) Sent by Outlook for Android On Mon, Jul 27, 2015 at 5:02 AM -0700, ashish koul koul.ash...@gmail.com wrote: use application.enableevents = false at the beginning and application.enableevents = true at end On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote: Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell k2. What I want is to run the code only once when a user selects “yes” and once when the user selects “no”, how can I code to terminate the process after the first run. Also I realized that the code runs if I change any cell on the sheet and not just K2 , how can this be fixed ? Codes below :- Private Sub Worksheet_Change(ByVal Target As Range) If (Range(k2) = Yes) Then Call inthousand End If End Sub Sub inthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell * 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub Sub notinthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell / 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't
Re: $$Excel-Macros$$ FIFO UDF not working
I think you need to work through some of your logic and techniques. First of all, I'd recommend using Option Explicit at the first of all code modules.This ensures that all variables are declared.(you can set this as default using Tools-Options and select Require Variable Declaration) With this option selected, you would have noticed that: Set Start_Cost = Range(Inventory_Unit_Cost) Set Start_Product = Range(Inventory_Products_Cost) is treating Inventory_Unit_Cost and Inventory_Products_Cost as variables.VBA initializes them as ,so your code results in:Set Start_Cost = Range() Set Start_Product = Range() which isn't what you're looking for. Using Option Explicit, VBA would inform you that these variables had not been declared and you would recognize that you need the quotes()Set Start_Cost = Range(Inventory_Unit_Cost) Set Start_Product = Range(Inventory_Products_Cost) Secondly:Product_Code is being passed to the function and converted to a String.from: Function FIFO(Product_Code As String Now, in:If Product_Code = Start_Product(Counter, 1) Then you're comparing Product_Code to the value in a cell.First of all, you're comparing the product code 1001 to the values in the COST?In the first loop, you're checking if 1001 = 536 Even if you were to check the product code to the values in the Product_Code column, you'd run into trouble.Simply because the product codes are numeric.so you're testing a string value against a numeric value: 1001 = 1001 is FALSE. to convert both values to strings, I often concatenate a x to the end of both: if (Product_Code X = Start_Product(Counter, 1).Value X) then Do you use breakpoints and step through your code when debugging? If not, you really ought to learn how.it is AMAZING for looking at run-time values as you step through your code to see what each line is doing! Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Shakeel Dhanani dhanan...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Saturday, July 25, 2015 4:49 AM Subject: $$Excel-Macros$$ FIFO UDF not working Dear All, Please help, i m trying to make FIFO Inventory Valuation UDF which is not working -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Code Loops indefiniely due to cell value
Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell k2. What I want is to run the code only once when a user selects “yes” and once when the user selects “no”, how can I code to terminate the process after the first run. Also I realized that the code runs if I change any cell on the sheet and not just K2 , how can this be fixed ? Codes below :- Private Sub Worksheet_Change(ByVal Target As Range) If (Range(k2) = Yes) Then Call inthousand End If End Sub Sub inthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell * 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub Sub notinthousand() Range(G17:W23).Select Dim cell As Range For Each cell In Selection cell = cell / 1000 Next Selection.NumberFormat = #,##0.00 ;[Red](#,##0.00) End Sub please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Query for Code
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the
column for May 1, 2016 on the Summary sheet (column G) will be populated?and
it will be a sum of all sheets in which the first column matches the date
selected?In your example, even though sheets A and C have a column for May 1,
2016, they won't be included in the total because it isn't in column C?
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: gargee singh garge...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Monday, July 27, 2015 8:01 AM
Subject: $$Excel-Macros$$ Query for Code
!--#yiv5268623891 .yiv5268623891hmmessage
P{margin:0px;padding:0px;}#yiv5268623891
body.yiv5268623891hmmessage{font-size:12pt;font-family:Calibri;}--
Notes :- The workbook will contain close to 200 individual sheets andone
summary sheet. The data in the summary sheet will be given to me by
individualteams and I will need to look at the summary sheet. Requirements
:- 1) User selects month of start on the summarysheet. 2) The Data
from all sheets in which the startmonth is same as selected by the user in the
summary sheet should be added toreflect in the summary sheet. I understand
that my requirement is achievable with aformula however since the workbook will
contain a lot of individual sheets I amnot sure if the formula will work out.
please help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client in Houston, TX need Cloud Architect
Hi Partner, Please send resume to ma...@genuineitllc.com *Title :Cloud Specialist * *Location :Houston TX* *Job Description:-* This is a “Hands On” role and will be a combination of *SysOps and DevOps practices.* The ideal candidate will have past experience working as a *systems engineer* and have a strong understanding of large scale computing solutions, software development and DevOps . You will enjoy keeping your existing technical skills honed and developing new ones, so you can make strong contributions to architecture and governance discussions. *Qualifications *• 3+ years deploying *Amazon Web Services (AWS)* public cloud infrastructures and a deep understanding of “Infrastructure as Code” • Experience in at least one of the following *: Java, .NET, Node.js, PHP, Python, Ruby, Powershell* • Demonstrated proficiency in systems administration (Linux/Windows), network administration (DNS, IPsec, BGP, VPN, Load Balancing) • Familiarity with Chef/Puppet and / or DevOps background • Technical degree required; Computer Science or Math background highly desired • Excellent oral and written communication skills • Customer service experience / strong customer focus • Familiarity of software development tools and methodologies • Strong multitasking skills • Support / Troubleshooting experience • Self-starter who is excited about technology --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as Spam as we have included the contact information. If you wish to be removed from our mailing list, please respond with remove in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent need QA Test Lead with UFT ALM needed (3 positions) - Colorado Springs CO
Hi All, Please send me resume to ma...@genuineitllc.com *Title :QA Test Lead (UFT, ALM)* *Location: Colorado Springs CO* *Duration: 6 months* Interview: 1st interview –Technical Interview – Phone 2nd interview – Client Phone interview 3rd interview – Client CISCO WEBEX interview *Test lead* Experience Required: *Strong Experience with HP ALM UFT* Maintain Test Plan documentation templates Maintain documentation on testing and QA strategy Writing test plans, implementing, and monitoring status (Jira experience preferred) *Extensively used automated test tools like Win ALM UFT for Functional and Regression Testing.* *Strong Experience in Using of UFT Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.).* Experience in executing SQL queries in order to view successful transactions of data and for validating data Hands on experience in preparing Test plans, Test cases, Automated Tests and Test Data. And executing the same Test Case Versioning and Migration ü Prep migration of all test cases for each release ü Regression testing ? migrating test cases from older releases and modifying them with any changes being made Test Case Automation of internal IT test cases (strong SQL required) ü Inserting new test cases ü Updating existing test cases ü Modifying stored procedures used to run test cases to enhance it for new functionality UAT ü Writing test plans - Determine what, how, and when ü Tracking results ü Coding scripts to run with the power users to get sign-off of the warehouse (strong SQL required) --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as Spam as we have included the contact information. If you wish to be removed from our mailing list, please respond with remove in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent need Hyperion --Dallas ,TX
Hi All, Please send resume to ma...@genuineitllc.com *Title : Hyperion * *location :Denton, TX * *Duration : 12 months* Denton is in the Dallas area.. JD:- Client confidential .but here are some details: · Hyperion DRM resource and cash Management. · eBTax a plus. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as Spam as we have included the contact information. If you wish to be removed from our mailing list, please respond with remove in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Require formula to find the count targeted till date
Hi All We have planned some execution of test cases daily. I would like to have the test conditions planned till date in a cell. For example in the attached sheet for reference we have dates from D2:V2 and corresponding test cases planned under each date for Sub process. Now if we take today date as 7/30/2015 for subarea (APA in cell b3) the planned conditions till date is 38 (i.e. D2+E2+F2+G2) I would like to have the this data automatically reflected in C2 cell. Can any one help me with a formula macros for the same Regards Raghu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Client in New York need SAP IT Banking Specialist with banking, FI, XML, interfaces, abap
Hi Partner, Please send resume to ma...@genuineitllc.com *Title: **SAP IT Banking Specialist* *Duration: **6 months * *Location: New York * *Rates: *Open, but send me only qualified resumes. Good communications skills *PURPOSE OF THE POSITION* Under the general guidance and supervision of ITSS, and in close coordination with the Banks Project Manager, the incumbent is expected to accelerate the implementation of the XML Bank Payments, and MT940 statement process to new banks. Work on this project is progressing with many client bank accounts. Consultant will also need to provide technical solutions to various issues that may arise from additional expansion to new banks. The consultant should be able to drive rapid implementation of additional bank accounts through technical expertise and process improvement. *Major Duties and Responsibilities* ü Configure/Setup SAP in order to accept incoming Bank statement in MT940 format for UBS, NORDEA, ECO, Standard Bank South Africa, Barclays via SWIFT Interfaces. Using either FIN and/or FILEACT formats. ü Configure SAP for electronic bank statement upload of the file sent by UBS, NORDEA, ECO, Standard Bank South Africa, Barclays in XML format. The XML Version being used in DMEE is XML (ISO 20022) Payment File for Credit Transfer Initiation (pain.001.001.03). ü Coordinate and review Technical specifications and interface specifications, including country specific requirements, with the client’s Banks and their specialists, Perform and coordinate regression and new interfaces testing with banks on both outbound and inbound interfaces. ü Provide support for the existing interfaces for SCB (in both Host to Host as well as via SWIFT), Citi bank and JPMC via SWIFT. ü Provide support for enhancements to existing Payment interfaces as well as support extending the interfaces for new Payment methods such as Check Payments as per Business requirements as negotiated with the Banks. ü Provide expert level advice/impact analysis and best practices for any new interface initiatives on both outbound Payments as well as inbound electronic Bank Statements being undertaken by client with their banking partners. ü Prepare functional specification of the selected solutions. Review and validate functional specifications with other team members to ensure business requirements are well articulated. ü Produce high quality and on-time implementation plan using a Solution Manager methodology. ü Work closely with other functional/process team members in IT, staff from Cashier (primarily), Treasury and Payroll to insure that all country specific requirements, including any master data requirements, are clearly known and integrated into the testing processes. ü Prepare technical specification if solution(s) needing development (such as User Exits) is proposed. ü Prepare report specifications for data analysis and control purposes as needed. ü Testing for all identified countries using their respective House Banks must be completed within agreed to deadline. ü Provide clear written documentation on proposed solutions. ü Provide post go-live support as well as necessary documentation to facilitate post go-live support can be provided by IT Staff on an on-going basis. ü Provide knowledge transfer and training to client staff as needed. ü Conduct unit and integration testing as a part of the broader project team effort. ü Produce high quality and on-time project deliverables. *Education Qualification: * *Required:* Advanced University degree in Computer Science, or Information Systems Management or related field required. Extensive knowledge and/or certification with SAP in either of the following SAP modules, ie; Accounting, Finance, Treasury, and related controlling models. *Asset:* ERP systems /development systems certification is helpful. *Work Experience:* *Required:* A minimum of eight (8) years of hands-on work experience in programming, maintaining SAP applications using ABAP and/or ABAP Objects, in developing Custom enhancements and reports. Experience in understanding the identified gaps and provide solution(s), translate it to technical efforts and estimate the work slate for the same. Experience in writing technical specifications. Practical experience in business process analysis and user requirements gathering, business process modelling and documentation. *Asset:* Experience in leading team of developers, conducting code reviews, and ensuring quality of development. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed
$$Excel-Macros$$ Urgent need in Montgomery, AL--SQL Server Developer / DBA with data conversion experience
Hi Partner, Please send resume to ma...@genuineitllc.com *Job Title: - SQL Server Developer / DBA with data conversion experience* *Location: - Montgomery, AL* *Duration: - 24 Months plus* ROLE: Data Conversion Consultant RESPONSIBILITIES: - Guiding the overall project in the data conversion process. - Mapping legacy client data to the new DPAS data schema that will be completed during project design. *EXPECTED DELIVERABLES:* The job entails executing batch programs to import data from staging tables into DPAS. Leading meetings with technical teams and possible business users will be a required part of the position. Familiarity with Database Design principles will assist the conversion lead in a successful conversion process. Conversion Lead will be responsible for the construction and delivery of the data conversion plan as well as creation and execution of batch ETL programs. REQUIRED SKILLS: • Strong knowledge of relational database design principles • 3-5 Years with MS SQL Server Development T-SQL and/or Administration • Strong oral and written communication skills required • Ability to present and demonstrate subject matter expertise in group settings • Knowledge of System Development Life Cycle processes *• Experience using and/or designing Public Pension System software either as a user or project team member.* • Experience with Microsoft SharePoint, Team Foundation Server or other ALM technologies • Experience as a consultant or participant in eliciting functional requirements, creating and reviewing design documents, and building or executing test plans. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as Spam as we have included the contact information. If you wish to be removed from our mailing list, please respond with remove in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
RE: $$Excel-Macros$$ Query for Code
Dear Paul, Good morning and Thank you for the reply. I will try and explain this in a better way. If a user selects May -16 as the month of start in summary sheet (Cell E) all columns from column G onwards will be updated in the summary sheet. the value updated will be a sum of values from all sheets where the first column is May-16 , so in this example the values of sheet B and sheet D will be added for each service type and updated in the summary sheet. Likewise for other months . to give you a background each individual sheet is a new office along with its start month, in the summary sheet we want to see total of all centres based on the month of selection which is a respective start date. You can also suggest if there is a better way to do this. Hope this helps. Thanks and Regards, Gargee Singh Date: Mon, 27 Jul 2015 14:12:27 + From: schreiner_p...@att.net To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Code So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the column for May 1, 2016 on the Summary sheet (column G) will be populated?and it will be a sum of all sheets in which the first column matches the date selected?In your example, even though sheets A and C have a column for May 1, 2016, they won't be included in the total because it isn't in column C? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: gargee singh garge...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, July 27, 2015 8:01 AM Subject: $$Excel-Macros$$ Query for Code Notes :- The workbook will contain close to 200 individual sheets and one summary sheet. The data in the summary sheet will be given to me by individual teams and I will need to look at the summary sheet. Requirements :- 1) User selects month of start on the summary sheet. 2) The Data from all sheets in which the start month is same as selected by the user in the summary sheet should be added to reflect in the summary sheet. I understand that my requirement is achievable with a formula however since the workbook will contain a lot of individual sheets I am not sure if the formula will work out. please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message 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
$$Excel-Macros$$ Re: Match function problem
check this out Public Sub test() Dim dt As Variant dt = Sheets(1).Cells(3, 4) MsgBox dt A = Application.Match(dt, Range(B2:EP2), 0) MsgBox (A) End Sub Regards, Mandeep Baluja On Sunday, July 26, 2015 at 5:00:04 PM UTC+5:30, Mohamed Elamrani wrote: Sorry for bothering you i'm new in VBA I am trying to use the MATCH function in VBA to search for a particular hour in a range containing hours and return the matching column number that give me Error N°13 so thank you for your help Public Sub test() With Sheets(F. Regulation) Dim dt As Double dt = Sheets(Standard d'engagement).Cells(3, 4) A = Application.Match(CLng(dt), Range(B2:EP2), 0) MsgBox (A) End With End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
