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

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


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

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 8:08 PM
 
 
 
 On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 7:25 PM
  
  
  
  On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA
  MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 6:42 PM
   
   
   
   On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA
 MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to pick numbers
  which are
   missing in serial numbers
    To: excel-macros@googlegroups.com
    Date: Tuesday, March 14, 2017, 6:32 PM
    
    
    
    On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
  MACROS
    
    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
     
     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 
      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
    

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

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


On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

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

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

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


On Mon, 3/6/17, Maatangi M. Karthik  wrote:

 Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 
2010 with Datavalidation & VBA
 To: "MS EXCEL AND VBA MACROS" 
 Cc: schreiner_p...@att.net
 Date: Monday, March 6, 2017, 6:30 AM
 
 Hello
 Paul,
 
 Pls find the attached
 Sample.xlsm file for your reference. 
 
 I did try the lock cells for certain cells but
 that when the formula had to be computed, locked cells had
 to be overwritten and that was not permitted.
 
 If there is a possibility of
 talking to explain things that I want to accomplish with the
 excel, do let me know.
 
 Otherwise, I will have to explain here and get
 it done.
 
 Thanks,
 Maatangi
 
 
 On Friday, 3 March 2017 18:27:55 UTC+5:30, Paul
 Schreiner  wrote:First
 of all (last of all?):You can lock some cells and
 leave others available for editing:- select all
 cells- right click on the selection -
 Select "Format Cells"- select
 "Protection" tab- Make sure
 "Locked" is checked.- click
 "OK"
 When the sheet is
 protected, all cells with this "locked" attribute
 will be.. um... "locked"...Now select the cells you want to allow users to
 enter data into.then:-
 Select "Format Cells"- select
 "Protection" tab- Make sure
 "Locked" is NOT checked.-
 click "OK"
 Now, depending on what
 options you choose when you protect the sheet, the cells with the formulas 
cannot even be
 selected!while the user entry cells are
 left unchanged.
 If you want to be able to
 copy and paste all the data INCLUDING the locked cells to
 another sheet,make the appropriate
 selection when protecting the sheet.
 I think it
 "SOUNDS" like you want to accomplish your other
 items using Excel functions rather than VBA.(however, VBA is ALWAYS an option)
 But it would
 be a LOT easier for both of us if you could share a sample
 file(even with "dummy"
 data)
 I'd be glad to help.
 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 Friday, March 3,
 2017 12:16 AM, Maatangi M. Karthik  wrote:
   
 
  
 Hi there are a few more things I want from the
 excel.
 
 1. There are some
 formulae in my excel sheet, I would like to convert them 
 to the backend so that the users cannot change them at any
 cost
 2. There are some fields that affect
 these formulae in succession, that is,
  two or three cell values together will make up the formula
 for another 
 cell. I want to be able to capture the input event and the
 formula 
 creation based on this input.
 For example,
 there is a field where a due date gets calculated. And this
 column is dependent on 2 other columns' values. so I
 want to capture those 2 columns' input events and invoke
 the formula once they are filled.
 3. In the
 excel there are 3 fields, Tax,sales price with tax and sales
 
 price without tax. At present I have given the option of
 entering / 
 choosing the Tax % and entering the without tax price.
 However, there 
 may be cases where the user will know only the with tax
 price and the 
 tax %. this creates double work for them as they have to
 compute the 
 without tax price and then paste it in this excel. I want to
 avoid this 
 double work and give the option for the users to enter price
 in either 
 of the columns and then be able to compute based on which
 one is input.
 4.  Last query for now,
 
 I tried Locking / hiding the formulae for certain fields;
 however, they 
 don't take effect unless the excel sheet is protected
 and if I protect 
 the sheet, then users are unable to edit / input their
 values where 
 necessary. Is there a VBA workaround for this? Most of the
 date fields have to be locked as well and should not be
 allowed to be changed by users.
 
 On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul
 Schreiner  wrote:I deleted a
 row and received the "Type Mismatch"
 error.If you select "Debug", you'll
 see that the offending line of code is:   If Target.Value = "OrderStatus"
 ThenPutting a  "watch" on the Target
 variable, you'll see that it isn't a single cell,
 but an array of cells!
 When you change multiple cells (even
 by deleting, or inserting, or copying), then the Change
 event is passed an range ARRAY rather than a single
 range.
 In your case,
 you have a choice.You can add an if() statement
 like:if (Target.count > 1)
 then exit sub
 Or, you can process each
 cell in the target array like:
 dim Targ as
 rangefor each Targ in Target... (replace each occurrence of "Target"
 with "Targ") ...Next
 Targ
 
 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,

