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

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,

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

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

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

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

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

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

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

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,

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 >

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,

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