from:"karleenbiggs via MS EXCEL AND VBA MACROS"

Re: $$Excel-Macros$$ Data moving from one file to other as required

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

On Tue, 3/21/17, JAYAVELU SUN  wrote:

 Subject: Re: $$Excel-Macros$$ Data moving from one file to other as required
 To: excel-macros@googlegroups.com
 Cc: "Vaibhav Joshi - Mumbai Excel" , "Paul Schreiner - USA 
Excel" , "De Premor - Indonesia Excel" 
, "The Viper - Chennai Excel" , 
"Ms-Exl-Learner - Chennai" , "Don Guillett - Excel" 

 Date: Tuesday, March 21, 2017, 12:07 PM

 On Tue, Feb 7, 2017 at
 11:40 AM, Pravin Gunjal 
 wrote:
 Hi Friends
 Greetings!
 I have attached two files
 viz. Sample Source & Sample Target.I want 3 columns data from
 source file to target file in columns H, I &
 J.
 This has to be done based on
 "Invoice No." column.
 (If the invoice no. comes
 more than one in next row then "Material" should
 be added with comma, whereas "Doctor Name" &
 "Patient Name" should come only once for an
 invoice)
 e.g. I have taken up the
 data for Invoice No.8137000290 from source file to
 target.
 Could you please help me to
 get it done with any VB / Formula.

 With regards,
 Pravin Gunjal

 -- 

 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.

 -- 
 JAYAVELU
 9710847899

 -- 

 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.
 imparat Carolde Habsburg  si refacerea in fapt a Ungariei milenare.

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

Re: $$Excel-Macros$$ book for excel

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

On Mon, 3/20/17, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ book for excel
 To: excel-macros@googlegroups.com
 Date: Monday, March 20, 2017, 10:53 AM

 On Mon, 3/20/17, georgemartin812 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ book for excel
  To: excel-macros@googlegroups.com
  Date: Monday, March 20, 2017, 3:36 AM

  On Mon, 3/20/17, julienneschindler via MS EXCEL AND VBA
  MACROS 
  wrote:

   Subject: Re: $$Excel-Macros$$ book for excel
   To: excel-macros@googlegroups.com
   Date: Monday, March 20, 2017, 2:16 AM

   On Mon, 3/20/17, mintaspriggs via MS EXCEL AND VBA
 MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ book for excel
    To: excel-macros@googlegroups.com
    Date: Monday, March 20, 2017, 1:43 AM

    On Sun, 3/19/17, margaretatolliver via MS EXCEL AND
  VBA
    MACROS 
    wrote:

     Subject: Re: $$Excel-Macros$$ book for excel
     To: excel-macros@googlegroups.com
     Date: Sunday, March 19, 2017, 10:27 PM

     On Sun, 3/19/17, libertystringer via MS EXCEL AND
   VBA
    MACROS

     wrote:

      Subject: Re: $$Excel-Macros$$ book for excel
      To: excel-macros@googlegroups.com
      Date: Sunday, March 19, 2017, 7:54 PM

      On Sun, 3/19/17, 'Izhar Ul Haq' via MS EXCEL AND
  VBA
     MACROS

      wrote:

       Subject: Re: $$Excel-Macros$$ book for excel
       To: "excel-macros@googlegroups.com"

       Date: Sunday, March 19, 2017, 4:12 PM

       There
       are so many books from which you may learn
 excel,
   and
     so
       many example from the internet from which you
 may
     learn
       excel, there is no comprehensive book from
 which
   you
     may
       learn a lot.

         From: Cori

        To: MS EXCEL AND VBA
       MACROS 

        Sent: Friday, March 17,
       2017 3:42 PM
        Subject:
       $$Excel-Macros$$ book for excel

       Can you
       suggest a book for excel

       -- 

       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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

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

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

 Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as 
per date
 To: excel-macros@googlegroups.com
 Date: Friday, March 17, 2017, 1:50 PM

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

  Subject: Re: $$Excel-Macros$$ How to pick rental on
 pro-rata/monthly basis as per date
  To: excel-macros@googlegroups.com
  Date: Friday, March 17, 2017, 11:41 AM

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

   Subject: Re: $$Excel-Macros$$ How to pick rental on
  pro-rata/monthly basis as per date
   To: excel-macros@googlegroups.com
   Date: Friday, March 17, 2017, 9:44 AM

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

    Subject: Re: $$Excel-Macros$$ How to pick rental on
   pro-rata/monthly basis as per date
    To: excel-macros@googlegroups.com
    Date: Friday, March 17, 2017, 9:17 AM

    Dear Paul,

    I want to
    formula in one column not month-wise separately.

    Please guide
    me!

    On Fri, Mar 17, 2017 at
    12:44 PM, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
    wrote:
    Dear Team,

    I want to pick
    rental pro-rata/monthly as per purchasing date.

    Pro-rata  -
    If purchasing date after 1st then rental will be
   calculated
    days-wise(count)

    monthly - If
    purchasing date 1st then rental will be paid full.

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

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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

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

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

 Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as 
per date
 To: excel-macros@googlegroups.com
 Date: Friday, March 17, 2017, 11:41 AM

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

  Subject: Re: $$Excel-Macros$$ How to pick rental on
 pro-rata/monthly basis as per date
  To: excel-macros@googlegroups.com
  Date: Friday, March 17, 2017, 9:44 AM

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

   Subject: Re: $$Excel-Macros$$ How to pick rental on
  pro-rata/monthly basis as per date
   To: excel-macros@googlegroups.com
   Date: Friday, March 17, 2017, 9:17 AM

   Dear Paul,

   I want to
   formula in one column not month-wise separately.

   Please guide
   me!

   On Fri, Mar 17, 2017 at
   12:44 PM, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
   wrote:
   Dear Team,

   I want to pick
   rental pro-rata/monthly as per purchasing date.

   Pro-rata  -
   If purchasing date after 1st then rental will be
  calculated
   days-wise(count)

   monthly - If
   purchasing date 1st then rental will be paid full.

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

   -- 
   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.
   8 21   ian. - Romania ia parte 
  la  deschiderea lucrarilor Conferintei de pace de la
  Paris.

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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

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

On Fri, 3/17/17, derrickandrew994 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as 
per date
 To: excel-macros@googlegroups.com
 Date: Friday, March 17, 2017, 9:44 AM

 On Fri, 3/17/17, Sunil Kumar Yadav 
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick rental on
 pro-rata/monthly basis as per date
  To: excel-macros@googlegroups.com
  Date: Friday, March 17, 2017, 9:17 AM

  Dear Paul,

  I want to
  formula in one column not month-wise separately.

  Please guide
  me!

  On Fri, Mar 17, 2017 at
  12:44 PM, Sunil Kumar Yadav 
  wrote:
  Dear Team,

  I want to pick
  rental pro-rata/monthly as per purchasing date.

  Pro-rata  -
  If purchasing date after 1st then rental will be
 calculated
  days-wise(count)

  monthly - If
  purchasing date 1st then rental will be paid full.

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

  -- 
  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.
  8 21   ian. - Romania ia parte 
 la  deschiderea lucrarilor Conferintei de pace de la
 Paris.

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

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 karleenbiggs via MS EXCEL AND VBA MACROS



