Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS 


On Thu, 12/21/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 
updates in 3 topics
 To: excel-macros@googlegroups.com
 Date: Thursday, December 21, 2017, 7:05 AM
 
 
 
 On Thu, 12/21/17, 'Yu Spain' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Digest
 for excel-macros@googlegroups.com
 - 4 updates in 3 topics
  To: excel-macros@googlegroups.com
  Date: Thursday, December 21, 2017,
 6:13 AM
  
  
 
 
  On Wed, 12/20/17, 'Karleen Biggs' via
  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Digest
  for excel-macros@googlegroups.com
  - 4 updates in 3 topics
   To: excel-macros@googlegroups.com
   Date: Wednesday, December 20,
 2017,
  9:19 PM
   
   
  
 
 
   On Wed, 12/20/17, David Lanman
 <david.lanm...@gmail.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Digest
   for excel-macros@googlegroups.com
   - 4 updates in 3 topics
    To: excel-macros@googlegroups.com
    Date: Wednesday, December 20,
  2017,
   1:56 AM
    
    How about simply copy
    and paste values and do it to
  the the
   whole
    sheet?Sub CopyPastVal()   
    Cells.Copy    Selection.Copy 
   
    Selection.PasteSpecial
   Paste:=xlPasteValues   
    Application.CutCopyMode =
  FalseEnd
    SubThanks, David
    On Tue, Dec 19, 2017
    at 3:31 PM,  <excel-macros@googlegroups.com>
    wrote:
    
    
      
        
          
            
              
            
      
            
        
            
        excel-macros@googlegroups.com
            
      
              
              
            
      Google
    Groups
              
              
            
      
              
            
          
        
      
      
    
    
    
      
      
      
        Topic digest
      
      
    
      
        View
    all topics
      
    
    
      
      
        
          
          Urgent Need
   Business Analyst 2 (Columbus OH)
 06+
    Months -
          1 Update
        
      
        
          
          Excel Macro Help
   -
          2 Updates
        
      
        
          
          Help with
   replacing formula with value
 over
  large
    range -
          1 Update
        
      
      
    
    
    
    
      
      
      
      
        
          Urgent Need
   Business Analyst 2 (Columbus OH)
 06+
    Months
        
      
      
    
      
        
          
            
             
   Javeed Khan <javed.businessanalyst@gmail.
    com>: Dec 19 01:53PM -0500
            
            
    
    
            Please
   share profile on ja...@nestarit.com
    
     
    
    Direct contact number: (201) 448
  1184
    
     
    
     
    
     
    
    This is *Javed Khan* from
  *NESTAR
   TECHNOLOGIES/ AESPATECH
    LLC* and we have
    
    an immediate requirement with
  our
   client where we have
    excellent hold and
    
    can close the positions pretty
  quick.
   If you find yourself
    comfortable with
    
    the requirement please reply
  back with
   your updated resume
    and I will get
    
    back to you or
    
     
    
    I would really appreciate if you
  can
   give me a call back at
    my contact
    
    number.
    
     
    
     
    
     
    
    We have a Requirement *Business
   Analyst 2 / BA2* position in
    *Columbus OH*.
    
    If you have any matching resumes
  for
   the below mentioned
    position.
    
     
    
     
    
     
    
    VERY URGENT AND IMMEDIATE NEED
    
     
    
     
    
     
    
    Job Title: Business Analyst 2 /
  BA2
    
     
    
    Location: *Columbus OH (Local)*
    
     
    
    Duration: 06+ Months Contract
    
     
    
    *Interview: INTERVIEW ONSITE ON
   WEDNESDAY*
    
     
    
     
    
     
    
    The Business Analyst is
  responsible
   for the set of tasks and
    techniques
    
    used to work as a liaison among
   stakeholders in order to
    understand the
    
    structure, policies, and
  operations of
   an organization, and
    to recommend
    
    solutions that enable the
  organization
   to achieve its
    goals.
    
     
    
     
    
     
    
    *Requirements:*
    
     
    
    •         *Four
   to six years of experience with
 the
    following:*
    
     
    
    •        
   Experience creating and
 coordinating
  technical
    documentation
    
    preparation and distribution
  for
   processes, projects and
    procedures.
    
     
    
    •        
   Experience gathering, analyzing
  information
    needs and functional
    
    requirements from stakeholders,

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Carmelita Cronin' via MS EXCEL AND VBA MACROS 


