date:20141112

RE: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

2014-11-12 Thread Amit Desai (MERU)

Dear Ashish,

Thanks a lot for your efforts. However, I need the output in the same way as in 
my file...only difference is, the current file is not able to process text in 
cell with special characters.

Regards,
Amit Desai – MIS Manager
M: +91 9867232534
[Description: 
cid:image005.jpg@01CFB633.17E40300]

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ashish Kumar
Sent: Thursday, November 13, 2014 10:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of 
them

Hi Amit Sir,

Pls check, can it helps.


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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ regarding 4 step filter

2014-11-12 Thread Vaibhav Joshi

With macro also it is possible & quite easy.. will send you soon..

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Thu, Nov 13, 2014 at 11:52 AM, Pol Ktk  wrote:

> Thank you Sir
> wanted this type filter
> is it possible using macro
> pls send otherwise its ok
>
> thanks
>
>
> On 13 November 2014 11:26, Vaibhav Joshi  wrote:
>
>> Hi
>>
>> Check this..
>>
>> You need to create helper sheet to list all unique values if condition
>> matched..
>>
>> First i created unique list for first condition met then for second &
>> third & for 4th..
>>
>> Then using offset function i used those unique values in list box / data
>> validation...
>>
>> HTH/Cheers!!
>>
>> +
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Wed, Nov 12, 2014 at 5:29 PM, Pol Ktk  wrote:
>>
>>> Sir,
>>> in attached there are 2 sheet
>>> 1 sheet contain data in 2nd sheet need filter data
>>>
>>>
>>> thanks
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join offic

Re: $$Excel-Macros$$ regarding 4 step filter

2014-11-12 Thread Pol Ktk

Thank you Sir
wanted this type filter
is it possible using macro
pls send otherwise its ok

thanks


On 13 November 2014 11:26, Vaibhav Joshi  wrote:

> Hi
>
> Check this..
>
> You need to create helper sheet to list all unique values if condition
> matched..
>
> First i created unique list for first condition met then for second &
> third & for 4th..
>
> Then using offset function i used those unique values in list box / data
> validation...
>
> HTH/Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, Nov 12, 2014 at 5:29 PM, Pol Ktk  wrote:
>
>> Sir,
>> in attached there are 2 sheet
>> 1 sheet contain data in 2nd sheet need filter data
>>
>>
>> thanks
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: regarding 4 step filter

2014-11-12 Thread Pol Ktk

not accurate.

thanks for your mail sir

On 13 November 2014 10:33, Mandeep Baluja  wrote:

> Hey Pol check this sheet and confirm you want this kind of filters or not
> .
>
> *Thanks *
> *mandeep Baluja*
>
> On Wednesday, November 12, 2014 5:29:41 PM UTC+5:30, Pol Ktk wrote:
>>
>> Sir,
>> in attached there are 2 sheet
>> 1 sheet contain data in 2nd sheet need filter data
>>
>>
>> thanks
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Website Scraping

2014-11-12 Thread Rajnish Malhotra

