$$Excel-Macros$$ Double click event for different column

[SAJID MEMON]

 



Dear Experts,
 
I have attached my file, here different column double clicking and data should 
paste in different columns, I have done only in one column and other is unable 
to do. please co-operate me to complete my assignment.
 
Awaiting your positive response
 
Regards
Sajid Memon

  

-- 
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/groups/opt_out.




beforerightclickeventConditionally.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$

[SAJID MEMON]

Dear Experts,
 
I have attached my file, here different column double clicking and data should 
paste in different columns, I have done only in one column and other is unable 
to do. please co-operate me to complete my assignment.
 
Awaiting your positive response
 
Regards
Sajid Memon
  

-- 
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/groups/opt_out.




beforerightclickeventConditionally.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

[Don Barton]

vba, thanks for your suggestion, which will work fine in formula.
De Premor - the code works exactly as designed with our barcode scanner!
 Our Blood Bank supervisor is impressed!

Thanks you so much for your quick reply and expert help.

Don




On Mon, Jul 29, 2013 at 12:37 PM, De Premor  wrote:

>  try this code
>
> Sub trunkit()
> Dim Ctx As Range
>
> 'We use this method to get dynamic Record count in C Column
> For Each Ctx In Range("C2:" & Cells(Range("C:C").Rows.Count,
> 3).End(xlUp).Address)
> If Right(Ctx, 2) = "00" Then
> 'Replace "=" sign, from removed 00 string
> Ctx.Value = Replace(Left(Ctx, Len(Ctx) - 2), "=", "")
> Else
> 'Clear cell if last 2 char not "00"
> Ctx.Value = ""
> End If
> Next
> End Sub
>
>
> Pada 30/07/2013 0:46, Sam Mathai Chacko menulis:
>
> Are the entire code only numerics, or are they alpha numeric?
>
>
> On Mon, Jul 29, 2013 at 10:44 PM, Don Barton  wrote:
>
>> Greetings,
>> We have a scanner we use to scan a barcode for blood units for a hospital
>> into an Excel spreadsheet.  The scanner reads the entire barcode, but we
>> want to remove  "00" at the end of the scanned string. If there isn't "00"
>> at the end, make it null cell.  We are using the correct symbology for the
>> barcode scanner.
>>
>> Sub trunkit()
>>
>>   For ctx = 2 To 100
>>If Right(Cells(ctx, 3), 2) = ”00” Then
>>  Trim (Right(Cells(ctx, 3), 2))
>>Else
>> IsNull (Cells(ctx, 3))
>>End If
>>   Next ctx
>>   End Sub
>>
>>
>>  --
>> 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Sam Mathai Chacko
> --
> 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/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

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

[De Premor]

try this code

Sub trunkit()
Dim Ctx As Range

'We use this method to get dynamic Record count in C Column
For Each Ctx In Range("C2:" & Cells(Range("C:C").Rows.Count, 
3).End(xlUp).Address)

If Right(Ctx, 2) = "00" Then
'Replace "=" sign, from removed 00 string
Ctx.Value = Replace(Left(Ctx, Len(Ctx) - 2), "=", "")
Else
'Clear cell if last 2 char not "00"
Ctx.Value = ""
End If
Next
End Sub


Pada 30/07/2013 0:46, Sam Mathai Chacko menulis:

Are the entire code only numerics, or are they alpha numeric?


On Mon, Jul 29, 2013 at 10:44 PM, Don Barton > wrote:


Greetings,
We have a scanner we use to scan a barcode for blood units for a
hospital into an Excel spreadsheet.  The scanner reads the entire
barcode, but we want to remove "00" at the end of the scanned
string. If there isn't "00" at the end, make it null cell.  We are
using the correct symbology for the barcode scanner.

Sub trunkit()

  For ctx = 2 To 100
   If Right(Cells(ctx, 3), 2) = ”00” Then
 Trim (Right(Cells(ctx, 3), 2))
   Else
IsNull (Cells(ctx, 3))
   End If
  Next ctx
  End Sub

-- 
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/groups/opt_out.





--
Sam Mathai Chacko
--
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/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 pos

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

[vba]

Hey

You can do do with formula

=MID (A1, 2, LEN (A2)-3)

HTH//Cheers
On 29 Jul 2013 23:48, "Don Barton"  wrote:

> Hi Sam,
> When the barcode is scanned it reads in alphnumerics and symbols.  The
> only symbol we have to worry about is the "=" sign at the beginning. In the
> example above I just asked about the "00" at the end.  If I can get the
> code for the "00", I should be able to figure out the code for the "=" at
> the beginning. An actual scanned example is: "=W05631300409200". If the
> column is formatted as text, the "=" is retained in the string, otherwise,
> Excel will try to do something with it, and it isn't understood.
> Thanks,
> Don
>
>
> On Mon, Jul 29, 2013 at 11:46 AM, Sam Mathai Chacko wrote:
>
>> Are the entire code only numerics, or are they alpha numeric?
>>
>>
>> On Mon, Jul 29, 2013 at 10:44 PM, Don Barton wrote:
>>
>>> Greetings,
>>> We have a scanner we use to scan a barcode for blood units for a
>>> hospital into an Excel spreadsheet.  The scanner reads the entire barcode,
>>> but we want to remove  "00" at the end of the scanned string. If there
>>> isn't "00" at the end, make it null cell.  We are using the correct
>>> symbology for the barcode scanner.
>>>
>>> Sub trunkit()
>>>
>>>   For ctx = 2 To 100
>>>If Right(Cells(ctx, 3), 2) = ”00” Then
>>>  Trim (Right(Cells(ctx, 3), 2))
>>>Else
>>> IsNull (Cells(ctx, 3))
>>>End If
>>>   Next ctx
>>>   End Sub
>>>
>>>
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> 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/tU53tTwrKIA/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.
>>
>>
>>
>
>
>
> --
> Don
>
> --
> 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 :

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

[Don Barton]

Hi Sam,
When the barcode is scanned it reads in alphnumerics and symbols.  The only
symbol we have to worry about is the "=" sign at the beginning. In the
example above I just asked about the "00" at the end.  If I can get the
code for the "00", I should be able to figure out the code for the "=" at
the beginning. An actual scanned example is: "=W05631300409200". If the
column is formatted as text, the "=" is retained in the string, otherwise,
Excel will try to do something with it, and it isn't understood.
Thanks,
Don


On Mon, Jul 29, 2013 at 11:46 AM, Sam Mathai Chacko wrote:

> Are the entire code only numerics, or are they alpha numeric?
>
>
> On Mon, Jul 29, 2013 at 10:44 PM, Don Barton  wrote:
>
>> Greetings,
>> We have a scanner we use to scan a barcode for blood units for a hospital
>> into an Excel spreadsheet.  The scanner reads the entire barcode, but we
>> want to remove  "00" at the end of the scanned string. If there isn't "00"
>> at the end, make it null cell.  We are using the correct symbology for the
>> barcode scanner.
>>
>> Sub trunkit()
>>
>>   For ctx = 2 To 100
>>If Right(Cells(ctx, 3), 2) = ”00” Then
>>  Trim (Right(Cells(ctx, 3), 2))
>>Else
>> IsNull (Cells(ctx, 3))
>>End If
>>   Next ctx
>>   End Sub
>>
>>
>>
>> --
>> 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> 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/tU53tTwrKIA/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.
>
>
>



-- 
Don

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

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

[Sam Mathai Chacko]

Are the entire code only numerics, or are they alpha numeric?


On Mon, Jul 29, 2013 at 10:44 PM, Don Barton  wrote:

> Greetings,
> We have a scanner we use to scan a barcode for blood units for a hospital
> into an Excel spreadsheet.  The scanner reads the entire barcode, but we
> want to remove  "00" at the end of the scanned string. If there isn't "00"
> at the end, make it null cell.  We are using the correct symbology for the
> barcode scanner.
>
> Sub trunkit()
>
>   For ctx = 2 To 100
>If Right(Cells(ctx, 3), 2) = ”00” Then
>  Trim (Right(Cells(ctx, 3), 2))
>Else
> IsNull (Cells(ctx, 3))
>End If
>   Next ctx
>   End Sub
>
>
>
> --
> 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/groups/opt_out.
>
>
>



-- 
Sam Mathai Chacko

-- 
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/groups/opt_out.

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

[vba]

Welcome back DP :)

Its been pleasure having you.

Cheers
On 29 Jul 2013 22:47, "De Premor"  wrote:

>  just remember, that i also not yet introduce my self :(
>
> then let me introduce my self
> You can call me *De* *Premor* and i am working in Network and
> Infrastucture Division at intermediate Palm and Oil Mills in beautiful
> Borneo, Indonesia, i love to learn programming in my spare time since i
> still dont know much about it, thats why i'am here :)
>
> I'am glad found this group that have lots of great people and helping each
> other, please help me to go to right way in excel and vba.
>
> Rgds,
> [dp]
>
> Note:
> English is not my main language, please forgive me if i'am wrong in that
> thing.
>
> --
> 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/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/groups/opt_out.

Re: $$Excel-Macros$$ Occurrence of a Denominaton

[vba]

Hey

Use this formula: =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))

Where A2:A10 is range of your data.

Thanks!!


On Mon, Jul 29, 2013 at 10:27 PM, Kush Shama wrote:

> Dear Team
>
> I have a Query. Let says I have a column in which multiple denominations
> are written. for example, A1 contains 1000, a2 contains 100 and A3 contains
> 500. Lets say I have 140 Such Cells in same column A. If I wish to count
> how many have a particular denomination, or the number of occurrence of a
> denomination in a particular column, please suggest a formula..
>
> --
> Regards Always,
>
> Kushlesh Sharma
> 9907517169
>
>
>
>  --
> 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/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/groups/opt_out.

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

[De Premor]