On Thu, 12/21/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 
updates in 3 topics
 To: excel-macros@googlegroups.com
 Date: Thursday, December 21, 2017, 6:13 AM
 
 
 
 On Wed, 12/20/17, 'Karleen Biggs' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Digest
 for excel-macros@googlegroups.com
 - 4 updates in 3 topics
  To: excel-macros@googlegroups.com
  Date: Wednesday, December 20, 2017,
 9:19 PM
  
  
 
 
  On Wed, 12/20/17, David Lanman <david.lanm...@gmail.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Digest
  for excel-macros@googlegroups.com
  - 4 updates in 3 topics
   To: excel-macros@googlegroups.com
   Date: Wednesday, December 20,
 2017,
  1:56 AM
   
   How about simply copy
   and paste values and do it to
 the the
  whole
   sheet?Sub CopyPastVal()   
   Cells.Copy    Selection.Copy 
  
   Selection.PasteSpecial
  Paste:=xlPasteValues   
   Application.CutCopyMode =
 FalseEnd
   SubThanks, David
   On Tue, Dec 19, 2017
   at 3:31 PM,  <excel-macros@googlegroups.com>
   wrote:
   
   
     
       
         
           
             
           
     
           
       
           
       excel-macros@googlegroups.com
           
     
             
             
           
     Google
   Groups
             
             
           
     
             
           
         
       
     
     
   
   
   
     
     
     
       Topic digest
     
     
   
     
       View
   all topics
     
   
   
     
     
       
         
         Urgent Need
  Business Analyst 2 (Columbus OH) 06+
   Months -
         1 Update
       
     
       
         
         Excel Macro Help
  -
         2 Updates
       
     
       
         
         Help with
  replacing formula with value over
 large
   range -
         1 Update
       
     
     
   
   
   
   
     
     
     
     
       
         Urgent Need
  Business Analyst 2 (Columbus OH) 06+
   Months
       
     
     
   
     
       
         
           
            
  Javeed Khan <javed.businessanalyst@gmail.
   com>: Dec 19 01:53PM -0500
           
           
   
   
           Please
  share profile on ja...@nestarit.com
   
    
   
   Direct contact number: (201) 448
 1184
   
    
   
    
   
    
   
   This is *Javed Khan* from
 *NESTAR
  TECHNOLOGIES/ AESPATECH
   LLC* and we have
   
   an immediate requirement with
 our
  client where we have
   excellent hold and
   
   can close the positions pretty
 quick.
  If you find yourself
   comfortable with
   
   the requirement please reply
 back with
  your updated resume
   and I will get
   
   back to you or
   
    
   
   I would really appreciate if you
 can
  give me a call back at
   my contact
   
   number.
   
    
   
    
   
    
   
   We have a Requirement *Business
  Analyst 2 / BA2* position in
   *Columbus OH*.
   
   If you have any matching resumes
 for
  the below mentioned
   position.
   
    
   
    
   
    
   
   VERY URGENT AND IMMEDIATE NEED
   
    
   
    
   
    
   
   Job Title: Business Analyst 2 /
 BA2
   
    
   
   Location: *Columbus OH (Local)*
   
    
   
   Duration: 06+ Months Contract
   
    
   
   *Interview: INTERVIEW ONSITE ON
  WEDNESDAY*
   
    
   
    
   
    
   
   The Business Analyst is
 responsible
  for the set of tasks and
   techniques
   
   used to work as a liaison among
  stakeholders in order to
   understand the
   
   structure, policies, and
 operations of
  an organization, and
   to recommend
   
   solutions that enable the
 organization
  to achieve its
   goals.
   
    
   
    
   
    
   
   *Requirements:*
   
    
   
   •         *Four
  to six years of experience with the
   following:*
   
    
   
   •        
  Experience creating and coordinating
 technical
   documentation
   
   preparation and distribution
 for
  processes, projects and
   procedures.
   
    
   
   •        
  Experience gathering, analyzing
 information
   needs and functional
   
   requirements from stakeholders,
  business owners, and
   customers.
   
    
   
   •        
  Experience analyzing user needs and
 existing
   functions to
   
   determine business
 requirements,
  screen and interface
   design, use cases.
   
    
   
   •        
  Experience providing ongoing system
 maintenance
   and evaluation of
   
   systems.
   
    
   
   •        
  Experience delivering project
 artifacts.
   
    
   
   •        
  Experience analyzing business
 requirements using
   interviews,
   
   document analysis, and
 workshops.
   
    
   
   •        
  Analyzes, reviews, and recommends
 possible
   solutions to
   
   identified business problems.
   
    

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS 


