Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

[Pravin Gunjal]

Good Morning,

It's fantastic...

On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar 
wrote:

> Dear Pravin jee
>
> PFA
>
>
>
> Regards
> Ashish
>
> --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe.
> To unsubscribe from this group and all its topics, 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.

Re: $$Excel-Macros$$ Change or destroy word page setup through VBA code

[amar takale]

any solution?

On Mon, Jan 19, 2015 at 4:24 PM, amar takale  wrote:

> Dear Experts
>
> Can anybody tell me why this word not change its pagesetp format. We can
> change word page setup through VBA code OR destroy this word file page
> setup through VBA code.
>
> Regards
> Amar
>
> --
> 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$$ Re: Introduce Yourself !!

[Bluey]

Hi All

My name is Ian and I am a retired contractor. My interests are my  family, 
gardening and the stock market. I am developing a share portfolio 
mangerment system, and am looking for assistance on to display data  on 
Excel Dashboard. Any assistance advice appreciated. Thank you.

On Saturday, June 9, 2012 at 5:21:59 AM UTC+10, Ayush Jain wrote:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

-- 
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 Requirement Business Analyst, | Chicago|3 Months

[Shyamayi Dakoju]

*Hi**,*



*Hope you are doing great!!*


* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com 
and I will get back as soon as possible.*


*Position: Business Analyst*

*Location: Bensenville_IL*

*Contract Period: 3 Months *


Please do not submit candidates that do not meet the requirements.


Specific knowledge in billing & accounting is a plus. This is a project
dealing with Accounts Receivable & the billing process. Technical writing
requirement relates to translating business requirements into technical
writing. The current methodology used is Waterfall. This position requires
Telecom Billing & Data Experience. The candidate must have at the minimum 3
years of active/focused BA experience.

*Describe the role:*

This BA will be part of the IS team. We will participate in the business
requirement sessions to ask technical questions and work closely with the
architects, development and testing to be the liaison between IS and the
business. The BA will produce a requirements document for internal and
external technical teams.

Responsible for working with the business to analyze business requirements.
Provide functional expertise, high level business process re engineering,
technical overviews and insight where appropriate. Produce specifications
for any new / change to technology applications. Work with the development
team to ensure that they understand the business and functional
specifications. Work with training team to document system scenarios and
identify roles impacted and help develop a change management / training
plan. Actively participate in SQA preparation for and execution of user
acceptance testing (UAT).

The request has the same requirements as the previous Business Analysts
positions. This request is urgent as it was originally filled and now
requires candidates. Preferably with security (SOX, compliance) experience
as well as reporting

Responsible for working with the business to analyze business requirements.
Provide functional expertise, high level business process re engineering,
technical overviews and insight where appropriate. Produce specifications
for any new / change to technology applications. Work with the development
team to ensure that they understand the business and functional
specifications. Work with training team to document system scenarios and
identify roles impacted and help develop a change management / training
plan. Actively participate in SQA preparation for and execution of user
acceptance testing (UAT)

*Technical skills*

· 7+ years of related experience as Business Analyst
· Should have 1-3 years of telecom experience BA 1-3 years – any is
helpful
· Ability to understand technical topics, data flows, architectural
diagrams; translate business requirements into technical terms; present
technical questions in language business team members can understand
· Billing experience It would be very helpful
· Experience with tools like Word, excel, visio, requisite pro,
quality center
· BA needs to be working on Application Development or SQA
experience with development, infrastructure and/or testing would be helpful
· BA needs to understand the Change management procedures

-- 
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$$ Very urgent need of Production Support Analyst – L2 (Unix & Shell) ===== Nashville, TN === Longterm contract.

[Mazhar Khan]

Hello ,



I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Production Support Analyst – L2 (Unix & Shell)*. *Nashville,
TN. *Please find below the job description for the same and revert back to
me with your updated profile and contact details at the earliest.



*Position: Production Support Analyst – L2 (Unix & Shell)*

*Location: Nashville, TN*

*Duration: Longterm contract*



*Description:*

· Strong skills on Unix/Linux, Shell scripting skills

· Good knowledge on Sybase/Oracle

· Good knowledge on SQL and PL/SQL

· Good exposure to Autosys/Cron and Batch Management

· Should have knowledge on ITIL Processes

· Strong knowledge on Market Data



*Skill Details (Primary)*





*Unix/Linux, Shell scripting Database – Oracle/Sybase (PL/SQL) Autosys/Cron
ITIL Processes Strong knowledge on Market Data*