just remember, that i also not yet introduce my self :(

then let me introduce my self
You can call me *De* *Premor* and i am working in Network and 
Infrastucture Division at intermediate Palm and Oil Mills in beautiful 
Borneo, Indonesia, i love to learn programming in my spare time since i 
still dont know much about it, thats why i'am here :)


I'am glad found this group that have lots of great people and helping 
each other, please help me to go to right way in excel and vba.


Rgds,
[dp]

Note:
English is not my main language, please forgive me if i'am wrong in that 
thing.


--
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/groups/opt_out.

$$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

[Don Barton]

Greetings, 
We have a scanner we use to scan a barcode for blood units for a hospital 
into an Excel spreadsheet.  The scanner reads the entire barcode, but we 
want to remove  "00" at the end of the scanned string. If there isn't "00" 
at the end, make it null cell.  We are using the correct symbology for the 
barcode scanner.

Sub trunkit()

  For ctx = 2 To 100
   If Right(Cells(ctx, 3), 2) = ”00” Then
 Trim (Right(Cells(ctx, 3), 2))
   Else
IsNull (Cells(ctx, 3))
   End If
  Next ctx
  End Sub

 

-- 
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/groups/opt_out.

$$Excel-Macros$$ Occurrence of a Denominaton

[Kush Shama]

Dear Team

I have a Query. Let says I have a column in which multiple denominations
are written. for example, A1 contains 1000, a2 contains 100 and A3 contains
500. Lets say I have 140 Such Cells in same column A. If I wish to count
how many have a particular denomination, or the number of occurrence of a
denomination in a particular column, please suggest a formula..

-- 
Regards Always,

Kushlesh Sharma
9907517169

-- 
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/groups/opt_out.

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

[vba]

Hey

Welcome on the board.
On 29 Jul 2013 22:18, "Don Barton"  wrote:

> Greetings,
>
> My name is Don Barton and I am a laboratory informaticist at a small
> hospital in beautiful Colorado, USA.  I've done a lot of work in Access,
> but am needing to learn VBA in Excel.  Look forward to interacting with you
> all.
>
> Don
>
>  --
> 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/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/groups/opt_out.

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

[Don Barton]

Greetings,

My name is Don Barton and I am a laboratory informaticist at a small 
hospital in beautiful Colorado, USA.  I've done a lot of work in Access, 
but am needing to learn VBA in Excel.  Look forward to interacting with you 
all.

Don

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

[Ashish Kumar]

Dear Prabhu,

THANKS A LOT.

On 29 July 2013 20:41, Prabhu Pinky  wrote:

> Sumif - used to sum the range by checking single condition.
> Sumifs - used to sum the range by checking multiple conditions.
>
> Countif - used to count the range by checking single condiyion.
> Countifs - used to count the range by checking multiple conditions.
> On Jul 29, 2013 8:28 PM, "Ashish Kumar"  wrote:
>
>> Dear seniors,
>>
>> How can we use sum & sumifs , countif & countifs. and what is the
>> diffrence between. pls explain with formula and example. pls help me.
>>
>>
>>
>> thanks
>> Ashish
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like 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/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 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/0CLM5tYOfjs/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/groups/opt_out.

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

[Ashish Kumar]

Dear Rajasekhar,

THanks

On 29 July 2013 21:00, Rajasekhar Praharaju
wrote:

> Hi Ashish,
>
> Just go through this link... you have good examples...
>
> http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
>
> Thanks,
> Raj
>
>
> On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote:
>
>> Sumif - used to sum the range by checking single condition.
>> Sumifs - used to sum the range by checking multiple conditions.
>>
>> Countif - used to count the range by checking single condiyion.
>> Countifs - used to count the range by checking multiple conditions.
>> On Jul 29, 2013 8:28 PM, "Ashish Kumar" 
>> wrote:
>>
>>> Dear seniors,
>>>
>>> How can we use sum & sumifs , countif & countifs. and what is the
>>> diffrence between. pls explain with formula and example. pls help me.
>>>
>>>
>>>
>>> thanks
>>> Ashish
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like 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/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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> --
> Thanks & Regards,
> *Rajasekhar.P*
>
>
>  --
> 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/0CLM5tYOfjs/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 

Re: $$Excel-Macros$$ Tricky tricks - 1

[Secret Shot]

Put "=" sign in cell A2 itself at the bagining of the text... :P


On Sun, Jul 28, 2013 at 1:46 PM, De Premor  wrote:

>  create defined name in example : "*Eval**A2*" that referring to
> =EVALUATE(A2)
>
> Then in some cell in that sheet, just type *=EvalA2**
> *
>
>
> Pada 28/07/2013 14:59, xlstime menulis:
>
>  and what about formula
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:
>
>>  using udf
>> On Cell A3, type* =Eval(A2)*
>>
>> then, on VBE, add module and paste this code
>> *Function eval(str As String)**
>> **eval = Evaluate(str)**
>> **End Function**
>> * :-X
>>
>> On 28/07/2013 12:09, xlstime wrote:
>>
>>  Hi All,
>>
>>  How to Evaluate cell value.
>>
>>  let assume that, in cell A2 -  '1+2+3+4'
>>
>>  now how to sum or calculate cell value
>>
>>  hint: evaluate
>>
>>  .
>>
>> Enjoy
>> Team XLS
>>
>>  --
>> 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/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/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/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 @
>

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

[Rajasekhar Praharaju]

Hi Ashish,

Just go through this link... you have good examples...

http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/

Thanks,
Raj


On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote:

> Sumif - used to sum the range by checking single condition.
> Sumifs - used to sum the range by checking multiple conditions.
>
> Countif - used to count the range by checking single condiyion.
> Countifs - used to count the range by checking multiple conditions.
> On Jul 29, 2013 8:28 PM, "Ashish Kumar"  wrote:
>
>> Dear seniors,
>>
>> How can we use sum & sumifs , countif & countifs. and what is the
>> diffrence between. pls explain with formula and example. pls help me.
>>
>>
>>
>> thanks
>> Ashish
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like 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/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/groups/opt_out.
>
>
>



-- 
-- 
Thanks & Regards,
*Rajasekhar.P*

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

[Prabhu Pinky]

Sumif - used to sum the range by checking single condition.
Sumifs - used to sum the range by checking multiple conditions.

Countif - used to count the range by checking single condiyion.
Countifs - used to count the range by checking multiple conditions.
On Jul 29, 2013 8:28 PM, "Ashish Kumar"  wrote:

> Dear seniors,
>
> How can we use sum & sumifs , countif & countifs. and what is the
> diffrence between. pls explain with formula and example. pls help me.
>
>
>
> thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like 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/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/groups/opt_out.

$$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

[Ashish Kumar]

Dear seniors,

How can we use sum & sumifs , countif & countifs. and what is the diffrence 
between. pls explain with formula and example. pls help me.



thanks
Ashish

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like 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/groups/opt_out.

Re: $$Excel-Macros$$ need vlookup formula help

[De Premor]

Try to use this in cell B2

*=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)**
*
Copy it down

Pada 29/07/2013 18:22, Dhaval Shah menulis:

here with attach a file for reference


On Mon, Jul 29, 2013 at 4:49 PM, Dhaval Shah > wrote:




Friends ,