I am trying to scrape questions, options and answers from this url 
(http://www.indiabix.com/general-knowledge/basic-general-knowledge/) but I 
have two issues:

1. In the ForEach loop, it has empty value and does not go in the following 
If Condition
2. Answer is not visible on webpage to scrape. It has a click event "View 
Answer" link (javascript I believe).

Please help. Thanks

Enum READYSTATE
READYSTATE_UNINITIALIZED = 0
READYSTATE_LOADING = 1
READYSTATE_LOADED = 2
READYSTATE_INTERACTIVE = 3
READYSTATE_COMPLETE = 4
End Enum

Sub ImportIndiaBixData()

'to refer to the running copy of Internet Explorer
Dim ie As InternetExplorer
'to refer to the HTML document returned
Dim html As HTMLDocument
'open Internet Explorer in memory, and go to website
Set ie = New InternetExplorer
ie.Visible = False
ie.navigate 
"http://www.indiabix.com/general-knowledge/basic-general-knowledge/";
'Wait until IE is done loading page
Do While ie.READYSTATE <> READYSTATE_COMPLETE
Application.StatusBar = "Trying to go to StackOverflow ..."
DoEvents
Loop
'show text of HTML document returned
Set html = ie.document
'close down IE and reset status bar
Set ie = Nothing
Application.StatusBar = ""

'clear old data out and put titles in
Cells.Clear

Dim QuestionList As IHTMLElement
Dim Questions As IHTMLElementCollection
Dim Question As IHTMLElement
Dim RowNumber As Long
Dim QuestionId As String
Dim QuestionFields As IHTMLElementCollection
Dim QuestionField As IHTMLElement
Dim votes As String
Dim views As String
Dim QuestionFieldLinks As IHTMLElementCollection

Set QuestionList = html.getElementById("ib-main-bar")
Set Questions = QuestionList.Children
RowNumber = 1

For Each Question In Questions
'if this is the tag containing the question details, process it
If Question.className = "bix-td-qtxt" Then

'first get and store the question in first column
QuestionId = Question.ID
Cells(RowNumber, 1).Value = CLng(QuestionId)

'get a list of all of the parts of this question,
'and loop over them
Set QuestionFields = Question.all
For Each QuestionField In QuestionFields

'if this is the question's options, store it
'look for option A and store it under the question
'look for option B and store it under A
'look for option C and store it under B
'look for option D and store it under C
'click the 'View Answer' link programatically and store the correct 
answer

Next QuestionField

'go on to next row of worksheet
RowNumber = RowNumber + 6
End If
Next
Set html = Nothing

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/d/optout.

Re: $$Excel-Macros$$ regarding 4 step filter

2014-11-12 Thread Vaibhav Joshi

Hi

Check this..

You need to create helper sheet to list all unique values if condition
matched..

First i created unique list for first condition met then for second & third
& for 4th..

Then using offset function i used those unique values in list box / data
validation...

HTH/Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Wed, Nov 12, 2014 at 5:29 PM, Pol Ktk  wrote:

> Sir,
> in attached there are 2 sheet
> 1 sheet contain data in 2nd sheet need filter data
>
>
> thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


filter data.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

2014-11-12 Thread Ashish Kumar

Thanks Vaibhav Bhai

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: regarding 4 step filter

2014-11-12 Thread Mandeep Baluja

Hey Pol check this sheet and confirm you want this kind of filters or not . 

*Thanks *
*mandeep Baluja*

On Wednesday, November 12, 2014 5:29:41 PM UTC+5:30, Pol Ktk wrote:
>
> Sir,
> in attached there are 2 sheet 
> 1 sheet contain data in 2nd sheet need filter data
>
>
> thanks
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Query filter data (1).xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Need help to create a user form.

2014-11-12 Thread Vaibhav Joshi

Great  one buddy!
On Nov 13, 2014 4:13 AM, "Bé Trần Văn"  wrote:

> Opening a file to show form.
>
> To import the data: Typing data into the form and click the Data Entry
>
>
> To edit data:Click listbox to select data, The data will appear on the
> form, Edit the data needed, and click Edit Data.
>
>
>
> 2014-11-12 13:34 GMT+07:00 Kamal Ganeshan :
>
>> Hi All,
>>
>> I want you to understand the requirements.
>>
>> Sub Brand numbers & Invoice number combination will be multiple.
>>
>> Can anyone will be help me out to create a user form.
>>
>> for eg:
>>
>> Brand numbers  Invoice numbersStatus
>> 90121   97012 2
>> 90121   97013 0
>> 90121   90124 1
>>
>> Regards,
>> Ganeshan
>>
>> On Wed, Nov 12, 2014 at 11:23 AM, Kamal Ganeshan
>>  wrote:
>> > Hi All,
>> >
>> > Need some help to create a User form based on the logic.
>> >
>> > If any enter Sub Brand numbers in cell F12 & Invoice number in cell
>> > G12 then I want the "H" should be update automatic as per the above
>> > table numbers.
>> >
>> > I have done the exercise which is manual Vlookup formula but i need
>> > the same logic in User form VBA .
>> >
>> > Requesting you to please do the needful & revert.
>> >
>> > Regards.
>> > Ganeshan
>> >
>> > --
>> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>> >
>> > FORUM RULES
>> >
>> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> > 2) Don't post a question in the thread of another member.
>> > 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> > 4) Acknowledge the responses you receive, good or bad.
>> > 5) Jobs posting is not allowed.
>> > 6) Sharing copyrighted material and their links is not allowed.
>> >
>> > NOTE  : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> > ---
>> > You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> an email to excel-macros+unsubscr...@googlegroups.com.
>> > To post to this group, send email to excel-macros@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/excel-macros.
>> > For more options, visit https://groups.google.com/d/optout.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

