Re: $$Excel-Macros$$ Which Formula to use for fetching the data

2015-04-24 Thread Mustapha LMIDMANI
Hello, Please see the file in attachment :) Best regards LMIDMANI Mustapha lmidmani.musta...@gmail.com 2015-04-24 9:27 GMT+01:00 Harish P Y py.har...@gmail.com: Hi, Help needed, kindly suggest which formula to be used to fetch the data from the corresponding data sheet to summary sheet.

Re: $$Excel-Macros$$ Which Formula to use for fetching the data

2015-04-24 Thread Mustapha LMIDMANI
generation* *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3 sheets of A4 paper pollutes 1 litre of water* On Fri, Apr 24, 2015 at 2:20 PM, Mustapha LMIDMANI lmidmani.musta...@gmail.com wrote: Hello, Please see the file in attachment :) Best regards LMIDMANI Mustapha

$$Excel-Macros$$ Re: Introduce Yourself !!

2015-06-19 Thread Mustapha LMIDMANI
Hello All, I'm Mustapha from Morocco. I'm beginer in VBA, and I want to learn and share my knowledge whith you. LMIDMANI Mustapha Product engineer lmidmani.musta...@gmail.com Le vendredi 8 juin 2012 20:21:59 UTC+1, Ayush Jain a écrit : Hey all new and current posters, Welcome to excel

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread Mustapha LMIDMANI
Please try to use function now() it gives the actual date and hour when you write it. but it will updated each time you open the file ... and this is not what you're looking for I think... 2015-05-21 16:43 GMT+01:00 siga eladebelhec...@gmail.com: bonjour je cherche un code vba qui affiche

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread Mustapha LMIDMANI
a vien code in Internet. the problem that execute from i = 2 to i = 100 beyond the 100 code is not working. the code you find in this link: http://familycomputerclub.com/auomatic-date-time-entry-excel-vba.html 2015-05-21 16:56 GMT+01:00 Mustapha LMIDMANI lmidmani.musta...@gmail.com : Please

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

2015-08-17 Thread Mustapha LMIDMANI
Hello, if you talk about cells lock, try below code: Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5

Re: $$Excel-Macros$$ lookup image from a folder

2016-01-29 Thread Mustapha LMIDMANI
l 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 Thursday, January 28, 2016 12:37 PM, Mustapha

Re: $$Excel-Macros$$ lookup image from a folder

2016-01-29 Thread Mustapha LMIDMANI
*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*

$$Excel-Macros$$ lookup image from a folder

2016-01-28 Thread Mustapha LMIDMANI
Hi dears, I'd need some help regarding my excel file, I want to "lookup" images from a folder, basing on file name on a cell ... is it possible with a VBA code Many thanks guys :) Regards LMDIMANI Mustapha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ lookup image from a folder

2016-01-28 Thread Mustapha LMIDMANI
can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Thursday, January 28, 2016 12:28 PM, Mustapha LMIDMANI < > lmidmani.musta...@gmail.com> wrote: > > > &g

Re: $$Excel-Macros$$ Help for if condition....

2016-07-22 Thread Mustapha LMIDMANI
Hello, Please check this ? is what do you want? 2016-07-22 8:42 GMT+01:00 Neeraj Pal : > Hi All, > > Please solve my if condition > > -- > 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

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-09-01 Thread Mustapha LMIDMANI
My N° Please :) +212 699 356 686 Thanks in advance :) 2016-09-01 5:16 GMT+01:00 Mohammad Ali Mehebub Hassan : > My no is +919932274103 > > On Thu, 1 Sep 2016 9:45 am Dhartikumar Sahu, > wrote: > >> Please add me my no. 7738363450 >> >> On Aug 8,

$$Excel-Macros$$ 32Bit Vs 64Bit

2017-03-29 Thread Mustapha LMIDMANI
Hello Guys, I'd like to know how to use "ptrsafe" in my function below, I've migrated to X64 yesterday, and the fuction gives me blank cell as result. Function Lookup_concat(Search_string As String, _ Search_in_col As Range, Return_val_col As Range) Dim i As Long, result As String Dim

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

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

2017-06-20 Thread Mustapha LMIDMANI
t; > *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.” - J

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

2017-06-20 Thread Mustapha LMIDMANI
; > > > > > *“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* > ----- > > >

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

2017-06-18 Thread Mustapha LMIDMANI
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

2017-06-19 Thread Mustapha LMIDMANI
> > > > > > > > *“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* > --

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

2017-06-06 Thread Mustapha LMIDMANI
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 ?