Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-03 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Tuesday, April 4, 2017, 1:42 AM
 
 
 
 On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Customized Inventory
 Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Monday, April 3, 2017, 5:12 PM
  
  
  
  On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA
 MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: Customized
 Inventory
  Software Required in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Monday, April 3, 2017, 4:59 PM
   
   
   
   On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA
  MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: Customized
  Inventory
   Software Required in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Monday, April 3, 2017, 1:53 PM
    
    
    
    On Mon, 4/3/17, Hitesh Kr. Aoul 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: Customized
   Inventory
    Software Required in Excel VBA
     To: "MS EXCEL AND VBA MACROS" 
     Date: Monday, April 3, 2017, 5:44 AM
     
     Hello
     Guys,
     Can anyone have any
     idea how to do the perfect Coding for this type
 of
     software... Waiting for the positive
     reply...
     
     
     
     On Wednesday,
     March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr.
   Aoul
     wrote:Hello
     Learner,
     Thanks for the
     reply. Please find the attachment, for material
 IN
   form i
     need subform as there are 100 items in Per Invoice
 to
   be
     enter. Kindly check and if anything else required
   please
     discuss.
     Regards,Hitesh 
     
     On Wednesday, March 29, 2017
     at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh,
     There are many solutions for
     inventory data. If you want customized solution,
 you
   need
    to
     specify input and output data and the report forms
 to
   be
     generated. Attach a file giving basic
     structure
     Learner
     
     
     On Tue, Mar 28, 2017 at
     12:30 PM, Hitesh Kr. Aoul 
    wrote:
     Hello Guys,
     Can anyone have any idea how to do
     the Coding for this type of software... Waiting
 for
   the
     positive reply...
     
     
     
     -- 
     
     Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
 And
   do you
     wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join
 official
     Facebook page of this forum @ https://www.facebook.com/
     discussexcel
     
      
     
     FORUM RULES
     
      
     
     1) Use concise, accurate thread titles. Poor
 thread
    titles,
     like Please Help, Urgent, Need Help, Formula
 Problem,
   Code
     Problem, and Need Advice will not get quick
 attention
   or
    may
     not be answered.
     
     2) Don't post a question in the thread of another
     member.
     
     3) Don't post questions regarding breaking or
   bypassing
     any security measure.
     
     4) Acknowledge the responses you receive, good or
   bad.
     
     5) Jobs posting is not allowed.
     
     6) Sharing copyrighted material and their links
 is
   not
     allowed.
     
      
     
     NOTE  : Don't ever post confidential data in a
    workbook.
     Forum owners and members are not responsible for
 any
     loss.
     
     --- 
     
     You received this message because you are
 subscribed
   to
    the
     Google Groups "MS EXCEL AND VBA MACROS" group.
     
     To unsubscribe from this group and stop receiving
   emails
     from it, send an email to excel-macros...@googlegroups.
    com.
     
     To post to this group, send email to excel-...@googlegroups.com.
     
     Visit this group at 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) 

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-03 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Tuesday, April 4, 2017, 1:42 AM
 
 
 
 On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Customized Inventory
 Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Monday, April 3, 2017, 5:12 PM
  
  
  
  On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA
 MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: Customized
 Inventory
  Software Required in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Monday, April 3, 2017, 4:59 PM
   
   
   
   On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA
  MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: Customized
  Inventory
   Software Required in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Monday, April 3, 2017, 1:53 PM
    
    
    
    On Mon, 4/3/17, Hitesh Kr. Aoul 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: Customized
   Inventory
    Software Required in Excel VBA
     To: "MS EXCEL AND VBA MACROS" 
     Date: Monday, April 3, 2017, 5:44 AM
     
     Hello
     Guys,
     Can anyone have any
     idea how to do the perfect Coding for this type
 of
     software... Waiting for the positive
     reply...
     
     
     
     On Wednesday,
     March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr.
   Aoul
     wrote:Hello
     Learner,
     Thanks for the
     reply. Please find the attachment, for material
 IN
   form i
     need subform as there are 100 items in Per Invoice
 to
   be
     enter. Kindly check and if anything else required
   please
     discuss.
     Regards,Hitesh 
     
     On Wednesday, March 29, 2017
     at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh,
     There are many solutions for
     inventory data. If you want customized solution,
 you
   need
    to
     specify input and output data and the report forms
 to
   be
     generated. Attach a file giving basic
     structure
     Learner
     
     
     On Tue, Mar 28, 2017 at
     12:30 PM, Hitesh Kr. Aoul 
    wrote:
     Hello Guys,
     Can anyone have any idea how to do
     the Coding for this type of software... Waiting
 for
   the
     positive reply...
     
     
     
     -- 
     
     Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
 And
   do you
     wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join
 official
     Facebook page of this forum @ https://www.facebook.com/
     discussexcel
     
      
     
     FORUM RULES
     
      
     
     1) Use concise, accurate thread titles. Poor
 thread
    titles,
     like Please Help, Urgent, Need Help, Formula
 Problem,
   Code
     Problem, and Need Advice will not get quick
 attention
   or
    may
     not be answered.
     
     2) Don't post a question in the thread of another
     member.
     
     3) Don't post questions regarding breaking or
   bypassing
     any security measure.
     
     4) Acknowledge the responses you receive, good or
   bad.
     
     5) Jobs posting is not allowed.
     
     6) Sharing copyrighted material and their links
 is
   not
     allowed.
     
      
     
     NOTE  : Don't ever post confidential data in a
    workbook.
     Forum owners and members are not responsible for
 any
     loss.
     
     --- 
     
     You received this message because you are
 subscribed
   to
    the
     Google Groups "MS EXCEL AND VBA MACROS" group.
     
     To unsubscribe from this group and stop receiving
   emails
     from it, send an email to excel-macros...@googlegroups.
    com.
     
     To post to this group, send email to excel-...@googlegroups.com.
     
     Visit this group at 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) 

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

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