In below pic there is a formula in B2
=VLOOKUP($A2,'12'!$B$2:$R$302,16,FALSE) in the formula capture the
data from Sheet *12 *actually every time I need it to do manually
is it way ??

Suppose I change  in B1 from 12 to 13 then in B2 out put side
automatic looking value from sheet *13 *



-- 
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/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/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/groups/opt_out.

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

[De Premor]

ups sorry, please ignore my last email, i've replied a wrong topic
My bad
:-\

Pada 29/07/2013 19:37, De Premor menulis:

Try to use this in cell B2

*=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)**
*
Copy it down


Pada 27/07/2013 20:44, Puttu * menulis:

Experts your assistance is much appreciated.


On Sat, Jul 27, 2013 at 4:55 PM, Puttu * > wrote:


Hi Experts,

Need a help on copying the data from one workbook (Reference) to
another workbook (master). I know asking too much, appreciate
could you please help me on this coding.

The workbook name different each time, i need dynamic name
selection option to select both the work sheets and data range
also dynamic.

1. Need a option or input box to select the two workbooks

2. Each workbook sheets names are not aligned properly, each time
worksheet name to cross verify and past as per the match.

3. Copy the data from reference (report 1) and past to Master
(report 1) next to the existing range (Example showed in Master
sheet report 1 highlighted in yellow color)

4. After the paste Sales report header merged to complete header
(shown in master sheet report 1)

5. entire data need to auto fit

6. Need a report log after each sheet is pasted in new sheets in
the master work book.

Attached is the reports

-- 
Putta
-- 
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/groups/opt_out.





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

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

[De Premor]

Try to use this in cell B2

*=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)**
*
Copy it down


Pada 27/07/2013 20:44, Puttu * menulis:

Experts your assistance is much appreciated.


On Sat, Jul 27, 2013 at 4:55 PM, Puttu * > wrote:


Hi Experts,

Need a help on copying the data from one workbook (Reference) to
another workbook (master). I know asking too much, appreciate
could you please help me on this coding.

The workbook name different each time, i need dynamic name
selection option to select both the work sheets and data range
also dynamic.

1. Need a option or input box to select the two workbooks

2. Each workbook sheets names are not aligned properly, each time
worksheet name to cross verify and past as per the match.

3. Copy the data from reference (report 1) and past to Master
(report 1) next to the existing range (Example showed in Master
sheet report 1 highlighted in yellow color)

4. After the paste Sales report header merged to complete header
(shown in master sheet report 1)

5. entire data need to auto fit

6. Need a report log after each sheet is pasted in new sheets in
the master work book.

Attached is the reports

-- 
Putta
-- 
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/groups/opt_out.





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

Re: $$Excel-Macros$$ Re: I appreciate your help :-)

[P.VIJAYKUMAR]

Respected Sonu,

Please look into the following links for explanation.There are also other
links on the net, but these may help you undersatnd OFFSET function better.
http://www.myonlinetraininghub.com/excel-offset-function-explained
http://www.youtube.com/watch?v=kvXToxeiS6Y
http://chandoo.org/wp/2012/09/17/offset-formula-explained/

Regards,
Vijaykumar






On Mon, Jul 29, 2013 at 2:54 PM, Sonu Kumar  wrote:

> Hello Ayush,
>
> I just want to know the functionality of offset. How to use it.
>
> Note - I am able to use Vlookup, index, match. But unable to understand
> the offset option. Please guide me asap.
>
> Thanks,
> Sonu
>
> On Thursday, March 7, 2013 9:36:29 PM UTC+5:30, Ayush Jain wrote:
>>
>> Dear members,
>>
>> Let's keep this post to recognize the forum members who have helped you
>> in solving problem or has shared any knowledge in the forum.
>> Let see who recognize first here.
>>
>> Thanks.
>>
>> Regards
>> Ayush Jain
>>
>  --
> 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/groups/opt_out.
>
>
>



-- 









P.VIJAY KUMAR

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: I appreciate your help :-)

[Sonu Kumar]

Hello Ayush,

I just want to know the functionality of offset. How to use it.

Note - I am able to use Vlookup, index, match. But unable to understand the 
offset option. Please guide me asap.

Thanks,
Sonu

On Thursday, March 7, 2013 9:36:29 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members, 
>
> Let's keep this post to recognize the forum members who have helped you in 
> solving problem or has shared any knowledge in the forum.
> Let see who recognize first here.
>
> Thanks.
>
> Regards
> Ayush Jain
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

