$$Excel-Macros$$ Re: VBA help

[Mandeep Baluja]

I have made this code for I have two worksheets that are in the same 
workbook. 
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: VBA help

[Mandeep Baluja]

Kindly find the file attached. 

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.


Query .xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ VLOOKUP QUEARY

[Mandeep Baluja]

Awesome ashish 

On Tuesday, November 11, 2014 1:11:31 PM UTC+5:30, Ashish Kumar wrote:
>
> Hi Saleem,
>
> PFA
>
>
> 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.

$$Excel-Macros$$ Re: Need Help with the macro file

[Mandeep Baluja]

Yes there is option in excel to split the data in seperate column as same 
format of pdf . 

On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote:
>
> Hello ,
>
> I need your help with regards to the attached macro file.
>
> I am trying to convert the pdf file to excel format but the conversion is 
> not as expected.
>
> *Issue* : Is it possible to convert pdf values split as per row and 
> column wise in excel ?
>Each cell should have single value.
>
> I have attached the sample pdf file along with the expected output file.
>
> Awaiting for your positive reply.
>
> Thanks,
> Ujjwal
>
>

-- 
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$$ VLOOKUP QUEARY

[Ashish Kumar]

Thanks Mandeep.

-- 
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: For Information

[Mandeep Baluja]

One thing I let you know that you're are truely awesome in excel and in 
concepts the way you answering the questions of Excel VBA related. Wish you 
good luck for you future. 

On Monday, September 15, 2014 5:41:09 PM UTC+5:30, Mandeep Baluja wrote:
>
> Who is Vabz and how much experience he' having ?
>

-- 
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: Mark Pass/Fail using excel vba macro

[Laxmanan M]

Guys ..Kindly,can you please help me or give me root to solve this problem.
Waiting for your valuable comments.
 
Lax

On Tuesday, November 11, 2014 1:27:54 PM UTC+5:30, Laxmanan M wrote:

> Hi All,
>  
> Need help to complete my task using vba.Thanks in advance..Attaching the 
> workbook here for review.
>  
>
> 1)  Macro 1 (use column BF for the message)
>
> a.   if there are dupe vendor numbers(column C), and the 
> corresponding bank records(column AF,AG) are unique, then it's ok, else fail
>
> b.  if there are dupe vendor names (column H), and the corresponding 
> account group (column D) is different, then it is ok, else it's fail
>
>  
>
> 2)  Macro 2 (use column BG for the message)
>
> a.   if there are dupe vendor names (column H), if the vendor account 
> group (column C) is either ZM05 or ZM14, then the country (column P) 
> associated to it should be the same as the the country (column P) 
> associated to ZM01. If fail, then mark all the lines failed
>
> 3)  This is not a macro. I made a TRIM check on column BE, but it 
> doesn’t work for some reason. I guess it has something to do with the 
> “convert to numbers” thing
>
>  
>
> Thanks,
>
> 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.

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

[Mandeep Baluja]

I got understand it today . thanks vab I can't expect this kind of 
formula what a logical thinking . 

On Saturday, August 16, 2014 8:02:59 PM UTC+5:30, Vabz wrote:
>
> Cheers !!
> On Aug 16, 2014 4:38 PM, "Rajan Verma" > 
> wrote:
>
>> Wow
>>
>> On Monday, 11 August 2014 12:57:05 UTC-6, kapil Gupta wrote:
>>>
>>> Thanks you really genius.
>>>
>>>
>>> Regards,
>>> Kapil Gupta
>>>
>>> On Monday, August 11, 2014 3:57:39 PM UTC+5:30, Vabz wrote:

 Hi

 FA

 Cheers!!


 On Mon, Aug 11, 2014 at 1:03 PM, kapil Gupta  wrote:

> Hello,
>
>   Please sheet and question mention in under of sheets.
>
>
> Regards,
> Kapil Gupta
>  
> -- 
> 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...@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$$ Please solve this sheet its very urgent

[Ashish Kumar]

Hi Vaibhav Bhai,

It's great.

-- 
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$$ Please solve this sheet its very urgent

[Vaibhav Joshi]

Cheers!!

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

On Tue, Nov 11, 2014 at 4:49 PM, Ashish Kumar 
wrote:

> Hi Vaibhav Bhai,
>
> It's great.
>
>
>
>

-- 
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$$ Insertion of calculation column in Pivot

[Vaibhav Joshi]

Select cell B4 then try this sequence..

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