On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Tuesday, April 4, 2017, 9:21 AM
 
 
 
 On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Customized Inventory
 Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Tuesday, April 4, 2017, 8:01 AM
  
  
  
  On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: Customized
 Inventory
  Software Required in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Tuesday, April 4, 2017, 5:48 AM
   
   
   
   On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA
 MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: Customized
  Inventory
   Software Required in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Tuesday, April 4, 2017, 1:42 AM
    
    
    
    On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND
  VBA
   MACROS
    
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: Customized
   Inventory
    Software Required in Excel VBA
     To: excel-macros@googlegroups.com
     Date: Monday, April 3, 2017, 5:12 PM
     
     
     
     On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND
 VBA
    MACROS
     
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: Customized
    Inventory
     Software Required in Excel VBA
      To: excel-macros@googlegroups.com
      Date: Monday, April 3, 2017, 4:59 PM
      
      
      
      On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND
  VBA
     MACROS
      
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: Customized
     Inventory
      Software Required in Excel VBA
       To: excel-macros@googlegroups.com
       Date: Monday, April 3, 2017, 1:53 PM
       
       
       
       On Mon, 4/3/17, Hitesh Kr. Aoul 
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Re: Customized
      Inventory
       Software Required in Excel VBA
        To: "MS EXCEL AND VBA MACROS" 
        Date: Monday, April 3, 2017, 5:44 AM
        
        Hello
        Guys,
        Can anyone have any
        idea how to do the perfect Coding for this
  type
    of
        software... Waiting for the positive
        reply...
        
        
        
        On Wednesday,
        March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh
  Kr.
      Aoul
        wrote:Hello
        Learner,
        Thanks for the
        reply. Please find the attachment, for
  material
    IN
      form i
        need subform as there are 100 items in Per
  Invoice
    to
      be
        enter. Kindly check and if anything else
  required
      please
        discuss.
        Regards,Hitesh 
        
        On Wednesday, March 29, 2017
        at 2:58:11 PM UTC+5:30, learner wrote:Hi
  Hitesh,
        There are many solutions for
        inventory data. If you want customized
  solution,
    you
      need
       to
        specify input and output data and the report
  forms
    to
      be
        generated. Attach a file giving basic
        structure
        Learner
        
        
        On Tue, Mar 28, 2017 at
        12:30 PM, Hitesh Kr. Aoul 
       wrote:
        Hello Guys,
        Can anyone have any idea how to do
        the Coding for this type of software...
  Waiting
    for
      the
        positive reply...
        
        
        
        -- 
        
        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

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-05 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Wednesday, April 5, 2017, 7:21 AM
 
 
 
 On Wed, 4/5/17, mintaspriggs via MS
 EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Customized Inventory Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Wednesday, April 5, 2017, 6:25
 AM
  
  
 
 
  On Wed, 4/5/17, 'Hopkins Ruben' via
 MS
  EXCEL AND VBA MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Customized Inventory Software Required
 in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Wednesday, April 5, 2017,
 5:28
  AM
   
   
  
 
 
   On Wed, 4/5/17, 'Carmelita
 Cronin'
  via
   MS EXCEL AND VBA MACROS 
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Customized Inventory Software
 Required
  in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Wednesday, April 5, 2017,
  4:19
   AM
    
    
   
  
 
 
    On Wed, 4/5/17, 'Margareta
  Tolliver'
    via MS EXCEL AND VBA MACROS
  
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Customized Inventory Software
  Required
   in Excel VBA
     To: excel-macros@googlegroups.com
     Date: Wednesday, April 5,
 2017,
   3:39
    AM
     
     
    
   
  
 
 
     On Wed, 4/5/17, 'Carmelita
   Cronin'
    via
     MS EXCEL AND VBA MACROS
 
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re:
     Customized Inventory
 Software
   Required
    in Excel VBA
      To: excel-macros@googlegroups.com
      Date: Wednesday, April 5,
  2017,
    1:26
     AM
      
      
     
    
   
  
 
 
      On Wed, 4/5/17, 'Kenyatta
  Freed'
    via
     MS
      EXCEL AND VBA MACROS 
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     Re:
      Customized Inventory
  Software
    Required
     in Excel VBA
       To: excel-macros@googlegroups.com
       Date: Wednesday, April 5,
   2017,
     1:15
      AM
       
       
      
     
    
   
  
 
 
       On Tue, 4/4/17,
 'Margareta
     Tolliver'
       via MS EXCEL AND VBA
 MACROS
     
       wrote:
       
        Subject: Re:
    $$Excel-Macros$$
      Re:
       Customized Inventory
   Software
     Required
      in Excel VBA
        To: excel-macros@googlegroups.com
        Date: Tuesday, April 4,
    2017,
      9:37 PM
        
        
       
      
     
    
   
  
 
 
        On Tue, 4/4/17,
  mintaspriggs
    via
      MS
       EXCEL AND VBA MACROS
        
        wrote:
        
         Subject: Re:
     $$Excel-Macros$$
       Re: Customized Inventory
        Software Required in
  Excel
    VBA
         To: excel-macros@googlegroups.com
         Date: Tuesday, April
 4,
     2017,
       6:09 PM
         
         
        
      
     
    
   
  
 
 --------------------
         On Tue, 4/4/17, 'Yu
   Spain'
     via
       MS EXCEL AND VBA MACROS
         
         wrote:
         
          Subject: Re:
    $$Excel-Macros$$
      Re:
       Customized
        Inventory
         Software Required in
   Excel
     VBA
          To: excel-macros@googlegroups.com
          Date: Tuesday, April
  4,
    2017,
      10:38
       AM
          
          
         
      
     
    
   
  
 
 
          On Tue, 4/4/17,
    'Margareta
       Tolliver' via MS EXCEL
 AND
        VBA
          MACROS 
          wrote:
          
           Subject: Re:
     $$Excel-Macros$$
       Re: Customized
         Inventory
          Software Required in
    Excel
      VBA
           To: excel-macros@googlegroups.com
           Date: Tuesday,
 April
   4,
     2017,
       9:21 AM
           
           
          
      
     
    
   
  
 
 
           On Tue, 4/4/17,
     'Margareta
       Tolliver' via MS EXCEL
 AND
         VBA
           MACROS 
           wrote:
           
            Subject: Re:
      $$Excel-Macros$$
       Re: Customized
          Inventory
           Software Required
 in
     Excel
       VBA
            To: excel-macros@googlegroups.com
            Date: Tuesday,
  April
    4,
      2017,
       8:01 AM
            
            
           
      
     
    
   
  
 
 --------------------
            On Tue, 4/4/17, 'Yu
    Spain'
      via
       MS EXCEL AND VBA
          MACROS
  

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-05 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Wed, 4/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Wednesday, April 5, 2017, 2:27 PM
 
 
 
 On Wed, 4/5/17, 'Margareta Tolliver'
 via MS EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Customized Inventory Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Wednesday, April 5, 2017, 7:21
 AM
  
  
 
 
  On Wed, 4/5/17, mintaspriggs via MS
  EXCEL AND VBA MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Customized Inventory Software Required
 in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Wednesday, April 5, 2017,
 6:25
  AM
   
   
  
 
 
   On Wed, 4/5/17, 'Hopkins Ruben'
 via
  MS
   EXCEL AND VBA MACROS 
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Customized Inventory Software
 Required
  in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Wednesday, April 5, 2017,
  5:28
   AM
    
    
   
  
 
 
    On Wed, 4/5/17, 'Carmelita
  Cronin'
   via
    MS EXCEL AND VBA MACROS 
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Customized Inventory Software
  Required
   in Excel VBA
     To: excel-macros@googlegroups.com
     Date: Wednesday, April 5,
 2017,
   4:19
    AM
     
     
    
   
  
 
 
     On Wed, 4/5/17, 'Margareta
   Tolliver'
     via MS EXCEL AND VBA MACROS
   
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re:
     Customized Inventory
 Software
   Required
    in Excel VBA
      To: excel-macros@googlegroups.com
      Date: Wednesday, April 5,
  2017,
    3:39
     AM
      
      
     
    
   
  
 
 
      On Wed, 4/5/17, 'Carmelita
    Cronin'
     via
      MS EXCEL AND VBA MACROS
  
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     Re:
      Customized Inventory
  Software
    Required
     in Excel VBA
       To: excel-macros@googlegroups.com
       Date: Wednesday, April 5,
   2017,
     1:26
      AM
       
       
      
     
    
   
  
 
 
       On Wed, 4/5/17, 'Kenyatta
   Freed'
     via
      MS
       EXCEL AND VBA MACROS
 
       wrote:
       
        Subject: Re:
    $$Excel-Macros$$
      Re:
       Customized Inventory
   Software
     Required
      in Excel VBA
        To: excel-macros@googlegroups.com
        Date: Wednesday, April 5,
    2017,
      1:15
       AM
        
        
       
      
     
    
   
  
 
 
        On Tue, 4/4/17,
  'Margareta
      Tolliver'
        via MS EXCEL AND VBA
  MACROS
      
        wrote:
        
         Subject: Re:
     $$Excel-Macros$$
       Re:
        Customized Inventory
    Software
      Required
       in Excel VBA
         To: excel-macros@googlegroups.com
         Date: Tuesday, April
 4,
     2017,
       9:37 PM
         
         
        
       
      
     
    
   
  
 
 
         On Tue, 4/4/17,
   mintaspriggs
     via
       MS
        EXCEL AND VBA MACROS
         
         wrote:
         
          Subject: Re:
      $$Excel-Macros$$
        Re: Customized Inventory
         Software Required in
   Excel
     VBA
          To: excel-macros@googlegroups.com
          Date: Tuesday, April
  4,
      2017,
        6:09 PM
          
          
         
       
      
     
    
   
  
 
 --------------------
          On Tue, 4/4/17, 'Yu
    Spain'
      via
        MS EXCEL AND VBA MACROS
          
          wrote:
          
           Subject: Re:
     $$Excel-Macros$$
       Re:
        Customized
         Inventory
          Software Required in
    Excel
      VBA
           To: excel-macros@googlegroups.com
           Date: Tuesday,
 April
   4,
     2017,
       10:38
        AM
           
           
          
       
      
     
    
   
  
 
 
           On Tue, 4/4/17,
     'Margareta
        Tolliver' via MS EXCEL
  AND
         VBA
           MACROS 
           wrote:
           
            Subject: Re:
      $$Excel-Macros$$
        Re: Customized
          Inventory
           Software Required
 in
     Excel
       VBA
            To: excel-macros@googlegroups.com
            Date: Tuesday,
  April
    4,
      2017,
        9:21 AM
            
            
           
       
      
     
    
   
  
 
 
            On Tue, 4/4/17,
     