*Skill Details (Secondary)*
XML Data Types
Perl
In this role we need the candidate to have excellent trading knowledge with
various exchanges, communication skills, and experience in dealing with
external vendors.
Ability to support a multi tiered development environment , and also
knowledge of the core ITIL processes of Incident , Problem and Change
management.









*Warm Regards,*

*Mazhar Khan*

*__*

*Resourcing Specialist*

*SYSTEL INC* | Atlanta, GA

*A **Certified** (MBE) Minority Business Enterprise*

*Direct: *+1- 678-203-2434

*mazh...@systelcomputers.com *

-- 
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 Requirement QA Tester (Senior)| Washigton, DC |Contract

[Shyamayi Dakoju]

*Hi**,*



*Hope you are doing great!!*


* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com 
and I will get back as soon as possible.*




*Position : **QA Tester (Senior)*

*Location : **Washigton, DC*

*Contract: **6 + months*



*Job Description:*

· Using the CMMi framework as a reference to define & implement
along with World Bank (WB) staff a Verification & Validation process in
terms of activities (testing, code inspection, etc..), methods, tools, etc

· Identify test cases for automation

· Prepare test cases for the selected functions

· Develop scripts for each of the test cases

· Train WB staff to use Mercury suite of products

· Document Standards and Guidelines for scripting

· Installation guide and User manual for the test automation scripts

· This person will provide leadership and “best practices”
experience for definition and implementation for the process area.

· This person will use excellent listening and communication skills
in order to surface issues related to the World Bank and TRO’s unique
culture and organizational constraints that could impact how designed
procedures work in practice

· Strong and demonstrated experience of working in an agile testing
capacity, independently and as part of a team.

· ISEB / ISTQB Foundation Certificate in Software Testing or
similar internationally recognized certification·

-- 
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 Requirement Demand Planner| Chicago|6 Months Plus

[Shyamayi Dakoju]

*Hi**,*



*Hope you are doing great!!*


* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com 
and I will get back as soon as possible.*



*Position: Demand Planner*

*Location: Chicago*

*Contract Period: 6 Months Plus*


*Overview/Summary*


The Demand Planner is responsible for managing the end-to-end supply chain
planning function. This individual contributor role is responsible for
using formal analytic techniques to predict and plan future demand on
approximately $750 million of inventory for devices to support
approximately 480 Retail locations, Direct Fulfillment, and Agent supply
chain channels. This role will capture, analyze and make recommendations at
the SKU level and provide target specific cause and effect relationship
information on demand to various levels of leadership. Determine and govern
key performance metrics surrounding inventory turn, service levels, and
obsolescence. Lead partnerships with cross-functional teams such as
Marketing to determine estimated and actual promotional lifts, Device
Management to report item performance, Replenishment Analysts to assist in
tiered buying strategies and identifying channel fill quantities.
Communicate and educate various partners on demand planning strategies.
Prevent and manage inventory backorders by collaborating with Inventory
Analysts on short term and long term forecasts. This position reports to
the Manager, Device Supply Chain.

*Responsibilities*:

*Lead the end-to-end supply chain planning function:*

· Monitor cell phone accessory sales at various depths of
granularity (by product by category and/or by location).

· Develop cell phone forecasts based on trends, promotions and
pricing.

· Partner with Inventory Analyst on demand forecasts to achieve
targeted inventory goals.

· Analyze store and DC inventory levels and sales rates,
recognizing company sales trends. Develop and manage a course of action
that will allow for a maximization of identifiable opportunities including
mix of product, allocation strategies, or performance of productive vs. non
productive inventory.

· Develop and lead device lifecycle planning through the
development of unit plans for all device SKU’s.

· Collaborate with peers and device channel partners to improve
advance planning and reduce end of life obsolescence.

· Participate in monthly Obsolescence review.

*Manage the reporting function for device supply chain:*

· Determine reporting requirements and analysis surrounding
inventory performance as well as forecasting for future demand.

· Utilize SAP BI for reporting

· Identify and support ad-hock reporting needs.
*Management of cross-functional relationships:*

· Lead short and long term demand forecasting for all product
categories using CPFR (Collaborative Planning and Forecasting Replenishment
Model).

· Lead and consolidate performance data from Planning Team to
present vendor

· Performance results at quarterly departmental meetings with
suppliers.

· Partner with Inventory Analyst to prevent and manage inventory
backorders, manage open orders by timing and quantity as needed to respond
to changing demand patterns.