On Tue, Nov 11, 2014 at 6:32 PM, Tarun Verma 
wrote:

> Thanks Vab for your prompt revert and i tried the same but getting
> error in doing same.
> Error snapshot has been attached.
> If possible then please a sample solution file i will learn from it
> but unfortunately i unable to make done% as a part of pivot.
>
> Thanks,
>
> On 11/9/14, Vaibhav Joshi  wrote:
> > Check this...
> >
> > You need to select Pvt Tbl Tools, Options, Formulas & then Calculated
> > Item...
> >
> > Cheers!!
> >
> > +
> > *I did not do this for you. God is here working through me for you.*
> >
> > On Sat, Nov 8, 2014 at 1:26 PM, Tarun Verma 
> > wrote:
> >
> >> Hi Team,
> >>
> >> Today i am tucked in a problem related to pivot. I have a pivot table in
> >> which i have some calculation outside of pivot and thats the only
> >> porblem.
> >> That calculation should be part of pivot table only not a outside
> >> calculations.
> >> Hope it is clear please revert if my problem in not understandable.
> >>
> >> 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 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/YqizOk0bErw/unsubscribe.
> > To unsubscribe from this group and all its topics, send an email to
> > excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros.
> > For more options, visit https://groups.google.com/d/optout.
> >
>
> --
> 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$$ VBA help

[Vaibhav Joshi]

Hi

Can you share sample data with desired result..

Cheers!!

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

On Tue, Nov 11, 2014 at 1:17 PM, 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.
>

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

[Vaibhav Joshi]

check this code for macro 1

Option Explicit
Sub Check_Dupe_2()
Dim n, i, str() As String
Application.ScreenUpdating = False
n = Range("A" & Rows.Count).End(xlUp).Row
ReDim str(1 To n + 1)
With CreateObject("Scripting.Dictionary")
For i = 1 To n
str(i) = Cells(i, "C") & Chr(30) & Cells(i, "AF") & Chr(30) &
Cells(i, "AG")
.Item(str(i)) = .Item(str(i)) + 1
Next i
For i = n To 1 Step -1
If .Item(str(i)) > 1 Then Cells(i, "BF") = "FAIL"
Next i
End With
With CreateObject("Scripting.Dictionary")
For i = 1 To n
str(i) = Cells(i, "H") & Chr(30) & Cells(i, "D")
.Item(str(i)) = .Item(str(i)) + 1
Next i
For i = n To 1 Step -1
If .Item(str(i)) > 1 Then Cells(i, "BF") = "FAIL"
Next i
End With

Application.ScreenUpdating = True
End Sub


Cheers!!

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

On Tue, Nov 11, 2014 at 1:27 PM, Laxmanan M  wrote:

> Hi All,
>
> Need help to complete my task using vba.Thanks in advance..Attaching the
> workbook here for review.
>
>
> 1)  Macro 1 (use column BF for the message)
>
> a.   if there are dupe vendor numbers(column C), and the
> corresponding bank records(column AF,AG) are unique, then it's ok, else fail
>
> b.  if there are dupe vendor names (column H), and the corresponding
> account group (column D) is different, then it is ok, else it's fail
>
>
>
> 2)  Macro 2 (use column BG for the message)
>
> a.   if there are dupe vendor names (column H), if the vendor account
> group (column C) is either ZM05 or ZM14, then the country (column P)
> associated to it should be the same as the the country (column P)
> associated to ZM01. If fail, then mark all the lines failed
>
> 3)  This is not a macro. I made a TRIM check on column BE, but it
> doesn’t work for some reason. I guess it has something to do with the
> “convert to numbers” thing
>
>
>
> Thanks,
>
> 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.
>

-- 
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: For Information

[Vaibhav Joshi]

Cheers!!

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

On Tue, Nov 11, 2014 at 4:06 PM, Mandeep Baluja 
wrote:

> One thing I let you know that you're are truely awesome in excel and in
> concepts the way you answering the questions of Excel VBA related. Wish you
> good luck for you future.
>
> On Monday, September 15, 2014 5:41:09 PM UTC+5:30, Mandeep Baluja wrote:
>>
>> Who is Vabz and how much experience he' having ?
>>
>  --
> 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$$ hlep me

['Anil Kumar' via MS EXCEL AND VBA MACROS]

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

Re: $$Excel-Macros$$ Re: VBA help

[Vaibhav Joshi]

Check this...

Cheers!!

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