Re: $$Excel-Macros$$ Re: Macros for screenshot

2017-04-08 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot
 To: excel-macros@googlegroups.com
 Date: Saturday, April 8, 2017, 7:49 PM
 
 
 
 On Sat, 4/8/17, 'Julienne Schindler'
 via MS EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Macros for screenshot
  To: excel-macros@googlegroups.com
  Date: Saturday, April 8, 2017, 8:18
 PM
  
  
 
 
  On Sat, 4/8/17, 'Karleen Biggs' via
 MS
  EXCEL AND VBA MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Macros for screenshot
   To: excel-macros@googlegroups.com
   Date: Saturday, April 8, 2017,
 5:28
  PM
   
   
  
 
 
   On Sat, 4/8/17, mintaspriggs via
 MS
   EXCEL AND VBA MACROS 
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Macros for screenshot
    To: excel-macros@googlegroups.com
    Date: Saturday, April 8, 2017,
  2:57
   PM
    
    
   
  
 
 
    On Sat, 4/8/17, 'Derrick Andrew'
  via
   MS
    EXCEL AND VBA MACROS 
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Macros for screenshot
     To: excel-macros@googlegroups.com
     Date: Saturday, April 8,
 2017,
   2:53
    PM
     
     
    
   
  
 
 
     On Sat, 4/8/17, 'Carmelita
   Cronin'
    via
     MS EXCEL AND VBA MACROS
 
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re:
     Macros for screenshot
      To: excel-macros@googlegroups.com
      Date: Saturday, April 8,
  2017,
    10:13
     AM
      
      
     
    
   
  
 
 
      On Sat, 4/8/17, priti verma
    
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     Re:
      Macros for screenshot
       To: excel-macros@googlegroups.com
       Date: Saturday, April 8,
   2017,
     9:03
      AM
       
       first you
       need to open that excel
 file
     and
      activate that particular
       excel file by using
      application.actiavte
  "workbbok
       name" and paste into
 excel
   file
     in
      desired
       range.
       On Fri, Mar 31, 2017 at
       4:40 PM, suresh k 
       wrote:
       Experts any inputs for
 the
     below
      requirement?
       On 23-Mar-2017 1:43
       pm, "suresh k" 
       wrote:
       Hi All,
       I have 10 files in my c
   drive. I
     have
      to
       capture other
 applications
     screenshot
      and paste in all 10
       files.
       I am able to capture
   screenshot,
     but
      not able
       to paste in 10 excel
 file.
       Please suggest macro to
   paste
      screenshot in all
       files
       Regards,
       
       Suresh
       
       
       
       
       -- 
       
       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

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-14 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Thu, 4/13/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Thursday, April 13, 2017, 7:02 PM
 
 
 
 On Thu, 4/13/17, 'Liberty Stringer' via
 MS EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Thursday, April 13, 2017, 4:49
 PM
  
  
 
 
  On Thu, 4/13/17, Paul Schreiner 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: "excel-macros@googlegroups.com"
  
   Date: Thursday, April 13, 2017,
 2:49
  PM
   
   Here's
   the approach I took:I
   defined a "public" Dictionary
 object
  called
   Dict_Category.I
   created a function to load the
  Dict_Category with the
   category listing from the
 "DATA"
  sheet.
   Being
   a "public" variable, the values
 are
  retained while
   the workbook is open.
   I
   created two worksheet
 
 events:Worksheet_SelectionChangeWorksheet_Change
   I
   created two events so that the
  Comments update when the cell
   is selected, and also if you
 were to
  copy/paste several
   cells into column "A".
   Personally,
   I think the Change event is the
 only
  one that is
   required.
   The
   Update_Comments function does
 things
  like:-
   Clears the comments from cells
 that
  are blank-
   Shows a message if a value is
 entered
  that is not in the
   Dictionary
   hope this gives you something to
 work
   from.
   
  
 
 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 Thursday, April 13, 2017
  5:26 AM,
   sunil lobo 
  wrote:
     
   
    hi [U][SIZE=5]just want to
   have comments populate when the
 cell
  is selected based on
   the lookup/vlookup function
 through
   VB[/SIZE][/U]two sheet 1)
 master_sheet
   2
   )data sheet masters sheet
 being
   dynamic data sheet is
   staticmaster sheet continuosly
   changing now when  a
 particular cell
  is
   activated by using mouse or
   keyboard comments should
 pop-up
  getting
    the value from the next data
  sheet 
   eg: master sheet , cell a2= 1 
                  
           cell a3=2 
                  
           cell a4=4so on and
 so
   forth 
   in data sheet , cell a2= 5 ,
 cell b2=
   present           
                 a3=2, cell
   b3= absent         
                   a4=
   3,cell b4= leave        
                  
       a5= 1, cell b5= leftnow
 when i
   select a3 cell in master_sheet i
 need
  to populate a comment
   as [B]absent[/B], when the cell
 a3
  changes to value [B]1[/B]
   i should get a comment display
 of
  value
   [B]left[/B]also when the cell
 value
  changes it
   chsould clear the previous
  comment basically
   it should popup comments based
 on the
  value from the data
   sheet !:)
   attaching herewith the sample
 data for
  ur
   reference
   
   
   
   -- 
   
   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 for

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
 To: excel-macros@googlegroups.com
 Date: Thursday, June 1, 2017, 6:30 PM
 
 
 
 On Thu, 6/1/17, Paul Schreiner 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Need
 help in Macro to convert table into dump.
  To: "excel-macros@googlegroups.com"
 
  Date: Thursday, June 1, 2017, 4:47 PM
  
  There
  is no standard format for "Raw
 Data".It
  depends on the original Application
 used to CREATE the
  source of data.Some
  systems output ASCII (text) files
 Some
  are tab delimited.Others
  are comma delimited (csv).
  The
  mechanism you used to read in the "raw
 data" used
  known characteristics of the data to
 determine how it is to
  be interpreted.
  Without
  knowing the characteristics of the
 "raw data", it
  would be impossible to
 reverse-engineer the file.
  It's
  like saying:  "I'm standing outside
 of my home,
  tell me how I got here"The
  answer requires first knowing where
 you started and what
  options are available to get from the
 start to the
  end.Lots
  of options are AVAILABLE, but if your
 starting point is two
  streets away, the use of an airplane
 is unlikely.
  Teleportation is WAY cooler, and
 should remain in
  consideration for that reason! :)
  More
  details are
 required. 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 Thursday, June 1,
  2017 10:20 AM, Secret Shot 
  wrote:
    
  
   Dear Team,
  I have one very large excel table
  which i made from Raw data,
 accidentally raw data has been
  deleted and the only option i have is
 that table to convert
  back in raw data.
  Its
  about my job so pls help, i have
 attached of the sample of
  what i am talking about. if anyone can
 me in writing a macro
  which can create raw data basis on the
 count in front of
  number and considering their header.
   
  
  Please help
  -- 
  Pankaj Pandey
  Bhopal
  
  
  
  
  -- 
  
  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

Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA

2017-06-23 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Fri, 6/23/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back 
ground : Richmond VA
 To: excel-macros@googlegroups.com
 Date: Friday, June 23, 2017, 4:53 PM
 
 
 
 On Fri, 6/23/17, Paul Schreiner 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Urgent
 Opening for Ab-initio with AWS JAVA back ground : Richmond
 VA
  To: "excel-macros@googlegroups.com"
 
  Date: Friday, June 23, 2017, 1:20 AM
  
  Sir:
   I realize you are new...But
  if you read the Forum RULES, #4
 specifically
  states:4)
  Jobs posting is not allowed.
  I
  have nearly 100 users that I've had to
 block from my
  email because they joined for the sole
 purpose of
  head-hunting.That's
  not what this site is about and not
 why I joined the site
  and I resent spending the time
 managing my blocked email
  list when I could be helping users
 with legitimate
  issues.
  If
  you are in need of assistance with
 Excel macros, then
  welcome!If
  you're looking for employees, well it
 ought to make a
  potential employee wonder if he/she
 can trust a company that
  cannot be bothered to follow the
 rules...
  Just
  an observation...
 
 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 Thursday, June 22,
  2017 5:39 PM, Kamal Paul 
  wrote:
    
  
   Hi
  All ,i have an urgent Opening for
  ab-initio with Java Back ground.
 please find the details for
  the Position and Reply me if you have
 available consultant
  for the same.
  
   Title : Ab-nitio with AWS
  java 
  Job
  Type : Contractual
  location : Richmond
  VADuration : 6 months
   
  
  
  
  
  
  
  
  · Work involves
 transferring
  from DDE to AWS using Ab Initio –
 Need candidates with
  strong Ab Initio background with java
  skills· Need folks
 with AWS
  knowledge with scripting  to create
 infrastructure, should
  have Java background 
  
  
   Kamal
  PaulTechnical
  Recruiter (Desk):610-590-1511 
  Gtalk : recruiter.kp...@gmail.com
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any
  loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscr...@googlegroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at
 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.
  
 

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Tue, 7/4/17, Puttu *  wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: "MS EXCEL AND VBA MACROS" 
 Date: Tuesday, July 4, 2017, 10:03 AM
 
 Thanks Sir, Formula match exactly my
 requirement, however I have more than 50 columns, quite
 difficult to input formula for every column. Thus the reason
 I am looking for macro.
 
 Please help
 
 On Tue, Jul 4, 2017 at
 11:21 AM, Swapnil Palande 
 wrote:
 Hi,
 
 No need of macro, you can do it using
 formulas also. Attached is the excel for your reference.
 
 Regards,
 Swapnil
 On Tue, Jul 4, 2017 at
 10:36 AM, Puttu * 
 wrote:
 Experts, Any help on this will be much appreciated
 
 
 On Mon, Jul 3, 2017 at
 10:33 PM, Puttu * 
 wrote:
 Hi Experts
 
 Please help on this.
 
 Thanks
 Putta
 
 On Mon,
 Jul 3, 2017 at 9:42 PM, Puttu * 
 wrote:
 Hi Experts,
 
 I am not a vba expert
 and need your help me on the attached requirement. 
 
 I have list of columns
 and from that I need to know based on the Model No. column
 filter if the other columns have any duplicate values, if
 yes then it should display comments column as Column Name
 + duplicate value (Ex: Category_description having duplicate
 value)
 
 2. If the
 any of the column is blank it should print Column Name is
 blank (Ex: Parent Category ID has blank value).
 
 Attached is the sample
 spread sheet. Please review and help me on it.
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 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@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 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@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 
 
 -- 
 
 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 recei

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS


On Sun, 7/30/17, 'Martinez David' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Help on Week Formula
 To: excel-macros@googlegroups.com
 Date: Sunday, July 30, 2017, 8:42 PM
 
 
 
 On Sun, 7/30/17, 'Hopkins Ruben' via MS
 EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Help on
 Week Formula
  To: excel-macros@googlegroups.com
  Date: Sunday, July 30, 2017, 3:31 PM
  
  
 
 
  On Sun, 7/30/17, Chandra Shekar 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Help on
  Week Formula
   To: excel-macros@googlegroups.com
   Date: Sunday, July 30, 2017,
 2:57 PM
   
   Hello
   Paul,
   For Ex: If I
   mention date as 07/01/2017(Sat)
  formula should give Week 1
   from there every week it should
  increase by 1.1)
   07-01-2017 to 07-07-2017 =
 Week12)
  22-01-2017 to
   28-07-2017 = Week43) 29-07-2017
 -
  04-08-2017 =
   Week5
   Regards,
   Chandru
   On Tue, Jul 25, 2017 at
   4:31 PM, Paul Schreiner 
   wrote:
   I
   think you'll need to be more
 specific
  on how you want
   the "weeks" calculated.For
   instance, in
 August (2017) August 1
  is on  a
   Tuesday.
   so,
   the weeks are handled:
   
   but,
   July 1 is on a Saturday,so,
   does Week 1 only have a single
 day?
   Or
   is July 1 counted as part of
 week 5 of
  June.If
   so, what is the minimum number
 of days
  counted in a week
   1?
   Or
   are you wanting a simple count
 of
  days:Week
   1 = first 7 daysWeek
   2 = Second 7 daysetc.
  
  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 Tuesday, July 25, 2017
 3:34
  AM,
   Chandra Shekar 
   wrote:
     
   
    Hello Team,
   Could you please help me in
 attached
   week formula.
   Regards,
   Chandru
   
   
   
   -- 
   
   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/
   gr

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

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