On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA MACROS 
 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 
 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 
  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
   
   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
    
    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
     
     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
      
      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 
       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" 
        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 
        wrote:

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

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

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

 Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
 To: excel-macros@googlegroups.com
 Date: Friday, March 10, 2017, 8:27 AM

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

  Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
 Priority
  To: excel-macros@googlegroups.com
  Date: Friday, March 10, 2017, 4:10 AM

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

   Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
  Priority
   To: excel-macros@googlegroups.com
   Date: Friday, March 10, 2017, 3:32 AM

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

    Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
   Priority
    To: excel-macros@googlegroups.com
    Date: Friday, March 10, 2017, 3:04 AM

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

     Subject: Re: $$Excel-Macros$$ Fwd: Need your Help
 on
    Priority
     To: excel-macros@googlegroups.com
     Date: Friday, March 10, 2017, 1:34 AM

     On Fri, 3/10/17, keisha.fry via MS EXCEL AND VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:

      Subject: Re: $$Excel-Macros$$ Fwd: Need your Help
  on
     Priority
      To: excel-macros@googlegroups.com
      Date: Friday, March 10, 2017, 12:17 AM

      On Thu, 3/9/17, Mohd Sadiq <mohdsadiq...@gmail.com>
      wrote:

       Subject: Re: $$Excel-Macros$$ Fwd: Need your
 Help
   on
      Priority
       To: "Pankaj Sharma" <pankaj123...@gmail.com>
       Cc: excel-macros@googlegroups.com
       Date: Thursday, March 9, 2017, 4:54 PM

       Hello
       Pankaj ,
       Pls response
       as I need to closed it asap.
       Regards,Sadiq979223

       On Wed,
       Mar 8, 2017 at 6:50 PM, Mohd Sadiq <mohdsadiq...@gmail.com>
       wrote:
       Pls response ?
       On Tue, Mar 7, 2017 at 7:00
       PM, Mohd Sadiq <mohdsadiq...@gmail.com>
       wrote:
       Dear Pankaj ,
       Sorry for delayed response as I was
       on leave.
       Here is
       attached one more resolution for the same but
 when
   I
     am
       trying to put same formula in another sheet
 then
   it
     does
      not
       working Specially when I'm putting in Night
       Shift.
       Pls look into
       this and let me know what should I do now.

       PN-
       Column highlighted in Yellow/Orange color.
       Thanks

       On Thu, Mar 2, 2017 at 7:46
       AM, Pankaj Sharma <pankaj123...@gmail.com>
       wrote:
       resolved
       PJ            

         MIS
       Analyst
           Greater Kailash-1, New
       Delhi.
       Instagram  pj_sharma_Tweeter 
        dude_sharma_pj
       Facebook   www.facebook.com/pankajesica1
       43pankajesica143
         We meet
       for a reason, either you're a blessing or a
       lesson...

       On
       Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq
 <mohdsadiq...@gmail.com>
       wrote:
       Here is the attached Sample Sheet,  Hope u
 can
       understand when u will see it :)
       On Tue, Feb 28, 2017 at
       11:37 PM, Mohd Sadiq <mohdsadiq...@gmail.com>
       wrote:
       Firstly Unhide the sheet , and  I need Shift
       wise Staffing / Present basis of business
 shift
   which
     is
       mentioned in "A" column 
       I had made Normal some / Split shift
       details in shared shift however I m getting
 error
   in
     Night
       Shift when I m trying to used same formula .
       Regards,Sadiq979223
       On Tue,
       Feb 28, 2017 at 9:52 PM, Pankaj Sharma <pankaj123...@gmail.com>
       wrote:
       Didn't get your query, what you want to do in
       this sheet, pls mention example with result.
       PJ            

         MIS
       Analyst
           Greater Kailash-1, New
       Delhi.
       Instagram  pj_sharma_Tweeter 
        dude_sharma_pj
       Facebook   www.facebook.com/dude.pj  We
 meet
       for a reason, either you're a blessing or a
       lesson...

       On

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

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

On Fri, 3/10/17, libertystringer via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
 To: excel-macros@googlegroups.com
 Date: Friday, March 10, 2017, 1:34 AM

 On Fri, 3/10/17, keisha.fry via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
 Priority
  To: excel-macros@googlegroups.com
  Date: Friday, March 10, 2017, 12:17 AM

  On Thu, 3/9/17, Mohd Sadiq 
  wrote:

   Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
  Priority
   To: "Pankaj Sharma" 
   Cc: excel-macros@googlegroups.com
   Date: Thursday, March 9, 2017, 4:54 PM

   Hello
   Pankaj ,
   Pls response
   as I need to closed it asap.
   Regards,Sadiq979223

   On Wed,
   Mar 8, 2017 at 6:50 PM, Mohd Sadiq 
   wrote:
   Pls response ?
   On Tue, Mar 7, 2017 at 7:00
   PM, Mohd Sadiq 
   wrote:
   Dear Pankaj ,
   Sorry for delayed response as I was
   on leave.
   Here is
   attached one more resolution for the same but when I
 am
   trying to put same formula in another sheet then it
 does
  not
   working Specially when I'm putting in Night
   Shift.
   Pls look into
   this and let me know what should I do now.

   PN-
   Column highlighted in Yellow/Orange color.
   Thanks

   On Thu, Mar 2, 2017 at 7:46
   AM, Pankaj Sharma 
   wrote:
   resolved
   PJ            

     MIS
   Analyst
       Greater Kailash-1, New
   Delhi.
   Instagram  pj_sharma_Tweeter 
    dude_sharma_pj
   Facebook   www.facebook.com/pankajesica1
   43pankajesica143
     We meet
   for a reason, either you're a blessing or a
   lesson...

   On
   Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq 
   wrote:
   Here is the attached Sample Sheet,  Hope u can
   understand when u will see it :)
   On Tue, Feb 28, 2017 at
   11:37 PM, Mohd Sadiq 
   wrote:
   Firstly Unhide the sheet , and  I need Shift
   wise Staffing / Present basis of business shift which
 is
   mentioned in "A" column 
   I had made Normal some / Split shift
   details in shared shift however I m getting error in
 Night
   Shift when I m trying to used same formula .
   Regards,Sadiq979223
   On Tue,
   Feb 28, 2017 at 9:52 PM, Pankaj Sharma 
   wrote:
   Didn't get your query, what you want to do in
   this sheet, pls mention example with result.
   PJ            

     MIS
   Analyst
       Greater Kailash-1, New
   Delhi.
   Instagram  pj_sharma_Tweeter 
    dude_sharma_pj
   Facebook   www.facebook.com/dude.pj  We meet
   for a reason, either you're a blessing or a
   lesson...

   On
   Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq 
   wrote:
   Hello Team ,

   Hope you are doing
   well,

   Here is attached a file
   where I need Interval / Day wise
   staffing which is mentioned in “H” Column, I am
 trying
   it multiple times to fixed
   Night Shift issue but unfortunately I’m not
 getting
   resolution L

   Request you to Pls help on the same
   on priority.

   Regards
   Mohd Sadiq

   -- 

   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

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

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

On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
 To: excel-macros@googlegroups.com
 Date: Thursday, March 2, 2017, 11:58 AM

 On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS 

 wrote:

  Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
 Priority
  To: excel-macros@googlegroups.com
  Date: Thursday, March 2, 2017, 8:34 AM

  On Thu, 3/2/17, keisha.fry via MS EXCEL AND VBA MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
  Priority
   To: excel-macros@googlegroups.com
   Date: Thursday, March 2, 2017, 7:20 AM

   On Thu, 3/2/17, hopkinsruben865 via MS EXCEL AND VBA
  MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
   Priority
    To: excel-macros@googlegroups.com
    Date: Thursday, March 2, 2017, 6:12 AM

    On Thu, 3/2/17, margaretatolliver via MS EXCEL AND
  VBA
    MACROS 
    wrote:

     Subject: Re: $$Excel-Macros$$ Fwd: Need your Help
 on
    Priority
     To: excel-macros@googlegroups.com
     Date: Thursday, March 2, 2017, 6:08 AM

     On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA
   MACROS

     wrote:

      Subject: Re: $$Excel-Macros$$ Fwd: Need your Help
  on
     Priority
      To: excel-macros@googlegroups.com
      Date: Thursday, March 2, 2017, 5:17 AM

      On Thu, 3/2/17, Pankaj Sharma 
      wrote:

       Subject: Re: $$Excel-Macros$$ Fwd: Need your
 Help
   on
      Priority
       To: excel-macros@googlegroups.com
       Date: Thursday, March 2, 2017, 4:16 AM

       resolved
       PJ        

         MIS
       Analyst
           Greater
       Kailash-1, New Delhi.
       Instagram  pj_sharma_Tweeter 
        dude_sharma_pj
       Facebook 
      www.facebook.com/pankajesica143pankajesica143
         We meet
       for a reason, either you're a blessing or a
       lesson...

       On Tue, Feb 28, 2017 at
       11:43 PM, Mohd Sadiq 
       wrote:
       Here is the attached Sample Sheet,  Hope u
 can
       understand when u will see it :)
       On Tue, Feb 28, 2017 at
       11:37 PM, Mohd Sadiq 
       wrote:
       Firstly Unhide the sheet , and  I need Shift
       wise Staffing / Present basis of business
 shift
   which
     is
       mentioned in "A" column 
       I had made Normal some / Split shift
       details in shared shift however I m getting
 error
   in
     Night
       Shift when I m trying to used same formula .
       Regards,Sadiq979223
       On Tue,
       Feb 28, 2017 at 9:52 PM, Pankaj Sharma 
       wrote:
       Didn't get your query, what you want to do in
       this sheet, pls mention example with result.
       PJ            

         MIS
       Analyst
           Greater Kailash-1, New
       Delhi.
       Instagram  pj_sharma_Tweeter 
        dude_sharma_pj
       Facebook   www.facebook.com/dude.pj  We
 meet
       for a reason, either you're a blessing or a
       lesson...

       On
       Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq 
       wrote:
       Hello Team ,

       Hope you are doing
       well,

       Here is attached a file
       where I need Interval / Day wise
       staffing which is mentioned in “H” Column,
 I
   am
     trying
       it multiple times to fixed
       Night Shift issue but unfortunately I’m not
     getting
       resolution L

       Request you to Pls help on the same
       on priority.

       Regards
       Mohd Sadiq

       -- 

       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

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-24 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Fri, 2/24/17, margaretatolliver via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
 To: excel-macros@googlegroups.com
 Date: Friday, February 24, 2017, 11:57 AM
 
 
 
 On Fri, 2/24/17, storeythomas725 via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not
 looping
  To: excel-macros@googlegroups.com
  Date: Friday, February 24, 2017, 11:44 AM
  
  
  
  On Fri, 2/24/17, keisha.fry via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: Once IF is met it
 is not
  looping
   To: excel-macros@googlegroups.com
   Date: Friday, February 24, 2017, 9:21 AM
   
   
   
   On Fri, 2/24/17, mintaspriggs via MS EXCEL AND VBA
 MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: Once IF is met it
  is not
   looping
    To: excel-macros@googlegroups.com
    Date: Friday, February 24, 2017, 3:56 AM
    
    
    
    On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA
  MACROS
    
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: Once IF is met
 it
   is not
    looping
     To: excel-macros@googlegroups.com
     Date: Friday, February 24, 2017, 12:59 AM
     
     
     
     On Thu, 2/23/17, storeythomas725 via MS EXCEL AND
   VBA
    MACROS
     
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: Once IF is met
  it
    is not
     looping
      To: excel-macros@googlegroups.com
      Date: Thursday, February 23, 2017, 8:50 PM
      
      
      
      On Thu, 2/23/17, martinez.david533 via MS EXCEL
  AND
    VBA
      MACROS 
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: Once IF is
 met
   it
     is not
      looping
       To: excel-macros@googlegroups.com
       Date: Thursday, February 23, 2017, 2:56 PM
       
       
       
       On Thu, 2/23/17, silvers.r via MS EXCEL AND
 VBA
     MACROS
       
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Re: Once IF is
  met
    it
      is not
       looping
        To: excel-macros@googlegroups.com
        Date: Thursday, February 23, 2017, 7:11 AM
        
        
        
        On Wed, 2/22/17, keisha.fry via MS EXCEL AND
  VBA
      MACROS
        
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Re: Once IF
 is
   met
     it
       is not
        looping
         To: excel-macros@googlegroups.com
         Date: Wednesday, February 22, 2017, 6:21 PM
         
         
        
 
         On Wed, 2/22/17, georgemartin812 via MS
 EXCEL
   AND
       VBA
        MACROS
         
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Re: Once IF
  is
    met
      it
        is not
         looping
          To: excel-macros@googlegroups.com
          Date: Wednesday, February 22, 2017, 11:52
  AM
          
          
         
  
          On Wed, 2/22/17, hopkinsruben865 via MS
  EXCEL
    AND
        VBA
         MACROS
          
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Re: Once
 IF
   is
     met
       it
         is not
          looping
           To: excel-macros@googlegroups.com
           Date: Wednesday, February 22, 2017,
 10:38
   AM
           
           
          
   
           On Wed, 2/22/17, spainy via MS EXCEL AND
   VBA
       MACROS
         
           wrote:
           
            Subject: Re: $$Excel-Macros$$ Re: Once
  IF
    is
      met
        it
          is not
           looping
            To: excel-macros@googlegroups.com
            Date: Wednesday, February 22, 2017, 9:46
  AM
            
            
           
    
            On Wed, 2/22/17, silvers.r via MS EXCEL
  AND
      VBA
          MACROS
            
            wrote:
            
             Subject: Re: $$Excel-Macros$$ Re:
 Once
   IF
     is
       met
         it
           is not
            looping
             To: excel-macros@googlegroups.com
             Date: Wednesday, February 22, 2017,
 7:40
   AM

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

