subject:"$$Excel\-Macros$$ How to pick numbers which are missing in serial numbers"

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread georgemartin812 via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 4:31 AM
 
 
 
 On Wed, 3/15/17, derrickandrew994 via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Wednesday, March 15, 2017, 3:46 AM
  
  
  
  On Wed, 3/15/17, storeythomas725 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Wednesday, March 15, 2017, 3:13 AM
   
   
   
   On Wed, 3/15/17, silvers.r via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Wednesday, March 15, 2017, 2:46 AM
    
    
    
    On Wed, 3/15/17, libertystringer via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Wednesday, March 15, 2017, 2:34 AM
     
     
     
     On Wed, 3/15/17, margaretatolliver via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Wednesday, March 15, 2017, 2:24 AM
      
      
      
      On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Wednesday, March 15, 2017, 1:56 AM
       
       
       
       On Tue, 3/14/17, libertystringer via MS EXCEL
 AND
     VBA
      MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 11:45 PM
        
        
        
        On Tue, 3/14/17, martinez.david533 via MS
  EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 10:58 PM
         
         
        
 
         On Tue, 3/14/17, cronincarmelita via MS
 EXCEL
   AND
       VBA
        MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 8:43 PM
          
          
         
  
          On Tue, 3/14/17, silvers.r via MS EXCEL AND
    VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 8:08 PM
           
           
          
   
           On Tue, 3/14/17, storeythomas725 via MS
   EXCEL
     AND
         VBA
          MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 7:25 PM
            
            
           
    
            On Tue, 3/14/17, margaretatolliver via
  MS
      EXCEL
        AND
          VBA
            MACROS <excel-macros@googlegroups.com>
            wrote:

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, derrickandrew994 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 3:46 AM
 
 
 
 On Wed, 3/15/17, storeythomas725 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Wednesday, March 15, 2017, 3:13 AM
  
  
  
  On Wed, 3/15/17, silvers.r via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Wednesday, March 15, 2017, 2:46 AM
   
   
   
   On Wed, 3/15/17, libertystringer via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Wednesday, March 15, 2017, 2:34 AM
    
    
    
    On Wed, 3/15/17, margaretatolliver via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Wednesday, March 15, 2017, 2:24 AM
     
     
     
     On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND
   VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Wednesday, March 15, 2017, 1:56 AM
      
      
      
      On Tue, 3/14/17, libertystringer via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 11:45 PM
       
       
       
       On Tue, 3/14/17, martinez.david533 via MS
 EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 10:58 PM
        
        
        
        On Tue, 3/14/17, cronincarmelita via MS EXCEL
  AND
      VBA
       MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 8:43 PM
         
         
        
 
         On Tue, 3/14/17, silvers.r via MS EXCEL AND
   VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 8:08 PM
          
          
         
  
          On Tue, 3/14/17, storeythomas725 via MS
  EXCEL
    AND
        VBA
         MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 7:25 PM
           
           
          
   
           On Tue, 3/14/17, margaretatolliver via
 MS
     EXCEL
       AND
         VBA
           MACROS <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 6:42 PM
            
            
           
    
            On Tue, 3/14/17, karleenbiggs via MS
  EXCEL
    AND
        VBA
          MACROS
            <excel-macros@googlegroups.com>
            wrote:

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread derrickandrew994 via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, storeythomas725 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 3:13 AM
 
 
 
 On Wed, 3/15/17, silvers.r via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Wednesday, March 15, 2017, 2:46 AM
  
  
  
  On Wed, 3/15/17, libertystringer via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Wednesday, March 15, 2017, 2:34 AM
   
   
   
   On Wed, 3/15/17, margaretatolliver via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Wednesday, March 15, 2017, 2:24 AM
    
    
    
    On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Wednesday, March 15, 2017, 1:56 AM
     
     
     
     On Tue, 3/14/17, libertystringer via MS EXCEL AND
   VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 11:45 PM
      
      
      
      On Tue, 3/14/17, martinez.david533 via MS EXCEL
  AND
    VBA
      MACROS <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 10:58 PM
       
       
       
       On Tue, 3/14/17, cronincarmelita via MS EXCEL
 AND
     VBA
      MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 8:43 PM
        
        
        
        On Tue, 3/14/17, silvers.r via MS EXCEL AND
  VBA
      MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 8:08 PM
         
         
        
 
         On Tue, 3/14/17, storeythomas725 via MS
 EXCEL
   AND
       VBA
        MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 7:25 PM
          
          
         
  
          On Tue, 3/14/17, margaretatolliver via MS
    EXCEL
      AND
        VBA
          MACROS <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 6:42 PM
           
           
          
   
           On Tue, 3/14/17, karleenbiggs via MS
 EXCEL
   AND
       VBA
         MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 6:32 PM
            
            
           
    
            On Tue, 3/14/17, mintaspriggs via MS
  EXCEL
    AND
        VBA
          MACROS
            <excel-macros@googlegroups.com>
            wrote:

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread storeythomas725 via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, silvers.r via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 2:46 AM
 
 
 
 On Wed, 3/15/17, libertystringer via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Wednesday, March 15, 2017, 2:34 AM
  
  
  
  On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Wednesday, March 15, 2017, 2:24 AM
   
   
   
   On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Wednesday, March 15, 2017, 1:56 AM
    
    
    
    On Tue, 3/14/17, libertystringer via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 11:45 PM
     
     
     
     On Tue, 3/14/17, martinez.david533 via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 10:58 PM
      
      
      
      On Tue, 3/14/17, cronincarmelita via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 8:43 PM
       
       
       
       On Tue, 3/14/17, silvers.r via MS EXCEL AND
 VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 8:08 PM
        
        
        
        On Tue, 3/14/17, storeythomas725 via MS EXCEL
  AND
      VBA
       MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 7:25 PM
         
         
        
 
         On Tue, 3/14/17, margaretatolliver via MS
   EXCEL
     AND
       VBA
         MACROS <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 6:42 PM
          
          
         
  
          On Tue, 3/14/17, karleenbiggs via MS EXCEL
  AND
      VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 6:32 PM
           
           
          
   
           On Tue, 3/14/17, mintaspriggs via MS
 EXCEL
   AND
       VBA
         MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 6:11 PM
            
            
           
    
            On Tue, 3/14/17, karleenbiggs via MS
  EXCEL
    AND
        VBA
          MACROS
            <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, libertystringer via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 2:34 AM
 
 
 
 On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Wednesday, March 15, 2017, 2:24 AM
  
  
  
  On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Wednesday, March 15, 2017, 1:56 AM
   
   
   
   On Tue, 3/14/17, libertystringer via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 11:45 PM
    
    
    
    On Tue, 3/14/17, martinez.david533 via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 10:58 PM
     
     
     
     On Tue, 3/14/17, cronincarmelita via MS EXCEL AND
   VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 8:43 PM
      
      
      
      On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 8:08 PM
       
       
       
       On Tue, 3/14/17, storeythomas725 via MS EXCEL
 AND
     VBA
      MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 7:25 PM
        
        
        
        On Tue, 3/14/17, margaretatolliver via MS
  EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 6:42 PM
         
         
        
 
         On Tue, 3/14/17, karleenbiggs via MS EXCEL
 AND
     VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 6:32 PM
          
          
         
  
          On Tue, 3/14/17, mintaspriggs via MS EXCEL
  AND
      VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 6:11 PM
           
           
          
   
           On Tue, 3/14/17, karleenbiggs via MS
 EXCEL
   AND
       VBA
         MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 5:49 PM
            
            
           
    
            On Tue, 3/14/17, derrickandrew994 via MS
    EXCEL
        AND
          VBA
            MACROS <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread libertystringer via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 2:24 AM
 
 
 
 On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Wednesday, March 15, 2017, 1:56 AM
  
  
  
  On Tue, 3/14/17, libertystringer via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 11:45 PM
   
   
   
   On Tue, 3/14/17, martinez.david533 via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 10:58 PM
    
    
    
    On Tue, 3/14/17, cronincarmelita via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 8:43 PM
     
     
     
     On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 8:08 PM
      
      
      
      On Tue, 3/14/17, storeythomas725 via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 7:25 PM
       
       
       
       On Tue, 3/14/17, margaretatolliver via MS
 EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 6:42 PM
        
        
        
        On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
    VBA
      MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 6:32 PM
         
         
        
 
         On Tue, 3/14/17, mintaspriggs via MS EXCEL
 AND
     VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 6:11 PM
          
          
         
  
          On Tue, 3/14/17, karleenbiggs via MS EXCEL
  AND
      VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 5:49 PM
           
           
          
   
           On Tue, 3/14/17, derrickandrew994 via MS
   EXCEL
       AND
         VBA
           MACROS <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 5:38 PM
            
            
           
    
            On Tue, 3/14/17, julienneschindler via
  MS
      EXCEL
        AND
          VBA
            MACROS <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS



On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Wednesday, March 15, 2017, 1:56 AM
 
 
 
 On Tue, 3/14/17, libertystringer via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 11:45 PM
  
  
  
  On Tue, 3/14/17, martinez.david533 via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 10:58 PM
   
   
   
   On Tue, 3/14/17, cronincarmelita via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 8:43 PM
    
    
    
    On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 8:08 PM
     
     
     
     On Tue, 3/14/17, storeythomas725 via MS EXCEL AND
   VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 7:25 PM
      
      
      
      On Tue, 3/14/17, margaretatolliver via MS EXCEL
  AND
    VBA
      MACROS <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 6:42 PM
       
       
       
       On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
   VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 6:32 PM
        
        
        
        On Tue, 3/14/17, mintaspriggs via MS EXCEL AND
    VBA
      MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 6:11 PM
         
         
        
 
         On Tue, 3/14/17, karleenbiggs via MS EXCEL
 AND
     VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 5:49 PM
          
          
         
  
          On Tue, 3/14/17, derrickandrew994 via MS
  EXCEL
      AND
        VBA
          MACROS <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 5:38 PM
           
           
          
   
           On Tue, 3/14/17, julienneschindler via
 MS
     EXCEL
       AND
         VBA
           MACROS <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 5:26 PM
            
            
           
    
            On Tue, 3/14/17, margaretatolliver via
  MS
      EXCEL
        AND
          VBA
            MACROS <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, libertystringer via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 11:45 PM
 
 
 
 On Tue, 3/14/17, martinez.david533 via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 10:58 PM
  
  
  
  On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 8:43 PM
   
   
   
   On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 8:08 PM
    
    
    
    On Tue, 3/14/17, storeythomas725 via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 7:25 PM
     
     
     
     On Tue, 3/14/17, margaretatolliver via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 6:42 PM
      
      
      
      On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
  VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 6:32 PM
       
       
       
       On Tue, 3/14/17, mintaspriggs via MS EXCEL AND
   VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 6:11 PM
        
        
        
        On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
    VBA
      MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 5:49 PM
         
         
        
 
         On Tue, 3/14/17, derrickandrew994 via MS
 EXCEL
     AND
       VBA
         MACROS <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 5:38 PM
          
          
         
  
          On Tue, 3/14/17, julienneschindler via MS
    EXCEL
      AND
        VBA
          MACROS <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 5:26 PM
           
           
          
   
           On Tue, 3/14/17, margaretatolliver via
 MS
     EXCEL
       AND
         VBA
           MACROS <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 12:10 PM
            
            
           
    
            On Tue, 3/14/17, hopkinsruben865 via MS
    EXCEL
      AND
          VBA
           MACROS
            <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread libertystringer via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, martinez.david533 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 10:58 PM
 
 
 
 On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 8:43 PM
  
  
  
  On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 8:08 PM
   
   
   
   On Tue, 3/14/17, storeythomas725 via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 7:25 PM
    
    
    
    On Tue, 3/14/17, margaretatolliver via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 6:42 PM
     
     
     
     On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
 VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 6:32 PM
      
      
      
      On Tue, 3/14/17, mintaspriggs via MS EXCEL AND
  VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 6:11 PM
       
       
       
       On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
   VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 5:49 PM
        
        
        
        On Tue, 3/14/17, derrickandrew994 via MS EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 5:38 PM
         
         
        
 
         On Tue, 3/14/17, julienneschindler via MS
   EXCEL
     AND
       VBA
         MACROS <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 5:26 PM
          
          
         
  
          On Tue, 3/14/17, margaretatolliver via MS
    EXCEL
      AND
        VBA
          MACROS <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 12:10 PM
           
           
          
   
           On Tue, 3/14/17, hopkinsruben865 via MS
   EXCEL
     AND
         VBA
          MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 11:04 AM
            
            
           
    
            On Tue, 3/14/17, silvers.r via MS EXCEL
  AND
      VBA
          MACROS
            <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ Ho

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread libertystringer via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 8:43 PM
 
 
 
 On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 8:08 PM
  
  
  
  On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 7:25 PM
   
   
   
   On Tue, 3/14/17, margaretatolliver via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 6:42 PM
    
    
    
    On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 6:32 PM
     
     
     
     On Tue, 3/14/17, mintaspriggs via MS EXCEL AND
 VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 6:11 PM
      
      
      
      On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
  VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 5:49 PM
       
       
       
       On Tue, 3/14/17, derrickandrew994 via MS EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 5:38 PM
        
        
        
        On Tue, 3/14/17, julienneschindler via MS
  EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 5:26 PM
         
         
        
 
         On Tue, 3/14/17, margaretatolliver via MS
   EXCEL
     AND
       VBA
         MACROS <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 12:10 PM
          
          
         
  
          On Tue, 3/14/17, hopkinsruben865 via MS
  EXCEL
    AND
        VBA
         MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 11:04 AM
           
           
          
   
           On Tue, 3/14/17, silvers.r via MS EXCEL
 AND
     VBA
         MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 10:54 AM
            
            
           
    
            On Tue, 3/14/17, silvers.r via MS EXCEL
  AND
      VBA
          MACROS
            <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ How to

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread martinez.david533 via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 8:43 PM
 
 
 
 On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 8:08 PM
  
  
  
  On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 7:25 PM
   
   
   
   On Tue, 3/14/17, margaretatolliver via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 6:42 PM
    
    
    
    On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 6:32 PM
     
     
     
     On Tue, 3/14/17, mintaspriggs via MS EXCEL AND
 VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 6:11 PM
      
      
      
      On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
  VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 5:49 PM
       
       
       
       On Tue, 3/14/17, derrickandrew994 via MS EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 5:38 PM
        
        
        
        On Tue, 3/14/17, julienneschindler via MS
  EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 5:26 PM
         
         
        
 
         On Tue, 3/14/17, margaretatolliver via MS
   EXCEL
     AND
       VBA
         MACROS <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 12:10 PM
          
          
         
  
          On Tue, 3/14/17, hopkinsruben865 via MS
  EXCEL
    AND
        VBA
         MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 11:04 AM
           
           
          
   
           On Tue, 3/14/17, silvers.r via MS EXCEL
 AND
     VBA
         MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 10:54 AM
            
            
           
    
            On Tue, 3/14/17, silvers.r via MS EXCEL
  AND
      VBA
          MACROS
            <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ How to

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread cronincarmelita via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 8:08 PM
 
 
 
 On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 7:25 PM
  
  
  
  On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 6:42 PM
   
   
   
   On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 6:32 PM
    
    
    
    On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 6:11 PM
     
     
     
     On Tue, 3/14/17, karleenbiggs via MS EXCEL AND
 VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 5:49 PM
      
      
      
      On Tue, 3/14/17, derrickandrew994 via MS EXCEL
  AND
    VBA
      MACROS <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 5:38 PM
       
       
       
       On Tue, 3/14/17, julienneschindler via MS
 EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 5:26 PM
        
        
        
        On Tue, 3/14/17, margaretatolliver via MS
  EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 12:10 PM
         
         
        
 
         On Tue, 3/14/17, hopkinsruben865 via MS
 EXCEL
   AND
       VBA
        MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 11:04 AM
          
          
         
  
          On Tue, 3/14/17, silvers.r via MS EXCEL AND
    VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 10:54 AM
           
           
          
   
           On Tue, 3/14/17, silvers.r via MS EXCEL
 AND
     VBA
         MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 10:49 AM
            
            
           
    
            On Tue, 3/14/17, hopkinsruben865 via MS
    EXCEL
      AND
          VBA
           MACROS
            <excel-macros@googlegroups.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ How to

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 7:25 PM
 
 
 
 On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 6:42 PM
  
  
  
  On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 6:32 PM
   
   
   
   On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 6:11 PM
    
    
    
    On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 5:49 PM
     
     
     
     On Tue, 3/14/17, derrickandrew994 via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 5:38 PM
      
      
      
      On Tue, 3/14/17, julienneschindler via MS EXCEL
  AND
    VBA
      MACROS <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 5:26 PM
       
       
       
       On Tue, 3/14/17, margaretatolliver via MS
 EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 12:10 PM
        
        
        
        On Tue, 3/14/17, hopkinsruben865 via MS EXCEL
  AND
      VBA
       MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 11:04 AM
         
         
        
 
         On Tue, 3/14/17, silvers.r via MS EXCEL AND
   VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 10:54 AM
          
          
         
  
          On Tue, 3/14/17, silvers.r via MS EXCEL AND
    VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 10:49 AM
           
           
          
   
           On Tue, 3/14/17, hopkinsruben865 via MS
   EXCEL
     AND
         VBA
          MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 9:48 AM
            
            
           
    
            On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ How to
   pick
       numbers
           which are
            missing in s

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread storeythomas725 via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 6:42 PM
 
 
 
 On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 6:32 PM
  
  
  
  On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 6:11 PM
   
   
   
   On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 5:49 PM
    
    
    
    On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 5:38 PM
     
     
     
     On Tue, 3/14/17, julienneschindler via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 5:26 PM
      
      
      
      On Tue, 3/14/17, margaretatolliver via MS EXCEL
  AND
    VBA
      MACROS <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 12:10 PM
       
       
       
       On Tue, 3/14/17, hopkinsruben865 via MS EXCEL
 AND
     VBA
      MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 11:04 AM
        
        
        
        On Tue, 3/14/17, silvers.r via MS EXCEL AND
  VBA
      MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 10:54 AM
         
         
        
 
         On Tue, 3/14/17, silvers.r via MS EXCEL AND
   VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 10:49 AM
          
          
         
  
          On Tue, 3/14/17, hopkinsruben865 via MS
  EXCEL
    AND
        VBA
         MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 9:48 AM
           
           
          
   
           On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ How to
  pick
      numbers
          which are
           missing in serial numbers
            To: excel-macros@googlegroups.com
            Date: Tuesday, March 14, 2017, 9:22 AM
            
            Thank you so much
            it's working perfectly:)
            On Mar 13, 2017 6:34 PM,
            "Paul Schreiner" <schreiner_p...@att.net>
            wrote:
            What
            I would do is first load your "Roll
  No."
      values
            into a Dictionary object.Then, loop
  through
      your

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 6:32 PM
 
 
 
 On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 6:11 PM
  
  
  
  On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 5:49 PM
   
   
   
   On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 5:38 PM
    
    
    
    On Tue, 3/14/17, julienneschindler via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 5:26 PM
     
     
     
     On Tue, 3/14/17, margaretatolliver via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 12:10 PM
      
      
      
      On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 11:04 AM
       
       
       
       On Tue, 3/14/17, silvers.r via MS EXCEL AND
 VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 10:54 AM
        
        
        
        On Tue, 3/14/17, silvers.r via MS EXCEL AND
  VBA
      MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 10:49 AM
         
         
        
 
         On Tue, 3/14/17, hopkinsruben865 via MS
 EXCEL
   AND
       VBA
        MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 9:48 AM
          
          
         
  
          On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ How to
 pick
     numbers
         which are
          missing in serial numbers
           To: excel-macros@googlegroups.com
           Date: Tuesday, March 14, 2017, 9:22 AM
           
           Thank you so much
           it's working perfectly:)
           On Mar 13, 2017 6:34 PM,
           "Paul Schreiner" <schreiner_p...@att.net>
           wrote:
           What
           I would do is first load your "Roll
 No."
     values
           into a Dictionary object.Then, loop
 through
     your
           "S.No." values and look to see if they
 are
   in
     the
           Dictionary.Report the missing
           values.Like:
           Sub
           Find_Missing()
              
           Dim Dict_SN, SN
              
           Dim nRows, nRow, drow
              
           Set Dict_SN = CreateObject("Scripting.
           Dictionary")
              
           Dict_SN.RemoveAll
              
           
              
           nRo

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 6:11 PM
 
 
 
 On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 5:49 PM
  
  
  
  On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 5:38 PM
   
   
   
   On Tue, 3/14/17, julienneschindler via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 5:26 PM
    
    
    
    On Tue, 3/14/17, margaretatolliver via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 12:10 PM
     
     
     
     On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
   VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 11:04 AM
      
      
      
      On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 10:54 AM
       
       
       
       On Tue, 3/14/17, silvers.r via MS EXCEL AND
 VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 10:49 AM
        
        
        
        On Tue, 3/14/17, hopkinsruben865 via MS EXCEL
  AND
      VBA
       MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 9:48 AM
         
         
        
 
         On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ How to pick
    numbers
        which are
         missing in serial numbers
          To: excel-macros@googlegroups.com
          Date: Tuesday, March 14, 2017, 9:22 AM
          
          Thank you so much
          it's working perfectly:)
          On Mar 13, 2017 6:34 PM,
          "Paul Schreiner" <schreiner_p...@att.net>
          wrote:
          What
          I would do is first load your "Roll No."
    values
          into a Dictionary object.Then, loop through
    your
          "S.No." values and look to see if they are
  in
    the
          Dictionary.Report the missing
          values.Like:
          Sub
          Find_Missing()
             
          Dim Dict_SN, SN
             
          Dim nRows, nRow, drow
             
          Set Dict_SN = CreateObject("Scripting.
          Dictionary")
             
          Dict_SN.RemoveAll
             
          
             
          nRows = Range("A1").SpecialCells(
          xlLastCell).Row
             
          '
          Load Dictionary
             
          For nRow = 2 To nRows
             
          SN = Trim(ActiveSheet.Cells(nRow,
  "B").Value)
             
          If (SN & "X" <> "X") Then
             
          If (Not Dict_SN.exists(SN)) Then
  Dict_SN.Add
    SN,
        nRow
             
          End If

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread mintaspriggs via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 5:49 PM
 
 
 
 On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 5:38 PM
  
  
  
  On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 5:26 PM
   
   
   
   On Tue, 3/14/17, margaretatolliver via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 12:10 PM
    
    
    
    On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 11:04 AM
     
     
     
     On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 10:54 AM
      
      
      
      On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 10:49 AM
       
       
       
       On Tue, 3/14/17, hopkinsruben865 via MS EXCEL
 AND
     VBA
      MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 9:48 AM
        
        
        
        On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ How to pick
   numbers
       which are
        missing in serial numbers
         To: excel-macros@googlegroups.com
         Date: Tuesday, March 14, 2017, 9:22 AM
         
         Thank you so much
         it's working perfectly:)
         On Mar 13, 2017 6:34 PM,
         "Paul Schreiner" <schreiner_p...@att.net>
         wrote:
         What
         I would do is first load your "Roll No."
   values
         into a Dictionary object.Then, loop through
   your
         "S.No." values and look to see if they are
 in
   the
         Dictionary.Report the missing
         values.Like:
         Sub
         Find_Missing()
            
         Dim Dict_SN, SN
            
         Dim nRows, nRow, drow
            
         Set Dict_SN = CreateObject("Scripting.
         Dictionary")
            
         Dict_SN.RemoveAll
            
         
            
         nRows = Range("A1").SpecialCells(
         xlLastCell).Row
            
         '
         Load Dictionary
            
         For nRow = 2 To nRows
            
         SN = Trim(ActiveSheet.Cells(nRow,
 "B").Value)
            
         If (SN & "X" <> "X") Then
            
         If (Not Dict_SN.exists(SN)) Then
 Dict_SN.Add
   SN,
       nRow
            
         End If
            
         Next nRow
            
         
            
         ActiveSheet.Range("C2:C65000")
 .ClearContents
            
         drow = 1
            
         For nRow = 2 To nRows
            
         SN = Trim(ActiveSheet.Cells(nRow,
 "A").Value)
            
         If (SN & "X" <> "X") Then
            
         If (Not Dict_SN.exists(SN)) Then
            
         drow = drow + 1

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 5:38 PM
 
 
 
 On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 5:26 PM
  
  
  
  On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 12:10 PM
   
   
   
   On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 11:04 AM
    
    
    
    On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 10:54 AM
     
     
     
     On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 10:49 AM
      
      
      
      On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 9:48 AM
       
       
       
       On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ How to pick
  numbers
      which are
       missing in serial numbers
        To: excel-macros@googlegroups.com
        Date: Tuesday, March 14, 2017, 9:22 AM
        
        Thank you so much
        it's working perfectly:)
        On Mar 13, 2017 6:34 PM,
        "Paul Schreiner" <schreiner_p...@att.net>
        wrote:
        What
        I would do is first load your "Roll No."
  values
        into a Dictionary object.Then, loop through
  your
        "S.No." values and look to see if they are in
  the
        Dictionary.Report the missing
        values.Like:
        Sub
        Find_Missing()
           
        Dim Dict_SN, SN
           
        Dim nRows, nRow, drow
           
        Set Dict_SN = CreateObject("Scripting.
        Dictionary")
           
        Dict_SN.RemoveAll
           
        
           
        nRows = Range("A1").SpecialCells(
        xlLastCell).Row
           
        '
        Load Dictionary
           
        For nRow = 2 To nRows
           
        SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
           
        If (SN & "X" <> "X") Then
           
        If (Not Dict_SN.exists(SN)) Then Dict_SN.Add
  SN,
      nRow
           
        End If
           
        Next nRow
           
        
           
        ActiveSheet.Range("C2:C65000") .ClearContents
           
        drow = 1
           
        For nRow = 2 To nRows
           
        SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
           
        If (SN & "X" <> "X") Then
           
        If (Not Dict_SN.exists(SN)) Then
           
        drow = drow + 1
           
        ActiveSheet.Cells(drow, "C").Value = SN
           
        End If
           
        End If
           
        Next nRow
        End
        SubPaul--
        ---
        “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.

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread derrickandrew994 via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 5:26 PM
 
 
 
 On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 12:10 PM
  
  
  
  On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 11:04 AM
   
   
   
   On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 10:54 AM
    
    
    
    On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 10:49 AM
     
     
     
     On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
   VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 9:48 AM
      
      
      
      On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ How to pick
 numbers
     which are
      missing in serial numbers
       To: excel-macros@googlegroups.com
       Date: Tuesday, March 14, 2017, 9:22 AM
       
       Thank you so much
       it's working perfectly:)
       On Mar 13, 2017 6:34 PM,
       "Paul Schreiner" <schreiner_p...@att.net>
       wrote:
       What
       I would do is first load your "Roll No."
 values
       into a Dictionary object.Then, loop through
 your
       "S.No." values and look to see if they are in
 the
       Dictionary.Report the missing
       values.Like:
       Sub
       Find_Missing()
          
       Dim Dict_SN, SN
          
       Dim nRows, nRow, drow
          
       Set Dict_SN = CreateObject("Scripting.
       Dictionary")
          
       Dict_SN.RemoveAll
          
       
          
       nRows = Range("A1").SpecialCells(
       xlLastCell).Row
          
       '
       Load Dictionary
          
       For nRow = 2 To nRows
          
       SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
          
       If (SN & "X" <> "X") Then
          
       If (Not Dict_SN.exists(SN)) Then Dict_SN.Add
 SN,
     nRow
          
       End If
          
       Next nRow
          
       
          
       ActiveSheet.Range("C2:C65000") .ClearContents
          
       drow = 1
          
       For nRow = 2 To nRows
          
       SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
          
       If (SN & "X" <> "X") Then
          
       If (Not Dict_SN.exists(SN)) Then
          
       drow = drow + 1
          
       ActiveSheet.Cells(drow, "C").Value = SN
          
       End If
          
       End If
          
       Next nRow
       End
       SubPaul--
       ---
       “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
       --
       --- 
       
        
         On Sunday, March 12, 2017 1:23 AM,
       Sunil Kumar Yadav <sk.yadav7...@gmail.com>
       wrote:
         
       
        Dear Paul,
       I have need your help for this
       query. Please guide me.
       --
       
       Sky
       
       
       "Good, Better,
       Best!Always listen to your
       heart, because there lives your
       parents.

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread julienneschindler via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 12:10 PM
 
 
 
 On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 11:04 AM
  
  
  
  On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 10:54 AM
   
   
   
   On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 10:49 AM
    
    
    
    On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 9:48 AM
     
     
     
     On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 9:22 AM
      
      Thank you so much
      it's working perfectly:)
      On Mar 13, 2017 6:34 PM,
      "Paul Schreiner" <schreiner_p...@att.net>
      wrote:
      What
      I would do is first load your "Roll No." values
      into a Dictionary object.Then, loop through your
      "S.No." values and look to see if they are in the
      Dictionary.Report the missing
      values.Like:
      Sub
      Find_Missing()
         
      Dim Dict_SN, SN
         
      Dim nRows, nRow, drow
         
      Set Dict_SN = CreateObject("Scripting.
      Dictionary")
         
      Dict_SN.RemoveAll
         
      
         
      nRows = Range("A1").SpecialCells(
      xlLastCell).Row
         
      '
      Load Dictionary
         
      For nRow = 2 To nRows
         
      SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
         
      If (SN & "X" <> "X") Then
         
      If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
    nRow
         
      End If
         
      Next nRow
         
      
         
      ActiveSheet.Range("C2:C65000") .ClearContents
         
      drow = 1
         
      For nRow = 2 To nRows
         
      SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
         
      If (SN & "X" <> "X") Then
         
      If (Not Dict_SN.exists(SN)) Then
         
      drow = drow + 1
         
      ActiveSheet.Cells(drow, "C").Value = SN
         
      End If
         
      End If
         
      Next nRow
      End
      SubPaul--
      ---
      “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
      --
      --- 
      
       
        On Sunday, March 12, 2017 1:23 AM,
      Sunil Kumar Yadav <sk.yadav7...@gmail.com>
      wrote:
        
      
       Dear Paul,
      I have need your help for this
      query. Please guide me.
      --
      
      Sky
      
      
      "Good, Better,
      Best!Always listen to your
      heart, because there lives your
      parents.
      
      
      
      
      -- 
      
      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
  atten

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread julienneschindler via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 12:10 PM
 
 
 
 On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 11:04 AM
  
  
  
  On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 10:54 AM
   
   
   
   On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 10:49 AM
    
    
    
    On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
  VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 9:48 AM
     
     
     
     On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: excel-macros@googlegroups.com
      Date: Tuesday, March 14, 2017, 9:22 AM
      
      Thank you so much
      it's working perfectly:)
      On Mar 13, 2017 6:34 PM,
      "Paul Schreiner" <schreiner_p...@att.net>
      wrote:
      What
      I would do is first load your "Roll No." values
      into a Dictionary object.Then, loop through your
      "S.No." values and look to see if they are in the
      Dictionary.Report the missing
      values.Like:
      Sub
      Find_Missing()
         
      Dim Dict_SN, SN
         
      Dim nRows, nRow, drow
         
      Set Dict_SN = CreateObject("Scripting.
      Dictionary")
         
      Dict_SN.RemoveAll
         
      
         
      nRows = Range("A1").SpecialCells(
      xlLastCell).Row
         
      '
      Load Dictionary
         
      For nRow = 2 To nRows
         
      SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
         
      If (SN & "X" <> "X") Then
         
      If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
    nRow
         
      End If
         
      Next nRow
         
      
         
      ActiveSheet.Range("C2:C65000") .ClearContents
         
      drow = 1
         
      For nRow = 2 To nRows
         
      SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
         
      If (SN & "X" <> "X") Then
         
      If (Not Dict_SN.exists(SN)) Then
         
      drow = drow + 1
         
      ActiveSheet.Cells(drow, "C").Value = SN
         
      End If
         
      End If
         
      Next nRow
      End
      SubPaul--
      ---
      “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
      --
      --- 
      
       
        On Sunday, March 12, 2017 1:23 AM,
      Sunil Kumar Yadav <sk.yadav7...@gmail.com>
      wrote:
        
      
       Dear Paul,
      I have need your help for this
      query. Please guide me.
      --
      
      Sky
      
      
      "Good, Better,
      Best!Always listen to your
      heart, because there lives your
      parents.
      
      
      
      
      -- 
      
      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
  atten

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 11:04 AM
 
 
 
 On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 10:54 AM
  
  
  
  On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 10:49 AM
   
   
   
   On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND
 VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 9:48 AM
    
    
    
    On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 9:22 AM
     
     Thank you so much
     it's working perfectly:)
     On Mar 13, 2017 6:34 PM,
     "Paul Schreiner" <schreiner_p...@att.net>
     wrote:
     What
     I would do is first load your "Roll No." values
     into a Dictionary object.Then, loop through your
     "S.No." values and look to see if they are in the
     Dictionary.Report the missing
     values.Like:
     Sub
     Find_Missing()
        
     Dim Dict_SN, SN
        
     Dim nRows, nRow, drow
        
     Set Dict_SN = CreateObject("Scripting.
     Dictionary")
        
     Dict_SN.RemoveAll
        
     
        
     nRows = Range("A1").SpecialCells(
     xlLastCell).Row
        
     '
     Load Dictionary
        
     For nRow = 2 To nRows
        
     SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
        
     If (SN & "X" <> "X") Then
        
     If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
   nRow
        
     End If
        
     Next nRow
        
     
        
     ActiveSheet.Range("C2:C65000") .ClearContents
        
     drow = 1
        
     For nRow = 2 To nRows
        
     SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
        
     If (SN & "X" <> "X") Then
        
     If (Not Dict_SN.exists(SN)) Then
        
     drow = drow + 1
        
     ActiveSheet.Cells(drow, "C").Value = SN
        
     End If
        
     End If
        
     Next nRow
     End
     SubPaul--
     ---
     “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
     --
     --- 
     
      
       On Sunday, March 12, 2017 1:23 AM,
     Sunil Kumar Yadav <sk.yadav7...@gmail.com>
     wrote:
       
     
      Dear Paul,
     I have need your help for this
     query. Please guide me.
     --
     
     Sky
     
     
     "Good, Better,
     Best!Always listen to your
     heart, because there lives your
     parents.
     
     
     
     
     -- 
     
     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

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 10:54 AM

 On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 10:49 AM

  On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:

   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 9:48 AM

   On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
   wrote:

    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 9:22 AM

    Thank you so much
    it's working perfectly:)
    On Mar 13, 2017 6:34 PM,
    "Paul Schreiner" <schreiner_p...@att.net>
    wrote:
    What
    I would do is first load your "Roll No." values
    into a Dictionary object.Then, loop through your
    "S.No." values and look to see if they are in the
    Dictionary.Report the missing
    values.Like:
    Sub
    Find_Missing()

    Dim Dict_SN, SN

    Dim nRows, nRow, drow

    Set Dict_SN = CreateObject("Scripting.
    Dictionary")

    Dict_SN.RemoveAll

    nRows = Range("A1").SpecialCells(
    xlLastCell).Row

    '
    Load Dictionary

    For nRow = 2 To nRows

    SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

    If (SN & "X" <> "X") Then

    If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
  nRow

    End If

    Next nRow

    ActiveSheet.Range("C2:C65000") .ClearContents

    drow = 1

    For nRow = 2 To nRows

    SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

    If (SN & "X" <> "X") Then

    If (Not Dict_SN.exists(SN)) Then

    drow = drow + 1

    ActiveSheet.Cells(drow, "C").Value = SN

    End If

    End If

    Next nRow
    End
    SubPaul--
    ---
    “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
    --
    --- 

      On Sunday, March 12, 2017 1:23 AM,
    Sunil Kumar Yadav <sk.yadav7...@gmail.com>
    wrote:

     Dear Paul,
    I have need your help for this
    query. Please guide me.
    --

    Sky

    "Good, Better,
    Best!Always listen to your
    heart, because there lives your
    parents.

    -- 

    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+unsubscribe@
    googlegroups.com.

    To post to this group, send email to excel-macros@googlegroups.com.

    Visit this group at https://groups.google.com/
    group/excel-macros.

    For more

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 10:49 AM

 On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 9:48 AM

  On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
  wrote:

   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 9:22 AM

   Thank you so much
   it's working perfectly:)
   On Mar 13, 2017 6:34 PM,
   "Paul Schreiner" <schreiner_p...@att.net>
   wrote:
   What
   I would do is first load your "Roll No." values
   into a Dictionary object.Then, loop through your
   "S.No." values and look to see if they are in the
   Dictionary.Report the missing
   values.Like:
   Sub
   Find_Missing()

   Dim Dict_SN, SN

   Dim nRows, nRow, drow

   Set Dict_SN = CreateObject("Scripting.
   Dictionary")

   Dict_SN.RemoveAll

   nRows = Range("A1").SpecialCells(
   xlLastCell).Row

   '
   Load Dictionary

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
 nRow

   End If

   Next nRow

   ActiveSheet.Range("C2:C65000") .ClearContents

   drow = 1

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then

   drow = drow + 1

   ActiveSheet.Cells(drow, "C").Value = SN

   End If

   End If

   Next nRow
   End
   SubPaul--
   ---
   “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
   --
   --- 

     On Sunday, March 12, 2017 1:23 AM,
   Sunil Kumar Yadav <sk.yadav7...@gmail.com>
   wrote:

    Dear Paul,
   I have need your help for this
   query. Please guide me.
   --

   Sky

   "Good, Better,
   Best!Always listen to your
   heart, because there lives your
   parents.

   -- 

   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+unsubscribe@
   googlegroups.com.

   To post to this group, send email to excel-macros@googlegroups.com.

   Visit this group at https://groups.google.com/
   group/excel-macros.

   For more options, visit https://groups.google.com/d/
   optout.

   -- 

   Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
 do you
   wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
   Facebook page of this forum @ https://www.facebook.com/
   discussexcel

   FORUM RULES

   1) Use concise, accurate thread titles. Poor thread
  titles,
   like Please Help, Urgent, Need Help, Formula Problem,
 Code
   Problem, and Need Advice will not get quick attention

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 10:49 AM

 On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 9:48 AM

  On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
  wrote:

   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 9:22 AM

   Thank you so much
   it's working perfectly:)
   On Mar 13, 2017 6:34 PM,
   "Paul Schreiner" <schreiner_p...@att.net>
   wrote:
   What
   I would do is first load your "Roll No." values
   into a Dictionary object.Then, loop through your
   "S.No." values and look to see if they are in the
   Dictionary.Report the missing
   values.Like:
   Sub
   Find_Missing()

   Dim Dict_SN, SN

   Dim nRows, nRow, drow

   Set Dict_SN = CreateObject("Scripting.
   Dictionary")

   Dict_SN.RemoveAll

   nRows = Range("A1").SpecialCells(
   xlLastCell).Row

   '
   Load Dictionary

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
 nRow

   End If

   Next nRow

   ActiveSheet.Range("C2:C65000") .ClearContents

   drow = 1

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then

   drow = drow + 1

   ActiveSheet.Cells(drow, "C").Value = SN

   End If

   End If

   Next nRow
   End
   SubPaul--
   ---
   “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
   --
   --- 

     On Sunday, March 12, 2017 1:23 AM,
   Sunil Kumar Yadav <sk.yadav7...@gmail.com>
   wrote:

    Dear Paul,
   I have need your help for this
   query. Please guide me.
   --

   Sky

   "Good, Better,
   Best!Always listen to your
   heart, because there lives your
   parents.

   -- 

   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+unsubscribe@
   googlegroups.com.

   To post to this group, send email to excel-macros@googlegroups.com.

   Visit this group at https://groups.google.com/
   group/excel-macros.

   For more options, visit https://groups.google.com/d/
   optout.

   -- 

   Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
 do you
   wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
   Facebook page of this forum @ https://www.facebook.com/
   discussexcel

   FORUM RULES

   1) Use concise, accurate thread titles. Poor thread
  titles,
   like Please Help, Urgent, Need Help, Formula Problem,
 Code
   Problem, and Need Advice will not get quick attention

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 9:48 AM

 On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 9:22 AM

  Thank you so much
  it's working perfectly:)
  On Mar 13, 2017 6:34 PM,
  "Paul Schreiner" <schreiner_p...@att.net>
  wrote:
  What
  I would do is first load your "Roll No." values
  into a Dictionary object.Then, loop through your
  "S.No." values and look to see if they are in the
  Dictionary.Report the missing
  values.Like:
  Sub
  Find_Missing()

  Dim Dict_SN, SN

  Dim nRows, nRow, drow

  Set Dict_SN = CreateObject("Scripting.
  Dictionary")

  Dict_SN.RemoveAll

  nRows = Range("A1").SpecialCells(
  xlLastCell).Row

  '
  Load Dictionary

  For nRow = 2 To nRows

  SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

  If (SN & "X" <> "X") Then

  If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow

  End If

  Next nRow

  ActiveSheet.Range("C2:C65000") .ClearContents

  drow = 1

  For nRow = 2 To nRows

  SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

  If (SN & "X" <> "X") Then

  If (Not Dict_SN.exists(SN)) Then

  drow = drow + 1

  ActiveSheet.Cells(drow, "C").Value = SN

  End If

  End If

  Next nRow
  End
  SubPaul--
  ---
  “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
  --
  --- 

    On Sunday, March 12, 2017 1:23 AM,
  Sunil Kumar Yadav <sk.yadav7...@gmail.com>
  wrote:

   Dear Paul,
  I have need your help for this
  query. Please guide me.
  --

  Sky

  "Good, Better,
  Best!Always listen to your
  heart, because there lives your
  parents.

  -- 

  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+unsubscribe@
  googlegroups.com.

  To post to this group, send email to excel-macros@googlegroups.com.

  Visit this group at https://groups.google.com/
  group/excel-macros.

  For more options, visit https://groups.google.com/d/
  optout.

  -- 

  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
  Facebook page of this forum @ https://www.facebook.com/
  discussexcel

  FORUM RULES

  1) Use concise, accurate thread titles. Poor thread
 titles,
  like Please Help, Urgent, Need Help, Formula Problem, Code
  Problem, and Need Advice will not get quick attention or
 may
  not be answered.

  2) Don't post a question in the thread of another
  member.

  3) Don't post questions regarding breaking or bypassing
  any security measure.

  4) Acknowledge the responses you receive, good or bad.

  5) Jobs posting is not allowed.

  6) Sharing copyrighted material and their links is not
  allowed.

  NOTE  : Don't ever post confidential data in a
 workbook.
  Forum owners and members are not responsible for any
  loss.

  --- 

  You received this message because y

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 9:22 AM

 Thank you so much
 it's working perfectly:)
 On Mar 13, 2017 6:34 PM,
 "Paul Schreiner" <schreiner_p...@att.net>
 wrote:
 What
 I would do is first load your "Roll No." values
 into a Dictionary object.Then, loop through your
 "S.No." values and look to see if they are in the
 Dictionary.Report the missing
 values.Like:
 Sub
 Find_Missing()

 Dim Dict_SN, SN

 Dim nRows, nRow, drow

 Set Dict_SN = CreateObject("Scripting.
 Dictionary")

 Dict_SN.RemoveAll

 nRows = Range("A1").SpecialCells(
 xlLastCell).Row

 '
 Load Dictionary

 For nRow = 2 To nRows

 SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

 If (SN & "X" <> "X") Then

 If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow

 End If

 Next nRow

 ActiveSheet.Range("C2:C65000") .ClearContents

 drow = 1

 For nRow = 2 To nRows

 SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

 If (SN & "X" <> "X") Then

 If (Not Dict_SN.exists(SN)) Then

 drow = drow + 1

 ActiveSheet.Cells(drow, "C").Value = SN

 End If

 End If

 Next nRow
 End
 SubPaul--
 ---
 “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
 --
 --- 

   On Sunday, March 12, 2017 1:23 AM,
 Sunil Kumar Yadav <sk.yadav7...@gmail.com>
 wrote:

  Dear Paul,
 I have need your help for this
 query. Please guide me.
 --

 Sky

 "Good, Better,
 Best!Always listen to your
 heart, because there lives your
 parents.

 -- 

 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+unsubscribe@
 googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/
 group/excel-macros.

 For more options, visit https://groups.google.com/d/
 optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/
 group/excel-macros.

 For more options, visit https://groups.google.com/d/
 optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Joi

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread kenyattafreed via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 9:22 AM

 Thank you so much
 it's working perfectly:)
 On Mar 13, 2017 6:34 PM,
 "Paul Schreiner" <schreiner_p...@att.net>
 wrote:
 What
 I would do is first load your "Roll No." values
 into a Dictionary object.Then, loop through your
 "S.No." values and look to see if they are in the
 Dictionary.Report the missing
 values.Like:
 Sub
 Find_Missing()

 Dim Dict_SN, SN

 Dim nRows, nRow, drow

 Set Dict_SN = CreateObject("Scripting.
 Dictionary")

 Dict_SN.RemoveAll

 nRows = Range("A1").SpecialCells(
 xlLastCell).Row

 '
 Load Dictionary

 For nRow = 2 To nRows

 SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

 If (SN & "X" <> "X") Then

 If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow

 End If

 Next nRow

 ActiveSheet.Range("C2:C65000") .ClearContents

 drow = 1

 For nRow = 2 To nRows

 SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

 If (SN & "X" <> "X") Then

 If (Not Dict_SN.exists(SN)) Then

 drow = drow + 1

 ActiveSheet.Cells(drow, "C").Value = SN

 End If

 End If

 Next nRow
 End
 SubPaul--
 ---
 “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
 --
 --- 

   On Sunday, March 12, 2017 1:23 AM,
 Sunil Kumar Yadav <sk.yadav7...@gmail.com>
 wrote:

  Dear Paul,
 I have need your help for this
 query. Please guide me.
 --

 Sky

 "Good, Better,
 Best!Always listen to your
 heart, because there lives your
 parents.

 -- 

 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+unsubscribe@
 googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/
 group/excel-macros.

 For more options, visit https://groups.google.com/d/
 optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/
 group/excel-macros.

 For more options, visit https://groups.google.com/d/
 optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Joi

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread Sunil Kumar Yadav

Thank you so much it's working perfectly:)

On Mar 13, 2017 6:34 PM, "Paul Schreiner"  wrote:

> What I would do is first load your "Roll No." values into a Dictionary
> object.
> Then, loop through your "S.No." values and look to see if they are in the
> Dictionary.
> Report the missing values.
> Like:
>
> Sub Find_Missing()
> Dim Dict_SN, SN
> Dim nRows, nRow, drow
> Set Dict_SN = CreateObject("Scripting.Dictionary")
> Dict_SN.RemoveAll
>
> nRows = Range("A1").SpecialCells(xlLastCell).Row
>
> ' Load Dictionary
> For nRow = 2 To nRows
> SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
> If (SN & "X" <> "X") Then
> If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow
> End If
> Next nRow
>
> ActiveSheet.Range("C2:C65000").ClearContents
> drow = 1
>
> For nRow = 2 To nRows
> SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
> If (SN & "X" <> "X") Then
> If (Not Dict_SN.exists(SN)) Then
> drow = drow + 1
> ActiveSheet.Cells(drow, "C").Value = SN
> End If
> End If
> Next nRow
> End Sub
> *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*
> -
>
>
> On Sunday, March 12, 2017 1:23 AM, Sunil Kumar Yadav <
> sk.yadav7...@gmail.com> wrote:
>
>
> Dear Paul,
>
> I have need your help for this query. Please guide me.
>
> --
> *Sky*
> "Good, Better, Best!
> *Always listen to your heart, because there lives your parents.*
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread silvers.r via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 5:19 AM
 
 
 
 On Tue, 3/14/17, kenyattafreed via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 4:20 AM
  
  
  
  On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 3:53 AM
   
   
   
   On Tue, 3/14/17, julienneschindler via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 3:35 AM
    
    
    
    On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: excel-macros@googlegroups.com
     Date: Tuesday, March 14, 2017, 2:54 AM
     
     
     
     On Mon, 3/13/17, Paul Schreiner <schreiner_p...@att.net>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to pick numbers
    which are
     missing in serial numbers
      To: "excel-macros@googlegroups.com"
     <excel-macros@googlegroups.com>
      Date: Monday, March 13, 2017, 3:04 PM
      
      What
      I would do is first load your "Roll No." values
      into a Dictionary object.Then, loop through your
      "S.No." values and look to see if they are in the
      Dictionary.Report the missing
      values.Like:
      Sub
      Find_Missing()
         
      Dim Dict_SN, SN
         
      Dim nRows, nRow, drow
         
      Set Dict_SN =
      CreateObject("Scripting.Dictionary")
         
      Dict_SN.RemoveAll
         
      
         
      nRows =
      Range("A1").SpecialCells(xlLastCell).Row
         
      '
      Load Dictionary
         
      For nRow = 2 To nRows
         
      SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
         
      If (SN & "X" <> "X") Then
         
      If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
    nRow
         
      End If
         
      Next nRow
         
      
         
      ActiveSheet.Range("C2:C65000").ClearContents
         
      drow = 1
         
      For nRow = 2 To nRows
         
      SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
         
      If (SN & "X" <> "X") Then
         
      If (Not Dict_SN.exists(SN)) Then
         
      drow = drow + 1
         
      ActiveSheet.Cells(drow, "C").Value = SN
         
      End If
         
      End If
         
      Next nRow
      End
      SubPaul-
      “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
      -
      
      
      
         On Sunday, March 12,
      2017 1:23 AM, Sunil Kumar Yadav
      <sk.yadav7...@gmail.com>
     wrote:
        
      
       Dear
      Paul,
      I have
      need your help for this query. Please guide
      me.
      -- 
      Sky
      
      
      "Good, Better,
      Best!Always listen to your
      heart, because there lives your
      parents.
      
      
      
      
      -- 
      
      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

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread silvers.r via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, kenyattafreed via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 4:20 AM
 
 
 
 On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 3:53 AM
  
  
  
  On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 3:35 AM
   
   
   
   On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 2:54 AM
    
    
    
    On Mon, 3/13/17, Paul Schreiner <schreiner_p...@att.net>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to pick numbers
   which are
    missing in serial numbers
     To: "excel-macros@googlegroups.com"
    <excel-macros@googlegroups.com>
     Date: Monday, March 13, 2017, 3:04 PM
     
     What
     I would do is first load your "Roll No." values
     into a Dictionary object.Then, loop through your
     "S.No." values and look to see if they are in the
     Dictionary.Report the missing
     values.Like:
     Sub
     Find_Missing()
        
     Dim Dict_SN, SN
        
     Dim nRows, nRow, drow
        
     Set Dict_SN =
     CreateObject("Scripting.Dictionary")
        
     Dict_SN.RemoveAll
        
     
        
     nRows =
     Range("A1").SpecialCells(xlLastCell).Row
        
     '
     Load Dictionary
        
     For nRow = 2 To nRows
        
     SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
        
     If (SN & "X" <> "X") Then
        
     If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
   nRow
        
     End If
        
     Next nRow
        
     
        
     ActiveSheet.Range("C2:C65000").ClearContents
        
     drow = 1
        
     For nRow = 2 To nRows
        
     SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
        
     If (SN & "X" <> "X") Then
        
     If (Not Dict_SN.exists(SN)) Then
        
     drow = drow + 1
        
     ActiveSheet.Cells(drow, "C").Value = SN
        
     End If
        
     End If
        
     Next nRow
     End
     SubPaul-
     “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
     -
     
     
     
        On Sunday, March 12,
     2017 1:23 AM, Sunil Kumar Yadav
     <sk.yadav7...@gmail.com>
    wrote:
       
     
      Dear
     Paul,
     I have
     need your help for this query. Please guide
     me.
     -- 
     Sky
     
     
     "Good, Better,
     Best!Always listen to your
     heart, because there lives your
     parents.
     
     
     
     
     -- 
     
     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 beca

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread kenyattafreed via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 3:53 AM

 On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 3:35 AM

  On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:

   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 2:54 AM

   On Mon, 3/13/17, Paul Schreiner <schreiner_p...@att.net>
   wrote:

    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: "excel-macros@googlegroups.com"
   <excel-macros@googlegroups.com>
    Date: Monday, March 13, 2017, 3:04 PM

    What
    I would do is first load your "Roll No." values
    into a Dictionary object.Then, loop through your
    "S.No." values and look to see if they are in the
    Dictionary.Report the missing
    values.Like:
    Sub
    Find_Missing()

    Dim Dict_SN, SN

    Dim nRows, nRow, drow

    Set Dict_SN =
    CreateObject("Scripting.Dictionary")

    Dict_SN.RemoveAll

    nRows =
    Range("A1").SpecialCells(xlLastCell).Row

    '
    Load Dictionary

    For nRow = 2 To nRows

    SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

    If (SN & "X" <> "X") Then

    If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
  nRow

    End If

    Next nRow

    ActiveSheet.Range("C2:C65000").ClearContents

    drow = 1

    For nRow = 2 To nRows

    SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

    If (SN & "X" <> "X") Then

    If (Not Dict_SN.exists(SN)) Then

    drow = drow + 1

    ActiveSheet.Cells(drow, "C").Value = SN

    End If

    End If

    Next nRow
    End
    SubPaul-
    “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
    -

       On Sunday, March 12,
    2017 1:23 AM, Sunil Kumar Yadav
    <sk.yadav7...@gmail.com>
   wrote:

     Dear
    Paul,
    I have
    need your help for this query. Please guide
    me.
    -- 
    Sky

    "Good, Better,
    Best!Always listen to your
    heart, because there lives your
    parents.

    -- 

    Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
  do you
    wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
    Facebook page of this forum @ https://www.facebook.com/discussexcel

    FORUM RULES

    1) Use concise, accurate thread titles. Poor thread
   titles,
    like Please Help, Urgent, Need Help, Formula Problem,
  Code
    Problem, and Need Advice will not get quick attention
  or
   may
    not be answered.

    2) Don't post a question in the thread of another
    member.

    3) Don't post questions regarding breaking or
  bypassing
    any security measure.

    4) Acknowledge the responses you receive, good or
  bad.

    5) Jobs posting is not allowed.

    6) Sharing copyrighted material and their links is
  not
    allowed.

    NOTE  : Don't ever post confidential data in a
   workbook.
    Forum owners and members are not responsible for any
    loss.

    --- 

    You received this message because you are subscribed
  to
   the
    Google Groups "MS EXCEL AND VBA MACROS" group.

    To unsubscribe from this group and stop receiving
  emails
    from it, send an email to excel-macros+unsubscr...@googlegroups.com.

    To post to this group, send email to excel-macros@googlegroups.com.

    Visit this group at
   https://groups.google.com/group/excel-macros.

    For more options, visit
   https://groups.google.com/d/optout.

    -- 

    Are you =EXP

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread cronincarmelita via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 3:35 AM

 On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 2:54 AM

  On Mon, 3/13/17, Paul Schreiner <schreiner_p...@att.net>
  wrote:

   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: "excel-macros@googlegroups.com"
  <excel-macros@googlegroups.com>
   Date: Monday, March 13, 2017, 3:04 PM

   What
   I would do is first load your "Roll No." values
   into a Dictionary object.Then, loop through your
   "S.No." values and look to see if they are in the
   Dictionary.Report the missing
   values.Like:
   Sub
   Find_Missing()

   Dim Dict_SN, SN

   Dim nRows, nRow, drow

   Set Dict_SN =
   CreateObject("Scripting.Dictionary")

   Dict_SN.RemoveAll

   nRows =
   Range("A1").SpecialCells(xlLastCell).Row

   '
   Load Dictionary

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
 nRow

   End If

   Next nRow

   ActiveSheet.Range("C2:C65000").ClearContents

   drow = 1

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then

   drow = drow + 1

   ActiveSheet.Cells(drow, "C").Value = SN

   End If

   End If

   Next nRow
   End
   SubPaul-
   “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
   -

      On Sunday, March 12,
   2017 1:23 AM, Sunil Kumar Yadav
   <sk.yadav7...@gmail.com>
  wrote:

    Dear
   Paul,
   I have
   need your help for this query. Please guide
   me.
   -- 
   Sky

   "Good, Better,
   Best!Always listen to your
   heart, because there lives your
   parents.

   -- 

   Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
 do you
   wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
   Facebook page of this forum @ https://www.facebook.com/discussexcel

   FORUM RULES

   1) Use concise, accurate thread titles. Poor thread
  titles,
   like Please Help, Urgent, Need Help, Formula Problem,
 Code
   Problem, and Need Advice will not get quick attention
 or
  may
   not be answered.

   2) Don't post a question in the thread of another
   member.

   3) Don't post questions regarding breaking or
 bypassing
   any security measure.

   4) Acknowledge the responses you receive, good or
 bad.

   5) Jobs posting is not allowed.

   6) Sharing copyrighted material and their links is
 not
   allowed.

   NOTE  : Don't ever post confidential data in a
  workbook.
   Forum owners and members are not responsible for any
   loss.

   --- 

   You received this message because you are subscribed
 to
  the
   Google Groups "MS EXCEL AND VBA MACROS" group.

   To unsubscribe from this group and stop receiving
 emails
   from it, send an email to excel-macros+unsubscr...@googlegroups.com.

   To post to this group, send email to excel-macros@googlegroups.com.

   Visit this group at
  https://groups.google.com/group/excel-macros.

   For more options, visit
  https://groups.google.com/d/optout.

   -- 

   Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
 do you
   wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
   Facebook page of this forum @ https://www.facebook.com/discussexcel

   FORUM RULES

   1) Use concise, accurate thread titles. Poor thread
  titles,
   like Please Help, Urgent, Need Help, Formula Problem,
 Code
   Problem, and Need Advice will not get quick attention
 or
  may
   not be answered.

   2) Don't post a question in the thread of another
   member.

   3) Don't post ques

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread julienneschindler via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 2:54 AM

 On Mon, 3/13/17, Paul Schreiner <schreiner_p...@att.net>
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: "excel-macros@googlegroups.com"
 <excel-macros@googlegroups.com>
  Date: Monday, March 13, 2017, 3:04 PM

  What
  I would do is first load your "Roll No." values
  into a Dictionary object.Then, loop through your
  "S.No." values and look to see if they are in the
  Dictionary.Report the missing
  values.Like:
  Sub
  Find_Missing()

  Dim Dict_SN, SN

  Dim nRows, nRow, drow

  Set Dict_SN =
  CreateObject("Scripting.Dictionary")

  Dict_SN.RemoveAll

  nRows =
  Range("A1").SpecialCells(xlLastCell).Row

  '
  Load Dictionary

  For nRow = 2 To nRows

  SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

  If (SN & "X" <> "X") Then

  If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow

  End If

  Next nRow

  ActiveSheet.Range("C2:C65000").ClearContents

  drow = 1

  For nRow = 2 To nRows

  SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

  If (SN & "X" <> "X") Then

  If (Not Dict_SN.exists(SN)) Then

  drow = drow + 1

  ActiveSheet.Cells(drow, "C").Value = SN

  End If

  End If

  Next nRow
  End
  SubPaul-
  “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
  -

     On Sunday, March 12,
  2017 1:23 AM, Sunil Kumar Yadav
  <sk.yadav7...@gmail.com>
 wrote:

   Dear
  Paul,
  I have
  need your help for this query. Please guide
  me.
  -- 
  Sky

  "Good, Better,
  Best!Always listen to your
  heart, because there lives your
  parents.

  -- 

  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel

  FORUM RULES

  1) Use concise, accurate thread titles. Poor thread
 titles,
  like Please Help, Urgent, Need Help, Formula Problem, Code
  Problem, and Need Advice will not get quick attention or
 may
  not be answered.

  2) Don't post a question in the thread of another
  member.

  3) Don't post questions regarding breaking or bypassing
  any security measure.

  4) Acknowledge the responses you receive, good or bad.

  5) Jobs posting is not allowed.

  6) Sharing copyrighted material and their links is not
  allowed.

  NOTE  : Don't ever post confidential data in a
 workbook.
  Forum owners and members are not responsible for any
  loss.

  --- 

  You received this message because you are subscribed to
 the
  Google Groups "MS EXCEL AND VBA MACROS" group.

  To unsubscribe from this group and stop receiving emails
  from it, send an email to excel-macros+unsubscr...@googlegroups.com.

  To post to this group, send email to excel-macros@googlegroups.com.

  Visit this group at
 https://groups.google.com/group/excel-macros.

  For more options, visit
 https://groups.google.com/d/optout.

  -- 

  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel

  FORUM RULES

  1) Use concise, accurate thread titles. Poor thread
 titles,
  like Please Help, Urgent, Need Help, Formula Problem, Code
  Problem, and Need Advice will not get quick attention or
 may
  not be answered.

  2) Don't post a question in the thread of another
  member.

  3) Don't post questions regarding breaking or bypassing
  any security measure.

  4) Acknowledge the responses you receive, good or bad.

  5) Jobs posting is not allowed.

  6) Sharing copyrighted material and their links is not
  allowed.

  NOTE  : Don't ever post confidential data in a
 workbook.
  Forum owners and members are not responsible for any
  loss.

  --- 

  You received this message because you are subscribed to
 the
  Google Groups "MS EXCEL AND VBA MACROS" group.

  To unsubscribe from this group an

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread mintaspriggs via MS EXCEL AND VBA MACROS