On Wed, 12/20/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 
updates in 3 topics
 To: excel-macros@googlegroups.com
 Date: Wednesday, December 20, 2017, 9:19 PM
 
 
 
 On Wed, 12/20/17, David Lanman <david.lanm...@gmail.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Digest
 for excel-macros@googlegroups.com
 - 4 updates in 3 topics
  To: excel-macros@googlegroups.com
  Date: Wednesday, December 20, 2017,
 1:56 AM
  
  How about simply copy
  and paste values and do it to the the
 whole
  sheet?Sub CopyPastVal()   
  Cells.Copy    Selection.Copy   
  Selection.PasteSpecial
 Paste:=xlPasteValues   
  Application.CutCopyMode = FalseEnd
  SubThanks, David
  On Tue, Dec 19, 2017
  at 3:31 PM,  <excel-macros@googlegroups.com>
  wrote:
  
  
    
      
        
          
            
          
    
          
      
          
      excel-macros@googlegroups.com
          
    
            
            
          
    Google
  Groups
            
            
          
    
            
          
        
      
    
    
  
  
  
    
    
    
      Topic digest
    
    
  
    
      View
  all topics
    
  
  
    
    
      
        
        Urgent Need
 Business Analyst 2 (Columbus OH) 06+
  Months -
        1 Update
      
    
      
        
        Excel Macro Help
 -
        2 Updates
      
    
      
        
        Help with
 replacing formula with value over large
  range -
        1 Update
      
    
    
  
  
  
  
    
    
    
    
      
        Urgent Need
 Business Analyst 2 (Columbus OH) 06+
  Months
      
    
    
  
    
      
        
          
           
 Javeed Khan <javed.businessanalyst@gmail.
  com>: Dec 19 01:53PM -0500
          
          
  
  
          Please
 share profile on ja...@nestarit.com
  
   
  
  Direct contact number: (201) 448 1184
  
   
  
   
  
   
  
  This is *Javed Khan* from *NESTAR
 TECHNOLOGIES/ AESPATECH
  LLC* and we have
  
  an immediate requirement with our
 client where we have
  excellent hold and
  
  can close the positions pretty quick.
 If you find yourself
  comfortable with
  
  the requirement please reply back with
 your updated resume
  and I will get
  
  back to you or
  
   
  
  I would really appreciate if you can
 give me a call back at
  my contact
  
  number.
  
   
  
   
  
   
  
  We have a Requirement *Business
 Analyst 2 / BA2* position in
  *Columbus OH*.
  
  If you have any matching resumes for
 the below mentioned
  position.
  
   
  
   
  
   
  
  VERY URGENT AND IMMEDIATE NEED
  
   
  
   
  
   
  
  Job Title: Business Analyst 2 / BA2
  
   
  
  Location: *Columbus OH (Local)*
  
   
  
  Duration: 06+ Months Contract
  
   
  
  *Interview: INTERVIEW ONSITE ON
 WEDNESDAY*
  
   
  
   
  
   
  
  The Business Analyst is responsible
 for the set of tasks and
  techniques
  
  used to work as a liaison among
 stakeholders in order to
  understand the
  
  structure, policies, and operations of
 an organization, and
  to recommend
  
  solutions that enable the organization
 to achieve its
  goals.
  
   
  
   
  
   
  
  *Requirements:*
  
   
  
  •         *Four
 to six years of experience with the
  following:*
  
   
  
  •        
 Experience creating and coordinating technical
  documentation
  
  preparation and distribution for
 processes, projects and
  procedures.
  
   
  
  •        
 Experience gathering, analyzing information
  needs and functional
  
  requirements from stakeholders,
 business owners, and
  customers.
  
   
  
  •        
 Experience analyzing user needs and existing
  functions to
  
  determine business requirements,
 screen and interface
  design, use cases.
  
   
  
  •        
 Experience providing ongoing system maintenance
  and evaluation of
  
  systems.
  
   
  
  •        
 Experience delivering project artifacts.
  
   
  
  •        
 Experience analyzing business requirements using
  interviews,
  
  document analysis, and workshops.
  
   
  
  •        
 Analyzes, reviews, and recommends possible
  solutions to
  
  identified business problems.
  
   
  
  •        
 Develop test scripts, test cases, for User
  Acceptance Testing
  
  (UAT) based on requirements.
  
   
  
  •         Act
 liaison between business units, customers
  (internal and
  
  external) and various stakeholders.
  
   
  
  •         Assist
 Project Manager in project planning and
  developing project
  
  task plans, leading JAD sessions.
  
   
  
  •         Work
 experience in creating and coordinating
  technical,
  
  functional and business requirements
 for processes, projects
  and procedures.
  
   
  
  •        
 Excellent communication both oral

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-20 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS 