[Puttu *]

please help me on the macro..


On Sun, Jul 28, 2013 at 10:14 AM, Puttu *  wrote:

> Any updated on the macro team..
>
>
> On Sat, Jul 27, 2013 at 7:14 PM, Puttu *  wrote:
>
>> Experts your assistance is much appreciated.
>>
>>
>> On Sat, Jul 27, 2013 at 4:55 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> Need a help on copying the data from one workbook (Reference) to another
>>> workbook (master). I know asking too much, appreciate could you please help
>>> me on this coding.
>>>
>>> The workbook name different each time, i need dynamic name selection
>>> option to select both the work sheets and data range also dynamic.
>>>
>>> 1. Need a option or input box to select the two workbooks
>>>
>>> 2. Each workbook sheets names are not aligned properly, each time
>>> worksheet name to cross verify and past as per the match.
>>>
>>> 3. Copy the data from reference (report 1) and past to Master (report 1)
>>> next to the existing range (Example showed in Master sheet report 1
>>> highlighted in yellow color)
>>>
>>> 4. After the paste Sales report header merged to complete header (shown
>>> in master sheet report 1)
>>>
>>> 5. entire data need to auto fit
>>>
>>> 6. Need a report log after each sheet is pasted in new sheets in the
>>> master work book.
>>>
>>> Attached is the reports
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

[De Premor]

This is the sample code, you can set it up in ExpDate variable

Private Sub Workbook_Open()
Dim ExpDate As Date
ExpDate = #8/17/2013 10:00:00 AM#