On Mon, 3/13/17, Paul Schreiner <schreiner_p...@att.net> wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
 Date: Monday, March 13, 2017, 3:04 PM

 What
 I would do is first load your "Roll No." values
 into a Dictionary object.Then, loop through your
 "S.No." values and look to see if they are in the
 Dictionary.Report the missing
 values.Like:
 Sub
 Find_Missing()

 Dim Dict_SN, SN

 Dim nRows, nRow, drow

 Set Dict_SN =
 CreateObject("Scripting.Dictionary")

 Dict_SN.RemoveAll

 nRows =
 Range("A1").SpecialCells(xlLastCell).Row

 '
 Load Dictionary

 For nRow = 2 To nRows

 SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

 If (SN & "X" <> "X") Then

 If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow

 End If

 Next nRow

 ActiveSheet.Range("C2:C65000").ClearContents

 drow = 1

 For nRow = 2 To nRows

 SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

 If (SN & "X" <> "X") Then

 If (Not Dict_SN.exists(SN)) Then

 drow = drow + 1

 ActiveSheet.Cells(drow, "C").Value = SN

 End If

 End If

 Next nRow
 End
 SubPaul-
 “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
 -

On Sunday, March 12,
 2017 1:23 AM, Sunil Kumar Yadav
 <sk.yadav7...@gmail.com> wrote:

  Dear
 Paul,
 I have
 need your help for this query. Please guide
 me.
 -- 
 Sky

 "Good, Better,
 Best!Always listen to your
 heart, because there lives your
 parents.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/group/excel-macros.

 For more options, visit https://groups.google.com/d/optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/group/excel-macros.

 For more options, visit https://groups.google.com/d/optout.
 Continuarea revolutiei de la 1848 in Transilvania66

