Re: $$Excel-Macros$$ Re: User name and Password in Excel with Sheets

2014-05-07 Thread Vaibhav Joshi
Cheers!!


On Wed, May 7, 2014 at 11:47 AM, Nitya  wrote:

>
> Thanks a ton. mind freaking solution. Thanks.
>
>
> Regards,
> Nitya
>  On Wed, May 7, 2014 at 11:10 AM, Vaibhav Joshi  wrote:
>
>>  Ok, That was for testing.
>>
>> You can test on it.
>>
>> Cheers!!
>>
>>
>>  On Wed, May 7, 2014 at 10:39 AM, Nitya 
>> wrote:
>>
>>> Dear Sir,
>>>
>>>  Thanks for sharing. but x indicates right to access sheet - Does not
>>> work in it. Correct, your logic is correct but if I enter Username "aa",
>>> then I am supposed to see sheet1 and sheet3 not Sheet2 (Sheet2 should hide.
>>>
>>>
>>>
>>> Thanks once again.
>>> ​​
>>>
>>>  Regards,
>>> Nitya​​
>>>
>>>  On Tue, May 6, 2014 at 8:11 PM, Vaibhav Joshi  wrote:
>>>
 Hi


 You can check attachment, may this will help you.


 Cheers!


 On Tue, May 6, 2014 at 1:42 PM, Nitya 
 wrote:

> Dear All,
>
> Do u have the template for below query ? Please share if you have one.
> Please...
>
> I was looking to set up a username/password protected workbook.
> I was hoping if I can make certain sheets visible depending on the
> username.
>
> so e.g
> User 1 will only get access to Sheet1 but
> User 2 will get acess to Sheet1 and Sheet 2
>
> I will have about 30 users so I am assuming I would have to have a
> seperate sheet to store the login/password information or can it all be
> hidden in the VBA?
>
> Optional: Would it be better if we set up a 3rd field called Type when
> prompting for login and password. Type would be "user","manager","owner".
> All users will get access to Sheet 1 only.
> Managers will get access to Sheet 1 and Sheet 2.
> Owner will get access to Sheet 1, 2 and 3
>
> Regards,
> Nitya
>
> --
> 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 ans

Re: $$Excel-Macros$$ Macro required

2014-05-07 Thread Shrinivas Shevde
Very very thanks


On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi  wrote:

> Hi
>
> Yes you can paste data in master file below the existing data. However you
> can test data.
>
>
> Thanks
>
>
> On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde 
> wrote:
>
>> Dear Vaibhav
>>
>> Really nice and lots of thanks
>> Small query.I will get data on daily basis as i said earlier so shall i
>> copy paste data below the current data in data sheet.
>>
>> Regards
>> Shrinivas
>>
>>
>>
>> On Tue, May 6, 2014 at 11:19 PM, Vaibhav Joshi  wrote:
>>
>>> Hey
>>>
>>> Check out this..
>>>
>>> Cheers!!
>>>
>>>
>>> On Mon, May 5, 2014 at 3:51 PM, Shrinivas Shevde >> > wrote:
>>>

 Dear all

 I am getting a data on daily basis.In which there are various items and
 items code.Item code is changing on daily basis.I have to make itemwise
 sheet an dneeds to copy paste the items code.
 Is it possible to write a code so that wheneve i clicked on a button
 all items code wil go to corresponding sheet.if the sheet is not available
 for particular item then it will create a new sheet.
 Sample file attached
 I have items like A,B ,C and having corresponding code
 For Eg For A item today item code is 1,2,3,9,13,Tomorrow I will get
 different data and item code may be 27,25

 --
 Shrini

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

$$Excel-Macros$$ Re: User name and Password in Excel with Sheets

2014-05-07 Thread Nitya
Sir, I think you have missed the attachment.  Please resend with updated
Asterisk. Thank you very much.

 Regards,
Nitya

 On Wed, May 7, 2014 at 12:37 PM, Vaibhav Joshi  wrote:

> Cheers!!
>
>
> On Wed, May 7, 2014 at 11:47 AM, Nitya 
> wrote:
>
>>
>> Thanks a ton. mind freaking solution. Thanks.
>>
>>
>> Regards,
>> Nitya
>>  On Wed, May 7, 2014 at 11:10 AM, Vaibhav Joshi  wrote:
>>
>>> Ok, That was for testing.
>>>
>>> You can test on it.
>>>
>>> Cheers!!
>>>
>>>
>>> On Wed, May 7, 2014 at 10:39 AM, Nitya 
>>> wrote:
>>>
 Dear Sir,

  Thanks for sharing. but x indicates right to access sheet - Does not
 work in it. Correct, your logic is correct but if I enter Username "aa",
 then I am supposed to see sheet1 and sheet3 not Sheet2 (Sheet2 should hide.



 Thanks once again.
 ​​

  Regards,
 Nitya​​

  On Tue, May 6, 2014 at 8:11 PM, Vaibhav Joshi  wrote:

> Hi
>
>
> You can check attachment, may this will help you.
>
>
> Cheers!
>
>
> On Tue, May 6, 2014 at 1:42 PM, Nitya 
> wrote:
>
>> Dear All,
>>
>> Do u have the template for below query ? Please share if you have
>> one. Please...
>>
>> I was looking to set up a username/password protected workbook.
>> I was hoping if I can make certain sheets visible depending on the
>> username.
>>
>> so e.g
>> User 1 will only get access to Sheet1 but
>> User 2 will get acess to Sheet1 and Sheet 2
>>
>> I will have about 30 users so I am assuming I would have to have a
>> seperate sheet to store the login/password information or can it all be
>> hidden in the VBA?
>>
>> Optional: Would it be better if we set up a 3rd field called Type
>> when prompting for login and password. Type would be
>> "user","manager","owner".
>> All users will get access to Sheet 1 only.
>> Managers will get access to Sheet 1 and Sheet 2.
>> Owner will get access to Sheet 1, 2 and 3
>>
>> Regards,
>> Nitya
>>
>> --
>> 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

Re: $$Excel-Macros$$ Re: User name and Password in Excel with Sheets

2014-05-07 Thread Nitya
Great your great...Thanks a ton for this.


On Wed, May 7, 2014 at 2:00 PM, Vaibhav Joshi  wrote:

> PFA
>
>
> On Wed, May 7, 2014 at 12:51 PM, Nitya wrote:
>
>> Sir, I think you have missed the attachment.  Please resend with updated
>> Asterisk. Thank you very much.
>>
>>  Regards,
>> Nitya
>>
>>  On Wed, May 7, 2014 at 12:37 PM, Vaibhav Joshi  wrote:
>>
>>>  Cheers!!
>>>
>>>
>>> On Wed, May 7, 2014 at 11:47 AM, Nitya 
>>> wrote:
>>>

 Thanks a ton. mind freaking solution. Thanks.


 Regards,
 Nitya
  On Wed, May 7, 2014 at 11:10 AM, Vaibhav Joshi  wrote:

> Ok, That was for testing.
>
> You can test on it.
>
> Cheers!!
>
>
>  On Wed, May 7, 2014 at 10:39 AM, Nitya 
> wrote:
>
>> Dear Sir,
>>
>>  Thanks for sharing. but x indicates right to access sheet - Does not
>> work in it. Correct, your logic is correct but if I enter Username "aa",
>> then I am supposed to see sheet1 and sheet3 not Sheet2 (Sheet2 should 
>> hide.
>>
>>
>>
>> Thanks once again.
>> ​​
>>
>>  Regards,
>> Nitya​​
>>
>>  On Tue, May 6, 2014 at 8:11 PM, Vaibhav Joshi  wrote:
>>
>>> Hi
>>>
>>>
>>> You can check attachment, may this will help you.
>>>
>>>
>>> Cheers!
>>>
>>>
>>> On Tue, May 6, 2014 at 1:42 PM, Nitya 
>>> wrote:
>>>
 Dear All,

 Do u have the template for below query ? Please share if you have
 one. Please...

 I was looking to set up a username/password protected workbook.
 I was hoping if I can make certain sheets visible depending on the
 username.

 so e.g
 User 1 will only get access to Sheet1 but
 User 2 will get acess to Sheet1 and Sheet 2

 I will have about 30 users so I am assuming I would have to have a
 seperate sheet to store the login/password information or can it all be
 hidden in the VBA?

 Optional: Would it be better if we set up a 3rd field called Type
 when prompting for login and password. Type would be
 "user","manager","owner".
 All users will get access to Sheet 1 only.
 Managers will get access to Sheet 1 and Sheet 2.
 Owner will get access to Sheet 1, 2 and 3

 Regards,
 Nitya

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

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

2014-05-07 Thread sylvie james

If you are lost or forgot MS Excel password and want to recover the lost 
password you can use an office password 
recoverytool to recover lost MS Excel 
password from the System. It is very 
effective and gives a instant solution to the user. This will be great help 
to you to recover crack Excel VBA password from your System.

-- 
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$$ Re: how to crack Excel VBA password

2014-05-07 Thread Manoj Garg
PLEASE SEND THE FILE.


On Sat, Mar 8, 2014 at 1:36 PM, nitin kumar  wrote:

> Dear Team,
>
> Below software is can recover password only VBA project file of Doc, Xla
> and Xls files but my exel file is xlsx so its not working.
> so plz suggest me the password remover of xlsx file format.
>
> Regards,
> Nitin Kumar
>
> Pfa,
>
> Regards,
> Nitin Kumar
>
> Pfa,
>
> Regards,
> Nitin Kumar
>
>
> On Fri, Feb 28, 2014 at 2:03 PM, nitin kumar  wrote:
>
>> Dear Elis,
>>
>> below software is not working & not showing the password can u find the
>> the password of attached file password.
>> please...
>>
>> Regards,
>> Nitin Kumar
>> +91 9784363535
>>
>> Pfa,
>>
>> Regards,
>> Nitin Kumar
>>
>>
>> On Fri, Feb 21, 2014 at 6:08 PM, elis smith wrote:
>>
>>> * You can use Excel file password creacker *software which easily crack
>>> Excel file password unlock Excel 
>>> spreadsheetafter then fastly re-open 
>>> Microsoft Excel file..
>>>
>>> --
>>> 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/B_bTLZ3HSp0/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/groups/opt_out.
>>>
>>
>>
>  --
> 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.
>



-- 


Regards,
Manoj Garg
Mobile:+91-9927199217


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

$$Excel-Macros$$ Interaction between worksheet using Userforms

2014-05-07 Thread Sherin
Hi I need to create a userform that selects data from one worksheet(sales) 
and then create an invoice in another worksheet. pls  advice

-- 
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$$ Interaction between worksheet using Userforms

2014-05-07 Thread Vaibhav Joshi
Hi

Share raw data & existing format which you  have.

Thanks


On Wed, May 7, 2014 at 6:38 PM, Sherin  wrote:

> Hi I need to create a userform that selects data from one worksheet(sales)
> and then create an invoice in another worksheet. pls  advice
>
> --
> 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.


$$Excel-Macros$$ Interaction between worksheet using Userforms

2014-05-07 Thread Sherin
Hi I need to create a userform that selects data from one worksheet(sales) 
and then create an invoice in another worksheet. pls  advice

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


New Microsoft Excel Worksheet (3).xlsx
Description: MS-Excel 2007 spreadsheet


Re: $$Excel-Macros$$ Interaction between worksheet using Userforms

2014-05-07 Thread Bé Trần Văn
You need to design your bill, File attached, you need to know the data is
Cell Ayo bill does?

To enter data for faster, you should use Form Sheet.



2014-05-07 20:39 GMT+07:00 Sherin :

> Hi I need to create a userform that selects data from one worksheet(sales)
> and then create an invoice in another worksheet. pls  advice
>
> --
> 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$$ Hi - Details needed for the MIS Executive Qualification

2014-05-07 Thread Surya Narayanan PV


Hi sir I am currently working as Junior Software engineer/MIS for the past 
2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also 
generate reports as per the requirement, so do have an average knowledge in 
Excel. But I have to set my future career in MIS dept. so I would like your 
help in tuning up myself. Kindly advice me about what all things I should 
learn.

 

https://www.facebook.com/surya.narayanan.96387?ref=br_rs&fref=browse_search

Regards,

Surya

On Monday, August 1, 2011 11:18:42 AM UTC+5:30, Venkat CV wrote:
>
>
> Welcome Krish
>
> On Sat, Jul 30, 2011 at 10:01 PM, krishna mummina 
> 
> > wrote:
>
>> vijaykumar and venkat
>>
>> thank you very much for your valuable input.
>>
>>
>> On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR 
>> 
>> > wrote:
>>
>>> Dear Krishna,
>>>
>>>
>>> The profile of MIS Executive changes with the type organisation.If it is 
>>> a small organisation MIS Executive role would be to prepare normal reports 
>>>  like the work you do.If it is a big and reputed organisation your role in 
>>> addition to normal report preparation would be to do fianacial modelling or 
>>> creating financial model which would help the management in its decision 
>>> making process. For more information for using excel in financial modelling 
>>> u can refer to the website   www.exinfm.com.
>>>
>>>
>>>
>>> Regards,
>>> Vijaykumar
>>>  
>>>
>>> On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
>>> 
>>> > wrote:
>>>
 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My 
 daily work includes working with excel, Creating General Reports, Pdf to 
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like, 
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS 
 Executive. I just want to know the exact qualification needed for the job. 
 I mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know 
 from you people,


 Thanking you and Waiting for your reply   - Krrish 

 -- 

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links : 
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to 
 excel-...@googlegroups.com
  
 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> -- 
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> P.VIJAY KUMAR
>>>  
>>> -- 
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links : 
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-...@googlegroups.com
>>>  
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>  -- 
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links : 
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-...@googlegroups.com
>>  
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> -- 
> *Best Regards,*
> *Venkat*
> *Chennai*
>
>  
>  
>
>

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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

2014-05-07 Thread Surya Narayanan PV
My Mail Id : surya.i...@gmail.com

On Thursday, May 8, 2014 1:49:39 AM UTC+5:30, Surya Narayanan PV wrote:
>
> Hi sir I am currently working as Junior Software engineer/MIS for the past 
> 2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also 
> generate reports as per the requirement, so do have an average knowledge in 
> Excel. But I have to set my future career in MIS dept. so I would like your 
> help in tuning up myself. Kindly advice me about what all things I should 
> learn.
>
>  
>
> https://www.facebook.com/surya.narayanan.96387?ref=br_rs&fref=browse_search
>
> Regards,
>
> Surya
>
> On Monday, August 1, 2011 11:18:42 AM UTC+5:30, Venkat CV wrote:
>>
>>
>> Welcome Krish
>>
>> On Sat, Jul 30, 2011 at 10:01 PM, krishna mummina wrote:
>>
>>> vijaykumar and venkat
>>>
>>> thank you very much for your valuable input.
>>>
>>>
>>> On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR wrote:
>>>
 Dear Krishna,


 The profile of MIS Executive changes with the type organisation.If it 
 is a small organisation MIS Executive role would be to prepare normal 
 reports  like the work you do.If it is a big and reputed organisation your 
 role in addition to normal report preparation would be to do fianacial 
 modelling or creating financial model which would help the management in 
 its decision making process. For more information for using excel in 
 financial modelling u can refer to the website   www.exinfm.com.



 Regards,
 Vijaykumar
  

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 wrote:

> Hi Group,
>
> My Name is krishna, Working as a Data Analyst from the last 3 years. 
> My daily work includes working with excel, Creating General Reports, Pdf 
> to 
> Excel Conversion, Data Mining and Analyzing data by using Data Tools 
> like, 
> Filter, Formulas, Sorting etc..
>
> But I got a mail from one of my friend, It is an Opening for MIS 
> Executive. I just want to know the exact qualification needed for the 
> job. 
> I mean, what are the Tools i need to know,
>
> I know, Many of us are already well settled. So, I just want to know 
> from you people,
>
>
> Thanking you and Waiting for your reply   - Krrish 
>
> -- 
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ 
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-...@googlegroups.com
>  
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



 -- 









 P.VIJAY KUMAR
  
 -- 

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links : 
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-...@googlegroups.com
  
 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>  -- 
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links : 
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-...@googlegroups.com
>>>  
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> -- 
>> *Best Regards,*
>> *Venkat*
>> *Chennai*
>>
>>  
>>  
>>
>>

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

$$Excel-Macros$$ Excel 2013 Userform Popup menu

2014-05-07 Thread The Frog
Hi Everyone,

I am having trouble making a pop-up menu display when working with a 
userform in Excel 2013. In the past I have used the CommandBars to create 
my popup, but this no longer seems to work. When trying to display any 
commandbar created popup menu in a userform the .ShowPopup method fails. I 
have no idea why.

The problem is easy to reproduce:
1/ Create a new userform
2/ In the forms Initialize event create the CommandBar Object:

On Error Resume Next
Application.CommandBars("myMenu").Delete
On Error GoTo 0

With CommandBars.Add(Name:="myMenu", Position:=msoBarPopup, 
MenuBar:=False, temporary:=True)
.Controls.Add Type:=msoControlButton
.Controls(1).Caption = "New Group"
.Controls(1).OnAction = "addValueGroup"
.Controls(1).FaceId = 71
.Controls.Add Type:=msoControlButton
.Controls(2).Caption = "Delete Group"
.Controls(2).OnAction = "removeValueGroup"
.Controls(2).FaceId = 72
End With

3/ In the forms Click event:
Application.CommandBars("myMenu").ShowPopup


You will get an error on the .ShowPopup method call.

I dont know what the cause of this error is. Any help is greatly 
appreciated.

Cheers

The Frog

-- 
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$$ Automation Site (2).xlsx

2014-05-07 Thread Vaibhav Joshi
Hi

What  you want exactly?

E.G. for IN-132 on 1 May DG was run for 3 times so do you want 3
against 1st May ?


Cheers!!


On Thu, May 8, 2014 at 11:35 AM, Neeraj Chauhan
wrote:

>  Dear experts,
>
>
>
> Kindly find the attached sheet there are alarm sheet and I want to know dg
> running date wise like
>
>
>
> Indus id  1may 2may
>
> 123456  2  3
>
> --
> 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$$ Automation Site (2).xlsx

2014-05-07 Thread Neeraj Chauhan
I want to make the differences of time in Hours from column J and K

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Vaibhav Joshi
Sent: Thursday, May 08, 2014 12:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Automation Site (2).xlsx

 

Hi

 

What  you want exactly?

 

E.G. for IN-132 on 1 May DG was run for 3 times so do you want 3 against 
1st May ?

 

See attachment ..

 

Cheers!!

   

 

On Thu, May 8, 2014 at 11:48 AM, Vaibhav Joshi  wrote:

Hi

 

What  you want exactly?

 

E.G. for IN-132 on 1 May DG was run for 3 times so do you want 3 against 
1st May ?

 

 

Cheers!!

 

On Thu, May 8, 2014 at 11:35 AM, Neeraj Chauhan  
wrote:

Dear experts,

 

Kindly find the attached sheet there are alarm sheet and I want to know dg 
running date wise like

 

Indus id  1may 2may

123456  2  3

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