Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


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 send

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Mustapha LMIDMANI 
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 Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P 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  wrote:

> *adjective: dynamic*
> *1. (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 Mustapha*
> *Industrial engineer*
> lmidmani.musta...@gmail.com
> P 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  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 Mustapha*
> *Industrial engineer*
> lmidmani.musta...@gmail.com
> P 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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Paul Schreiner 
If you can give me a larger sample of data, I can try to work on 
something.Since it sounds like you have no background with VBA programming, 
I'll try to develop an Excel-Function solution. 
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 7:20 AM, Mustapha LMIDMANI 
 wrote:
 

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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Paul Schreiner 
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 
 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  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 
 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  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 
 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,

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Mustapha LMIDMANI 
Sorry Paul, I didn't get what you mean by "dynamic".


Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P 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  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 Mustapha*
> *Industrial engineer*
> lmidmani.musta...@gmail.com
> P 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  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 advance
> Mustapha
>
>
> --
> 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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-19 Thread Paul Schreiner 
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 
 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  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 
 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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

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

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-19 Thread Paul Schreiner 
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 
 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+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.

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-18 Thread 'Liberty Stringer' via MS EXCEL AND VBA MACROS 


On Sun, 6/18/17, Rajan Verma <rajanverma1...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same 
workbook
 To: excel-macros@googlegroups.com
 Date: Sunday, June 18, 2017, 7:09 PM
 
 countif, sumif,
 sumproduct can do this
 On Sun, 18 Jun 2017 at
 9:23 PM, 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+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.
 
 -- 
 Regards
 Rajan verma
 +91
 7838100659
 
 
 
 -- 
 
 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.
 adarau  Essay sur la penssee   1925   I.D. Gherea  Le moix et le monde.

-- 
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$$ Need Help: Summary data from sheets in the same workbook

2017-06-18 Thread Rajan Verma 
countif, sumif, sumproduct can do this

On Sun, 18 Jun 2017 at 9:23 PM, 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 advance
> Mustapha
>
>
>
> --
> 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.
>
-- 
Regards
Rajan verma
+91 7838100659

-- 
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$$ Need Help: Summary data from sheets in the same workbook

2017-06-08 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


On Thu, 6/8/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: Thursday, June 8, 2017, 11:18 AM
 
 Hi,
 Can somone help on
 my issue please .
 
 
 
 On 6 June 2017 at 10:50,
 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+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.
 espre Viata teatrala   din Istoria Teatrului in Romania :

-- 
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$$ Need Help: Summary data from sheets in the same workbook

2017-06-08 Thread Mustapha LMIDMANI 
Hi,

Can somone help on my issue please .



On 6 June 2017 at 10:50, Mustapha LMIDMANI 
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 advance
> Mustapha
>
> --
> 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.