On Tue, Nov 11, 2014 at 1:33 PM, Mandeep Baluja 
wrote:

>
> I have made this code for I have two worksheets that are in the same
> workbook.
> 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.
>

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


copy matching cell in 2 sheets.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[Bud Windelborn]

This is driving me nuts.  What am I doing wrong?

I'm need to open a new workbook and the name of that new workbook is 
contained in a cell.  All I need to do is copy the data, close the new 
workbook, retain the data in the clipboard, then paste the data into my 
original workbook.  Here's where I am now:

Workbooks.Open Filename:=Range("BusinessOrganizerMapping2013.xlsm!A7")
Application.DisplayAlerts = False
Range("A1:I100").Select
Selection.Copy
ActiveWindow.Close SaveChanges = False


Workbooks("BusinessOrganizerMapping2013.xlsm").Activate
Worksheets("Temp").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False


It's the first section, the copying and closing of the new workbook, that 
doesn't work.  I've tried a bunch of solutions, combinations and commands 
with no luck.

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

[Paul Schreiner]

I cannot test it right now, but there are some things that look odd to me.
I usually use Activeworkbook.close savechanges:=false
and, I'd suggest that you paste the clipboard before you close the workbook.
I'm not sure how Windows decides, but sometimes when you close the SOURCE of 
the clipboard data, it releases the memory in the clipboard.

also:Range("A1:I100").Select
Selection.Copy

is the same as 
Range("A1:I100").Copy

and, there might be a way to do this without using the clipboard at all, 
by using something like:
Workbooks("BusinessOrganizerMapping2013.xlsm").sheets("Temp").Range("A1:I100") 
= _
Workbooks(Range("BusinessOrganizerMapping2013.xlsm!A7"))").sheets("Temp").Range("A1:I100"

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: Tuesday, November 11, 2014 4:43 PM
>Subject: $$Excel-Macros$$ Issue with:  Open Sheet, Copy Sheet, Close Sheet, 
>Retain Clipboard, Paste
>  
>
>
>This is driving me nuts.  What am I doing wrong?
>
>
>I'm need to open a new workbook and the name of that new workbook is contained 
>in a cell.  All I need to do is copy the data, close the new workbook, retain 
>the data in the clipboard, then paste the data into my original workbook.  
>Here's where I am now:
>
>
>Workbooks.Open Filename:=Range("BusinessOrganizerMapping2013.xlsm!A7")
>>Application.DisplayAlerts = False
>>Range("A1:I100").Select
>>Selection.Copy
>>ActiveWindow.Close SaveChanges = False
>>
>>
>>
>>
>>Workbooks("BusinessOrganizerMapping2013.xlsm").Activate
>>Worksheets("Temp").Activate
>>Range("A1").Select
>>Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
>>False, Transpose:=False
>>Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
>>SkipBlanks:=False, Transpose:=False
>
>
>It's the first section, the copying and closing of the new workbook, that 
>doesn't work.  I've tried a bunch of solutions, combinations and commands with 
>no luck.
-- 
>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

[Bud Windelborn]

I'd like to paste the data before I close the sheet, but I'm having trouble 
figuring out how to do that.  Since the name of the new worksheet is 
variable (the name is in a cell on the original sheet), the usual Activate 
commands don't seem to work.  



On Tuesday, November 11, 2014 4:09:45 PM UTC-6, Paul Schreiner wrote:
>
> I cannot test it right now, but there are some things that look odd to me.
> I usually use Activeworkbook.close savechanges:=false
> and, I'd suggest that you paste the clipboard before you close the 
> workbook.
> I'm not sure how Windows decides, but sometimes when you close the SOURCE 
> of the clipboard data, it releases the memory in the clipboard.
>
> also:
> Range("A1:I100").Select
> Selection.Copy
>
> is the same as 
> Range("A1:I100").Copy
>
> and, there might be a way to do this without using the clipboard at all, 
> by using something like:
> Workbooks("BusinessOrganizerMapping2013.xlsm").sheets("Temp").Range("A1:I100")
>  
> = _
>
> Workbooks(Range("BusinessOrganizerMapping2013.xlsm!A7"))").sheets("Temp").Range("A1:I100"
>  
> *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:* Tuesday, November 11, 2014 4:43 PM
> *Subject:* $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close 
> Sheet, Retain Clipboard, Paste
>  
> This is driving me nuts.  What am I doing wrong?
>
> I'm need to open a new workbook and the name of that new workbook is 
> contained in a cell.  All I need to do is copy the data, close the new 
> workbook, retain the data in the clipboard, then paste the data into my 
> original workbook.  Here's where I am now:
>
> Workbooks.Open Filename:=Range("BusinessOrganizerMapping2013.xlsm!A7")
> Application.DisplayAlerts = False
> Range("A1:I100").Select
> Selection.Copy
> ActiveWindow.Close SaveChanges = False
>
>
> Workbooks("BusinessOrganizerMapping2013.xlsm").Activate
> Worksheets("Temp").Activate
> Range("A1").Select
> Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
> False, Transpose:=False
> Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
> SkipBlanks:=False, Transpose:=False
>
>
> It's the first section, the copying and closing of the new workbook, that 
> doesn't work.  I've tried a bunch of solutions, combinations and commands 
> with no luck.
> -- 
> 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 