· Categorize article selling by product category and/or feature
sets to provide feedback to accessory management team on breadth & depth of
assortments.

· Partner with Inventory Replenishment Analysts to ensure in stocks
are being met.

· Partner with cross-functional teams to understand upcoming
promotions and new product launches. Analyze results of similar promotions
or similar products in order to estimate and plan for demand.

· Responsible for participating in various projects as a subject
matter expert and lead resource for device supply chain related initiatives.


* Other duties as needed:*
Minimum Experience and Educational Requirements

· Bachelor's degree or equivalent experience required.

· 5-7 years of relevant work experience required; inventory
planning in retail or related field preferred.

· 1-3 years of demand planning experience required.

· Excellent written and verbal communication skills required.

· The ability to work with multiple computer applications at the
same time.

· Ability to balance multiple tasks at once, and reprioritize as
needed.

· Strong ability to manage time affectively, and to be versatile.

· Self motivated, and demonstrates initiative.

· Ability to develop relationships and work in a team environment.

· Experience with vendor (or 3rd party) relationships.

· Demonstrated analytical ability.

· Ability to sort through ambiguity and work in sometimes undefined
roles.

· Understanding of retail math conc

$$Excel-Macros$$ Urgent Requirement Salesforce Architect | Somerset NJ |Contract

[Shyamayi Dakoju]

*Hi**,*



*Hope you are doing great!!*


* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com 
and I will get back as soon as possible.*


*Position : Salesforce Architect*

*Location : **Somerset** NJ**.*

*Contract: 6 months*