Re: $$Excel-Macros$$

2017-02-06 Thread cronincarmelita via MS EXCEL AND VBA MACROS 


On Mon, 2/6/17, amar takale  wrote:

 Subject: Re: $$Excel-Macros$$
 To: excel-macros@googlegroups.com
 Date: Monday, February 6, 2017, 8:06 AM
 
 check
 
 On Sat, Feb 4, 2017 at
 11:11 AM, Muralidhar E 
 wrote:
 
 Dear Friends
 & experts, Good morning
 friends If any one can helped can be
 appreciated,iam using excel-2013, my problem is i want to
 get the result for second and third match(occurence)both
 left and right columns, but iam failed to do so. Iam
 successed for first lookup value and but fail in second and
 third.It is more help me to give solutions better
 than me by two,three type
 solutions..Information reg. data is explained
 in the attached file.
 
 Thanks in advance.
 -- 
 Thanks &
 Regards,
  
 Muralidhar E.
 Think
 different
 Do
 Different
 Make
 different
 
 
 
 
 -- 
 
 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+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.
 enle lor democratice  dar si un model de viata  de multe ori elogiat de

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

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

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


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

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

2017-01-01 Thread cronincarmelita via MS EXCEL AND VBA MACROS 


On Mon, 1/2/17, amar takale <amartak...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel 
template
 To: excel-macros@googlegroups.com
 Date: Monday, January 2, 2017, 7:10 AM
 
 Dear
 Paul Sir
 Pls see this matter.Any idea
 for it or sample sheet.
 
 On Thu, Dec 29, 2016 at
 11:30 AM, karleenbiggs via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com>
 wrote:
 
 
 -- --
 
 On Thu, 12/29/16, Sushil Kumar
 <sushilck.sha...@gmail.com>
 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"
 
  <excel-macros@googlegroups.com
 >
 
  wrote:
 
 
 
 
 
  --
 --
 
 
 
  On Thu, 12/29/16, amar takale <amartak...@gmail.com>
 
  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
 
  <excel-macros@googlegroups.com
 
  >
 
 
 
   wrote:
 
 
 
 
 
 
 
 
 
 
 
   - - --
 
 
 
 
 
 
 
   On Thu, 12/29/16,
 
 
 
   martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com
 
 
 
   > 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 <excel-macros@googlegroups.com
 
 
 
   >
 
 
 
 
 
 
 
    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
 
 
 
 
 
 
 
     <excel-macros@googlegroups.com
 
 
 
   >
 
 
 
 
 
 
 
     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 <amartak...@gmail.com>
 
 
 
 
 
 
 
  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
 
 
 
 
 
 
 
  <excel-macros@googlegroups.com
 
 
 
   >
 
 
 
 
 
 
 
       wrote:
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
       -- --
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
       On Wed, 12/28/16,
 
 
 
 
 
 
 
       ashleypartridge via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com
 
 
 
 
 
 
 
       > wrote:
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
        Subject: Re: $$Excel-Macros$$ CRM (Customer
 
 
 
 
 
 
 
     relationship
 
 
 
 
 
 
 
       management ) excel template
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
        To: excel-macros@googlegroups.com
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
        Date: Wednesday, December 28, 2016, 10:41 AM
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
      
 
 
 
 
 
 
 
        - -
 --

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

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


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 new with my ideas.
    
    
    
      Pls
    
      send excel template OR related weblink.
    
    
    
      Regards
    
      Amar
    
    
    
    
    
    
    
    
    
      --
    
    
    
      Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
  And do
    you
    
      wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join
  official
    
      Facebook page of this forum @ https://www.facebook.com/
    
      discussexcel
    
    
    
       
    
    
    
      FORUM RULES
    
    
    
       
    
    
    
      1) Use concise, accurate thread titles. Poor
  thread
    
     titles,
    
      like Please Help, Urgent, Need Help, Formula
  Problem,
    Code
    
      Problem, and Need Advice will not get quick
  attention
    or
    
     may
    
      not be answered.
    
    
    
      2) Don't post a question in the thread of another
    
      member.
    
    
    
      3) Don't post questions regarding breaking or
    bypassing
    
      any security measure.
    
    
    
      4) Acknowledge the responses you receive, good or
  bad.
    
    
    
      5) Jobs posting is not allowed.
    
    
    
      6) Sharing copyrighted material and their links is
  not
    
      allowed.
    
    
    
       
    
    
    
      NOTE  : Don't ever post confidential data in a
    
     workbook.
    
      Forum owners and members are not responsible for
  any
    loss.
    
    
    
      ---
    
    
    
      You received this message because you are
  subscribed
    to
    
     the
    
      Google Groups "MS EXCEL AND VBA MACROS"
    group.
    
    
    
      To unsubscribe from this group and stop receiving
    emails
    
      from it, send an email to
  excel-macros+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/
    
   

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