$$Excel-Macros$$ mass change of URLs

[Thomas Mack]

I have worksheet where my URL links where the text is "Yes'  has a link 
similar to this:

http://libproxy.library.unt.edu:4432/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0

The website changed the "4432" to "3106" as such:

http://libproxy.library.unt.edu:3106/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0

Instead of editing 517 links I was hoping I can do this in mass  but the 
VBA code I found online does not see me to work.

I should note I am less than a novice at VBA and creating macros

Thanks Tom


-- 
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$$ Insertion of calculation column in Pivot

[Tarun Verma]

Thanks Vab,

your instruction working superb but still there is miss match fill is
attached with higlighting concern in red color.
Done % for grand total is 217%.

Thanks for you help

Regards,


On 11/11/14, Vaibhav Joshi  wrote:
> Select cell B4 then try this sequence..
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Nov 11, 2014 at 6:32 PM, Tarun Verma 
> wrote:
>
>> Thanks Vab for your prompt revert and i tried the same but getting
>> error in doing same.
>> Error snapshot has been attached.
>> If possible then please a sample solution file i will learn from it
>> but unfortunately i unable to make done% as a part of pivot.
>>
>> Thanks,
>>
>> On 11/9/14, Vaibhav Joshi  wrote:
>> > Check this...
>> >
>> > You need to select Pvt Tbl Tools, Options, Formulas & then Calculated
>> > Item...
>> >
>> > Cheers!!
>> >
>> > +
>> > *I did not do this for you. God is here working through me for you.*
>> >
>> > On Sat, Nov 8, 2014 at 1:26 PM, Tarun Verma 
>> > wrote:
>> >
>> >> Hi Team,
>> >>
>> >> Today i am tucked in a problem related to pivot. I have a pivot table
>> >> in
>> >> which i have some calculation outside of pivot and thats the only
>> >> porblem.
>> >> That calculation should be part of pivot table only not a outside
>> >> calculations.
>> >> Hope it is clear please revert if my problem in not understandable.
>> >>
>> >> 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 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/YqizOk0bErw/unsubscribe.
>> > To unsubscribe from this group and all its topics, send an email to
>> > excel-macros+unsubscr...@googlegroups.com.
>> > To post to this group, send email to excel-macros@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/excel-macros.
>> > For more options, visit https://groups.google.com/d/optout.
>> >
>>
>> --
>> 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) Shar

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

[Ashish Kumar]

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.


C_board.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Help Vlookup function duplicate

['Anil Kumar' via MS EXCEL AND VBA MACROS]

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.


duplicate.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ mass change of URLs

[Ganesh N]

Hi Thomas,

If all the links you want to change only "4432" to "3106" just find and
replace http://libproxy.library.unt.edu:3106

instead
of http://libproxy.library.unt.edu:4432
,
else share the worksheet to make the macro.

Regards,
Ganesh

On Wed, Nov 12, 2014 at 8:09 AM, Thomas Mack  wrote:

> I have worksheet where my URL links where the text is "Yes'  has a link
> similar to this:
>
>
> http://libproxy.library.unt.edu:4432/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0
>
> The website changed the "4432" to "3106" as such:
>
>
> http://libproxy.library.unt.edu:3106/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0
>
> Instead of editing 517 links I was hoping I can do this in mass  but the
> VBA code I found online does not see me to work.
>
> I should note I am less than a novice at VBA and creating macros
>
> Thanks Tom
>
>
>  --
> 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$$ Need help to create a user form.

[Kamal Ganeshan]

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.xlsx
Description: MS-Excel 2007 spreadsheet

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

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