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

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

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

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

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

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

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

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

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

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

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

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 >

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

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 ?

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

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

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

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

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 ?

Re: $$Excel-Macros$$ Need Help for Data

Hi Team Any update regarding on the same?? Regards, On Mon, Dec 19, 2016 at 9:51 AM, vikas khen wrote: > Hi all, > > Good Morning!!! > > Team, need help for pooling data from Outlook2016 mails (Which is I kept > in the one folder) to Excel Sheet in Desired format. > > my

$$Excel-Macros$$ Need Help for Data

Hi all, Good Morning!!! Team, need help for pooling data from Outlook2016 mails (Which is I kept in the one folder) to Excel Sheet in Desired format. my mail contains following data in table format wich I need to export in excel sheet in the same manner. It would be very helpful if you could

$$Excel-Macros$$ Need help on data validation: List

Hi, I am looking for some help on data validation. If the value in cell A1 is Global B1 should display a dropdown list. If the value is Local, B1 should be left editable to the user to enter value of their choice. I appreciate your help. thank you, Sharath -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Need help on data validation: List

Hi Ashish, I am sorry I was not clear in my email. Let me clarify. Cell A1 has a drop down list (Global, Local) If someone selects Global, Cell B1 should show a drop-down list which is coming through a named range. I have that assigned. But, if the user selects Local, the Cell B1 should not

Re: $$Excel-Macros$$ Need help on data validation: List

Hi Sharath, PFA..! Change your data in A1. If you select Global in A1 then drop down list will show in B1 and If you select Local in A1 then drop down list will be deleted in B1. you are able to write anything in B1 Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Need help on data validation: List

Thanks Ashish, This is exactly what I wanted! Regards, Sharath On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Sharath, PFA..! Change your data in A1. If you select Global in A1 then drop down list will show in B1 and If you select Local in A1 then

Re: $$Excel-Macros$$ Need help on data validation: List

Welcome Sharath. Regards Ashish -- 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