2016-12-16 Thread cronincarmelita via MS EXCEL AND VBA MACROS 


On Fri, 12/16/16, libertystringer 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: Friday, December 16, 2016, 4:56 PM
 
 
 
 On Fri, 12/16/16, ashleypartridge 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: Friday, December 16, 2016, 2:42 PM
  
  
  
  On Fri, 12/16/16, mintaspriggs 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: Friday, December 16, 2016, 2:14 PM
   
   
   
   On Fri, 12/16/16, silvers.r 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: Friday, December 16, 2016, 12:26 PM
    
    
    ----
    On Fri, 12/16/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: Friday, December 16, 2016, 6:03 AM
     
     
     
     On Fri, 12/16/16, silvers.r 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: Friday, December 16, 2016, 3:28 AM
      
      
      
      On Fri, 12/16/16, mintaspriggs 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: Friday, December 16, 2016, 1:40 AM
       
       
       
       On Thu, 12/15/16, Vijayendra Rao <vijayendrar...@gmail.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
    and
      Unhide
        To: excel-macros@googlegroups.com
        Date: Thursday, December 15, 2016, 5:12 PM
        
        Hi
        Paul,
        Thank you very much
        for your time, I tried both the option and
  both
    are
       working
        very fine. You have fulfilled my all
  requirement.
      Thank
       you
        once again for your timely help.
        Regards,Vijayendra
        
        2016-12-15 20:17 GMT+05:30
        Paul Schreiner <schreiner_p...@att.net>:
        Look
        at the "Thisworkbook" module in the VB
        Editor.
        Notice
        that in the Hide...xlsm workbook, this module
  has
      the
        Workbook_Open event macro?
        Your
        testing.xlsm workbook doesn't have this.
        I noticed that you've added an
        Auto_Open macro.this is also an
        option.You
        could simply add  a call to HideAllSheets to
    this
      macro
        before the Msgbox
       line. Paul--
        ---
        “Do all the good you can,
        By all the means you can,
        In
        all the ways you can,
        In all the places you
        can,
        At all the times you can,
        To all the people you can,
        As
        long as ever you can.” - John Wesley
        --
        --- 
        
         
          On Thursday, December 15, 2016 7:43 AM,
       Vijayendra
        Rao <vijayendrar...@gmail.com>
        wrote:
          
        
         Dear Paul,
        I am facing one issue here, I try to
        use the macros to my other file by using you
  have
      provided
        macros. It is not hide when I open second time.
  I
    am
      not
        sure where I made a mistake or do I need to
    change
      any
        settings. Can you please help on the same.
        Attached are the both the files.
        "Hide & unhilde - 2nd page" is the macro
        provided by you and "TESTING - 001" is my
        file.
        Regards,Vijayendra
        
        2016-12-13 18:24 GMT+05:30
        Vijayendra Rao <vijayendrar...@gmail.com>:
        Thanks Paul for your
        help, it is working fine. You saved my lot of
    time.
        Thank you again.
        Regards,Vijayendra
        2016-12-13 17:41 GMT+05:30 Paul
        Schreiner <schreiner_p...@att.net>:
        I'd
        suggest changing the HideAllSheets macro to
    first
      d

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