2014-11-12 Thread Vaibhav Joshi

Cool  bro..
On Nov 13, 2014 10:20 AM, "Ashish Kumar"  wrote:

> Hi Amit Sir,
>
> Pls check, can it helps.
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

2014-11-12 Thread Ashish Kumar

Hi Amit Sir,

Pls check, can it helps.


Regards
Ashish

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-12 Thread Ashish Kumar

Welcome Bud.

Regards
Ashish

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need help to create a user form.

2014-11-12 Thread Bé Trần Văn

 Opening a file to show form.

To import the data: Typing data into the form and click the Data Entry


To edit data:Click listbox to select data, The data will appear on the
form, Edit the data needed, and click Edit Data.



2014-11-12 13:34 GMT+07:00 Kamal Ganeshan :

> Hi All,
>
> I want you to understand the requirements.
>
> Sub Brand numbers & Invoice number combination will be multiple.
>
> Can anyone will be help me out to create a user form.
>
> for eg:
>
> Brand numbers  Invoice numbersStatus
> 90121   97012 2
> 90121   97013 0
> 90121   90124 1
>
> Regards,
> Ganeshan
>
> On Wed, Nov 12, 2014 at 11:23 AM, Kamal Ganeshan
>  wrote:
> > Hi All,
> >
> > Need some help to create a User form based on the logic.
> >
> > If any enter Sub Brand numbers in cell F12 & Invoice number in cell
> > G12 then I want the "H" should be update automatic as per the above
> > table numbers.
> >
> > I have done the exercise which is manual Vlookup formula but i need
> > the same logic in User form VBA .
> >
> > Requesting you to please do the needful & revert.
> >
> > Regards.
> > Ganeshan
> >
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
> >
> > FORUM RULES
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> > 2) Don't post a question in the thread of another member.
> > 3) Don't post questions regarding breaking or bypassing any security
> measure.
> > 4) Acknowledge the responses you receive, good or bad.
> > 5) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE  : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros.
> > For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visi

Re: $$Excel-Macros$$ My macro won't work in Excel 2013. Please help.

2014-11-12 Thread Daryl Zer0

Thanks Vabz:) I will try this.