Required Skills:

   - B.S. degree in Computer Science, Software Engineering, MIS or
   equivalent
   - 10+ years of experience with technical implementations of customer
   projects
   - Proficient in SFDC technologies including configuration and custom
   development
   - Experience with Salesforce service and sales domain
   - Experience with Apex coding (Custom Visual Pages, Classes, Triggers,
   Workflows) Experience with custom portals/communities
   - Have worked with secure web services and integration
   with Salesforce both synchronous and asynchronous call outs
   - Experience with enterprise integration tools and extract,
   transformation and load (ETL) tools
   - Application development experience with Javascript, XML, XML, HTML,
   XSLT, XSD, WSDL, WADL
   - One or more current Salesforce.com  certifications
   (e.g. DEV401, DEV501) desirable
   - Strong understanding of relational databases (MySQL, SQL Server,
   Oracle, etc.)
   - Familiarity with Object Oriented concepts and experience with OO
   languages(Java, Ruby, C#, C++, etc)

-- 
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$$

[Shyamayi Dakoju]

*Hi**,*



*Hope you are doing great!!*


* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com 
and I will get back as soon as possible.*


*Position : Salesforce Architect*

*Location : **Somerset** NJ**.*

*Contract: 6 months*



Required Skills:


   - B.S. degree in Computer Science, Software Engineering, MIS or
   equivalent
   - 10+ years of experience with technical implementations of customer
   projects
   - Proficient in SFDC technologies including configuration and custom
   development
   - Experience with Salesforce service and sales domain
   - Experience with Apex coding (Custom Visual Pages, Classes, Triggers,
   Workflows) Experience with custom portals/communities
   - Have worked with secure web services and integration
   with Salesforce both synchronous and asynchronous call outs
   - Experience with enterprise integration tools and extract,
   transformation and load (ETL) tools
   - Application development experience with Javascript, XML, XML, HTML,
   XSLT, XSD, WSDL, WADL
   - One or more current Salesforce.com  certifications
   (e.g. DEV401, DEV501) desirable
   - Strong understanding of relational databases (MySQL, SQL Server,
   Oracle, etc.)
   - Familiarity with Object Oriented concepts and experience with OO
   languages(Java, Ruby, C#, C++, etc)

-- 
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 Requirement Data Warehouse ETL Developer | Princeton, NJ | Contract Position

[Shyamayi Dakoju]

*Hi**,*



*Hope you are doing great!!*


* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com 
and I will get back as soon as possible.*



*Position : **Data Warehouse ETL Developer*

*Location : **Princeton**, NJ*

*Duration : 6+ months*



*Qualifications:*

   - Strong understanding of ETL tools (5+ years ETL required), including
   Informatica
   - Very Large Database and DW Implementation experience (20+ TBs)
   - Programming in a Linux/Unix environment, including shell scripting
   - Demonstrated experience and ability to work with business users to
   gather requirements and manage scope
   - Demonstrated experience and ability to deliver results quickly in a
   fast-paced environment on multiple projects
   - Proven ability to effectively manage their time and a desire to
   deliver results quickly and correctly
   - Strong trouble-shooting and problem-solving skills with a Logical and
   pragmatic attitude
   - Team player with strong oral and interpersonal skills



*Nice to Have:*


   - Programming in Java, C++, Python
   - Hadoop stack/Map Reduce and other Hadoop-related open-source tools
   - HBase/NoSQL or similar technologies
   - Very Large Database and DW Implementation experience (20+ TBs)
   - BI Tools such as Qlikview and Cognos
   - Data Modeling skills including ERWin/ERStudio
   - Green Plum and/or Oracle database experience

-- 
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$$ Hi, have you tried LensKart? I just did!

[Pradeep Kumar]

Hi, have you tried LensKart? I just did!

-- 
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$$ Very urgent need of Scrum Master with Scrum Master certification. === Charlotte, NC for 6 + months contract.

[Mazhar Khan]

Hello,

 I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Scrum Master with Scrum Master certification.* *Charlotte,
NC*. Please find below the job description for the same and revert back to
me with your consultant updated profile and contact details at the earliest
om my email ID *mazh...@systelcomputers.com *.



*Position:  Scrum Master with Scrum Master certification. *

*Location: Charlotte, NC*

*Duration: 6 Months +*



*Description:*

· 12 – 15 years’ experience in projects

· Atleast 5 years of experience as scrum master in a project

· Good knowledge and hands on experience on TDD , continuous
integration , BDD

· Excellent problem solving skills and communication skills

· Should have worked on proposals and provided solutions

· Should have coached multiple teams – client and team

· Certifications desirable – Scrum master , certified product owner
, SAFE ( scaled agile certified)  << atleast one or 2 needed >>





*Warm Regards,*

*Mazhar Khan*

*__*

*Resourcing Specialist*

*SYSTEL INC* | Atlanta, GA

*A Certified (MBE) Minority Business Enterprise*

*Direct: *+1- 678-203-2434

*mazh...@systelcomputers.com *

-- 
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 of Sr. Java Developer with Telecom Domain experience -- San Ramon, CA/Middletown, NJ --- 12 + Months contract.

[Mazhar Khan]

Hello,



I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Sr.  Java Developer with Telecom Domain experience.* *San
Ramon, CA/Middletown, NJ*. Please find below the job description for the
same and revert back to me with your consultant updated profile and contact
details at the earliest om my email ID *mazh...@systelcomputers.com
*.





*Position: Sr.  Java Developer with Telecom Domain experience. *

*Location: San Ramon, CA/Middletown, NJ*

*Duration: 12 Months*



*Description:*

· Hands on experience in projects using Agile Scrum

· Java, JBOSS, RAD, Motive, Web Logic, Web Sphere, Work Flow
Engine, Agile Process

· Telecom experience

· Uverse and LightSpeed is desirable.

· Excellent interpersonal and organizational skills.



*Warm Regards,*

*Mazhar Khan*

*__*

*Resourcing Specialist*

*SYSTEL INC* | Atlanta, GA

*A **Certified** (MBE) Minority Business Enterprise*

*Direct: *+1- 678-203-2434

*mazh...@systelcomputers.com *

-- 
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$$ Re: Need a Formula or Macro to pick-up values from other sheets

[Pravin Gunjal]

Dear Ashish jee

Its fine and working good as per requirement.  Thank you.

But it would be much better, if any pop-up will appear here in Batch column
to select the batches out of many.  In pop-up if we type any starting
letter then only those batches should appear which contains that typed
letter/number.

Please look in to this.



On Sat, Jan 17, 2015 at 9:32 PM, Ashish Kumar 
wrote:

> PFA
>
> Regards
> Ashish
>
> --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe.
> To unsubscribe from this group and all its topics, 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$$ Change or destroy word page setup through VBA code

[amar takale]

Dear Experts

Can anybody tell me why this word not change its pagesetp format. We can
change word page setup through VBA code OR destroy this word file page
setup through VBA code.

Regards
Amar

-- 
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.


Valuing the Market-October-1996.doc
Description: MS-Word document

Re: $$Excel-Macros$$ Re: sum values with col/row criteria

[Vaibhav Joshi]

Can you add output sheet with desired result in it..i am unable to relate
ur explanation..
ᐧ

On Mon, Jan 19, 2015 at 9:03 AM, MLT  wrote:

> File attached to try to be more clear on what I'm trying to do.
>
> --
> 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.