2016-12-15 Thread cronincarmelita via MS EXCEL AND VBA MACROS 


On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Friday, December 16, 2016, 3:28 AM
 
 
 
 On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Friday, December 16, 2016, 1:40 AM
  
  
  
  On Thu, 12/15/16, Vijayendra Rao 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Thursday, December 15, 2016, 5:12 PM
   
   Hi
   Paul,
   Thank you very much
   for your time, I tried both the option and both are
  working
   very fine. You have fulfilled my all requirement.
 Thank
  you
   once again for your timely help.
   Regards,Vijayendra
   
   2016-12-15 20:17 GMT+05:30
   Paul Schreiner :
   Look
   at the "Thisworkbook" module in the VB
   Editor.
   Notice
   that in the Hide...xlsm workbook, this module has
 the
   Workbook_Open event macro?
   Your
   testing.xlsm workbook doesn't have this.
   I noticed that you've added an
   Auto_Open macro.this is also an
   option.You
   could simply add  a call to HideAllSheets to this
 macro
   before the Msgbox
  line. Paul--
   ---
   “Do all the good you can,
   By all the means you can,
   In
   all the ways you can,
   In all the places you
   can,
   At all the times you can,
   To all the people you can,
   As
   long as ever you can.” - John Wesley
   --
   --- 
   
    
     On Thursday, December 15, 2016 7:43 AM,
  Vijayendra
   Rao 
   wrote:
     
   
    Dear Paul,
   I am facing one issue here, I try to
   use the macros to my other file by using you have
 provided
   macros. It is not hide when I open second time. I am
 not
   sure where I made a mistake or do I need to change
 any
   settings. Can you please help on the same.
   Attached are the both the files.
   "Hide & unhilde - 2nd page" is the macro
   provided by you and "TESTING - 001" is my
   file.
   Regards,Vijayendra
   
   2016-12-13 18:24 GMT+05:30
   Vijayendra Rao :
   Thanks Paul for your
   help, it is working fine. You saved my lot of time.
   Thank you again.
   Regards,Vijayendra
   2016-12-13 17:41 GMT+05:30 Paul
   Schreiner :
   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  wrote:
     
   
    
   --
   --
   On Tue, 12/13/16,
   ileanakeating via MS EXCEL AND VBA MACROS  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 
    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 :
     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

Re: $$Excel-Macros$$ Combine two macros in to one

2016-12-15 Thread cronincarmelita via MS EXCEL AND VBA MACROS 