-- 
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/discusse

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread Paul Schreiner

What I would do is first load your "Roll No." values into a Dictionary 
object.Then, loop through your "S.No." values and look to see if they are in 
the Dictionary.Report the missing values.Like:
Sub Find_Missing()
    Dim Dict_SN, SN
    Dim nRows, nRow, drow
    Set Dict_SN = CreateObject("Scripting.Dictionary")
    Dict_SN.RemoveAll
    
    nRows = Range("A1").SpecialCells(xlLastCell).Row
    ' Load Dictionary
    For nRow = 2 To nRows
    SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
    If (SN & "X" <> "X") Then
    If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow
    End If
    Next nRow
    
    ActiveSheet.Range("C2:C65000").ClearContents
    drow = 1
    For nRow = 2 To nRows
    SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
    If (SN & "X" <> "X") Then
    If (Not Dict_SN.exists(SN)) Then
    drow = drow + 1
    ActiveSheet.Cells(drow, "C").Value = SN
    End If
    End If
    Next nRow
End SubPaul-
“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
- 

On Sunday, March 12, 2017 1:23 AM, Sunil Kumar Yadav 
 wrote:
 

 Dear Paul,
I have need your help for this query. Please guide me.
-- 
Sky
"Good, Better, Best!Always listen to your heart, because there lives your 
parents.-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-11 Thread Sunil Kumar Yadav

Dear Paul,

I have need your help for this query. Please guide me.

-- 
*Sky*
"Good, Better, Best!
*Always listen to your heart, because there lives your parents.*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


How to pick numbers which are missing in serial numbers.xlsx
Description: MS-Excel 2007 spreadsheet

37 matches

Mail list logo