On Wed, 12/20/17, David Lanman <david.lanm...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 
updates in 3 topics
 To: excel-macros@googlegroups.com
 Date: Wednesday, December 20, 2017, 1:56 AM
 
 How about simply copy
 and paste values and do it to the the whole
 sheet?Sub CopyPastVal()   
 Cells.Copy    Selection.Copy   
 Selection.PasteSpecial Paste:=xlPasteValues   
 Application.CutCopyMode = FalseEnd
 SubThanks, David
 On Tue, Dec 19, 2017
 at 3:31 PM,  <excel-macros@googlegroups.com>
 wrote:
 
 
   
 
   
 
   
 
   
   excel-macros@googlegroups.com
 
   
   
 Google
 Groups
   
   
 
   
 
   
 
   
   
 
 
 
   
   
   
 Topic digest
   
   
 
   
 View
 all topics
   
 
 
   
   
 
   
   Urgent Need Business Analyst 2 (Columbus OH) 06+
 Months -
   1 Update
 
   
 
   
   Excel Macro Help -
   2 Updates
 
   
 
   
   Help with replacing formula with value over large
 range -
   1 Update
 
   
   
 
 
 
 
   
   
   
   
 
   Urgent Need Business Analyst 2 (Columbus OH) 06+
 Months
 
   
   
 
   
 
   
 
   Javeed Khan <javed.businessanalyst@gmail.
 com>: Dec 19 01:53PM -0500
 
 
 
 
 Please share profile on ja...@nestarit.com
 
  
 
 Direct contact number: (201) 448 1184
 
  
 
  
 
  
 
 This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH
 LLC* and we have
 
 an immediate requirement with our client where we have
 excellent hold and
 
 can close the positions pretty quick. If you find yourself
 comfortable with
 
 the requirement please reply back with your updated resume
 and I will get
 
 back to you or
 
  
 
 I would really appreciate if you can give me a call back at
 my contact
 
 number.
 
  
 
  
 
  
 
 We have a Requirement *Business Analyst 2 / BA2* position in
 *Columbus OH*.
 
 If you have any matching resumes for the below mentioned
 position.
 
  
 
  
 
  
 
 VERY URGENT AND IMMEDIATE NEED
 
  
 
  
 
  
 
 Job Title: Business Analyst 2 / BA2
 
  
 
 Location: *Columbus OH (Local)*
 
  
 
 Duration: 06+ Months Contract
 
  
 
 *Interview: INTERVIEW ONSITE ON WEDNESDAY*
 
  
 
  
 
  
 
 The Business Analyst is responsible for the set of tasks and
 techniques
 
 used to work as a liaison among stakeholders in order to
 understand the
 
 structure, policies, and operations of an organization, and
 to recommend
 
 solutions that enable the organization to achieve its
 goals.
 
  
 
  
 
  
 
 *Requirements:*
 
  
 
 • *Four to six years of experience with the
 following:*
 
  
 
 • Experience creating and coordinating technical
 documentation
 
 preparation and distribution for processes, projects and
 procedures.
 
  
 
 • Experience gathering, analyzing information
 needs and functional
 
 requirements from stakeholders, business owners, and
 customers.
 
  
 
 • Experience analyzing user needs and existing
 functions to
 
 determine business requirements, screen and interface
 design, use cases.
 
  
 
 • Experience providing ongoing system maintenance
 and evaluation of
 
 systems.
 
  
 
 • Experience delivering project artifacts.
 
  
 
 • Experience analyzing business requirements using
 interviews,
 
 document analysis, and workshops.
 
  
 
 • Analyzes, reviews, and recommends possible
 solutions to
 
 identified business problems.
 
  
 
 • Develop test scripts, test cases, for User
 Acceptance Testing
 
 (UAT) based on requirements.
 
  
 
 • Act liaison between business units, customers
 (internal and
 
 external) and various stakeholders.
 
  
 
 • Assist Project Manager in project planning and
 developing project
 
 task plans, leading JAD sessions.
 
  
 
 • Work experience in creating and coordinating
 technical,
 
 functional and business requirements for processes, projects
 and procedures.
 
  
 
 • Excellent communication both oral and written.-
 REQUIRED
 
  
 
  
 
  
 
  -- ---
 
  
 
 *Warm Regards,*
 
  
 
 Javed Khan (Sr. Technical Recruiter)
 
  
 
 *NESTAR TECHNOLOGIES/ AESPATECH LLC*
 
  
 
 Direct: (201) 448-1153
 
  
 
 Email: ja...@nestarit.com
 
  
 
 Skype ID: javeedkhan.khan2
 
  
 
 GTalk: javeedimrank...@gmail.com
   ; javednesta...@gmail.com
 
  
 
 www.nestarit.com
 
  
 
  
 
  
 
 *Notice of Confidentiality:*
 
  
 
 The information contained herein is intended only for the
 confidential use
 
 of the recipient. If the reader of this message is neither
 the intended
 
 recipient, nor the person responsible for delivering it to
 the intended
 
 recipient, you are hereby notified that you have received
 this
 
 comm

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-19 Thread David Lanman 
How about simply copy and paste values and do it to the the whole sheet?
Sub CopyPastVal()
Cells.Copy
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks, David