On Thu, 12/15/16, keisha.fry via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Combine two macros in to one
 To: excel-macros@googlegroups.com
 Date: Thursday, December 15, 2016, 1:10 PM
 
 
 
 On Thu, 12/15/16, julienneschindler via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Combine two macros in to one
  To: excel-macros@googlegroups.com
  Date: Thursday, December 15, 2016, 12:52 PM
  
  
  
  On Thu, 12/15/16, silvers.r via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Combine two macros in
 to one
   To: excel-macros@googlegroups.com
   Date: Thursday, December 15, 2016, 1:35 AM
   
   
   
   On Wed, 12/14/16, cronincarmelita via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Combine two macros in
  to one
    To: excel-macros@googlegroups.com
    Date: Wednesday, December 14, 2016, 11:22 PM
    
    
    
    On Wed, 12/14/16, julienneschindler via MS EXCEL AND
  VBA
    MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Combine two macros
 in
   to one
     To: excel-macros@googlegroups.com
     Date: Wednesday, December 14, 2016, 8:15 PM
     
     
     
     On Wed, 12/14/16, kenyattafreed via MS EXCEL AND
 VBA
    MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Combine two macros
  in
    to one
      To: excel-macros@googlegroups.com
      Date: Wednesday, December 14, 2016, 8:09 PM
      
      
      
      On Wed, 12/14/16, Paul Schreiner <schreiner_p...@att.net>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Combine two
 macros
   in
     to one
       To: "excel-macros@googlegroups.com"
      <excel-macros@googlegroups.com>
       Date: Wednesday, December 14, 2016, 3:57 PM
       
       Your
       buttons call two separate
      macros.Print_OptionandSUPPRESS_ROWS
       to
       combine the two, simply have the Print_Option
   macro
       "call" the SUPPRESS_ROWS macro, like:
       Sub
       Print_option()
          
       SUPRESS_ROWS
          
       Application.Dialogs(xlDialogPrint).Show
       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 Wednesday,
       December 14, 2016 2:40 AM, Vijayendra Rao
       <vijayendrar...@gmail.com>
      wrote:
         
       
        Dear Experts,
       I have created two macros, one is
       for suppress zero rows and another print
 option.
     Currently
      I
       need to run first suppress zero rows and
  later
     print
       macros. Is it possible to combine both the
   macros.
     By
       running print option, rows should be suppress
 and
     later
      need
       to show print dialogue option.
       Attached is the file which is I have
       created the macros. 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 messag

Re: $$Excel-Macros$$ Combine two macros in to one

2016-12-14 Thread cronincarmelita via MS EXCEL AND VBA MACROS 


On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Combine two macros in to one
 To: excel-macros@googlegroups.com
 Date: Wednesday, December 14, 2016, 8:15 PM
 
 
 
 On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Combine two macros in to one
  To: excel-macros@googlegroups.com
  Date: Wednesday, December 14, 2016, 8:09 PM
  
  
  
  On Wed, 12/14/16, Paul Schreiner 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Combine two macros in
 to one
   To: "excel-macros@googlegroups.com"
  
   Date: Wednesday, December 14, 2016, 3:57 PM
   
   Your
   buttons call two separate
  macros.Print_OptionandSUPPRESS_ROWS
   to
   combine the two, simply have the Print_Option macro
   "call" the SUPPRESS_ROWS macro, like:
   Sub
   Print_option()
      
   SUPRESS_ROWS
      
   Application.Dialogs(xlDialogPrint).Show
   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 Wednesday,
   December 14, 2016 2:40 AM, Vijayendra Rao
   
  wrote:
     
   
    Dear Experts,
   I have created two macros, one is
   for suppress zero rows and another print option.
 Currently
  I
   need to run first suppress zero rows and  later
 print
   macros. Is it possible to combine both the macros.
 By
   running print option, rows should be suppress and
 later
  need
   to show print dialogue option.
   Attached is the file which is I have
   created the macros. 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+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.
   ricum

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

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


On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA MACROS 
 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
 
 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 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: "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
   
  wrote:
     
   
    
   
   On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA
  MACROS
   
   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 
    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 :
     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  wrote:
       
     
      
     -- --
     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
     

Re: $$Excel-Macros$$ Average of Columns while excluding certain columns

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


