Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

[Learner Excel]

here you go..



--

On Tue, Oct 11, 2016 at 6:59 PM, HOTEL PRESIDENT <
hotelpresident.raj...@gmail.com> wrote:

> pl
> reply soon
>
> *Thanks & Regards*
>
> *Sohil S. Hudani*
> * C/O Hotel President*
> *Mo. 9998241341*
>
>
> On Tue, Oct 11, 2016 at 6:37 PM, HOTEL PRESIDENT <
> hotelpresident.raj...@gmail.com> wrote:
>
>> here the attachment is missing. i need a simple logic for room no 205 and
>> 201 the rate for pax 1 is 1500 and
>> the rate for 2 pax is 1700, same way for room no 202,203 and 204 the rate
>> for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file in
>> which upon entering the room no and pax the value should be automatically
>> generated in tariff.
>>
>> *Thanks & Regards*
>>
>> *Sohil S. Hudani*
>> * C/O Hotel President*
>> *Mo. 9998241341*
>>
>>
>> On Tue, Oct 11, 2016 at 6:36 PM, HOTEL PRESIDENT <
>> hotelpresident.raj...@gmail.com> wrote:
>>
>>> here the attachment is missing. i need a simple logic for room no 205
>>> and 201 the rate for pax 1 is 1500 and
>>> the rate for 2 pax is 1700, same way for room no 202,203 and 204 the
>>> rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file
>>> in which upon entering the room no and pax the value should be
>>> automatically generated in tariff.
>>>
>>> *Thanks & Regards*
>>>
>>> *Sohil S. Hudani*
>>> * C/O Hotel President*
>>> *Mo. 9998241341*
>>>
>>>
>>> On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel 
>>> wrote:
>>>
>>>> oops attachment missing
>>>>
>>>> --
>>>>
>>>> On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel 
>>>> wrote:
>>>>
>>>>> Hi Enclosed solution with simple vlookup.
>>>>>
>>>>> It would be great if you can share the tariff plan calculation logic
>>>>> so that we are create this more dynamic
>>>>>
>>>>> --
>>>>>
>>>>> On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESIDENT <
>>>>> hotelpresident.raj...@gmail.com> wrote:
>>>>>
>>>>>> pl reply
>>>>>>
>>>>>> *Thanks & Regards*
>>>>>>
>>>>>> *Sohil S. Hudani*
>>>>>> * C/O Hotel President*
>>>>>> *Mo. 9998241341*
>>>>>>
>>>>>>
>>>>>> On Tue, Oct 11, 2016 at 1:07 PM, HOTEL PRESIDENT <
>>>>>> hotelpresident.raj...@gmail.com> wrote:
>>>>>>
>>>>>>> Here I've attached a format please check it.. Details given in format
>>>>>>>
>>>>>>> *Thanks & Regards*
>>>>>>>
>>>>>>> *Sohil S. Hudani*
>>>>>>> * C/O Hotel President*
>>>>>>> *Mo. 9998241341*
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Oct 11, 2016 at 12:53 PM, Deepu Dubey 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> What equation you need??  elaborate
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Oct 11, 2016 at 12:51 PM, 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Need a help in formating an equation for the nested if..
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> 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

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

[Learner Excel]

oops attachment missing

--

On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel  wrote:

> Hi Enclosed solution with simple vlookup.
>
> It would be great if you can share the tariff plan calculation logic so
> that we are create this more dynamic
>
> --
>
> On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESIDENT <
> hotelpresident.raj...@gmail.com> wrote:
>
>> pl reply
>>
>> *Thanks & Regards*
>>
>> *Sohil S. Hudani*
>> * C/O Hotel President*
>> *Mo. 9998241341*
>>
>>
>> On Tue, Oct 11, 2016 at 1:07 PM, HOTEL PRESIDENT <
>> hotelpresident.raj...@gmail.com> wrote:
>>
>>> Here I've attached a format please check it.. Details given in format
>>>
>>> *Thanks & Regards*
>>>
>>> *Sohil S. Hudani*
>>> * C/O Hotel President*
>>> *Mo. 9998241341*
>>>
>>>
>>> On Tue, Oct 11, 2016 at 12:53 PM, Deepu Dubey 
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> What equation you need??  elaborate
>>>>
>>>>
>>>> On Tue, Oct 11, 2016 at 12:51 PM, 
>>>> wrote:
>>>>
>>>>>
>>>>>
>>>>> Need a help in formating an equation for the nested if..
>>>>>
>>>>> --
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>>> pic/excel-macros/Q2F8YLfdGd0/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 gro

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

[Learner Excel]

