$$Excel-Macros$$ Required formula for 52 week high & low as per attach sheet
Dear Sir Please find the attachment and provide solution as per requirement mentioned. Regards -- *Rajesh Kumar Agarwal* *9811063001* -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. required formula for 52 week high & low.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Required Macro
Thank you sooo much Mandeep :) You are really the best :) thanks again On Wed, Jan 20, 2016 at 11:13 AM, Mandeep Baluja wrote: > PFA !! > > Regards, > Mandeep baluja > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Putta -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: add date instantly when there is update in worksheet
Hi Mandeep, I've already got the database in the worksheet1. User can add data in row or column after the available data on current worksheet. When user add data in either row or column, I want it to automatically write the word 'new' in A column and compare worksheet1 with worksheet2 and add the new added row or column in worksheet1 to worksheet2 and show the date at the left side (eg. Column A) in worksheet2 as well. On Wednesday, 20 January 2016 13:14:26 UTC+8, Mandeep Baluja wrote: > > Use the worksheet event to trigger, It depends on you where you want to >> place date. >> > > Private Sub Worksheet_Change(ByVal Target As Range) > 'Application.EnableEvents = False > Range("E1").Value = Date > 'Application.EnableEvents = True > End Sub > > > Regards, > Mandeep baluja > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Required Macro
PFA !! Regards, Mandeep baluja -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. BasicTxlsm.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Having trouble with INDEX and INDIRECT
> > Hey, > The Error you are getting is just because the defined array is not Correct in INDEX,Let me Explain it to you Why !! Indirect Syntax is =INDEX(Array,Rownum,Column) For example you want to go two rows down and 2 columns wide then formula would be = index(A1:D10,2rows down,3columns to right) Here the value of L9 = 3 which is column which means 3 columns to right*(Which is not defined in Array)* from starting and M9 = 1 Which is the row *Change your array to :- $A$64:$D$501 * *Regards, * *Mandeep baluja * -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: add date instantly when there is update in worksheet
> > Use the worksheet event to trigger, It depends on you where you want to > place date. > Private Sub Worksheet_Change(ByVal Target As Range) 'Application.EnableEvents = False Range("E1").Value = Date 'Application.EnableEvents = True End Sub Regards, Mandeep baluja -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Required Macro
Hi Experts, Please help me solve this problem through VBA Macro. Problem Statement In the Input sheet some names of the employees will be populated in column A as shown below. The rows in which data will be available is uncertain. Provide the output in Output sheet in column A. First row should contain number of names, second row should contain number of unique name and third onwards list all the unique names in Descending order. Blank and white characters(example space,tab,etc) values to be eliminated from the output The macro should read input from Input tab and write the output in Output tab -- Putta -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Basic VBA Assignment1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ add date instantly when there is update in worksheet
Hi all, I was wondering how to have the date being added automatically when there is new update in the worksheet either by column or by row. Cheers -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Reminer -- Prompt / Ask the value & then calculate value
Hello Friends Any solution for my query . Is this possible ?? Then please take some time to resolve my query. Thanks & have a nice day ... Respected Friends Information --- >> This is sample file for the premium calcualtion as per Age & sum Insured If any body age is more then 70 then I have to write in Cell -- G26 For example age is 72 I have written in G26 -- Age 72 But the premium calculates only if I mention E26 as 70 Otherwise the premium comes false Query --- >> 1] If I write anything in G26 -- above 71 then automatically in E26 -- 70 comes 2] If I write nothing in G26 -- then it should allow any value in E26 3] I should prompt or ask -- in I26 ---no claim discount coulmn it should ask to put the value in I26 -- any value -- then it allow to caluculate the exact premium This is to do because if I not prompt then I will give discount to all as per last record But discount is based on some criteria -- Claim -- Age & Sum Insured Thank you -- 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 https://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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. MEDICLAIM NI PREM CALCULATION - SAMPLE.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Client in Houston TX need Tableau SME
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Position: Tableau SME* *Location: Spring (north of Houston), TX* *Job Type: Contract (3-6 months)* *Description: * Acts as a technical lead on projects. Responsible for solving highly technical and complex problems on multiple projects. Role of Subject Matter Expert for Tableau service *Qualifications:* v Minimum 2-3 years visualization design experience including dashboards or front-end visualizations v Minimum 2-3 years of design or development experience with Tableau v Preferred Tableau certified - Tableau Desktop Qualified Associate or Tableau Desktop Certified Professional Minimum 1 year Data Technology experience with Business Intelligence (BI) tools, methodologies, and/or responsibilities (ex, ETL, BI Reporting, etc.) v Provides guidance and Knowledge transfer to technical team members. v Be a team player in a dynamic, global team environment. v Strong communication skills (written and verbal) v Lead business requirements gathering for visualizations with business teams v Preferably has major oil company experience or large enterprise experience. ExxonMobil experience is preferred. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… 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 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. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client need VOIP Systems Engineer in Chevy Chase , MD
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :VOIP Systems Engineer* *Location :Chevy Chase , MD* Hands on knowledge of *Cisco Unified Contact Center Enterprise (UCCE), * *JD:-* Telecommunications Team is seeking a highly motivated and organized VOIP Systems Engineer with a minimum of 4 years of hands on experience with Client/Server application and infrastructure implementation and support. The VOIP Systems Engineer position will require strong technical leadership to drive large scale systems deployments throughout the organization. *Core Responsibilities include but are not limited to:* · Design, development, implementation and maintenance of VoIP telephony initiatives for Clients contact centers and back office. · Experience with VoIP deployments, including understanding the entire call flow for an enterprise and appreciates "big picture " when designing scripting solutions. · Provide technical leadership and relevant strategic direction. · Interface with business customer and peer IT teams to develop and analyze requirements and solution/system delivery. · Develop process and procedures for implementation and operational support of systems. · Project management and oversight; perform risk evaluation, issue management, etc. · 24x7 production support and technical support to team and customers. · Minimum 3 years of related experience in Collaboration technologies are *Required Skills/ years of experience needed:* · Hands on scripting experience Cisco tool set including UCCE, *Call Manager and CVP* · Hands on knowledge of Cisco Unified Contact Center Enterprise ( *UCCE*) and Unified Communications Manager (*UCM*). · Understanding and experience implementing, operating, configuring and troubleshooting a converged IP network. · Effective verbal and written communication skills in order to communicate with all levels of associates and management teams. · Proven experience in end to end problem determination/troubleshooting system issues. · Proven Project Management Experience working on large complicated plan items · Ability to drive to achieve goals with limited supervision · Good technical foundation in networking is required, ideally *CCNP or above* *Desired Skills:* · Understanding of SDLC and CMMI concepts · Proven experience in end-to-end problem determination/troubleshooting system issues · Familiarity with SIP integration techniques - carrier, cross systems, etc. · Proficient in MS Office product set: MS Word, Excel, power point, Visio, Project · Experience in systems and business analysis · Experience with data extraction tools (SQL, etc.) · knowledge in other technologies/products, experience and certifications are a preferred --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… 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 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. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client in Chevy Chase, MD need SOA Architect(.Net) role-Preferred LOCALS
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :Application Architect* *Location: Chevy Chase, MD* *Duration: 6+ months* *Notes: Looking for 30% architect + 70% hands on developer* *Prefer consultant from DC metro area or near by.* *Job Description* - Experience designing enterprise applications with enterprise workflow and business process integration. - *Experience designing applications with service oriented architecture (SOA).* - Strong communication using both business and technical terms. - Ensure software and system architecture are in synchronization. - Act as the emissary of the architecture. - Confirm the appropriate modeling is being done, to ensure qualities, like performance, are going to be met. - Provide input to tool and environment selection. - Identify and interact with stakeholders to ensure their needs are being met. - Make certain that the architecture is not only the right one for operations, but also for deployment and sustainment. - Resolve technical problems. - Perform advanced-level application design and development activities, under minimal direction. - Diagnose and correct both application and infrastructure issues. - Experience designing enterprise applications with enterprise *workflow* and business process integration. - Experience designing applications with service oriented architecture (SOA). - Strong communication using both business and technical terms. - Ensure software and system architecture are in synchronization. - *Act as the emissary of the architecture.* - Confirm the appropriate modeling is being done, to ensure qualities, like performance, are going to be met. - Provide input to tool and environment selection. - Identify and interact with stakeholders to ensure their needs are being met. - Make certain that the architecture is not only the right one for operations, but also for deployment and sustainment. - Resolve technical problems. - Perform advanced-level application design and development activities, under minimal direction. - Diagnose and correct both application and infrastructure issues. - Manage application security vulnerabilities and maintain compliance with industry security standards. - Research and evaluate new software, frameworks and techniques to provide recommendations to the division and training to developers. · Document and maintain technical specifications. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… 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 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. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client in Houston TX need Senior .Net Application Developer--- locals ONLY
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Senior .Net Application Developer* *Location: Houston, TX* *Duration: 12+ months* *In person interview required so please send locals ONLY * *Description of the work to be performed:* The US Operations Applications area within the client IT is looking for one Application Developer to continue the development and support of their in-house developed applications and COTS Solutions which support the client’s Gas Transmission Operations. The candidate should be proficient in .NET Development, C#, VB.NET, ASP.NET, Microsoft Visual Studio 2012, SQL Server technologies (SSRS, SSIS, and SQL Server), Microsoft Team Foundation Server, and Oracle. *It is critical that the candidate possess strong communication and business analyst skills, allowing them to successfully work with team members and internal customer groups. Additionally, the candidate must be willing to learn and support COTS Solutions.* *Requirements* · Experience in designing and developing Windows applications, web applications, and web services. · *Experience in supporting and configuring COTS solutions. * · Full Life Cycle (SDLC) Microsoft .NET application design and development experience. · Analyzing business requirements, recommending technical solutions and writing technical specifications. · Degree in Computer Science, Management Information Systems, Business or other related computer fields. · Strong written and oral communication skills. · Ability to achieve goals and meet deadlines while working on multiple tasks. · Proficient in .NET Development, C#, VB.NET, and ASP.NET. · Proficient in SQL, SQL Server, SQL Server technologies including (SSRS and SSIS) and Oracle. *Competencies* Competency / Experience Desired Level Of Importance: *Required* *Desired* Level of Skill: *Strong* *Intermediate* *Entry Level* 1. C#, VB.NET / VB.NET for Windows, ASP.NET Development R S 1. Oracle R I 1. Webservices, WCF and Windows Service D I 1. N-Tier Development Experience R S 1. SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server R S 1. Strong verbal and written communication skills R S 1. Oracle R S --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… 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 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. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client in Bethpage, NY need WebLogic/JBoss Admin C2H role
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : WebLogic/JBoss Admin * *Location: Bethpage, NY* *Duration: 6 months Contract to hire- Will sponsor H1B* *Skype/Telephone Interview * Strong knowledge of UNIX operating systems (HP-UX, Sun/Solaris, AIX, Linux) ü *Experience with Apache, iPlanet Webserver & Weblogic, JBOSS* ü Experience providing Weblogic systems administration support in both a development and production environments ü Knowledge of web and application server performance analysis, capacity planning and security practices ü Excellent verbal & written communication skills ü Ability to work effectively with minimal supervision both individually and in a team setting ü Daily maintenance of systems including monitoring system operations, performance tuning, applying necessary system patches and resolving user problems. ü Set up and configure new web and application server instances and operating environments ü Provide support for overnight production application code deployments ü Provide periodic on call support for production application issues ü Provide support for annual disaster recovery testing practice ü *Perform R&D activities* independently or in a team setting as required ü Create and maintain *shell scripts to* automate various tasks ü Maintain support for jobs and applications as required ü Maintain system backup & recovery procedures ü Understanding of middleware software technologies and architectures and new technology trends --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… 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 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. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ edges swapped problem
this is my small code I want some help .. in this sheet I have some input about userid,subjectid,rowid, that the output is source ,target,label..it hepled me to find the combinations of two users ...but it's give me the swapped too..how can I fixed it any idea plz...!! -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. data.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Having trouble with INDEX and INDIRECT
Hello, I've struggled with building a INDEX formula that would reference dynamic file names and tabs which I'm hoping that someone can help with. I'm building a file that would consolidate hours entered into a schedule by a shop. Each week I would define which week from which I would pull the hours and use that value to look up the same named tab. Here are two example files: https://www.dropbox.com/sh/w97qm7rv6nffttb/AAD7M23do2rotEko8I6YBxfGa?dl=0 1 - planning: schedule used by shop 2 - consol: the file i'll use each week to consolidate the hours. I've attempted the INDEX formula using the dynamic INDIRECT variables but I keep getting a REF! error - [=INDEX((INDIRECT("'["&$B$2&"]"&$B$3&"'!"&"$A$64:$A$501")),M9,L9)&""]. See cell H9 in consol file. If I use a regular INDEX formula the value is returned correctly [=INDEX('[PLANNING.xlsb]43'!$A$64:$AX$501,M9,L9)] so there must be something wrong with what I've attempted. See cell H6 in consol file. What's odd is that my formula does work when it references other cells in the range so I looked at the cell and the only thing I can think of is that the cell with the error has conditional formatting? Would this trigger it? Thanks in advance for your help! Dza -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Prompt / Ask the value & then calculate value
Respected Friends Information --- >> This is sample file for the premium calcualtion as per Age & sum Insured If any body age is more then 70 then I have to write in Cell -- G26 For example age is 72 I have written in G26 -- Age 72 But the premium calculates only if I mention E26 as 70 Otherwise the premium comes false Query --- >> 1] If I write anything in G26 -- above 71 then automatically in E26 -- 70 comes 2] If I write nothing in G26 -- then it should allow any value in E26 3] I should prompt or ask -- in I26 ---no claim discount coulmn it should ask to put the value in I26 -- any value -- then it allow to caluculate the exact premium This is to do because if I not prompt then I will give discount to all as per last record But discount is based on some criteria -- Claim -- Age & Sum Insured Thank you -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. MEDICLAIM NI PREM CALCULATION - SAMPLE.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder
Check this out and let me know !! Regards, Mandeep baluja Sub SearchDir() Dim i As Long: i = 2 'A variable to paste values in main sheet Dim Searchword As Variant 'Search value to be used Dim Wbmain As Workbook 'Main workbook Dim fldAs Object'fso object On Error GoTo Tech: 'On error Go to @mandeep.bal...@snapdeal.com 'Turn off Flickering Application.ScreenUpdating = False: Application.DisplayAlerts = False Set Wbmain = ThisWorkbook Wbmain.Sheets("Sheet2").Cells.ClearContents Wbmain.Sheets("Sheet2").Range("A1:C1") = Array("Filename", "Sheetname", "Cellnumber") Searchword = Wbmain.Sheets("Sheet1").Range("A3") Wbmain.Sheets("Sheet2").AutoFilterMode = False 'Set path of Folder Set fld = Application.FileDialog(msoFileDialogFolderPicker) fld.Show fldpath = fld.SelectedItems(1) & "\" fname = Dir(fldpath) 'Looping of Files Do While fname <> "" Set wbtemp = Workbooks.Open(fldpath & fname) For Each ws In wbtemp.Sheets Wbmain.Sheets("Sheet2").Cells(i, 2).Value = ws.Name Wbmain.Sheets("Sheet2").Cells(i, 1).Value = fname ws.Activate Set f = ws.Cells.Find(what:=Searchword, LookIn:=xlValues, lookat:=xlWhole) If Not f Is Nothing Then k = f.Address Add = f.Address Do Set f = ws.UsedRange.FindNext(f) If f.Address <> k Then Add = Add & "," & f.Address End If Loop While Not f Is Nothing And k <> f.Address Wbmain.Sheets("sheet2").Cells(i, 3).Value = Add End If i = i + 1 Next fname = Dir() wbtemp.Close Loop Wbmain.Sheets("sheet2").Activate lr = Wbmain.Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row Wbmain.Sheets("Sheet2").Range("A1:C" & lr).AutoFilter field:=3, Criteria1:="" Wbmain.Sheets("Sheet2").Range("A2:A" & lr).SpecialCells(xlCellTypeVisible).Select Selection.Rows.Delete Wbmain.Sheets("Sheet2").AutoFilterMode = False Exit Sub Tech: MsgBox "An unexpected error has occured You have done something Wrong Contact mandeep.bal...@snapdeal.com" 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Question Sheet.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder
Hey, I understood you're question that's why I replied bro. Okay let me tell you a trick. > Go to that folder open in window explorer on right side you will see the > search option enter the number you're are looking for it will show you > those files which contains the text present anywhere in the report,copy > those files in separate folder simple !! Now main work copy the address bar > like path > C:\Users\Mandeep.baluja\Desktop\Hell paste it in google address bar , it will show open a link with file names copy all text from webpage by ctrl+A put it in excel files ,Now you have the names of file you are interested in !! Regards, Mandeep baluja -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.