On Tuesday, November 4, 2014 12:55:50 AM UTC-7, Vabz wrote:
>
> Hi
>
> Use this code:
>
> Sub Macro1()
> If ActiveSheet.FilterMode Then
> ActiveSheet.ShowAllData
> End If
> Range("F4:F16").ClearContents
> ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1, Criteria1:=RGB(255, _
> 0, 0), Operator:=xlFilterCellColor
> a = Range("A" & Rows.Count).End(xlUp).Row
> Set Rng = Range("A2:A" & a)
> Rng.Offset(1, 0).Resize(Rng.Rows.Count - 1) _
> .SpecialCells(xlCellTypeVisible).Copy _
>  Destination:=Range("F4")
> ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1
> End Sub
>
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Nov 4, 2014 at 7:24 AM, Daryl Zer0  > wrote:
>
>> Trying to filter a few numbers from a larger group of numbers in one 
>> cell, copy them, then paste them in another cell. Error comes up as 
>> "Runtime error '1004': Paste special Method of Range class fail". When I go 
>> to "debug", it shows this:
>>
>>  [image: copy to clipboard]
>>
>> Sub Macro1()
>> '
>> ' Macro1 Macro
>> ' averages
>> '
>> ' Keyboard Shortcut: Ctrl+m
>> '
>> Range("F4:F16").Select
>> Selection.ClearContents
>> ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1, 
>> Criteria1:=RGB(198, _
>> 239, 206), Operator:=xlFilterCellColor
>> Range("A8:A239").Select
>> Selection.Copy
>> ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1
>> Range("F4:F15").Select
>> ActiveSheet.Paste
>> End Sub
>>
>>
>>
>> How can I get my macro to cut and paste what I want without this error?
>>
>> This is exactly how I tried to create my macro:
>>
>> Selected "View tab"
>> Selected "Record Macro" tab (use relative references tab not highlighted)
>> Macro name: Macro1
>> Short cut Key: Ctrl + "m"
>> Store macro in: this workbook
>> Select f4-f16
>> right click and select clear contents
>> click on filter tab in column "A"
>> select filter by color
>> select green
>> select "a8-a239"
>> right click and select "copy"
>> click on filter tab in column "A"
>> select clear filter from "column A"
>> select f4-f16
>> right click and select "paste"
>> click on stop button to stop recording macro.
>>
>> Then to run macro I:
>>
>> view macros
>> select macro1
>> click on "run"
>>
>> Then it executes everything I did in my macro EXCEPT "paste" at the end. 
>> That's when I get the run-time error code '1004' paste special method of 
>> worksheet class failed. 
>>
>> It seems to me I did everything right but it didn't work.
>>
>> -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-12 Thread Bud Windelborn

Hooray!  This is exactly what I needed and it did the trick.

Thanks for all your help, Paul and Ashish!

On Wednesday, November 12, 2014 1:31:12 PM UTC-6, Paul Schreiner wrote:
>
> When you open the new workbook, it will be "active"
> using something like:
> WbName = activeworkbook.Name
>  
> will store the name of the open workbook.
>  
> later:
>  
> Workbooks(WbName).Close SaveChanges:=False
>  
> will close that workbook 
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Bud Windelborn >
> *To:* excel-...@googlegroups.com  
> *Sent:* Wednesday, November 12, 2014 2:22 PM
> *Subject:* Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close 
> Sheet, Retain Clipboard, Paste
>  
> Thanks!  I'm not sure I understand yet though.
>
> When I run this macro, I've already got the sheet 
> BusinessOrganizerMapping2013.xlsm open.  I hit the button to run the macro 
> and another sheet opens based on the sheet name that's in cell A7 of 
> BusinessOrganizerMapping2013.xlsm.  I can manage the copy and paste just 
> fine, but I'm unable to close the new sheet that the macro opened 
> (Incidentally, the reason I need to close the new sheet is that all the 
> sheets I'm opening have the same name even though they're in different 
> locations.  So when I try to open the second one on the list I get an error 
> that another sheet with that name is already open).
>
> The issue for me is that I don't seem to be able to re-activate the new 
> sheet after I've pasted to BusinessOrganizerMapping2013.xlsm.  How do I 
> re-activate, and then close, the dynamically named sheet?
>
> I tried the code you listed, but it didn't quite fit the situation I 
> describe above.
>
>
>
>
>
> On Tuesday, November 11, 2014 9:45:50 PM UTC-6, Ashish Kumar wrote:
>
> Hi Bud,
>
> PFA!!
>
>
> Do changes in macro according to your requirement in Set x and Set y.
>
>
> Regards
> Ashish
>
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like 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...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>  

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-12 Thread Paul Schreiner

When you open the new workbook, it will be "active"
using something like:
WbName = activeworkbook.Name
 
will store the name of the open workbook.
 
later:
 
Workbooks(WbName).Close SaveChanges:=False
 
