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
<lmidmani.musta...@gmail.com> 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 <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.
--
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.