On Tue, Dec 19, 2017 at 3:31 PM,  wrote:

> excel-macros@googlegroups.com
> 
>  Google
> Groups
> 
> 
> Topic digest
> View all topics
> 
>
>- Urgent Need Business Analyst 2 (Columbus OH) 06+ Months
><#m_2017834070392865919_group_thread_0> - 1 Update
>- Excel Macro Help <#m_2017834070392865919_group_thread_1> - 2 Updates
>- Help with replacing formula with value over large range
><#m_2017834070392865919_group_thread_2> - 1 Update
>
> Urgent Need Business Analyst 2 (Columbus OH) 06+ Months
> 
> Javeed Khan : Dec 19 01:53PM -0500
>
> Please share profile on ja...@nestarit.com
>
> Direct contact number: (201) 448 1184
>
>
>
> This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH LLC* and we have
> an immediate requirement with our client where we have excellent hold and
> can close the positions pretty quick. If you find yourself comfortable with
> the requirement please reply back with your updated resume and I will get
> back to you or
>
> I would really appreciate if you can give me a call back at my contact
> number.
>
>
>
> We have a Requirement *Business Analyst 2 / BA2* position in *Columbus OH*.
> If you have any matching resumes for the below mentioned position.
>
>
>
> VERY URGENT AND IMMEDIATE NEED
>
>
>
> Job Title: Business Analyst 2 / BA2
>
> Location: *Columbus OH (Local)*
>
> Duration: 06+ Months Contract
>
> *Interview: INTERVIEW ONSITE ON WEDNESDAY*
>
>
>
> The Business Analyst is responsible for the set of tasks and techniques
> used to work as a liaison among stakeholders in order to understand the
> structure, policies, and operations of an organization, and to recommend
> solutions that enable the organization to achieve its goals.
>
>
>
> *Requirements:*
>
> • *Four to six years of experience with the following:*
>
> • Experience creating and coordinating technical documentation
> preparation and distribution for processes, projects and procedures.
>
> • Experience gathering, analyzing information needs and functional
> requirements from stakeholders, business owners, and customers.
>
> • Experience analyzing user needs and existing functions to
> determine business requirements, screen and interface design, use cases.
>
> • Experience providing ongoing system maintenance and evaluation of
> systems.
>
> • Experience delivering project artifacts.
>
> • Experience analyzing business requirements using interviews,
> document analysis, and workshops.
>
> • Analyzes, reviews, and recommends possible solutions to
> identified business problems.
>
> • Develop test scripts, test cases, for User Acceptance Testing
> (UAT) based on requirements.
>
> • Act liaison between business units, customers (internal and
> external) and various stakeholders.
>
> • Assist Project Manager in project planning and developing project
> task plans, leading JAD sessions.
>
> • Work experience in creating and coordinating technical,
> functional and business requirements for processes, projects and
> procedures.
>
> • Excellent communication both oral and written.- REQUIRED
>
>
>
> -
>
> *Warm Regards,*
>
> Javed Khan (Sr. Technical Recruiter)
>
> *NESTAR TECHNOLOGIES/ AESPATECH LLC*
>
> Direct: (201) 448-1153
>
> Email: ja...@nestarit.com
>
> Skype ID: javeedkhan.khan2
>
> GTalk: javeedimrank...@gmail.com ; javednesta...@gmail.com
>
> www.nestarit.com
>
>
>
> *Notice of Confidentiality:*
>
> The information contained herein is intended only for the confidential use
> of the recipient. If the reader of this message is neither the intended
> recipient, nor the person responsible for delivering it to the intended
> recipient, you are hereby notified that you have received this
> communication in error, and that any review, dissemination, distribution,
> or copying of this communication is strictly prohibited. If you receive
> this in error, please notify the sender immediately by telephone, and
> destroy this e-mail message OR reply with the subject *“REMOVE”* such that
> your email would be taken out of our distribution list.
> Back to top <#m_2017834070392865919_digest_top>
> Excel Macro Help
> 
> Julienne Schindler :