will close that workbook 

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Bud Windelborn 
>To: excel-macros@googlegroups.com 
>Sent: Wednesday, November 12, 2014 2:22 PM
>Subject: Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, 
>Retain Clipboard, Paste
>  
>
>
>Thanks!  I'm not sure I understand yet though.
>
>
>When I run this macro, I've already got the sheet 
>BusinessOrganizerMapping2013.xlsm open.  I hit the button to run the macro and 
>another sheet opens based on the sheet name that's in cell A7 of 
>BusinessOrganizerMapping2013.xlsm.  I can manage the copy and paste just fine, 
>but I'm unable to close the new sheet that the macro opened (Incidentally, the 
>reason I need to close the new sheet is that all the sheets I'm opening have 
>the same name even though they're in different locations.  So when I try to 
>open the second one on the list I get an error that another sheet with that 
>name is already open).
>
>
>The issue for me is that I don't seem to be able to re-activate the new sheet 
>after I've pasted to BusinessOrganizerMapping2013.xlsm.  How do I re-activate, 
>and then close, the dynamically named sheet?
>
>
>I tried the code you listed, but it didn't quite fit the situation I describe 
>above.
>
>
>
>
>
>
>
>
>On Tuesday, November 11, 2014 9:45:50 PM UTC-6, Ashish Kumar wrote:
>Hi Bud,
>>
>>
>>PFA!!
>>
>>
>>
>>
>>Do changes in macro according to your requirement in Set x and Set y.
>>
>>
>>
>>
>>Regards
>>Ashish 
>-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES
> 
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

2014-11-12 Thread Bud Windelborn

Thanks!  I'm not sure I understand yet though.

When I run this macro, I've already got the sheet 
BusinessOrganizerMapping2013.xlsm open.  I hit the button to run the macro 
and another sheet opens based on the sheet name that's in cell A7 of 
BusinessOrganizerMapping2013.xlsm.  I can manage the copy and paste just 
fine, but I'm unable to close the new sheet that the macro opened 
(Incidentally, the reason I need to close the new sheet is that all the 
sheets I'm opening have the same name even though they're in different 
locations.  So when I try to open the second one on the list I get an error 
that another sheet with that name is already open).

The issue for me is that I don't seem to be able to re-activate the new 
sheet after I've pasted to BusinessOrganizerMapping2013.xlsm.  How do I 
re-activate, and then close, the dynamically named sheet?

I tried the code you listed, but it didn't quite fit the situation I 
describe above.

On Tuesday, November 11, 2014 9:45:50 PM UTC-6, Ashish Kumar wrote:
>
> Hi Bud,
>
> PFA!!
>
>
> Do changes in macro according to your requirement in Set x and Set y.
>
>
> Regards
> Ashish
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-12 Thread ivavok

ok, thank you;)

Dne úterý, 11. listopadu 2014 6:47:02 UTC+1 Vabz napsal(a):
>
> Once you are in the Account Settings, look under 'Personal Info', and look 
> at the current Country/Region of your account it should be Czech Republic 
> to change it to comma instead of dot.
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Nov 11, 2014 at 2:56 AM, ivavok  > wrote:
>
>> Great, thank you, Vabz! Yes, could be;)
>>
>> Dne neděle, 9. listopadu 2014 20:05:10 UTC+1 Vabz napsal(a):
>>>
>>> Ok, here you go..
>>>
>>> Also do you need to change no. format to match with your native currency?
>>>
>>> +
>>> *I did not do this for you. God is here working through me for you.*
>>>
>>> On Sun, Nov 9, 2014 at 11:49 PM, ivavok  wrote:
>>>
 Hi,

 that´s perfect! Thanks. Just the comma is decimal not between 
 thousands. So the first figure should be 15 750,00 and not 1 575 
 000,00...How should I change the macro so that it works this way?

 Thank you in advance!

 Dne neděle, 9. listopadu 2014 15:20:35 UTC+1 Vabz napsal(a):
