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

[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 <schreiner_p...@att.net> 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 <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 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 

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

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

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

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

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

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.


My_dashboard.xlsx
Description: MS-Excel 2007 spreadsheet

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

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

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

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

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.


My_dashboard.xlsx
Description: MS-Excel 2007 spreadsheet

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

[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 Search_strings, Value As Variant
Search_strings = Split(Search_string, ";")
For Each Value In Search_strings
For i = 1 To Search_in_col.Count
  If Search_in_col.Cells(i, 1) = Value Then
result = result & " " & Return_val_col.Cells(i, 1).Value
  End If
Next i
Next Value
Lookup_concat = Trim(result)
End Function

Thanks in advance

Regards
*Mustapha*
*Industrial designer.*

-- 
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$$ Re: VBA macro - WhatsApp group.

[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, 2016 21:43, "Rajeev Ranjan" <06raj...@gmail.com> wrote:
>>
>>> please add the my number 9811503853
>>>
>>> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:

 Creating WhatsApp group for VBA macro... Pls msg me your contact, if
 you wants to join.

 Add me in WhatsApp and Msg me to - 9500087194

 Regards,
 Prabhu.R

>>> --
>>> 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.
>>
> --
>
> Md Ali Mehebub Hassan
>
> --
> 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
*LMIDMANI Mustapha*
*Indutrial designer*
lmidmani.musta...@gmail.com

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

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

[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 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
*LMIDMANI Mustapha*
*Indutrial designer*
lmidmani.musta...@gmail.com

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


if condition.xlsx
Description: MS-Excel 2007 spreadsheet

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

[Mustapha LMIDMANI]

If I understand well the function, I need to have the image in a excel
file...
but in my case, I have images in a folder.

2016-01-28 18:48 GMT+00:00 Paul Schreiner <schreiner_p...@att.net>:

> Oops, forgot the attachment.
>
> *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 Thursday, January 28, 2016 1:48 PM, Paul Schreiner <
> schreiner_p...@att.net> wrote:
>
>
>
> Take a look at this.
> I created a change event macro that looks to the "B" column for changes to
> the filename.
> The image folder is hard-coded in that macro.
> You COULD put the folder name on the sheet and get it from there.
>
> The Event calls a macro that inserts the image and sizes it to fit the
> cell in column C.
>
> The biggest problem that I can see at this point is that if you copy/paste
> the entire column,
> it will put a SECOND copy of the image over the first.
>
> Checking for an image at that location and deleting it is a bit tricky.
>
> See if that's what you're looking for.
>
>
> *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 Thursday, January 28, 2016 12:37 PM, Mustapha LMIDMANI <
> lmidmani.musta...@gmail.com> wrote:
>
>
>
> I want to show those pictures (located in a specific file) in the cells
> next to the product name (see attachment)
>
> 2016-01-28 17:33 GMT+00:00 Paul Schreiner <schreiner_p...@att.net>:
>
> really need more information than that.
>
> What do you mean by "look up"?
>
> Are your images simple .tif, .jpg, .bmp images?
>
> Is your excel file just a list of filenames that you're wanting to check
> to see if the file exists in the folder?
>
> What is it you're wanting to know (return)?
>
> what is it you wish to accomplish?
>
> can you give an example of what the file/folder looks like and what your
> excel file looks like?
>
> *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 Thursday, January 28, 2016 12:28 PM, Mustapha LMIDMANI <
> lmidmani.musta...@gmail.com> wrote:
>
>
>
> 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
> =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 thr

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

[Mustapha LMIDMANI]

Many thanks guys :)

2016-01-29 14:18 GMT+00:00 Paul Schreiner <schreiner_p...@att.net>:

> Evidently, you don't understand the function (just kidding).
>
> In the Change Event,
> I checked to see if the cell changed is where the filenames are defined:
>
> Targ.Column = 2
>
> I defined the folder as:
>
> ImageFolder = "C:\temp\Images\"
>
> I read the image name as targ.value
> The location for the image is one column to the right of the 'target'
> or:
> Targ.Offset(0,1)
>
> and called the function with:  Merge_Pict(ImageFolder & Targ.Value,
> Targ.Offset(0,1))
>
>
> so, if you change the line:
> ImageFolder = "C:\temp\Images\"
>
> to show the folder where you have your images (be sure to have a "\" at
> the end)
> then this macro should work for you.
>
> *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 Friday, January 29, 2016 3:05 AM, Mustapha LMIDMANI <
> lmidmani.musta...@gmail.com> wrote:
>
>
>
> If I understand well the function, I need to have the image in a excel
> file...
> but in my case, I have images in a folder.
>
> 2016-01-28 18:48 GMT+00:00 Paul Schreiner <schreiner_p...@att.net>:
>
> Oops, forgot the attachment.
>
> *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 Thursday, January 28, 2016 1:48 PM, Paul Schreiner <
> schreiner_p...@att.net> wrote:
>
>
>
> Take a look at this.
> I created a change event macro that looks to the "B" column for changes to
> the filename.
> The image folder is hard-coded in that macro.
> You COULD put the folder name on the sheet and get it from there.
>
> The Event calls a macro that inserts the image and sizes it to fit the
> cell in column C.
>
> The biggest problem that I can see at this point is that if you copy/paste
> the entire column,
> it will put a SECOND copy of the image over the first.
>
> Checking for an image at that location and deleting it is a bit tricky.
>
> See if that's what you're looking for.
>
>
> *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 Thursday, January 28, 2016 12:37 PM, Mustapha LMIDMANI <
> lmidmani.musta...@gmail.com> wrote:
>
>
>
> I want to show those pictures (located in a specific file) in the cells
> next to the product name (see attachment)
>
> 2016-01-28 17:33 GMT+00:00 Paul Schreiner <schreiner_p...@att.net>:
>
> really need more information than that.
>
> What do you mean by "look up"?
>
> Are your images simple .tif, .jpg, .bmp images?
>
> Is your excel file just a list of filenames that you're wanting to check
> to see if the file exists in the folder?
>
> What is it you're wanting to know (return)?
>
> what is it you wish to accomplish?
>
> can you give an example of what the file/folder looks like and what your
> excel file looks like?
>
> *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 Thursday, January 28, 2016 12:28 PM, Mustapha LMIDMANI <
> lmidmani.musta...@gmail.com> wrote:
>
>
>
> 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
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, 

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

[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 
=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$$ lookup image from a folder

[Mustapha LMIDMANI]

I want to show those pictures (located in a specific file) in the cells
next to the product name (see attachment)

2016-01-28 17:33 GMT+00:00 Paul Schreiner <schreiner_p...@att.net>:

> really need more information than that.
>
> What do you mean by "look up"?
>
> Are your images simple .tif, .jpg, .bmp images?
>
> Is your excel file just a list of filenames that you're wanting to check
> to see if the file exists in the folder?
>
> What is it you're wanting to know (return)?
>
> what is it you wish to accomplish?
>
> can you give an example of what the file/folder looks like and what your
> excel file looks like?
>
> *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 Thursday, January 28, 2016 12:28 PM, Mustapha LMIDMANI <
> lmidmani.musta...@gmail.com> wrote:
>
>
>
> 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
> =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, 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 l

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

[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 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i)  Chr(j)  Chr(k)  _
Chr(l)  Chr(m)  Chr(i1)  Chr(i2)  Chr(i3)  _
Chr(i4)  Chr(i5)  Chr(i6)  Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox One usable password is   Chr(i)  Chr(j)  _
Chr(k)  Chr(l)  Chr(m)  Chr(i1)  Chr(i2)  _
Chr(i3)  Chr(i4)  Chr(i5)  Chr(i6)  Chr(n)
 Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub



*LMIDMANI Mustapha*
*Industrial engineer*

2015-08-17 11:06 GMT+01:00 idris.akinwu...@gmail.com:

 Hi sham,

 Please help me with these workbook. I have tried the steps below but i
 couldn't break the password.

 Awaiting yours

 *Idris*

 On Saturday, February 20, 2010 at 6:27:18 PM UTC+1, SHAM wrote:

 To crack the password of an VBA Macro / coding first download an HEX
 Editor

 its available from the site
 http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
 (its a very small file of 0.5 MB capacity)

 Close the workbook and open the workbook file in the hex editor. Find
 the string DPB and change it to DPx (x is in small letter). Save
 the file. Open the workbook and click OK until the workbook is open
 (one or more dialogs are displayed describing various problems with
 the VBA project). Press ALT+F11, choose the menu command Tools-
 VBAProject Properties, navigate to the Protection tab, and change the
 password but do not remove it (note the new password). Save, close,
 and re-open the workbook. Press ALT+F11 and enter the new password.
 Choose Tools-VBAProject Properties, navigate to the Protection tab,
 and remove the password. Save the workbook.
 Now open the same workbook, You can use the password that you already
 given.

 SHAMEER P, KERALA, INDIA

 On Feb 20, 8:50 pm, sunil sasidharan sunil.sasidha...@gmail.com
 wrote:
  Hi,
 
  I wont be able to send the file as it has some confidential data of our
  organisations.
 
  Please let me know how do i go about cracking the password.
 
  Regards,
  Sunil
 
 
 
  On Sat, Feb 20, 2010 at 10:04 AM, ankur ankurpande...@gmail.com
 wrote:
   send ur file
   Have A Nice Time  Enjoy Life
 
   Regards:
   CMA Ankur Pandey
   (Someone Different)
 
   I'm not the best but i'm not like the rest~~
 
On Sat, Feb 20, 2010 at 5:16 AM, JsinSk jsin...@gmail.com wrote:
Post the file here and someone will crack it for you.
 
On Feb 19, 9:24 am, sunil sasidharan sunil.sasidha...@gmail.com
wrote:
*Hi All,*
**
*I need to edit an excel macro file but the VBA coing is protected
 and
nobody is aware of the password.*
**
*Could you please help me on how do i crack the excel password or
 is
   there
any free software available?*
**
*Thanks in advance for your help
 
Regards,
Sunny
*
 
--
 
  
 --
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
2. Join our Facebook Group @
  http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials athttp://www.excel-macros.blogspot.com
4. Learn VBA Macros athttp://www.quickvba.blogspot.com
5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 
To post to this group, send email to excel-...@googlegroups.com
 

HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice
 notes
   about the learning and support from the group.Let friends and
 co-workers
   know they can subscribe to group at
  http://groups.google.com/group/excel-macros/subscribe
 
   --
 
  
 --
   Some important links for excel users:
   1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
   2. Join our Facebook Group @
  http://www.facebook.com/group.php?gid=287779555678
   3. Excel tutorials athttp://www.excel-macros.blogspot.com
   4. Learn VBA Macros athttp://www.quickvba.blogspot.com
   5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 
   To post to this group, send email to excel-...@googlegroups.com
 
   
   HELP US GROW !!
 
   We reach over 6,800 subscribers worldwide and receive many nice notes
 about
   the learning and support from the group.Let friends and co-workers
 know they
   

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

[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 group,one of the largest online community of excel Fans!
  
 I hope you enjoy your time here  find this forum to be a friendly and 
 knowledgeable community. Please feel free to post a small introduction, a 
 friendly hello or tell us a bit about yourself. Why not tell us where are 
 you from, what you do, what your interests are, how old you are, which is 
 your favourite excel site or blog is or anything else that comes to mind!

 Thanks for your time
 Ayush Jain
 Group Manager
 Microsoft MVP


-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[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 la date dans la cellule e après qu'on
 a saisie les données dans le cellule a b c d et que cette date soit fixe et
 ne change pas avec le temps.
  merci pour l'aid

 --
 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[Mustapha LMIDMANI]

without reading in deep of the code, you can just give to i a verry big
value this will solve your issue ?

2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com:

 thanks
 yes the problem is what you just said, each time you open the file the
 date changes. in this case I find 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 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 la date dans la cellule e après
 qu'on a saisie les données dans le cellule a b c d et que cette date soit
 fixe et ne change pas avec le temps.
  merci pour l'aid

 --
 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 http://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 a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/a1cR3saIVrY/unsubscribe.
 To unsubscribe from this group and all its topics, 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 http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




 --


 *Cordialement   Elhechmi  Eladeb*

 --
 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 http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
Are you =EXP(E:RT) or =NOT(EXP

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

[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.
 Please find the attached file.

 Regards

 Harish

 --
 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Bolts and Weights .xlsx
Description: MS-Excel 2007 spreadsheet

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

[Mustapha LMIDMANI]

you're welcome :)

2015-04-24 11:21 GMT+01:00 Harish P Y py.har...@gmail.com:

 Thank you :-)


 With Regards

 *HARISH P Y*

 *P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether
 it is really necessary. Thanks for your support to protect our environment
 for the future 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
 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.
 Please find the attached file.

 Regards

 Harish

 --
 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 http://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 http://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 http://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