RE: $$Excel-Macros$$ Query for Code

[gargee singh]

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 
 To: "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 http://groups.google.com/group/excel-macros.

For more options, visit h

$$Excel-Macros$$ Urgent need in Montgomery, AL--SQL Server Developer / DBA with data conversion experience

[MADHU-GenuineItLlc]

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.

$$Excel-Macros$$ Client in New York need SAP IT Banking Specialist with banking, FI, XML, interfaces, abap

[MADHU-GenuineItLlc]

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 by

$$Excel-Macros$$ Require formula to find the count targeted till date

[raghu]

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$$ Urgent need Hyperion --Dallas ,TX

[MADHU-GenuineItLlc]

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$$ Urgent need QA Test Lead with UFT ALM needed (3 positions) - Colorado Springs CO

[MADHU-GenuineItLlc]

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.

Re: $$Excel-Macros$$ Query for Code

[Paul Schreiner]

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 
 To: "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 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

[MADHU-GenuineItLlc]

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.

Re: $$Excel-Macros$$ FIFO UDF not working

[Paul Schreiner]

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 
 To: MS EXCEL AND VBA MACROS  
 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$$ Direct client in Austin, TX-- Project Manager---LOCALS PREFERED

[MADHU-GenuineItLlc]

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.

$$Excel-Macros$$ Direct Client in Austin ,TX-Business Analyst(Healthcare ) --LOCALS PREFERED

[MADHU-GenuineItLlc]

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$$ Find string, copy, paste

[Mike B]

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 > 
> 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 .
> > To post to this group, send email to excel-...@googlegroups.com 
> .
> > 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.

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee28]

absolutely perfect now. thanks a lot.  :)  :)


Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:27 AM -0700, "ashish koul"  
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,  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  for Android
>
>
>
> On Mon, Jul 27, 2015 at 5:13 AM -0700,  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 
> 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 
> Join Us on Facebook 
>
>
>  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 th

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[ashish koul]

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,  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  for Android
>
>
>
> On Mon, Jul 27, 2015 at 5:13 AM -0700,  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 
> 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 
> Join Us on Facebook 
>
>
>  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 t

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee28]

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,  wrote:
its perfect!  thanks a lot...  :)


Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul"  
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  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 
Join Us on Facebook 


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 g

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee28]

its perfect!  thanks a lot...  :)


Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul"  
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  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 
Join Us on Facebook 


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 dat

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[ashish koul]

use application.enableevents = false at the beginning

and application.enableevents  = true at end

On Mon, Jul 27, 2015 at 5:29 PM, gargee singh  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 
Join Us on Facebook 


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$$ Query for Code

[gargee singh]

 

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

$$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee singh]

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.