On Wed, 12/20/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS 
 wrote:

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

Re: $$Excel-Macros$$ Re: concatenate in one cell

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


On Sat, 12/30/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell
 To: excel-macros@googlegroups.com
 Date: Saturday, December 30, 2017, 10:18 AM
 
 
 
 On Fri, 12/29/17, 'Kenyatta Freed' via
 MS EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 concatenate in one cell
  To: excel-macros@googlegroups.com
  Date: Friday, December 29, 2017, 3:34
 AM
  
  
 
 
  On Thu, 12/28/17, N.Shivkumar 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  concatenate in one cell
   To: excel-macros@googlegroups.com
   Date: Thursday, December 28,
 2017,
  8:14 AM
   
   see attached solution
   
   
   
    
    
    
    
    
   
    
   
   
   
   
   
   On 25 December 2017 at
   14:35, Aamir Shahzad 
   wrote:
   this is manual formula &
   need select cells one by one I
 want to
  use entire range e.g.
   A1:HL1
   On Mon,
   Dec 25, 2017 at 4:40 AM, who
 
   wrote:
  
 
 =trim(C4)&trim(D4)&trim(E4)&tr
   im(F4)&trim(G4)
   Try the above,
   assuming the data is in the
 addresses
   used.
   Thanks,
   David
   
   On
   Saturday, December 23, 2017 at
 1:39:57
  AM UTC-8, Aamir
   Shahzad wrote:Friends,
   I want to concatenate all below
   data in one cell without any
 space.
  Formula please. 
   
   data148351,183776,032290,
   result148351,183776,032290 
   Regards,
   
   Aamir Shahzad
   
   
   
   
   
   
   
   
   
   -- 
   
   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/discu
   ssexcel
   
    
   
   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@googl
   egroups.com.
   
   To post to this group, send
 email to
  excel-macros@googlegroups.com.
   
   Visit this group at https://groups.google.com/grou
   p/excel-macros.
   
   For more options, visit https://groups.google.com/d/op
   tout.
   
   
   
   
   -- 
   
   
   
   Regards,Aamir Shahzad
   
   
   
   
   
   
   
   
   -- 
   
   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
 n