--------------------------------------------
On Tue, 6/20/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same 
workbook
 To: excel-macros@googlegroups.com
 Date: Tuesday, June 20, 2017, 10:10 PM
 
 
 --------------------------------------------
 On Tue, 6/20/17, 'Kenyatta Freed' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Need
 Help: Summary data from sheets in the same workbook
  To: excel-macros@googlegroups.com
  Date: Tuesday, June 20, 2017, 2:34 PM
  
  
 
 --------------------------------------------
  On Tue, 6/20/17, Mustapha LMIDMANI
  <lmidmani.musta...@gmail.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Need
  Help: Summary data from sheets in the
 same workbook
   To: "excel-macros" <excel-macros@googlegroups.com>
   Date: Tuesday, June 20, 2017,
 1:19 PM
   
   I have fixed N° of
   product and fixed N° of
 customers. 
   It would be great if
   I can modify customer and
 product list
  in separated sheet if
   I want to add or remove
 something :)
   Many thanks
   Paul​
   
   Regards
   LMIDMANI
   MustaphaIndustrial
   engineerlmidmani.musta...@gmail.comp
  Be green – leave it
   on the screen
   NOTICE: This privileged and
   confidential email is intended
 only
  for the individual or
   entity to whom it is addressed.
 With
  regard to all others,
   any action related with this
 email as
  well as any reading,
   reproduction, transmission
 and/or
  dissemination in whole or
   in part of the information
 included in
  this email is
   prohibited. If you are not the
  addressee, immediately return
   the email to sender prior to
  destroying all copies. Even if
   this email is believed to be
 free from
  any virus, it is the
   responsibility of the recipient
 to
  make sure that it is
   virus exempt. Our communications
 to
  you may contain
   confidential information or
  information protected under
   solicitor-client privilege.
 Please
  advise if you wish us to
   use a mode of communication
 other than
  regular, unsecured
   e-mail in our communications
 with you
   
   
   On 20 June 2017 at 11:15,
   Paul Schreiner <schreiner_p...@att.net>
   wrote:
   adjective:
   dynamic1.
   (of a process or system)
 characterized
  by constant change,
   activity, or progress.
   That's
   why I defined the meaning in my
  question:How
   "dynamic" is your data?Is
   the number of Products variable
 or
  fixed?is
   the number of Customers variable
 or
   fixed?
   Meaning,
   does the number of customers or
  products change from
   month-to-month.does
   their position on the sheet
  change?Are
   there more columns or rows?
   If
   each month is a fixed template
 and has
  a specific number of
   products and customers(which
   I doubt)then
   you can Name ranges and refer
 those
  Named Ranges.
   If
   the layout changes, while it is
 a
  cumbersome layout, it
   ought to be possible to write a
 macro
  that searches through
   the data and collects the data.
   
  
  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, June 20, 2017 4:11 AM,
  Mustapha LMIDMANI <lmidmani.musta...@gmail.com>
   wrote:
     
   
    Sorry Paul, I
   didn't get what you mean by
   "dynamic". 
   
   Regards
   LMIDMANI MustaphaIndustrial engineerlmidmani.musta...@gmail.comp
  Be green – leave it on
   the screen
   NOTICE: This privileged and
   confidential email is intended
 only
  for the individual or
   entity to whom it is addressed.
 With
  regard to all others,
   any action related with this
 email as
  well as any reading,
   reproduction, transmission
 and/or
  dissemination in whole or
   in part of the information
 included in
  this email is
   prohibited. If you are not the
  addressee, immediately return
   the email to sender prior to
  destroying all copies. Even if
   this email is believed to be
 free from
  any virus, it is the
   responsibility of the recipient
 to
  make sure that it is
   virus exempt. Our communications
 to
  you may contain
   confidential information or
  information protected under
   solicitor-client privilege.
 Please
  advise if you wish us to
   use a mode of communication
 other than
  regular, unsecured
   e-mail in our communications
 with you
   
   
   On 19 June 2017 at 15:41, Paul
   Schreiner <schreiner_p...@att.net>
   wrote:
   That
   didn't answer my
 
 questions. 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, June 19, 2017
 7:18
  AM,
   Mustapha LMIDMANI <lmidmani.musta...@gmail.com>
   wrote:
     
   
    Hi dears,
   Thanks for your
   feedback guys.
   Paul: sheets are
   filled weekly (manually). and
 the
  dashboard have to reflect
   data on sheets by selecting
 Customer
  and month 
   thanks in
   advance
   
   Regards
   LMIDMANI MustaphaIndustrial engineerlmidmani.musta...@gmail.comp
  Be green – leave it on
   the screen
   NOTICE: This privileged and
   confidential email is intended
 only
  for the individual or
   entity to whom it is addressed.
 With
  regard to all others,
   any action related with this
 email as
  well as any reading,
   reproduction, transmission
 and/or
  dissemination in whole or
   in part of the information
 included in
  this email is
   prohibited. If you are not the
  addressee, immediately return
   the email to sender prior to
  destroying all copies. Even if
   this email is believed to be
 free from
  any virus, it is the
   responsibility of the recipient
 to
  make sure that it is
   virus exempt. Our communications
 to
  you may contain
   confidential information or
  information protected under
   solicitor-client privilege.
 Please
  advise if you wish us to
   use a mode of communication
 other than
  regular, unsecured
   e-mail in our communications
 with you
   
   
   On
   19 June 2017 at 10:53, Paul
 Schreiner
  <schreiner_p...@att.net>
   wrote:
   There's
   not enough information for me to
 guess
  how you want the
   summary populated.
   How
   "dynamic" is your data?Is
   the number of Products variable
 or
  fixed?is
   the number of Customers variable
 or
  fixed?
   
  
 
   Paul------------------------------
   -----------
   “Do
   all the good you can,
   By all the means you
   can,
   In all the ways you can,
   In all the places you can,
   At
   all the times you can,
   To all the people you
   can,
   As long as ever you can.” -
 John
   Wesley
   ------------------------------
   -----------
   
   
    
     On Sunday, June 18, 2017
 11:53
  AM,
   Mustapha LMIDMANI <lmidmani.musta...@gmail.com>
   wrote:
     
   
    
   Hi Guys,
   I'd like to
   know if there is any possibility
 with
  functions to fill my
   Summary sheet from montly report
 sheet
  in the attached
   sample. or I need to create a
 macro?
   By selecting Customer and month
   (Blue cells) filling the
 indicator .
   If I have to code a macro, can
   somone help me ?
   Thanks in
   advanceMustapha
   
   
   
   
   
   
   
   
   -- 
   
   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, 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, 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, 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.
   iarul Universul  despre
  asasinarea primului ministru Armand
 Calinescu
  
  -- 
  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. Partidul comunist
 critica desfasurarea evenimentelor din Polonia.19822 apr.-14
 iun. - Razboi intre Argentina si Marea Britanie pe tema
 insulelor Malvine  Falkland  din Oceanul Atlantic.
 10 nov. - Moartea lui Leonid Brejnev. Este urmat in functia
 suprema de Iuri Andropov  fostul sef al KGB. 31 dec. -
 Suspendarea starii de urgenta in Polonia.
 
 -- 
 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.u fost stabilite numeroase contacte 
diplomatice cu reprezentantii coalitiei antihitleriste si de catre diplomatii 
romani in capitalele statelor neutre. Astfel  au avut loc tratative cu 
participarea  intre altii  la Lisabona a lui Ion Panga s't Victor Cadere  la 
Madrid a lui Scarlat Crigoriu  la Berna a lui Grigore Gafencu  Richard 
Franasovici  Vespasian Pella  Nicolae Lahovary  la Roma si Vatican a lui 
RaoulBossy  la Stockholm a lui George Duca.

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

Reply via email to