On Tue, 12/13/16, ashleypartridge via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain 
columns
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 13, 2016, 7:18 PM
 
 
 
 On Tue, 12/13/16, Paul Schreiner 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Average of Columns while
 excluding certain columns
  To: "excel-macros@googlegroups.com"
 
  Date: Tuesday, December 13, 2016, 6:14 PM
  
  Could
  I get a copy of the sheet?What do you base
  "current" year on, the year
  of "today's" date?(rather
  than a fiscal year or other criteria)
  There are
  several options.But I'd rather not
  try to recreate your data, only to find out my creation
  doesn't match
 yours! 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 11:06 AM, Joseph Carney
  
 wrote:
    
  
   
  
  Hello all , 
  I
  have a conundrum.  I have a table that i am using to
  collate data from previous years sales.  The data is
 from
  2008 thru current year.  I have the table set up as
  follows:Month | 2008 | 2009 | 2009 | 2010 |
  2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 5year
  Average
  Under each of the headings, I
  have a numeric value sorted by month.  What I would like
 to
  be able to do is to average the PREVIOUS 5 years sales
 while
  ignoring the current year.  Is there a way/formula that I
  can set up that would give me the previous 5 year average
  without having to manually adjust the formula?
  Thank you for your kind
  assistance,
  Joe
  
  
  
  -- 
  
  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.
  dunarile ad-hoc  1857 . Anii 1853-1858 s-au aratat
 hotaratori si in plan intern. Pasoptistilor moldoveni 
 carora li se interzisese de catre domn sa sustina cauza
 statului national roman  li se vor adauga si cei
 munteni reintorsi  masiv  in

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

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


On Tue, 12/13/16, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 13, 2016, 2:13 AM
 
 
 
 On Tue, 12/13/16, mintaspriggs via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Tuesday, December 13, 2016, 2:04 AM
  
  
  
  On Tue, 12/13/16, kenyattafreed via MS EXCEL AND VBA
 MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Tuesday, December 13, 2016, 1:18 AM
   
   
   
   On Mon, 12/12/16, keisha.fry via MS EXCEL AND VBA
 MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: excel-macros@googlegroups.com
    Date: Monday, December 12, 2016, 11:44 PM
    
    
    
    On Mon, 12/12/16, derrickandrew994 via MS EXCEL AND
  VBA
    MACROS 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
 and
   Unhide
     To: excel-macros@googlegroups.com
     Date: Monday, December 12, 2016, 11:05 PM
     
     
     
     On Mon, 12/12/16, ashleypartridge via MS EXCEL
 AND
   VBA
     MACROS 
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
  and
    Unhide
      To: excel-macros@googlegroups.com
      Date: Monday, December 12, 2016, 8:53 PM
      
      
      
      On Mon, 12/12/16, julienneschindler via MS EXCEL
  AND
    VBA
      MACROS 
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
   and
     Unhide
       To: excel-macros@googlegroups.com
       Date: Monday, December 12, 2016, 4:53 PM
       
       
       
       On Mon, 12/12/16, Paul Schreiner 
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
    and
      Unhide
        To: "excel-macros@googlegroups.com"
       
        Date: Monday, December 12, 2016, 3:22 PM
        
        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
        
       wrote:
          
        
         
        
        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

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

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


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

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Sunday, December 11, 2016, 11:25 AM
 
 
 
 On Sun, 12/11/16, ashleypartridge via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Sunday, December 11, 2016, 10:41 AM
  
  
  
  On Sun, 12/11/16, karleenbiggs via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
  Group
   To: excel-macros@googlegroups.com
   Date: Sunday, December 11, 2016, 10:08 AM
   
   
   
   On Sun, 12/11/16, margaretatolliver via MS EXCEL AND
 VBA
   MACROS 
   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
    
    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
     
     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
      
      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
       
       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 
        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
         
         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
          
          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 
           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:
             
             

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

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


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

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Sunday, December 11, 2016, 4:20 AM
 
 
 
 On Sun, 12/11/16, ashleypartridge via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Sunday, December 11, 2016, 3:54 AM
  
  
  
  On Sun, 12/11/16, kenyattafreed via MS EXCEL AND VBA
 MACROS
  
  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
   
   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
    
    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
     
     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 
      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
       
       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
        
        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 
         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:

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

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


On Sat, 12/10/16, mintaspriggs 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:26 PM
 
 
 
 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