2017-02-16 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Thu, 2/16/17, keisha.fry via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding 
weekends with Business hours 9 AM to 8 PM)
 To: excel-macros@googlegroups.com
 Date: Thursday, February 16, 2017, 5:54 PM
 
 
 
 On Thu, 2/16/17, Chandra Shekar 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Difference between
 times(Including and excluding weekends with Business hours 9
 AM to 8 PM)
  To: excel-macros@googlegroups.com
  Date: Thursday, February 16, 2017, 3:46 PM
  
  Hello
  Paul,
  Thanks a lot.
  Its working fine.
  
  Regards,
  Chandru
  On Wed, Feb 15, 2017 at
  8:21 PM, Paul Schreiner 
  wrote:
  There
  are several ways to approach this.Here's
  the logic I used:first:
  Excel
  date is stored as a number. (the number of days since
  1/1/1900)Excel
  TIME is stored as the decimal part of a day.so, the
  date/time: 19/11/2016 12:10 PM  is actually
  42693.50694Excel
  allows you to DISPLAY this value in a variety of ways, but
  it doesn't change the value.
  That
  means that to determine the time of day without regard to
  the date, you must subtract the "integer" portion
  of the value.
  Now,
  if you worked from Monday, 2-Feb to Friday, 10-Feb, you
  expect the result to show you worked 5 days.However,
  simply subtracting day #42772 from day #42776 gives you a
  DIFFERENCE of 4 instead of 5!So,
  you have to be careful with date arithmetic...
  Excel
  provides two functions:NetworkdaysNetworkdays.intl
  Networkdays.intl
  provides a means to define which days are your
  "weekend".(some
  people may work Thu-Fri-Sat-Sun-Mon and have Tuesday and
  Wednesday off for their "weekend")This
  also provides a means to say ALL days are workdays!
  (thereby, "including weekends").
  In
  the file attached, I created a sheet with Named Ranges for
  Start_Time, End_Time and HolidayListYou
  can add/remove dates to this HolidayList as appropriate to
  your needs.
  The
  logic is to first calculate the number of workdays between
  the Start date and End data.=NETWORKDAYS.INTL($A2,$B2,"
  011",HolidayList)Now,
  the End_Time - Start_Time gives you the fractional part of
 a
  day that represents a "full" workday.Multiplying
  this times the number of workdays results in the number of
  hours if full days are worked.
  This
  number needs to be adjusted based on the actual start/end
  time.If
  the start or end day is on a weekend, then the actual
  start/end time is disregarded.IF(WEEKDAY($A2,2)>5,0
  Otherwise,
  for the start time, subtract the actual start time (A2 -
  int(A2)) from the scheduled
  "Start_Time".Now,
  if the person started BEFORE the scheduled start time,
 this
  value will be negative and should be disregarded. (unless
  you wish to calculate "overtime", or allow for a
  person to come in 30 minutes early and leave 30 minutes
  early?)
  so,
  to use only positive numbers, you can use:
  MAX(($A2-INT($A2))-Start_Time, 0)
  For
  End time, the arithmetic is reversed:
  MAX(End_Time-($B2-INT($B2)),0)
  So,
  calculating the full working days, and removing the
  adjustments for start/end time, you
 get:=NETWORKDAYS.INTL($A2,$B2,"
  011",HolidayList)*(End_ Time-Start_Time)
  -(IF(WEEKDAY($A2,2)>5,0,MAX($
  A2-INT($A2)-Start_Time,0)))
  -(IF(WEEKDAY($B2,2)>5,0,MAX(
  End_Time-($B2-INT($B2)),0)))
  But
  if you wish to use it as a number of hours, you'll need
  to multiply it by 24.
  To
  calculate these values and INCLUDE weekends, simply change
  the Networkdays.Intl formula to include "000"
  and remove the IF(WEEKDAY(
 test:=NETWORKDAYS.INTL($A2,$B2,"
  000",HolidayList)*(End_ Time-Start_Time)
  -(MAX($A2-INT($A2)-Start_Time,
  0))
  -(MAX(End_Time-($B2-INT($B2)),
  0))
  Note:
  What
  this technique does NOT do is check to see if the Start or
  End date is one of the listed holidays.Nor
  does it account for any time outside of the core
  "Business Hours".
  Hope
  this helps.
  
  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 Wednesday,
  February 15, 2017 7:17 AM, Chandra Shekar 
  wrote:
    
  
   Hello,
  Needed difference between
  times(Including and excluding weekends with Business hours
  from 9AM to 8PM)
  Could
  you help me on this attachment.
  
  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

Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!

2017-02-10 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Fri, 2/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection 
of web page list!!!
 To: excel-macros@googlegroups.com
 Date: Friday, February 10, 2017, 8:02 AM

 On Fri, 2/10/17, RamiZ Majid 
 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick one webpage each
 from a collection of web page list!!!
  To: "Kishore P V K" 
  Cc: excel-macros@googlegroups.com
  Date: Friday, February 10, 2017, 7:47 AM

  Thanks
  bro!!!
  It
  worked.
  On Fri, Feb 10, 2017 at
  2:09 AM, Kishore P V K 
  wrote:
  Here is the simple solution for your
  requirement:
  Insert a new
  column before the URL column:

  Enter
  the formula as showed in A2 column below

  after
  enter the formula in A2 drag the column till the URL
 values.
  Then you will find the all domain names in the column A as
  per the below screen shot

  Then
  select the required columns and go to DATA ribbon and
 select
  "Remove duplicates" option when option comes just
  select the newly created column A (Domain)

  Then
  click OK.  There you go:

  Hope
  this helps you !!!
  Cheers

  On Thu, Feb 9, 2017 at 3:34 AM, Ramiz
  Majid 
  wrote:
  I
  have a list of webpages contacting different domain
  pages!!!

  I want to pick a single webpage
  of each domains
  Please help !
  This is an example
  list: 

  And I need this as
  .

  Thanks!

  -- 

  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 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.
  83617 febr. - CraGovia  Polonia  este ocupata de
 trupele ruse  austriece si prusace. - Independenta
 Texasului  care se rupe de Mexic. 29
 30   oct.   -   incercarea 
   lui    Ludovic Napoleon de a prelua puterea
 in Franta.

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

Re: $$Excel-Macros$$ Help Required

2017-01-22 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Sun, 1/22/17, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Help Required
 To: excel-macros@googlegroups.com
 Date: Sunday, January 22, 2017, 6:29 PM

 On Sat, 1/21/17, sriram ji 
 wrote:

  Subject: Re: $$Excel-Macros$$ Help Required
  To: excel-macros@googlegroups.com
  Date: Saturday, January 21, 2017, 12:24 PM

  Thank you so much
   Saleem Ansari.
  File working fine and also i need same format
  splitup in master file. i attached the file. Kindly help
  me..
  Thank in advance.
  Thanks & Regards,Sriram
  G
  On Thu, Jan 12, 2017
  at 6:35 PM, Saleem Ansari 
  wrote:
  Dear
  Friend,
  Please
  check & Confirm
  if any
  query plz revert
  Regards,
  Saleem Ansari
  On Thu, Jan 12, 2017
  at 2:13 PM, sriram ji 
  wrote:
  Hi Excel Guru,
  Kindly help me the below attached
  file,
  Thanks in advance.
  Thanks  & Regards,Sriram
  G 

  -- 

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

Re: $$Excel-Macros$$ something wrong with the attach macro

2017-01-20 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Sat, 1/21/17, martinez.david533 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ something wrong with the attach macro
 To: excel-macros@googlegroups.com
 Date: Saturday, January 21, 2017, 7:01 AM
 
 
 
 On Sat, 1/21/17, libertystringer via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ something wrong with the
 attach macro
  To: excel-macros@googlegroups.com
  Date: Saturday, January 21, 2017, 6:08 AM
  
  
  
  On Sat, 1/21/17, kenyattafreed via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ something wrong with
 the
  attach macro
   To: excel-macros@googlegroups.com
   Date: Saturday, January 21, 2017, 2:29 AM
   
   
   
   On Fri, 1/20/17, spainy via MS EXCEL AND VBA MACROS
 
   wrote:
   
    Subject: Re: $$Excel-Macros$$ something wrong with
  the
   attach macro
    To: excel-macros@googlegroups.com
    Date: Friday, January 20, 2017, 11:37 PM
    
    
    
    On Fri, 1/20/17, storeythomas725 via MS EXCEL AND
  VBA
   MACROS
    
    wrote:
    
     Subject: Re: $$Excel-Macros$$ something wrong
 with
   the
    attach macro
     To: excel-macros@googlegroups.com
     Date: Friday, January 20, 2017, 6:38 PM
     
     
     
     On Fri, 1/20/17, georgemartin812 via MS EXCEL AND
   VBA
    MACROS
     
     wrote:
     
      Subject: Re: $$Excel-Macros$$ something wrong
  with
    the
     attach macro
      To: excel-macros@googlegroups.com
      Date: Friday, January 20, 2017, 4:53 PM
      
      
      
      On Fri, 1/20/17, silvers.r via MS EXCEL AND VBA
    MACROS
      
      wrote:
      
       Subject: Re: $$Excel-Macros$$ something wrong
   with
     the
      attach macro
       To: excel-macros@googlegroups.com
       Date: Friday, January 20, 2017, 4:19 PM
       
       
       
       On Fri, 1/20/17, keisha.fry via MS EXCEL AND
 VBA
     MACROS
       
       wrote:
       
        Subject: Re: $$Excel-Macros$$ something wrong
    with
      the
       attach macro
        To: excel-macros@googlegroups.com
        Date: Friday, January 20, 2017, 3:57 PM
        
        
        
        On Fri, 1/20/17, julienneschindler via MS
  EXCEL
    AND
      VBA
        MACROS 
        wrote:
        
         Subject: Re: $$Excel-Macros$$ something
 wrong
     with
       the
        attach macro
         To: excel-macros@googlegroups.com
         Date: Friday, January 20, 2017, 10:15 AM
         
         
        
 
         On Thu, 1/19/17, storeythomas725 via MS
 EXCEL
   AND
       VBA
        MACROS
         
         wrote:
         
          Subject: Re: $$Excel-Macros$$ something
  wrong
      with
        the
         attach macro
          To: excel-macros@googlegroups.com
          Date: Thursday, January 19, 2017, 3:56 PM
          
          
         
  
          On Thu, 1/19/17, GENIUS 
          wrote:
          
           Subject: Re: $$Excel-Macros$$ something
   wrong
       with
         the
          attach macro
           To: "MS EXCEL AND VBA MACROS" 
           Cc: schreiner_p...@att.net
           Date: Thursday, January 19, 2017, 9:06
 AM
           
           That's
           working for me as well, thank you
           
           
           
           -- 
           
           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)

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Wed, 1/18/17, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ converting sheet to macro
 To: excel-macros@googlegroups.com
 Date: Wednesday, January 18, 2017, 6:13 PM

 On Wed, 1/18/17, Paul Schreiner 
 wrote:

  Subject: Re: $$Excel-Macros$$ converting sheet to macro
  To: "excel-macros@googlegroups.com"

  Date: Wednesday, January 18, 2017, 4:37 PM

  So,
  you're saying that you're trying to learn how to
  write macros and you'd like us to write a macro that
  would take the list in columns A:F and create the list in
  columns I:L?
  The
  problem with that is that you're asking us to take the
  "input" (columns A:F) and compare it to the output
  (columns I:L) and "guess" what criteria was used
  to get the result. 
  On
  top of that, you have the fields being randomly
  generated!
  so,
  I cannot tell what the original input data was to even
 BEGIN
  to guess what criteria is used to determine
  output.
  I'm
  sorry, but I'm not sure where to begin.
  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, January
  17, 2017 10:57 PM, GENIUS 
  wrote:

   sometime when
  you have to learn a new function or formula, for this
  purpose one must have a file on which the same function or
  formula must be applied so I need a data set for my
 learning
  about a new function or new formula, I have created it
 thru
  function but the same I want to create thru macro, so
 would
  you please make the same file thru macro.

  -- 

  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.
  ramantari si rascoale taranesti  1888-1907 .
 Framantarile si agitatiile ranimii  al caror punct
 culminant l-au reprezentat rascoalele  au pus in lumina
 ontradictiile din sanul societatii romanesti in pragul
 secolului al XX-lea si au onstituit forme de actiune

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-12 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
 To: excel-macros@googlegroups.com
 Date: Friday, January 13, 2017, 9:05 AM
 
 
 
 On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address
 formula
  To: excel-macros@googlegroups.com
  Date: Friday, January 13, 2017, 6:48 AM
  
  
  
  On Fri, 1/13/17, amar takale 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Index+Match+Indirect+Address
  formula
   To: excel-macros@googlegroups.com
   Date: Friday, January 13, 2017, 6:20 AM
   
   
   
   Dear Paul Sir
   Good Morning
   Sorry for Late reply.
   
   
    
   
   Actually Index match is as
   per my thinking formula it not
   fix for this situation , you can also give another
 formula
   or option. I am
   thinking index match formula match criteria field
 like
  year
   & net sales
   & address find sheet name. So I ask for that.
 which I
   attached index
   formula file for only your reference sheet where
 index
   match+indirect formula
   extract data but internal sheet only & I want
 extract
  it
   external workbooks
   in folder.
   
    
   
   Step
   
   1)  Extract
   All sheet from software in folder & next time
 only
   overwrite on it if any
   updation.
   
   2)  Create
   One output sheet in folder where more than 100 sheets
 data
   extract
   fieldwise,yearwise & worksheets wise through
 formula
  OR
   VBA.
   
   3)  Suggest
   formula or VBA
   
    
   
    
   
   Regards
   
   Amar
   
    
   
   
   On Thu, Jan 12, 2017 at
   2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS
 
   wrote:
   
   
   -- --
   
   On Thu, 1/12/17, storeythomas725
   via MS EXCEL AND VBA MACROS  wrote:
   
   
   
    Subject: Re: $$Excel-Macros$$
  Index+Match+Indirect+Address
   formula
   
    To: excel-macros@googlegroups.com
   
    Date: Thursday, January 12, 2017, 3:26 AM
   
   
   
   
   
    -- --
   
    On Wed, 1/11/17, Paul Schreiner 
   
    wrote:
   
   
   
     Subject: Re: $$Excel-Macros$$
   Index+Match+Indirect+Address
   
    formula
   
     To: "excel-macros@googlegroups.com
   "
   
    
   
     Date: Wednesday, January 11, 2017, 3:56 PM
   
   
   
     OK.
   
     It
   
     sounds like you're saying that you have some
   
     reporting software that generates a report
   
     file.But
   
     evidently I don't understand what it is you're
   
     trying to do.
   
     Can
   
     you describe it step-by-step with examples?What
   
     does the file generated by your software look
   
     like?what do you do with it?
   
     I have the two files you sent originally, but I
   
     don't see what information is common between the
   two
   
     files,so I don't know how you get from the
   
     "Index-Match" file to the "output"
   
     file. 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, January 10, 2017 11:48
   
     PM, amar takale 
   
    wrote:
   
   
   
   
   
      Dear Paul
   
   
   
     Good Morning.
   
   
   
     Exact explanation by you
   
     regarding my issue.Required field (like net
   sales,Share
   
     capital,cash) extract after match year & show
 in
   
    output
   
     sheet.
   
   
   
     And also one
   
     thing that there are no need to open 100 sheet
 bcos
   all
   
     sheet extract from our software with same format
 (only
   
    field
   
     up & down if any issue otherwise same
 format).Once
   
     output sheet prepared with formula OR VBA in
 folder
   then
   
     next time all sheet extract from software &
   overwrite
   
    on
   
     it in same folder so data update 100 sheet
   automatically
   
     from software.No required to check updation of
 each
   
     sheet.
   
   
   
     Pls suggest
   
     formula OR VBA.Send example sheet.
   
   
   
     Other two members group try to
   
     solution my issue but I cant understand their
   language.
   
   
   
     Regards
   
     Amar
   
   
   
   
   
     On Wed, Jan 11, 2017 at
   
     9:04 AM, martinez.david533 via MS EXCEL AND VBA
 MACROS

Re: $$Excel-Macros$$ Help Required

2017-01-12 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Help Required
 To: excel-macros@googlegroups.com
 Date: Thursday, January 12, 2017, 10:55 PM

 On Thu, 1/12/17, julienneschindler via MS EXCEL AND VBA
 MACROS 
 wrote:

  Subject: Re: $$Excel-Macros$$ Help Required
  To: excel-macros@googlegroups.com
  Date: Thursday, January 12, 2017, 10:45 PM

  On Thu, 1/12/17, georgemartin812 via MS EXCEL AND VBA
 MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ Help Required
   To: excel-macros@googlegroups.com
   Date: Thursday, January 12, 2017, 8:43 PM

   On Thu, 1/12/17, spainy via MS EXCEL AND VBA MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ Help Required
    To: excel-macros@googlegroups.com
    Date: Thursday, January 12, 2017, 8:00 PM

    On Thu, 1/12/17, martinez.david533 via MS EXCEL AND
  VBA
    MACROS 
    wrote:

     Subject: Re: $$Excel-Macros$$ Help Required
     To: excel-macros@googlegroups.com
     Date: Thursday, January 12, 2017, 7:47 PM

     On Thu, 1/12/17, Saleem Ansari 
     wrote:

      Subject: Re: $$Excel-Macros$$ Help Required
      To: excel-macros@googlegroups.com
      Date: Thursday, January 12, 2017, 3:06 PM

      Dear Friend,
      Please check &
      Confirm
      if any query plz revert
      Regards,
      Saleem
      Ansari
      On Thu, Jan 12, 2017 at
      6:35 PM, Saleem Ansari 
      wrote:
      Dear
      Friend,
      Please
      check & Confirm
      if any query plz revert
      Regards,
      Saleem
      Ansari
      On Thu, Jan 12, 2017 at
      2:13 PM, sriram ji 
      wrote:
      Hi Excel Guru,
      Kindly help me the below attached
      file,
      Thanks in
      advance.
      Thanks
       & Regards,Sriram G 

      -- 

      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  :

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-10 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Tue, 1/10/17, cronincarmelita via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files
 To: excel-macros@googlegroups.com
 Date: Tuesday, January 10, 2017, 10:39 AM

 On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA
 MACROS 
 wrote:

  Subject: Re: $$Excel-Macros$$ How to use Index Match for
 two different files
  To: excel-macros@googlegroups.com
  Date: Tuesday, January 10, 2017, 10:29 AM

  On Tue, 1/10/17, hopkinsruben865 via MS EXCEL AND VBA
 MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ How to use Index Match
 for
  two different files
   To: excel-macros@googlegroups.com
   Date: Tuesday, January 10, 2017, 9:34 AM

   On Mon, 1/9/17, Devendra Sahay 
   wrote:

    Subject: Re: $$Excel-Macros$$ How to use Index Match
  for
   two different files
    To: excel-macros@googlegroups.com
    Date: Monday, January 9, 2017, 6:23 PM

    Paul, I mean to say first
    occurrence of the order id. 
    On Jan 9, 2017 9:51
    PM, "Paul Schreiner" 
    wrote:
    First
    occurrence of... what?First
    occurrence of the  Order ID?customer
    ID?
    Is
    the data already sorted in the order by which you
  want to
    determine "first occurrence"?

    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 Monday, January 9, 2017 11:06 AM,
    Devendra Sahay  wrote:

     Paul,
    Thanks for your reply. Can we extract the details of
  first
    occurrence. there might be some issues with the
  sample
    data, always the data will be unique and
    clean.
    On
    Jan 9, 2017 8:36 PM, "Paul Schreiner" 
    wrote:
    I'm
    not sure what RESULT you're expecting.
    For instance, Order ID #CA-2014-AB10015140-41954
    has two entries in the "Dump.xlsx" file.Row 40098 is
   identical to row 40099 except for the
    Product related data (ID, Category, Sub-Cat, Name,
  Sales,
   Profit,
    Shipping)
    So, what do you wish to record in the
    Workbook2.xlsx file?
    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 Saturday,
    January 7, 2017 10:42 PM, Devendra Sahay  wrote:

     Hi Team,
    Sorry for posting such a long query on the forum,
    but am working on few reports in which I have to
  write the
    Index match formula multiple times on daily basis. So
  am
    thinking to write a macro for this but as I am new to
  VBA,
    am not able to do so. If you guys can help me out
  here,
    would be really appreciated. 
    Scenario- 
    I have a dump file with the record in the columns
    & rows with headers. I have a another file in
  which I
    want to extract the details from the dump file in
  the
    respect of header & the value. The value (It
    could be number or the text), of which details I want
  to
    pull from dump file, always be in the first column in
  the
    workbook. and also the headers will be also the same
  in
   both
    workbook for easily map the data.

    Required Solution- 
    Code needs to be written in the workbook 2,where
    i want to map the values from dump. When I hit the
  run
   macro
    button, macro will open a dialogue box to select the
  file
    & after selecting the file, It starts the mapping
  of
    values. 
    Sharing both sample files, Dump & the
    Workbook2. 

    -- 

    With Regards !!!Devendra

    -- 

    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

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-09 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Mon, 1/9/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files
 To: "excel-macros@googlegroups.com" 
 Date: Monday, January 9, 2017, 7:48 PM

 Take
 a look at the macros attached.See
 if it looks like what you envisioned, or at least gives you
 a starting point.
 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 Monday, January 9, 2017 11:23 AM,
 Devendra Sahay  wrote:

  Paul, I mean to say first
 occurrence of the order id. 
 On Jan 9, 2017 9:51 PM,
 "Paul Schreiner"  wrote:
 First
 occurrence of... what?First
 occurrence of the  Order ID?customer
 ID?
 Is
 the data already sorted in the order by which you want to
 determine "first occurrence"?

 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 Monday, January 9, 2017 11:06 AM,
 Devendra Sahay 
 wrote:

  Paul,
 Thanks for your reply. Can we extract the details of first
 occurrence. there might be some issues with the
 sample data, always the data will be unique and
 clean.
 On
 Jan 9, 2017 8:36 PM, "Paul Schreiner"  wrote:
 I'm
 not sure what RESULT you're expecting.
 For instance, Order ID #CA-2014-AB10015140-41954
 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 
except for the
 Product related data (ID, Category, Sub-Cat, Name, Sales, Profit,
 Shipping)
 So, what do you wish to record in the
 Workbook2.xlsx file?
 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 Saturday,
 January 7, 2017 10:42 PM, Devendra Sahay 
 wrote:

  Hi Team,
 Sorry for
 posting such a long query on the forum, but am working on
 few reports in which I have to write the Index match formula
 multiple times on daily basis. So am thinking to write a
 macro for this but as I am new to VBA, am not able to do so.
 If you guys can help me out here, would be really
 appreciated. 
 Scenario- 
 I have a dump file with the record
 in the columns & rows with headers. I have a another
 file in which I want to extract the details from the dump
 file in the respect of header & the
 value. The value (It could be number or the
 text), of which details I want to pull from dump file,
 always be in the first column in the workbook. and also the
 headers will be also the same in both workbook for easily
 map the data.

 Required
 Solution- 
 Code
 needs to be written in the workbook 2,where i want to map
 the values from dump. When I hit the run macro button, macro
 will open a dialogue box to select the file & after
 selecting the file, It starts the mapping of
 values. 
 Sharing
 both sample files, Dump & the
 Workbook2. 

 -- 

 With Regards
 !!!Devendra

 -- 

 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

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Fri, 1/6/17, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste
 To: excel-macros@googlegroups.com
 Date: Friday, January 6, 2017, 2:27 AM

 On Fri, 1/6/17, storeythomas725 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste
  To: excel-macros@googlegroups.com
  Date: Friday, January 6, 2017, 12:49 AM

  On Thu, 1/5/17, georgemartin812 via MS EXCEL AND VBA
 MACROS

  wrote:

   Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy
 Paste
   To: excel-macros@googlegroups.com
   Date: Thursday, January 5, 2017, 10:25 PM

   On Thu, 1/5/17, spainy via MS EXCEL AND VBA MACROS

   wrote:

    Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy
  Paste
    To: excel-macros@googlegroups.com
    Date: Thursday, January 5, 2017, 6:55 PM

    On Thu, 1/5/17, derrickandrew994 via MS EXCEL AND
  VBA
   MACROS

    wrote:

     Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy
   Paste
     To: excel-macros@googlegroups.com
     Date: Thursday, January 5, 2017, 2:13 PM

     On Thu, 1/5/17, ileanakeating via MS EXCEL AND
 VBA
   MACROS

     wrote:

      Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy
    Paste
      To: excel-macros@googlegroups.com
      Date: Thursday, January 5, 2017, 12:53 PM

      On Thu, 1/5/17, silvers.r via MS EXCEL AND VBA
    MACROS

      wrote:

       Subject: Re: Fwd: $$Excel-Macros$$ Macro for
 Copy
     Paste
       To: excel-macros@googlegroups.com
       Date: Thursday, January 5, 2017, 12:02 PM

       On Thu, 1/5/17, Shrinivas Shevde 
       wrote:

        Subject: Re: Fwd: $$Excel-Macros$$ Macro for
  Copy
      Paste
        To: excel-macros@googlegroups.com
        Date: Thursday, January 5, 2017, 11:32 AM

        Dear Paul
        Thanks for replyPlease find detila you
        asked forThere will be seperate summary sheet
        which contain folowingPlease find attached
        sheetThanks once again  for great
        Help
        RegardsShrinivas

        On Wed, Jan 4, 2017 at
        7:52 PM, Paul Schreiner 
        wrote:
        This
        can be easily done.I
        recently created a "Combined Summary" report
    that
        opened over 500 files in subfolders and
  copied
    160
       columns
        of data from a variable number of rows on the
        "Summary" sheet of each workbook to the
        "combined" workbook.Resulting
        in over 2700 rows of data.Since
        the files weren't large, it took slightly over
  5
      minutes
        to run.

        It
        should be simple to do what you want, but how
  do
    you
      want
        the final report to look?The values in cells
       E3,F5,E8,E9 from the file in
        folder AA should appear... where?The values
  in
      cells
       E3,F5,E8,E9 from the file in
        folder BB should appear... where? on the
  same
        sheet?
        Can you send me a couple of samples of
        what the files look like and what you want the
      summary
       sheet
        to look like?

        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 Wednesday, January 4, 2017 1:16
        AM, Shrinivas Shevde 
        wrote:

         Dear FriendsWaiting for
        reply
        --
        Forwarded message --
        From: Shrinivas
        Shevde 
        Date: Tue, Jan 3, 2017 at 4:55 PM
        Subject: $$Excel-Macros$$ Macro for Copy Paste
        To: excel-macros@googlegroups.com

        Dear AllI want a macro for
        following can Anyone help me.
        I have a folder ,which contain many folder,In
        each folder there are excel file(File having
      single
        sheet) .I want to copy

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

2016-12-28 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Thu, 12/29/16, Sushil Kumar  wrote:

 Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel 
template
 To: excel-macros@googlegroups.com
 Date: Thursday, December 29, 2016, 6:53 AM
 
 I have one crm
 system if you want share with you access
 information 
 On Dec 29, 2016 10:04 AM,
 "margaretatolliver via MS EXCEL AND VBA MACROS"
 
 wrote:
 
 
 -- --
 
 On Thu, 12/29/16, amar takale 
 wrote:
 
 
 
  Subject: Re: $$Excel-Macros$$ CRM (Customer relationship
 management ) excel template
 
  To: excel-macros@googlegroups.com
 
  Date: Thursday, December 29, 2016, 6:19 AM
 
 
 
  Dear
 
  Sir
 
 
 
  
 
 
 
  Can you send me Example
 
  excel Sheet.
 
 
 
  On Thu, Dec 29, 2016 at
 
  6:52 AM, cronincarmelita via MS EXCEL AND VBA MACROS
 
 
  wrote:
 
 
 
 
 
  -- --
 
 
 
  On Thu, 12/29/16,
 
  martinez.david533 via MS EXCEL AND VBA MACROS  wrote:
 
 
 
 
 
 
 
   Subject: Re: $$Excel-Macros$$ CRM (Customer
 relationship
 
  management ) excel template
 
 
 
   To: excel-macros@googlegroups.com
 
 
 
   Date: Thursday, December 29, 2016, 2:57 AM
 
 
 
 
 
 
 
 
 
 
 
   - - --
 
 
 
   On Thu, 12/29/16, storeythomas725 via MS EXCEL AND
 VBA
 
 
 
   MACROS 
 
 
 
   wrote:
 
 
 
 
 
 
 
    Subject: Re: $$Excel-Macros$$ CRM (Customer
 
  relationship
 
 
 
   management ) excel template
 
 
 
    To: excel-macros@googlegroups.com
 
 
 
    Date: Thursday, December 29, 2016, 2:10 AM
 
 
 
 
 
 
 
 
 
 
 
    -- --
 
 
 
    On Wed, 12/28/16, mintaspriggs via MS EXCEL AND VBA
 
  MACROS
 
 
 
    
 
 
 
    wrote:
 
 
 
 
 
 
 
     Subject: Re: $$Excel-Macros$$ CRM (Customer
 
 
 
   relationship
 
 
 
    management ) excel template
 
 
 
     To: excel-macros@googlegroups.com
 
 
 
     Date: Wednesday, December 28, 2016, 5:57 PM
 
 
 
    
 
 
 
    
 
 
 
     -- --
 
 
 
     On Wed, 12/28/16, amar takale 
 
 
 
     wrote:
 
 
 
    
 
 
 
      Subject: Re: $$Excel-Macros$$ CRM (Customer
 
 
 
    relationship
 
 
 
     management ) excel template
 
 
 
      To: excel-macros@googlegroups.com
 
 
 
      Date: Wednesday, December 28, 2016, 12:46 PM
 
 
 
     
 
 
 
      Sir,
 
 
 
      which Language
 
 
 
     
 
 
 
       I cant understand.Can you translate in english.
 
 
 
     
 
 
 
      On Wed, Dec 28, 2016 at
 
 
 
      3:17 PM, julienneschindler via MS EXCEL AND VBA
 
 
 
    MACROS
 
 
 
     
 
 
 
      wrote:
 
 
 
     
 
 
 
     
 
 
 
      -- --
 
 
 
     
 
 
 
      On Wed, 12/28/16,
 
 
 
      ashleypartridge via MS EXCEL AND VBA MACROS  wrote:
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
       Subject: Re: $$Excel-Macros$$ CRM (Customer
 
 
 
    relationship
 
 
 
      management ) excel template
 
 
 
     
 
 
 
       To: excel-macros@googlegroups.com
 
 
 
     
 
 
 
       Date: Wednesday, December 28, 2016, 10:41 AM
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
       - - --
 
 
 
     
 
 
 
       On Wed, 12/28/16, amar takale 
 
 
 
     
 
 
 
       wrote:
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
        Subject: Re: $$Excel-Macros$$ CRM (Customer
 
 
 
      relationship
 
 
 
     
 
 
 
       management ) excel template
 
 
 
     
 
 
 
        To: excel-macros@googlegroups.com
 
 
 
     
 
 
 
        Date: Wednesday, December 28, 2016, 6:44 AM
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
        Dear Friends
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
        Any Ides?
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
        On Tue, Dec 27, 2016
 
 
 
     
 
 
 
        at 10:02 AM, amar takale 
 
 
 
     
 
 
 
        wrote:
 
 
 
     
 
 
 
        Dear All Friends,
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
        Goog Morning
 
 
 
     
 
 
 
     
 
 
 
     
 
 
 
        Can anyone send me CRM (Customer
 
 
 
     
 
 
 
        relationship management ) excel template
 
 
 
    (customer
 
 
 
     
 
 
 
        discussion date by date & their follow up
 
 
 
      discussion)
 
 
 
     
 
 
 
       in
 
 
 
     
 
 
 
        excel.With
 
 
 
     
 
 
 
        the goal of improving business relationships
 
  with
 
 
 
     
 
 
 
       customers.
 
 
 
     
 
 
 
        I know this is not possible in excel due to
 many
 
 
 
      issue.But
 
 
 
     
 
 
 
       I
 
 
 
     
 
 
 
        try to do something

Re: $$Excel-Macros$$ REminder: Mail Charts via Vba Macro!

2016-12-26 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Mon, 12/26/16, keisha.fry via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ REminder: Mail Charts via Vba Macro!
 To: excel-macros@googlegroups.com
 Date: Monday, December 26, 2016, 3:48 PM

 On Mon, 12/26/16, Mohd Sadiq 
 wrote:

  Subject: Re: $$Excel-Macros$$ REminder: Mail Charts via Vba
 Macro!
  To: excel-macros@googlegroups.com
  Date: Monday, December 26, 2016, 2:41 PM

  hey , Did u get the
  file ?
  On Tue, Dec 6, 2016 at
  9:38 AM, Chand, Satish 
  wrote:

  Thank you so
  much for your reply..
  Please share a
  file in which you have use this
  coding..!

  From: excel-macros@googlegroups.com
  [mailto:excel-macros@
  googlegroups.com]
  On Behalf Of Soumyendu Paul

  Sent: Tuesday, December 06, 2016 7:09 AM

  To: excel-macros@googlegroups.com

  Subject: Re: $$Excel-Macros$$ REminder: Mail Charts
  via Vba Macro!

  Save the chart as an image
  and insert the image in mail body

  On Mon, Dec 5, 2016 at
  12:28 PM, sourav devrani 
  wrote:

  let me try
  sir

  On Thu, Dec 1, 2016 at
  12:06 PM, Chand, Satish 
  wrote:

  Yet Not Recvd any
  response…
  Please help on this
  matter

  From: Chand, Satish

  Sent: Friday, November 25, 2016 9:07 PM

  To: 'excel-macros@googlegroups.com
  ' 

  Subject: Mail Charts via Vba Macro!

  Hello
  Friend,

  I have a sheet in which
  multiple 3 charts as below screen shot.
  I want a macro for mail in
  which only copy all charts in mail body and
  send.

  Regards

  Satish
  Chand

  -- 

  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) ! 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,

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS

l 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, December 13, 2016
  1:45
      AM,
               karleenbiggs via MS EXCEL AND VBA
   MACROS
       <excel-macros@googlegroups.com
               > wrote:

               --
               --
               On Tue, 12/13/16,
               ileanakeating via MS EXCEL AND VBA
     MACROS
         <excel-macros@googlegroups.com
               > wrote:

                Subject: Re:
               $$Excel-Macros$$ Excel Sheet Hide
 and
       Unhide
                To: excel-macros@googlegroups.com
                Date: Tuesday, December 13, 2016,
    8:27
      AM

               --
       --
                On Tue, 12/13/16, Vijayendra Rao
    <vijayendrar...@gmail.com>
                wrote:

               Subject: Re: $$Excel-Macros$$
 Excel
     Sheet
       Hide
           and
             Unhide
                 To: excel-macros@googlegroups.com
                 Date: Tuesday, December 13,
 2016,
     3:50
       AM

                 Thanks Paul for quick
                 help, it fulfilled my most of
 the
               requirement. One last
                 favor, Now while
               opening last saved sheet only
 visible
     and

               guidelines sheet is hide , is it
     possible
       to
         view
             only
                first
                 sheet (sheet name
               read) of the file.
                 Regards,Vijayendra
                 2016-12-12 18:52

               GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
                 There's
                 nothing that
               is "automatic".
                 Attached
                 uses a Workbook_open
 event macro
   to
       hide
               the sheets when
                 you OPEN the document.
                 That way, it doesn't matter
   whether
               the
                 sheets are visible or not when
 the
               file is saved, but
                 it will hide the
               sheets when it's opened.

                 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 Monday, December 12, 2016
   7:50
     AM,
                 karleenbiggs via MS EXCEL AND
 VBA
     MACROS
               <excel-macros@googlegroups.com
                 > wrote:

               --
       --
                 On Mon, 12/12/16, Vijayendra
 Rao
     <vijayendrar...@gmail.com>
                 wrote:

                 Subject: Re: $$Excel-Macros$$
   Excel
       Sheet
         Hide
             and
                Unhide
                  To: excel-macros@googlegroups.com
                  Date: Monday, December 12,
  2016,
    2:43
      PM

                  Thanks Paul for
               quick
                  guidance.
                  This
               file is used by many people and
 they
   are

               working without reading few
   guidelines
     from
         first
                sheet.
                  There may be
               chances of not using the
 sheet_hide

               macro
                  option by other user. Is there
  any
               macros which
                  automatically hide those
               sheets when close the file.
                  Attached is
               the my workbook.
                  Regards,Vijayendra
                  2016-12-12 17:46

               GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
                  Just
                  as you created a
               macro to "unhide" the sheets,

               you
                  need to create a macro to hide
               them.
                  Additionally,

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-13 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Wed, 12/14/16, cronincarmelita via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Wednesday, December 14, 2016, 3:14 AM

 On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Wednesday, December 14, 2016, 2:51 AM

  On Wed, 12/14/16, ileanakeating via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:

   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Wednesday, December 14, 2016, 12:37 AM

   On Tue, 12/13/16, Paul Schreiner <schreiner_p...@att.net>
   wrote:

    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: "excel-macros@googlegroups.com"
   <excel-macros@googlegroups.com>
    Date: Tuesday, December 13, 2016, 2:11 PM

    I'd
    suggest changing the HideAllSheets macro to first
    display the "read" sheet (what you
    called "guidelines"?)then hide everything EXCEPT
  the
   "read"
    sheet.
    Like:
    Sub HideAllSheets()

    Dim wsSheet As Worksheet

    Sheets("read").Visible = True

    For Each wsSheet In ActiveWorkbook.Worksheets

    If wsSheet.Name <> "read" Then

    wsSheet.Visible = xlSheetHidden

    End If

    Next wsSheet
    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 Tuesday, December 13, 2016 1:45
    AM, karleenbiggs via MS EXCEL AND VBA MACROS
    <excel-macros@googlegroups.com>
   wrote:

    On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA
   MACROS
    <excel-macros@googlegroups.com>
    wrote:

     Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
 and
   Unhide
     To: excel-macros@googlegroups.com
     Date: Tuesday, December 13, 2016, 8:27 AM

     On Tue, 12/13/16, Vijayendra Rao <vijayendrar...@gmail.com>
     wrote:

      Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
  and
    Unhide
      To: excel-macros@googlegroups.com
      Date: Tuesday, December 13, 2016, 3:50 AM

      Thanks Paul for quick
      help, it fulfilled my most of the requirement.
  One
    last
      favor, Now while opening last saved sheet only
    visible and
      guidelines sheet is hide , is it possible to view
    only
     first
      sheet (sheet name read) of the file.
      Regards,Vijayendra
      2016-12-12 18:52
      GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
      There's
      nothing that is "automatic".
      Attached
      uses a Workbook_open event macro to hide
    the sheets when
      you OPEN the document.
      That way, it doesn't matter whether the
      sheets are visible or not when the file is saved,
    but
      it will hide the sheets when it's opened.

      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 Monday, December 12, 2016 7:50 AM,
      karleenbiggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com
      > wrote:

      -- --
      On Mon, 12/12/16, Vijayendra Rao <vijayendrar...@gmail.com>
      wrote:

       Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
   and
     Unhide
       To: excel-macros@googlegroups.com
       Date: Monday, December 12, 2016, 2:43 PM

       Thanks Paul for quick
       guidance.
       This file is used by many people and they are
       working without reading few guidelines from
 first
     sheet.
       There may be chances of not using the
 sheet_hide
     macro
       option by other user. Is there any macros
 which
       automatically hide those sheets when close the
    file.
       Attached is the my workbook.
       Regards,Vijayendra
       2

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-12 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 13, 2016, 8:27 AM

 On Tue, 12/13/16, Vijayendra Rao <vijayendrar...@gmail.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Tuesday, December 13, 2016, 3:50 AM

  Thanks Paul for quick
  help, it fulfilled my most of the requirement. One last
  favor, Now while opening last saved sheet only visible and
  guidelines sheet is hide , is it possible to view only
 first
  sheet (sheet name read) of the file.
  Regards,Vijayendra
  2016-12-12 18:52
  GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
  There's
  nothing that is "automatic".
  Attached
  uses a Workbook_open event macro to hide the sheets when
  you OPEN the document.
  That way, it doesn't matter whether the
  sheets are visible or not when the file is saved, but
  it will hide the sheets when it's opened.

  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 Monday, December 12, 2016 7:50 AM,
  karleenbiggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com
  > wrote:

  -- --
  On Mon, 12/12/16, Vijayendra Rao <vijayendrar...@gmail.com>
  wrote:

   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Monday, December 12, 2016, 2:43 PM

   Thanks Paul for quick
   guidance.
   This file is used by many people and they are
   working without reading few guidelines from first
 sheet.
   There may be chances of not using the sheet_hide
 macro
   option by other user. Is there any macros which
   automatically hide those sheets when close the file.
   Attached is the my workbook.
   Regards,Vijayendra
   2016-12-12 17:46
   GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
   Just
   as you created a macro to "unhide" the sheets,
  you
   need to create a macro to hide them.
   Additionally,
   you can create a BeforeSave event to check to see if
 the
   sheets are displayed.Then
   execute your "Sheets_Hide" macro to hide the
   sheets before saving (that
   way the sheets are always hidden before saving the
   file)
   Note:
   Using a macro, you can use .Visible =
 xlVeryHiddenwhich
  will hide the sheets and they will not show
   up when trying to manually unhide the sheets!
   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 Monday, December 12, 2016 7:04 AM, Vijayendra
   Rao <vijayendrar...@gmail.com>
   wrote:

    Hi Experts,
   I have created one excel file and except one
   sheet all sheets are hided. I have added shape button
 in
   first sheet to unhide all the sheets with the help
 of
  macro.
   When i worked and saved all sheets will be visible
 when I
   opened again. Is it possible to remain hide those
 sheets
   after saving the file.
   Request you to help on the same.-- 

   Regards,
   Vijayendra
   94491 67631

   -- 

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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-12 Thread karleenbiggs via MS EXCEL AND VBA MACROS

On Mon, 12/12/16, Vijayendra Rao  wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Monday, December 12, 2016, 2:43 PM

 Thanks Paul for quick
 guidance.
 This file is used by many people and they are
 working without reading few guidelines from first sheet.
 There may be chances of not using the sheet_hide macro
 option by other user. Is there any macros which
 automatically hide those sheets when close the file.
 Attached is the my workbook.
 Regards,Vijayendra
 2016-12-12 17:46
 GMT+05:30 Paul Schreiner :
 Just
 as you created a macro to "unhide" the sheets, you
 need to create a macro to hide them.
 Additionally,
 you can create a BeforeSave event to check to see if the
 sheets are displayed.Then
 execute your "Sheets_Hide" macro to hide the
 sheets before saving (that
 way the sheets are always hidden before saving the
 file)
 Note:
 Using a macro, you can use .Visible = xlVeryHiddenwhich will hide the sheets 
and they will not show
 up when trying to manually unhide the sheets!
 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 Monday, December 12, 2016 7:04 AM, Vijayendra
 Rao 
 wrote:

  Hi Experts,
 I have created one excel file and except one
 sheet all sheets are hided. I have added shape button in
 first sheet to unhide all the sheets with the help of macro.
 When i worked and saved all sheets will be visible when I
 opened again. Is it possible to remain hide those sheets
 after saving the file.
 Request you to help on the same.-- 

 Regards,
 Vijayendra
 94491 67631

 -- 

 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.

 -- 
 ಧನ್ಯವಾದಗಳು,
 ವಿಜಯೇಂದ್ರ,
 ೯೪೪೯೧ ೬೭೬೩೧

 Regards,
 Vijayendra
 94491 67631

 -- 

 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

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-11 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Sun, 12/11/16, margaretatolliver via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Sunday, December 11, 2016, 9:36 AM
 
 
 
 On Sun, 12/11/16, kenyattafreed via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Sunday, December 11, 2016, 3:48 AM
  
  
  
  On Sun, 12/11/16, mintaspriggs via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
  Group
   To: excel-macros@googlegroups.com
   Date: Sunday, December 11, 2016, 3:14 AM
   
   
   
   On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
  Whatsapp
   Group
    To: excel-macros@googlegroups.com
    Date: Sunday, December 11, 2016, 12:56 AM
    
    
    
    On Sat, 12/10/16, silvers.r via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
   Whatsapp
    Group
     To: excel-macros@googlegroups.com
     Date: Saturday, December 10, 2016, 11:55 PM
     
     
     
     On Sat, 12/10/16, margaretatolliver via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
    Whatsapp
     Group
      To: excel-macros@googlegroups.com
      Date: Saturday, December 10, 2016, 4:49 PM
      
      
      
      On Sat, 12/10/16, kenyattafreed via MS EXCEL AND
  VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
     Whatsapp
      Group
       To: excel-macros@googlegroups.com
       Date: Saturday, December 10, 2016, 4:45 PM
       
       
       ----
       On Sat, 12/10/16, karleenbiggs via MS EXCEL
 AND
   VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
      Whatsapp
       Group
        To: excel-macros@googlegroups.com
        Date: Saturday, December 10, 2016, 4:06 PM
        
        
        
        On Sat, 12/10/16, ashleypartridge via MS EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Re: VBA Macro
 -
       Whatsapp
        Group
         To: excel-macros@googlegroups.com
         Date: Saturday, December 10, 2016, 12:03 PM
         
         
        
 
         On Sat, 12/10/16, spainy via MS EXCEL AND
 VBA
     MACROS
       <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Re: VBA Macro
  -
        Whatsapp
         Group
          To: excel-macros@googlegroups.com
          Date: Saturday, December 10, 2016, 11:37 AM
          
          
         
  
          On Sat, 12/10/16, LEARNING EXCEL <excellea...@gmail.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Re: VBA
 Macro
   -
         Whatsapp
          Group
           To: excel-macros@googlegroups.com
           Date: Saturday, December 10, 2016, 11:35
 AM
           
           Please add my Number
           9600160150
           On 10 December 2016 at
           13:01, sugat misra <suga...@gmail.com>
           wrote:
           Please adde me as well 8880740879
           
           On Saturday, 10 December 2016 03:55:25
     UTC+5:30,
       julienne...@yahoo.com
            wrote:
           
           --
   --
           
           On Fri, 12/9/16, XLS time <xls...@gmail.com>
          wrote:
           
           
           
            Subject: Re: $$Excel-Macros$$ Re: VBA
   Macro
     -
         Whatsapp
           Group
           
            To: excel-...@googlegroups.com
           
            Date: Friday, December 9,
           2016, 8:38 AM
           
            
           
            8860067995
           
            --
           
            
           
            On Fri, Dec 9, 2016 at 9:36
           
            AM, N.MADHAN <madh...@gmail.com>
           
            wrote:

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-10 Thread karleenbiggs via MS EXCEL AND VBA MACROS



On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Saturday, December 10, 2016, 12:03 PM
 
 
 
 On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS 

 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Saturday, December 10, 2016, 11:37 AM
  
  
  
  On Sat, 12/10/16, LEARNING EXCEL 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
  Group
   To: excel-macros@googlegroups.com
   Date: Saturday, December 10, 2016, 11:35 AM
   
   Please add my Number
   9600160150
   On 10 December 2016 at
   13:01, sugat misra 
   wrote:
   Please adde me as well 8880740879
   
   On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com
    wrote:
   
   -- --
   
   On Fri, 12/9/16, XLS time 
  wrote:
   
   
   
    Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
   Group
   
    To: excel-...@googlegroups.com
   
    Date: Friday, December 9,
   2016, 8:38 AM
   
    
   
    8860067995
   
    --
   
    
   
    On Fri, Dec 9, 2016 at 9:36
   
    AM, N.MADHAN 
   
    wrote:
   
    Could you
   
    please add my number +91 9442944095
   
    
   
    
   
    
   
    On 12/9/16, Amit Kumar 
   
    wrote:
   
    
   
    > Please add my number 9618644088
   
    
   
    >
   
    
   
    >
   
    
   
    > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran
   Kumar 
   
    
   
    > wrote:
   
    
   
    >
   
    
   
    >> Pls add my number +265999336673
   
    
   
    >>
   
    
   
    >> On Sunday, 11 September 2016 08:01:31
 UTC+2,
   Prabhu
   
    Pinky wrote:
   
    
   
    >>>
   
    
   
    >>> Hi Friends,
   
    
   
    >>>
   
    
   
    >>> Since i have created Whatsapp group
 for VBA
   
    Macro learners/experts.
   
    
   
    >>>
   
    
   
    >>> And i have added many peoples in this
  group.
   
    Please Msg me to 9500087194
   
    
   
    >>> in whatsapp to get added in this
 group. if
   
    anyone missed or not yet
   
    
   
    >>> added
   
    
   
    >>> even you requested earlier.
   
    
   
    >>>
   
    
   
    >>> Thanks & Regards,
   
    
   
    >>> Prabhu R
   
    
   
    >>>
   
    
   
    >> --
   
    
   
    >> 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-...@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
   
    
   
    >
   
    
   
    >

Re: $$Excel-Macros$$ Data moving from one file to other as required

Re: $$Excel-Macros$$ book for excel

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

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

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!

Re: $$Excel-Macros$$ Help Required

Re: $$Excel-Macros$$ something wrong with the attach macro

Re: $$Excel-Macros$$ converting sheet to macro

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

Re: $$Excel-Macros$$ Help Required

Re: $$Excel-Macros$$ How to use Index Match for two different files

Re: $$Excel-Macros$$ How to use Index Match for two different files

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template

Re: $$Excel-Macros$$ REminder: Mail Charts via Vba Macro!

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

29 matches

Site Navigation

Mail list logo

Footer information