Hi Enclosed solution with simple vlookup.

It would be great if you can share the tariff plan calculation logic so
that we are create this more dynamic

--

On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESIDENT <
hotelpresident.raj...@gmail.com> wrote:

> pl reply
>
> *Thanks & Regards*
>
> *Sohil S. Hudani*
> * C/O Hotel President*
> *Mo. 9998241341*
>
>
> On Tue, Oct 11, 2016 at 1:07 PM, HOTEL PRESIDENT <
> hotelpresident.raj...@gmail.com> wrote:
>
>> Here I've attached a format please check it.. Details given in format
>>
>> *Thanks & Regards*
>>
>> *Sohil S. Hudani*
>> * C/O Hotel President*
>> *Mo. 9998241341*
>>
>>
>> On Tue, Oct 11, 2016 at 12:53 PM, Deepu Dubey  wrote:
>>
>>> Hi,
>>>
>>> What equation you need??  elaborate
>>>
>>>
>>> On Tue, Oct 11, 2016 at 12:51 PM, 
>>> wrote:
>>>


 Need a help in formating an equation for the nested if..

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

 FORUM RULES

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

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

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

-- 
A

Re: $$Excel-Macros$$ Need Help in VBA

[Learner Excel]

Hi Try below VBA code

Option Base 1
Sub rr()
For Each r In Range("b2:b" & Range("b9").End(xlUp).Row)
x = Split(r, ",")
For t = LBound(x) To UBound(x)
Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1)
Range("i9").End(xlUp).Offset(1).Value = x(t)
Next
Next
End Sub


--

On Mon, Oct 10, 2016 at 6:16 PM,  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro run very slow

[Learner Excel]

please share your code.

--

On Tue, Sep 20, 2016 at 1:33 PM, chandrashekarb.xls <
chandrashekarb@gmail.com> wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Outlook 2016 - Macro Help!

[Learner Excel]

No,

You can not record macro on Outlook, if you are looking for basic of
outlook macro thn please refer below url-

http://www.easytweaks.com/add-macros-outlook-2016/

--

On Mon, Sep 19, 2016 at 8:54 PM, dza49  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

[Learner Excel]

Hey Bil,

You can do this thru formula only.

Enclosed without macro solution, let us know if you still required macro.

--

On Sun, Sep 18, 2016 at 8:42 AM, Bill Q  wrote:

> Please see attached.
>
> Looking for a macro to automate a repetitive task.
>
> 1. It is to look for a specific text in Column C. In this case, it would
> be the word "GEORGE"
> 2. Once it encounters the word, Column B would be populated with "X".
> 3. The "X" would continue to be populated until it column C encounters
> it's second instance of cells containing a letter(s) (not date).
> 4. At this point, column B would revert back to a blank.
> 5. It continues to search and replace as outlined above until ROW 35000 or
> end of file.
>
> Attached shows the resulting output that I am looking for based on a small
> sample that contains two instances of the word "GEORGE".
>
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


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

Re: $$Excel-Macros$$ Query on formula

[Learner Excel]

Welcome back Ashish!.😉

--

On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul  wrote:

> =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N")
>
> On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel  wrote:
>
>> Dear Experts,
>>
>> Please help me to solve the attached query.
>>
>> --
>> *Kalyan Chattopadhyay*
>>
>>
>> *Executive Corporate MIS*
>>
>> *Joy Cosmetics*
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> *Regards*
>
> *Ashish Koul*
>
>
> *Visit*
> http://www.excelvbamacros.in
> Like Us on Facebook 
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro to extract datas from PDF form to Excel sheet

[Learner Excel]

Hey,

If you are good in VBA coding then you can search "pdf to excel convert
vba" and take reference.

Please see below the some useful urls-


https://www.linkedin.com/groups/1871310/1871310-74131482
http://quickvba.blogspot.in/2010/12/import-pdf-in-excel.html
http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101
http://www.ozgrid.com/forum/showthread.php?t=186024
https://acrobatusers.com/forum/general-acrobat-topics/
search-text-pdf-vba-only-adobe-reader-installed/
http://www.mrexcel.com/forum/excel-questions/776114-how-copy-data-pdf-excel-using-visual-basic-applications-multiple-sheets.html


--

On Wed, Sep 14, 2016 at 4:27 PM,  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

[Learner Excel]

No,
you can not add more thn 250 ppls

--

On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk  wrote:

> is there any option in whatsup appln to add unlimited members(in single
> group)
> paid or free ?
>
> On 11 September 2016 at 11:50, Learner Excel  wrote:
>
>> Thanks Prabhu!..
>>
>> Happy to here from you!>=.
>>
>> --
>>
>> On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky 
>> wrote:
>>
>>> Hi Friends,
>>>
>>> Since i have created Whatsapp group for VBA Macro learners/experts.
>>>
>>> And i have added many peoples in this group. Please Msg me to 9500087194
>>> in whatsapp to get added in this group. if anyone missed or not yet added
>>> even you requested earlier.
>>>
>>> Thanks & Regards,
>>> Prabhu R
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 Gr

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

[Learner Excel]

Thanks Prabhu!..

Happy to here from you!>=.

--

On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky 
wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

[Learner Excel]

Please go thru below url

http://dailydoseofexcel.com/archives/2015/02/13/converting-an-excel-range-to-html-the-hard-way/


--

On Sat, Sep 10, 2016 at 9:49 PM, Learner Excel  wrote:

> Hey please refer enclosed sample workbook (excel table to html code)
>
>
>
> --
>
> On Sat, Sep 10, 2016 at 4:35 PM, Dheeraj Bankoti 
> wrote:
>
>> hi
>> is any expert there in group who can short out the issue..
>>
>> Regards
>> -- Forwarded message --
>> From: Dheeraj Bankoti 
>> Date: Sun, Sep 4, 2016 at 9:11 AM
>> Subject: Re: $$Excel-Macros$$ Single Quotes Added to Email Address
>> To: excel-macros@googlegroups.com
>>
>>
>> Hello experts,
>> Is it possible to remove single quote from sent email addresses?
>>
>> Regards
>> Dheeraj
>>
>> On Sat, Sep 3, 2016 at 7:57 AM, Dheeraj Bankoti 
>> wrote:
>>
>>> Hi
>>> Is any group member short it out?
>>>
>>> Regards
>>>
>>> -- Forwarded message --
>>> From: Dheeraj Bankoti 
>>> Date: Tue, Aug 30, 2016 at 5:31 PM
>>> Subject: $$Excel-Macros$$ Single Quotes Added to Email Address
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Dear Group Members,
>>> I am using Out look10 and after sending the message the email address or
>>> name is showing by quote (single quote " ' ") / apostrophe.
>>> I checked display as field and display name but there is no quote. The
>>> reply comes back to me w/o quotes and my subsequent reply goes out with
>>> quotes.
>>>
>>> I removed the account and re-sync the email wherein previous emails
>>> quoted are removed and showing correct name without quote. Now it is
>>> showing for new sending messages only.
>>>
>>> Is there any way to shut off the feature where Outlook adds single quotes
>>> around an email address when replying?
>>>
>>> Thanking You,
>>>
>>> Regards
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To u

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

[Learner Excel]

Hey please refer enclosed sample workbook (excel table to html code)



--

On Sat, Sep 10, 2016 at 4:35 PM, Dheeraj Bankoti  wrote:

> hi
> is any expert there in group who can short out the issue..
>
> Regards
> -- Forwarded message --
> From: Dheeraj Bankoti 
> Date: Sun, Sep 4, 2016 at 9:11 AM
> Subject: Re: $$Excel-Macros$$ Single Quotes Added to Email Address
> To: excel-macros@googlegroups.com
>
>
> Hello experts,
> Is it possible to remove single quote from sent email addresses?
>
> Regards
> Dheeraj
>
> On Sat, Sep 3, 2016 at 7:57 AM, Dheeraj Bankoti 
> wrote:
>
>> Hi
>> Is any group member short it out?
>>
>> Regards
>>
>> -- Forwarded message --
>> From: Dheeraj Bankoti 
>> Date: Tue, Aug 30, 2016 at 5:31 PM
>> Subject: $$Excel-Macros$$ Single Quotes Added to Email Address
>> To: excel-macros@googlegroups.com
>>
>>
>> Dear Group Members,
>> I am using Out look10 and after sending the message the email address or
>> name is showing by quote (single quote " ' ") / apostrophe.
>> I checked display as field and display name but there is no quote. The
>> reply comes back to me w/o quotes and my subsequent reply goes out with
>> quotes.
>>
>> I removed the account and re-sync the email wherein previous emails
>> quoted are removed and showing correct name without quote. Now it is
>> showing for new sending messages only.
>>
>> Is there any way to shut off the feature where Outlook adds single quotes
>> around an email address when replying?
>>
>> Thanking You,
>>
>> Regards
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to t

Re: $$Excel-Macros$$ Excel Table to HTML table

[Learner Excel]

Please refer below url

https://gist.github.com/jkatricak/801024
http://windowssecrets.com/forums/showthread.php/107929-VBA-code-to-HTML
http://dailydoseofexcel.com/archives/2011/09/20/roll-your-own-html-from-excel-vba/