>
> Hi
>
> Try this, Run macro by clicking blue button, select range containing 
> number when prompted!!
>
> You will get output as desired without help of any helper sheet.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Sat, Nov 8, 2014 at 1:46 PM, ivavok  wrote:
>
>> Hi,
>>
>> I have tried it before too but it does not work. It does not delete 
>> "Kč" at all...When I run my macro, I get the data in the table attached. 
>> "Kč" is deleted but spaces are kept:( I have to delete each space at the 
>> end of the text in the cell and also between thousands, then it will be 
>> a 
>> number for Excel.
>>
>> Columns("C:C").Select
>> Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _
>>SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
>>ReplaceFormat:=False
>> 
>> Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart, _
>>SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
>>ReplaceFormat:=False
>>
>> Could you please help me?
>>
>> Thank you
>>
>> Dne pátek, 7. listopadu 2014 18:05:56 UTC+1 Vabz napsal(a):
>>>
>>> Hi
>>>
>>> I see there is a space between  number and   "Kč" so use " Kč" 
>>> instead.
>>>
>>> Cheers !!  
>>> On Nov 7, 2014 8:15 PM, "ivavok"  wrote:
>>>
 Hi,

 I would appreciate if you could help me with this macro:

 *Columns("C:C").Select*
 *Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _*
 *   SearchOrder:=xlByRows, MatchCase:=False, 
 SearchFormat:=False, _*
 *   ReplaceFormat:=False*
 
 *Selection.Replace What:="  ", Replacement:="", LookAt:=xlPart, _*
 *   SearchOrder:=xlByRows, MatchCase:=False, 
 SearchFormat:=False, _*
 *   ReplaceFormat:=False*

 *Columns("C:C").Select*
 *Selection.NumberFormat = "#,##0.00"*

 What is wrong with it? I need to change data in cells from texts 
 into numbers. I attach the initial data. In cells there are also 
 spaces 
 which must be deleted but I do not know how. This macro does not fully 
 do 
 this. Spaces are still at the end of the cell and between thousands 
 but 
 then the excel does not take it as numbers..I do not need the currency 
 just 
 the numbers.

 Thank you in advance for your help!


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

$$Excel-Macros$$ Re: hlep me

2014-11-12 Thread Mandeep Baluja

Hey Amit, 

kindly find the attachment of data .

Thanks 
*Mandeep Baluja *

On Tuesday, November 11, 2014 10:37:18 PM UTC+5:30, Anil Kumar wrote:
>
> how to use function show all location by country name
>
> pfa
>
>
> Regards,
>
> Anil Kumar Maurya
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

countyr .xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ regarding 4 step filter

2014-11-12 Thread Pol Ktk

Sir,
in attached there are 2 sheet
1 sheet contain data in 2nd sheet need filter data


thanks

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


filter data.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: How to repair corrupted Excel file

2014-11-12 Thread Kaye R. Jenkins


It is very well programmed application that immediately repair and recover 
badly damaged or corrupt Excel file within few clicks. If you want to know 
more about the software visit:-  
http://www.recoverydeletedfiles.com/excel-file-recovery-tool.html

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

2014-11-12 Thread Laxmanan M

Thanks vabz,

How to achieve the second macro using vba.I tried here but am failing when 
trying to fetch details..

Lax 

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: VBA help

2014-11-12 Thread Mandeep Baluja

Thanks Vaibhav I got to know that I have not entirerow while pasting the 
data to sheet2 . thanks :) 

On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
>
> I have made this code for I have two worksheets that are in the same 
> workbook. 
>
> I want to check the values of WS 2, Column B to WS 1, Column B. If there 
> is a match, then copy/write the row of WS1 to WS 2. but in my code I am 
> retreiving the values through cells one by one I want *if cell matches 
> criteria whole row will get copies and paste to next celll. *
>
> Sub compareranges() 
>
> 'Specify the two ranges 
> Dim Firstrng As Range 
> Dim secondrng As Range 
> Dim i As Integer 
> Dim j As Integer 
>
>
> Set Firstrng = Application.InputBox("Enter first rng", "select rng", "", 
> Type:=8) 
> Set secondrng = Application.InputBox("Enter Second rng", "select rng", "", 
> Type:=8) 
>
> Debug.Print Firstrng.Address 
> Debug.Print secondrng.Address 
>
> For i = 2 To Firstrng.Rows.Count 
>
>
> For j = 2 To Firstrng.Rows.Count 
>
> If Sheets(2).Cells(i, 2).Value = Sheets(1).Cells(j, 2).Value Then 
>
> Sheets(2).Cells(i, 2).Offset(0, 1).Value = Sheets(1).Cells(j, 2).Offset(0, 
> 1).Value 
> Sheets(2).Cells(i, 2).Offset(0, 2).Value = Sheets(1).Cells(j, 2).Offset(0, 
> 2).Value 
> Sheets(2).Cells(i, 2).Offset(0, 3).Value = Sheets(1).Cells(j, 2).Offset(0, 
> 3).Value 
> Sheets(2).Cells(i, 2).Offset(0, 4).Value = Sheets(1).Cells(j, 2).Offset(0, 
> 4).Value 
>
> End If 
>
> Next j 
>
> Next i 
>
>
> 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/d/optout.