If Now > ExpDate Then ThisWorkbook.Close
MsgBox "This workbook will expired at " & Format(ExpDate, "dd  
 hh:mm:ss AM/PM")

End Sub

Rgds,
[dp]

On 29/07/2013 15:39, Kannan Excel wrote:

can u do me a favor???

i don't want user and pswd...
i want vb coding for expire date and time

pls send that code how to set date and time to expire



On Mon, Jul 29, 2013 at 1:16 PM, De Premor > wrote:


try this attached file

user, pass, and expiration date defined in a sheet


On 29/07/2013 13:05, Mangesh Vimay wrote:

Thanks for asking this query.

Appreciate your mind !!!

And also thanks De Pemor for the solution.

Have a great day all !!!

On 7/29/13, Kannan Excel mailto:kannan.ex...@gmail.com>> wrote:

Hi,

I want to set particular date and* time* also for expire
 is this
possible.???

Or i want to set date and time for password...

When i set date and time, password will appear
automatically

pls do the needful ASAP...






On Sat, Jul 27, 2013 at 3:19 PM, De Premor mailto:d...@premor.net>> wrote:

  Using macro, but required user to run the macro

This is the basic, user still can skip this by
changing date on his
computer

Private Sub Workbook_Open()
 Dim Expired As Date
 Expired = "20 Jul 2013"

 If Now() > Expired Then
 MsgBox "File " & ThisWorkbook.FullName & "
expired"
 ThisWorkbook.Close
 End If

End Sub

Next step, you may add a cell validation on current
file to avoid skipped
by user with changin the date on his computer
Once the expiration msg appear, it will write in
sheet1 cell A1 a word
EXPIRED, then everytime file open, it will check that
cell and also the
date on current computer, if one of that criteria
match then it will
still close the workbook.

 If Now() > Expired or *Sheet1**.Range(**"A1") =
"EXPIRED"* Then
 MsgBox "File " & ThisWorkbook.FullName & "
expired"
*if Sheet1**.Range(**"A1") <> "EXPIRED" then
 **   Sheet1.Range("A1") = "EXPIRED"**
*   *ThisWorkbook.Save
End If
* ThisWorkbook.Close
 End If

Rgds,
[dp]

  Pada 27/07/2013 15:55, Kannan Excel menulis:

Hi,

  how to make a file expire after a period of time.


  regards
Kannan V
  --
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/gr

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

[Kannan Excel]

thanks  thanks a lot  i am really happy.


On Mon, Jul 29, 2013 at 2:13 PM, De Premor  wrote:

>  sorry little mistake there, try new attached
>
>
> On 29/07/2013 15:37, Kannan Excel wrote:
>
> how to make this???
>
>  can u send code???
>
>  and if i type user and pswd means, permission granted or user has
> expired message only appear...
>
>  excel sheet not open...
>
>
>
>
> On Mon, Jul 29, 2013 at 1:16 PM, De Premor  wrote:
>
>> try this attached file
>>
>> user, pass, and expiration date defined in a sheet
>>
>>
>> On 29/07/2013 13:05, Mangesh Vimay wrote:
>>
>>> Thanks for asking this query.
>>>
>>> Appreciate your mind !!!
>>>
>>> And also thanks De Pemor for the solution.
>>>
>>> Have a great day all !!!
>>>
>>> On 7/29/13, Kannan Excel  wrote:
>>>
 Hi,

 I want to set particular date and* time* also for expire  is this
 possible.???

 Or i want to set date and time for password...

 When i set date and time, password will appear automatically

 pls do the needful ASAP...






 On Sat, Jul 27, 2013 at 3:19 PM, De Premor  wrote:

Using macro, but required user to run the macro
>
> This is the basic, user still can skip this by changing date on his
> computer
>
> Private Sub Workbook_Open()
>  Dim Expired As Date
>  Expired = "20 Jul 2013"
>
>  If Now() > Expired Then
>  MsgBox "File " & ThisWorkbook.FullName & " expired"
>  ThisWorkbook.Close
>  End If
>
> End Sub
>
> Next step, you may add a cell validation on current file to avoid
> skipped
> by user with changin the date on his computer
> Once the expiration msg appear, it will write in sheet1 cell A1 a word
> EXPIRED, then everytime file open, it will check that cell and also the
> date on current computer, if one of that criteria match then it will
> still close the workbook.
>
>  If Now() > Expired or *Sheet1**.Range(**"A1") = "EXPIRED"* Then
>  MsgBox "File " & ThisWorkbook.FullName & " expired"
> *if Sheet1**.Range(**"A1") <> "EXPIRED" then
>  **   Sheet1.Range("A1") = "EXPIRED"**
> *   *ThisWorkbook.Save
> End If
> * ThisWorkbook.Close
>  End If
>
> Rgds,
> [dp]
>
>   Pada 27/07/2013 15:55, Kannan Excel menulis:
>
> Hi,
>
>   how to make a file expire after a period of time.
>
>
>   regards
> Kannan V
>   --
> 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/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

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

[Kannan Excel]

can u do me a favor???

i don't want user and pswd...
i want vb coding for expire date and time

pls send that code how to set date and time to expire



On Mon, Jul 29, 2013 at 1:16 PM, De Premor  wrote:

> try this attached file
>
> user, pass, and expiration date defined in a sheet
>
>
> On 29/07/2013 13:05, Mangesh Vimay wrote:
>
>> Thanks for asking this query.
>>
>> Appreciate your mind !!!
>>
>> And also thanks De Pemor for the solution.
>>
>> Have a great day all !!!
>>
>> On 7/29/13, Kannan Excel  wrote:
>>
>>> Hi,
>>>
>>> I want to set particular date and* time* also for expire  is this
>>> possible.???
>>>
>>> Or i want to set date and time for password...
>>>
>>> When i set date and time, password will appear automatically
>>>
>>> pls do the needful ASAP...
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Sat, Jul 27, 2013 at 3:19 PM, De Premor  wrote:
>>>
>>>Using macro, but required user to run the macro

 This is the basic, user still can skip this by changing date on his
 computer

 Private Sub Workbook_Open()
  Dim Expired As Date
  Expired = "20 Jul 2013"

  If Now() > Expired Then
  MsgBox "File " & ThisWorkbook.FullName & " expired"
  ThisWorkbook.Close
  End If

 End Sub

 Next step, you may add a cell validation on current file to avoid
 skipped
 by user with changin the date on his computer
 Once the expiration msg appear, it will write in sheet1 cell A1 a word
 EXPIRED, then everytime file open, it will check that cell and also the
 date on current computer, if one of that criteria match then it will
 still close the workbook.

  If Now() > Expired or *Sheet1**.Range(**"A1") = "EXPIRED"* Then
  MsgBox "File " & ThisWorkbook.FullName & " expired"
 *if Sheet1**.Range(**"A1") <> "EXPIRED" then
  **   Sheet1.Range("A1") = "EXPIRED"**
 *   *ThisWorkbook.Save
 End If
 * ThisWorkbook.Close
  End If

 Rgds,
 [dp]

   Pada 27/07/2013 15:55, Kannan Excel menulis:

 Hi,

   how to make a file expire after a period of time.


   regards
 Kannan V
   --
 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+unsubscribe@**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-ma

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

[Kannan Excel]

how to make this???

can u send code???

and if i type user and pswd means, permission granted or user has expired
message only appear...

excel sheet not open...




On Mon, Jul 29, 2013 at 1:16 PM, De Premor  wrote:

> try this attached file
>
> user, pass, and expiration date defined in a sheet
>
>
> On 29/07/2013 13:05, Mangesh Vimay wrote:
>
>> Thanks for asking this query.
>>
>> Appreciate your mind !!!
>>
>> And also thanks De Pemor for the solution.
>>
>> Have a great day all !!!
>>
>> On 7/29/13, Kannan Excel  wrote:
>>
>>> Hi,
>>>
>>> I want to set particular date and* time* also for expire  is this
>>> possible.???
>>>
>>> Or i want to set date and time for password...
>>>
>>> When i set date and time, password will appear automatically
>>>
>>> pls do the needful ASAP...
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Sat, Jul 27, 2013 at 3:19 PM, De Premor  wrote:
>>>
>>>Using macro, but required user to run the macro

 This is the basic, user still can skip this by changing date on his
 computer

 Private Sub Workbook_Open()
  Dim Expired As Date
  Expired = "20 Jul 2013"

  If Now() > Expired Then
  MsgBox "File " & ThisWorkbook.FullName & " expired"
  ThisWorkbook.Close
  End If

 End Sub

 Next step, you may add a cell validation on current file to avoid
 skipped
 by user with changin the date on his computer
 Once the expiration msg appear, it will write in sheet1 cell A1 a word
 EXPIRED, then everytime file open, it will check that cell and also the
 date on current computer, if one of that criteria match then it will
 still close the workbook.

  If Now() > Expired or *Sheet1**.Range(**"A1") = "EXPIRED"* Then
  MsgBox "File " & ThisWorkbook.FullName & " expired"
 *if Sheet1**.Range(**"A1") <> "EXPIRED" then
  **   Sheet1.Range("A1") = "EXPIRED"**
 *   *ThisWorkbook.Save
 End If
 * ThisWorkbook.Close
  End If

 Rgds,
 [dp]

   Pada 27/07/2013 15:55, Kannan Excel menulis:

 Hi,

   how to make a file expire after a period of time.


   regards
 Kannan V
   --
 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+unsubscribe@**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 

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

[De Premor]

try this attached file

user, pass, and expiration date defined in a sheet

On 29/07/2013 13:05, Mangesh Vimay wrote:

Thanks for asking this query.

Appreciate your mind !!!

And also thanks De Pemor for the solution.

Have a great day all !!!

On 7/29/13, Kannan Excel  wrote:

Hi,

I want to set particular date and* time* also for expire  is this
possible.???

Or i want to set date and time for password...

When i set date and time, password will appear automatically

pls do the needful ASAP...






On Sat, Jul 27, 2013 at 3:19 PM, De Premor  wrote:


  Using macro, but required user to run the macro

This is the basic, user still can skip this by changing date on his
computer

Private Sub Workbook_Open()
 Dim Expired As Date
 Expired = "20 Jul 2013"

 If Now() > Expired Then
 MsgBox "File " & ThisWorkbook.FullName & " expired"
 ThisWorkbook.Close
 End If

End Sub

Next step, you may add a cell validation on current file to avoid skipped
by user with changin the date on his computer
Once the expiration msg appear, it will write in sheet1 cell A1 a word
EXPIRED, then everytime file open, it will check that cell and also the
date on current computer, if one of that criteria match then it will
still close the workbook.

 If Now() > Expired or *Sheet1**.Range(**"A1") = "EXPIRED"* Then
 MsgBox "File " & ThisWorkbook.FullName & " expired"
*if Sheet1**.Range(**"A1") <> "EXPIRED" then
 **   Sheet1.Range("A1") = "EXPIRED"**
*   *ThisWorkbook.Save
End If
* ThisWorkbook.Close
 End If

Rgds,
[dp]

  Pada 27/07/2013 15:55, Kannan Excel menulis:

Hi,

  how to make a file expire after a period of time.


  regards
Kannan V
  --
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/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/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 an