--

On Sat, Sep 10, 2016 at 12:18 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:

> Hi Guys,
>
> Is there any who can solve this problem.
>
> On Fri, Sep 9, 2016 at 8:41 PM, Devendra Sahay <
> devendrasahanypt...@gmail.com> wrote:
>
>> Hi Guys,
>>
>> Am waiting for response. If anyone can help in this regard would be
>> helpful.
>>
>> On Fri, Sep 9, 2016 at 8:46 AM, Devendra Sahay <
>> devendrasahanypt...@gmail.com> wrote:
>>
>>> Hi Experts,
>>>
>>> Am working for company in which i have to convert an excel table in HTML
>>> table format & as am not from the technical background then I have to
>>> struggle with existing templates to modify them as per new requirement.
>>> I found a code on google, which is giving as desired output but I want
>>> few modifications in that OR someone can fix the shared code with
>>> predefined HTML parameters.
>>>
>>> Scenario.
>>>
>>> I have mentioned the header in excel sheet, which may vary as per user &
>>> language. and the table which i have shared in column A would be the
>>> respective Parameter & Column B would the detail but in column B, there
>>> could be multiple rows for the same parameter. If the respective row is
>>> greater that 1 then it will appear on webpage as shared snapshot.
>>> Then rest of things will run as similar process, code will check
>>> respective header & the value in table then it will count the rows for that
>>> parameter.
>>>
>>> Code should run only for selected range not the entire sheet.
>>>
>>> Guys, If any one can help me on this code, would be much appreciated
>>>
>>> @paul, You are the one guy, who can do anything with excel. Am waiting
>>> for your suggestions on this concern.
>>>
>>> --
>>>
>>> With Regards !!!
>>> Devendra
>>>
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>
>>
>> --
>>
>> With Regards !!!
>> Devendra
>>
>>
>
>
> --
>
> With Regards !!!
> Devendra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

[Learner Excel]

Who's making this group, please reply? else I can take initiave to do the
same.

--

On Sat, Sep 10, 2016 at 11:07 AM, Satheesh Arumugam Naidu <
satheesh.arumu...@gmail.com> wrote:

> please add 8861087687
>
> On Thu, Sep 8, 2016 at 1:01 PM, prkhan56  wrote:
>
>> Please add me
>> 8291577844
>> Rashid
>>
>> On Monday, September 5, 2016 at 10:00:12 AM UTC+4, Prabhakar Thakur wrote:
>>>
>>> please add me 9953736776
>>>
>>> Thanks,
>>> Prabhakar Thakur
>>> New Delhi
>>> +919953736776
>>>
>>> On Fri, Sep 2, 2016 at 5:49 PM, Prashant Pednekar 
>>> wrote:
>>>
 please add me 8308800600

 On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06ra...@gmail.com>
 wrote:

> please add the my number 9811503853
>
> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>>
>> Creating WhatsApp group for VBA macro... Pls msg me your contact, if
>> you wants to join.
>>
>> Add me in WhatsApp and Msg me to - 9500087194
>>
>> Regards,
>> Prabhu.R
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@googlegroups.com.
> To post to this group, send email to excel-...@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

 FORUM RULES

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

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

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

Re: $$Excel-Macros$$ Macro not working

[Learner Excel]

Try enclosed one

--

On Fri, Sep 9, 2016 at 9:37 AM, GENIUS  wrote:

> working perfectly, thank you very much for your help
>
> one more question, if I have  figures in column A as shown in the sheet
> and I want to take the 17% in  column B of the amount of column A as shown
> in the attachment then how do I automate this task whenever i put a figure
> in column A and run the macro it calculates 17% in column B for more
> details please see the attachment
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


MACRO FOR APPLYING PERCENTAGE IN COLUMN B.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ To seek help on writing Excel formula

[Learner Excel]

Is there any relation between both sheets? If yes you can use vlookup.

It would be great if you can upload (attache) some sample data with your
requirement

--

On Fri, Sep 9, 2016 at 5:17 PM, Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com> wrote:

> Hi
>
> I have a spreadsheet with two tab:
> Sheet1 has three variable:
>
> NameFirstNameLastName
> abc_xyz abc   xyz
> rpm_xyz rpm   xyz
>
> Sheet2 has one variable:
>
> Name
> abc_xyz
> rpm_xyz
>
> I need to write an excel formula in Sheet1 such that I obtain:
>
>
> NameFirstNameLastName  Variable_sheet2
> abc_xyz abc   xyz rpm_xyz
> rpm_xyz rpm   xyz abc_xyz
>
>
>
> Thanks & regards,
> *Sandeep Kumar Baranwal*
> Lead Solution Advisor
> Model validation and Valuation, Deloitte US India
> Gurgaon
> India
> Mob:-+91-8588802543
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro not working