$$Excel-Macros$$ Re: Help Vlookup function duplicate

2014-11-12 Thread Mandeep Baluja

Use this 
formula 
=IF(COUNTIF($A$2:$A$64,VLOOKUP(A2,$A$2:$A$64,1,0))>1,"Duplicate","unique") 
if you want to be specific for only using vlookup function in this you can 
use =VLOOKUP(VLOOKUP(A2,$A$2:$A$64,1,0),A3:A64,1,0) if na received then 
value is unique if value retreived value is duplicate. You can't let the 
single formula to work alone for retreiving the values. 

On Wednesday, November 12, 2014 10:11:34 AM UTC+5:30, Anil Kumar wrote:
>
> Hi friends,
>
> pfa
>
> please help me only  vlookup function use find duplicate value. 
>
> Regards,
> Anil Kumar Maurya
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Need help to create a user form.

2014-11-12 Thread Mandeep Baluja

Hello kamal, 

check dis out .  
Private Sub CommandButton1_Click()

Dim brand As Long
Dim invoice As Long
Dim cell As Range

brand = TextBox1.Value
invoice = TextBox2.Value

temp = brand & invoice

Set ws1 = ActiveWorkbook.Sheets(1)

For Each cell In ws1.Range("a1", [a65535].End(xlUp))

If cell.Value = temp Then

TextBox3.Value = cell.Offset(0, 3)

End If

Else

MsgBox " check the NUmbers"

Next

End Sub


On Wednesday, November 12, 2014 11:23:33 AM UTC+5:30, kamal ganeshan wrote:
>
> Hi All, 
>
> Need some help to create a User form based on the logic. 
>
> If any enter Sub Brand numbers in cell F12 & Invoice number in cell 
> G12 then I want the "H" should be update automatic as per the above 
> table numbers. 
>
> I have done the exercise which is manual Vlookup formula but i need 
> the same logic in User form VBA . 
>
> Requesting you to please do the needful & revert. 
>
> Regards. 
> Ganeshan 
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Need help in User form (1).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

RE: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Re: $$Excel-Macros$$ regarding 4 step filter

Re: $$Excel-Macros$$ regarding 4 step filter

Re: $$Excel-Macros$$ Re: regarding 4 step filter

$$Excel-Macros$$ Website Scraping

Re: $$Excel-Macros$$ regarding 4 step filter

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

$$Excel-Macros$$ Re: regarding 4 step filter

Re: $$Excel-Macros$$ Need help to create a user form.

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

Re: $$Excel-Macros$$ Need help to create a user form.

Re: $$Excel-Macros$$ My macro won't work in Excel 2013. Please help.

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

Re: $$Excel-Macros$$ How to change texts into numbers by macro

$$Excel-Macros$$ Re: hlep me

$$Excel-Macros$$ regarding 4 step filter

$$Excel-Macros$$ Re: How to repair corrupted Excel file

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

$$Excel-Macros$$ Re: VBA help

$$Excel-Macros$$ Re: Help Vlookup function duplicate

$$Excel-Macros$$ Re: Need help to create a user form.

25 matches

Site Navigation

Mail list logo

Footer information