[Learner Excel]

Opps you have register incorrect data type against variable j, data type
should be string

[image: Inline image 1]

--

On Thu, Sep 8, 2016 at 10:01 PM, GENIUS  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro not working

[Learner Excel]

Attachment missing


--

On Thu, Sep 8, 2016 at 9:59 PM, GENIUS  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

[Learner Excel]

Do you need all values from brackets or some specif .

--

On Wed, Sep 7, 2016 at 8:41 PM, Pierre  wrote:

> here it is
>
> On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote:
>>
>> sorry typo error,
>>
>> Can you please upload some sample ASCII file if possible
>>
>> --
>>
>> On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel  wrote:
>>
>>> Can you please upload some same ASCII same file if possible
>>>
>>> --
>>>
>>> On Wed, Sep 7, 2016 at 8:25 PM, Pierre  wrote:
>>>
>>>> the data is an ASCII file that I need to parse
>>>>
>>>> On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote:
>>>>>
>>>>> Hi Pirerre,
>>>>>
>>>>> Please help me understand -
>>>>> 1. Is this in excel only?
>>>>> 2. There is any unique identifier if the blocks are more than one.
>>>>>
>>>>> Suggestions -
>>>>> 1. We can you us Text to column than use some formulas to make table
>>>>> 2. You can extract value thru using LEFT,RIGHT formula
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> On Wed, Sep 7, 2016 at 6:41 PM, Pierre  wrote:
>>>>>
>>>>>>
>>>>>> Hello
>>>>>>
>>>>>> I have this file that I need to extract data from it
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> $begin pec
>>>>>>
>>>>>>  simple('conductivity', 1.0E30)
>>>>>>
>>>>>>  ModTime=1028307964
>>>>>>
>>>>>> $end pec
>>>>>>
>>>>>>.
>>>>>>
>>>>>>.
>>>>>>
>>>>>>.
>>>>>>
>>>>>> $begin nickel
>>>>>>
>>>>>>  simple('conductivity', 1450)
>>>>>>
>>>>>>  simple('permeability', 600)
>>>>>>
>>>>>>  simple('thermal_conductivity',90)
>>>>>>
>>>>>>  simple('mass_density',8900)
>>>>>>
>>>>>>  simple('specific_heat',444)
>>>>>>
>>>>>>  simple('youngs_modulus',2100)
>>>>>>
>>>>>>  simple('poissons_ratio',0.35)
>>>>>>
>>>>>>  simple('thermal_expansion_coeffcient',1.3e-005)
>>>>>>
>>>>>>  ModTime=1132068240
>>>>>>
>>>>>> $end nickel
>>>>>>
>>>>>>
>>>>>>
>>>>>> I would like to create a table that looks like
>>>>>>
>>>>>> name
>>>>>>
>>>>>> conductivity
>>>>>>
>>>>>> permeability
>>>>>>
>>>>>> thermal_conductivity
>>>>>>
>>>>>> pec
>>>>>>
>>>>>> 1.00E+30
>>>>>>
>>>>>> …
>>>>>>
>>>>>> ….
>>>>>> ...
>>>>>>
>>>>>>
>>>>>>
>>>>>> nickel
>>>>>>
>>>>>> 1450
>>>>>>
>>>>>> 600
>>>>>>
>>>>>> 90
>>>>>>
>>>>>>
>>>>>> any suggestions?
>>>>>>
>>>>>> 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 r

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

[Learner Excel]

sorry typo error,

Can you please upload some sample ASCII file if possible

--

On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel  wrote:

> Can you please upload some same ASCII same file if possible
>
> --
>
> On Wed, Sep 7, 2016 at 8:25 PM, Pierre  wrote:
>
>> the data is an ASCII file that I need to parse
>>
>> On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote:
>>>
>>> Hi Pirerre,
>>>
>>> Please help me understand -
>>> 1. Is this in excel only?
>>> 2. There is any unique identifier if the blocks are more than one.
>>>
>>> Suggestions -
>>> 1. We can you us Text to column than use some formulas to make table
>>> 2. You can extract value thru using LEFT,RIGHT formula
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> On Wed, Sep 7, 2016 at 6:41 PM, Pierre  wrote:
>>>
>>>>
>>>> Hello
>>>>
>>>> I have this file that I need to extract data from it
>>>>
>>>>
>>>>
>>>>
>>>> $begin pec
>>>>
>>>>  simple('conductivity', 1.0E30)
>>>>
>>>>  ModTime=1028307964
>>>>
>>>> $end pec
>>>>
>>>>.
>>>>
>>>>.
>>>>
>>>>.
>>>>
>>>> $begin nickel
>>>>
>>>>  simple('conductivity', 1450)
>>>>
>>>>  simple('permeability', 600)
>>>>
>>>>  simple('thermal_conductivity',90)
>>>>
>>>>  simple('mass_density',8900)
>>>>
>>>>  simple('specific_heat',444)
>>>>
>>>>  simple('youngs_modulus',2100)
>>>>
>>>>  simple('poissons_ratio',0.35)
>>>>
>>>>  simple('thermal_expansion_coeffcient',1.3e-005)
>>>>
>>>>  ModTime=1132068240
>>>>
>>>> $end nickel
>>>>
>>>>
>>>>
>>>> I would like to create a table that looks like
>>>>
>>>> name
>>>>
>>>> conductivity
>>>>
>>>> permeability
>>>>
>>>> thermal_conductivity
>>>>
>>>> pec
>>>>
>>>> 1.00E+30
>>>>
>>>> …
>>>>
>>>> ….
>>>> ...
>>>>
>>>>
>>>>
>>>> nickel
>>>>
>>>> 1450
>>>>
>>>> 600
>>>>
>>>> 90
>>>>
>>>>
>>>> any suggestions?
>>>>
>>>> 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...@googlegroups.com.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.faceb

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

[Learner Excel]

Can you please upload some same ASCII same file if possible

--

On Wed, Sep 7, 2016 at 8:25 PM, Pierre  wrote:

> the data is an ASCII file that I need to parse
>
> On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote:
>>
>> Hi Pirerre,
>>
>> Please help me understand -
>> 1. Is this in excel only?
>> 2. There is any unique identifier if the blocks are more than one.
>>
>> Suggestions -
>> 1. We can you us Text to column than use some formulas to make table
>> 2. You can extract value thru using LEFT,RIGHT formula
>>
>>
>>
>>
>>
>> --
>>
>> On Wed, Sep 7, 2016 at 6:41 PM, Pierre  wrote:
>>
>>>
>>> Hello
>>>
>>> I have this file that I need to extract data from it
>>>
>>>
>>>
>>>
>>> $begin pec
>>>
>>>  simple('conductivity', 1.0E30)
>>>
>>>  ModTime=1028307964
>>>
>>> $end pec
>>>
>>>.
>>>
>>>.
>>>
>>>.
>>>
>>> $begin nickel
>>>
>>>  simple('conductivity', 1450)
>>>
>>>  simple('permeability', 600)
>>>
>>>  simple('thermal_conductivity',90)
>>>
>>>  simple('mass_density',8900)
>>>
>>>  simple('specific_heat',444)
>>>
>>>  simple('youngs_modulus',2100)
>>>
>>>  simple('poissons_ratio',0.35)
>>>
>>>  simple('thermal_expansion_coeffcient',1.3e-005)
>>>
>>>  ModTime=1132068240
>>>
>>> $end nickel
>>>
>>>
>>>
>>> I would like to create a table that looks like
>>>
>>> name
>>>
>>> conductivity
>>>
>>> permeability
>>>
>>> thermal_conductivity
>>>
>>> pec
>>>
>>> 1.00E+30
>>>
>>> …
>>>
>>> ….
>>> ...
>>>
>>>
>>>
>>> nickel
>>>
>>> 1450
>>>
>>> 600
>>>
>>> 90
>>>
>>>
>>> any suggestions?
>>>
>>> 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...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this m

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

[Learner Excel]

Is the data in PDF is text or image?

If text, please refer below urls for your reference

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101
http://www.ozgrid.com/forum/showthread.php?t=186024
https://acrobatusers.com/forum/general-acrobat-topics/search-text-pdf-vba-only-adobe-reader-installed/

--

On Wed, Sep 7, 2016 at 3:09 PM, Pravin Lal  wrote:

> Dear All,
>
> I have an urgent requirement to extract ONLY the tabluar data in a PDF
> into excel. How can this be done??? Any thoughts?
>
> Text in the PDF should not come into the excel only the data presented in
> tabular format in PDF should come into the excel.
>
> Regards
> Pravin Lal
>
>
> On Friday, November 7, 2014 at 2:54:55 PM UTC+5:30, Sampath Kumar wrote:
>>
>>
>> Hello Ayush Jain,
>>
>> When using this macro. got some error in VBA script as below mentioned
>> screen shot. Kindly solve this issues.
>>
>>
>> Regards,
>> Sampath.S
>>
>>
>>
>>
>>
>> On Saturday, February 19, 2011 1:04:46 PM UTC+5:30, Ayush Jain wrote:
>>>
>>> Hi Rashid,
>>>
>>> You can find the macro at the link below :
>>> http://quickvba.blogspot.com/2010/12/import-pdf-in-excel.html
>>>
>>> Let us know if you have any questions:
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>> On Saturday, February 19, 2011 12:47:51 PM UTC+5:30, rashid memon wrote:

 Dear Experts,

 i want to convert PDF file to Excel so plz provide me macro

 file is attached...


 Looking forward to receive your kind attention.


 Thanks & Best Regards

 Rashid Hussaini

 Email:- *mr.rash...@gmail.com*

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

[Learner Excel]

Hi Pirerre,

Please help me understand -
1. Is this in excel only?
2. There is any unique identifier if the blocks are more than one.

Suggestions -
1. We can you us Text to column than use some formulas to make table
2. You can extract value thru using LEFT,RIGHT formula





--

On Wed, Sep 7, 2016 at 6:41 PM, Pierre  wrote:

>
> Hello
>
> I have this file that I need to extract data from it
>
>
>
>
> $begin pec
>
>  simple('conductivity', 1.0E30)
>
>  ModTime=1028307964
>
> $end pec
>
>.
>
>.
>
>.
>
> $begin nickel
>
>  simple('conductivity', 1450)
>
>  simple('permeability', 600)
>
>  simple('thermal_conductivity',90)
>
>  simple('mass_density',8900)
>
>  simple('specific_heat',444)
>
>  simple('youngs_modulus',2100)
>
>  simple('poissons_ratio',0.35)
>
>  simple('thermal_expansion_coeffcient',1.3e-005)
>
>  ModTime=1132068240
>
> $end nickel
>
>
>
> I would like to create a table that looks like
>
> name
>
> conductivity
>
> permeability
>
> thermal_conductivity
>
> pec
>
> 1.00E+30
>
> …
>
> ….
> ...
>
>
>
> nickel
>
> 1450
>
> 600
>
> 90
>
>
> any suggestions?
>
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro not working

[Learner Excel]

Brother, you have to add Outlook reference as well

[image: Inline image 1]

--

On Tue, Sep 6, 2016 at 9:18 AM, GENIUS  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ I need help breaking a numerical data range. I have an excel worksheet with over 6000000 rows of dat

[Learner Excel]

If the row count is really 60lac than I strongly suggest you to please use
MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac
only.)


--

On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda <
malungotoms...@gmail.com> wrote:

> I need help breaking a numerical data range. I have an excel worksheet
> with over 600 rows of data of which I am interested in just two columns
> that contain numerical information.
>
> Here is a sample.
>
> RCV Serial StartRCV Serial End
> 801120206779111 801120206779111
> 105100851967111 105100851967111
> 808920143800 808920143999
> 808920143700 808920143729
> 808920143500 808920143599
> 808920143400 808920143499
> 808920143390 808920143399
> 808920143370 808920143389
> 808920143350 808920143369
> 808920143310 808920143349
> 808920143300 808920143309
> 808920143200 808920143299
> 808920143000 808920143199
> 808920136800 808920136999
> 808920136550 808920136559
> 808920136490 808920136499
> 808920136480 808920136489
> 808920136470 808920136479
> 808920136460 808920136469
> Kindly assist,
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro not working

[Learner Excel]

You need to add "Microsoft Outlook 14.0 Object Library" in references

--

On Sat, Sep 3, 2016 at 10:10 PM, Izhar  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

[Learner Excel]

Please add 886006795

--

On Sat, Sep 3, 2016 at 8:17 AM, Ankit Monga  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro is not working

[Learner Excel]

For list of file name, use enclosed code.

--

On Fri, Sep 2, 2016 at 10:33 PM, Izhar  wrote:

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

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

FORUM RULES

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

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


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

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

[Learner Excel]

Hey Dheeraj

Please see below urls hope this will help

http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/outlook-2010-some-names-in-sent-items-appear-in/c3c1ef47-6af0-44d5-bdec-ae7d4b0f7bef?auth=1
https://www.experts-exchange.com/questions/26282293/Single-Quotes-in-E-mail-Address.html



--

On Tue, Aug 30, 2016 at 8:01 PM, Dheeraj Bankoti  wrote:

> Dear Group Members,
> I am using Out look10 and after sending the message the email address or
> name is showing by quote (single quote " ' ") / apostrophe.
> I checked display as field and display name but there is no quote. The
> reply comes back to me w/o quotes and my subsequent reply goes out with
> quotes.
>
> I removed the account and re-sync the email wherein previous emails quoted
> are removed and showing correct name without quote. Now it is showing for
> new sending messages only.
>
> Is there any way to shut off the feature where Outlook adds single quotes
> around an email address when replying?
>
> Thanking You,
>
> Regards
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Need help in macro

[Learner Excel]

Yes, its working for me,

can you please share the screenshot.

thanks

--

On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi 
wrote:

> Was it working fine for you? i am getting error in the below two line
> (error #1044) so, Else part "Range("b2").Validation.Delete" is not
> working.
>
> .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
> xlBetween, Formula1:="=OFFSET(Sheet1!$A$
> 2,,,COUNTA(Sheet1!$A$2:$A$100))"
>
>
> Thanks,
> Keerthi
> ...
>
> On Saturday, August 27, 2016 at 10:17:24 PM UTC+5:30, XLS S wrote:
>>
>> Try enclosed one.
>>
>> --
>>
>> On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi 
>> wrote:
>>
>>> Thank you so much. This helped me a lot:-)
>>>
>>> Is there any option to disappear the dropdown when user does not have
>>> any value in column B. instead of disable the drop down in the column B.
>>>
>>> once again Thanks a lot :-)
>>>
>>> Keerthi
>>>
>>>
>>>
>>> On Saturday, August 27, 2016 at 11:33:50 AM UTC+5:30, Manju Keerthi
>>> wrote:

 Hi



 I need your help to create a macro for the below mentioned scenario.



 *Scenario*



 We need two columns namely User, drop down



 *“IF user enter data in User column(cells) a automatic drop down needs
 to create in a column B*



 *Else*



 *No drop down required”*



 *And the macro should run automatically when the user start enter the
 data in user column(cell 1).*





 It is urgent please  respond ASAP.



 Thanks in advance



 Thanks,

 Keerthi

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

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

FORUM RULES

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

NOTE  :

Re: $$Excel-Macros$$ Re: Need help in macro

[Learner Excel]

Try enclosed one.

--

On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi 
wrote:

> Thank you so much. This helped me a lot:-)
>
> Is there any option to disappear the dropdown when user does not have any
> value in column B. instead of disable the drop down in the column B.
>
> once again Thanks a lot :-)
>
> Keerthi
>
>
>
> On Saturday, August 27, 2016 at 11:33:50 AM UTC+5:30, Manju Keerthi wrote:
>>
>> Hi
>>
>>
>>
>> I need your help to create a macro for the below mentioned scenario.
>>
>>
>>
>> *Scenario*
>>
>>
>>
>> We need two columns namely User, drop down
>>
>>
>>
>> *“IF user enter data in User column(cells) a automatic drop down needs to
>> create in a column B*
>>
>>
>>
>> *Else*
>>
>>
>>
>> *No drop down required”*
>>
>>
>>
>> *And the macro should run automatically when the user start enter the
>> data in user column(cell 1).*
>>
>>
>>
>>
>>
>> It is urgent please  respond ASAP.
>>
>>
>>
>> Thanks in advance
>>
>>
>>
>> Thanks,
>>
>> Keerthi
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


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

Re: $$Excel-Macros$$ Need help in macro

[Learner Excel]

HI Manju,

See this help you

--

On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva  wrote:

> Hi
>
>
>
> I need your help to create a macro for the below mentioned scenario.
>
>
>
> *Scenario*
>
>
>
> We need two columns namely User, drop down
>
>
>
> *“IF user enter data in User column(cells) a automatic drop down needs to
> create in a column B*
>
>
>
> *Else*
>
>
>
> *No drop down required”*
>
>
>
> *And the macro should run automatically when the user start enter the data
> in user column(cell 1).*
>
>
>
>
>
> It is urgent please  respond ASAP.
>
>
>
> Thanks in advance
>
>
>
> Thanks,
>
> Keerthi
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


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

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

[Learner Excel]

WelCome Manju,

Keep posting and learn more and more.

Why you need this thru marco/VBA? Are you familiar with VBA or macor

--

On Sat, Aug 27, 2016 at 11:12 AM, Manju Keerthi 
wrote:

> Hi,
>
> I am a beginner in excel i need your help to solve the following scenario
> i need to create a macro which should does the bellow thing
>
> *If user enter the value in Column A, a drop down list needs to create
> automatically in Column B *
>
> *Else No drop down required and once the user start entering data in
> column A macro needs to run automatically.*
>
>
>
> Thanks in advance
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
>
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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