Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

Hi Swapnil,

Just to let you know all your comments should be based on the error code.

Error Code column
1
2
3

all these three has different error description.

Thanks
Putta

On Thu, Jul 6, 2017 at 7:14 PM, Puttu *  wrote:

> Hi Swapnil,
>
> Thanks you so much appreciate your time and help on getting this macro. I
> think got almost what required, there is only small changes, which need to
> be done. Sorry its my mistake not giving right information on that.
>
> The reason I am looking a macro is I can't educate others who are very
> beginning stage of learning. Macro will be more easier for them to use than
> conditional formatting.
>
> I have added my comments in Final Tab. Please review and let me know if
> any points are unclear.
>
> Thanks
> Putta
>
>
> On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande <
> palande.swapni...@gmail.com> wrote:
>
>> Hi,
>>
>> Why are you not using conditional formatting. If your main purpose is to
>> display user duplicates and empty cells, conditional formatting is best
>> solution.
>>
>> Have applied both solutions (conditional formatting as well as macro) in
>> attached excel.
>>
>> Regards,
>> Swapnil.
>>
>> On Wed, Jul 5, 2017 at 12:24 AM, Puttu *  wrote:
>>
>>> anyhelp please
>>>
>>> On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:
>>>
>>>> Thanks Sir, Formula match exactly my requirement, however I have more
>>>> than 50 columns, quite difficult to input formula for every column. Thus
>>>> the reason I am looking for macro.
>>>>
>>>> Please help
>>>>
>>>> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
>>>> palande.swapni...@gmail.com> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> No need of macro, you can do it using formulas also. Attached is the
>>>>> excel for your reference.
>>>>>
>>>>> Regards,
>>>>> Swapnil
>>>>>
>>>>> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>>>>>
>>>>>> Experts, Any help on this will be much appreciated
>>>>>>
>>>>>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>>>>>
>>>>>>> Hi Experts
>>>>>>>
>>>>>>> Please help on this.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Putta
>>>>>>>
>>>>>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>>>>>
>>>>>>>> Hi Experts,
>>>>>>>>
>>>>>>>> I am not a vba expert and need your help me on the attached
>>>>>>>> requirement.
>>>>>>>>
>>>>>>>> I have list of columns and from that I need to know based on the
>>>>>>>> Model No. column filter if the other columns have any duplicate 
>>>>>>>> values, if
>>>>>>>> yes then it should display comments column as *Column Name +
>>>>>>>> duplicate value (Ex: Category_description having duplicate value)*
>>>>>>>>
>>>>>>>> 2. If the any of the column is blank it should print Column Name is
>>>>>>>> blank (*Ex: Parent Category ID has blank value).*
>>>>>>>>
>>>>>>>> Attached is the sample spread sheet. Please review and help me on
>>>>>>>> it.
>>>>>>>>
>>>>>>>> --
>>>>>>>> Putta
>>>>>>>>
>>>>>>>> --
>>>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
>>>>>>>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
>>>>>>>> forum @
>>>>>>>> https://www.facebook.com/discussexcel
>>>>>>>>
>>>>>>>> FORUM RULES
>>>>>>>>
>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>> 3) Don't post questions regarding breaking

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

Hi Swapnil,

Thanks you so much appreciate your time and help on getting this macro. I
think got almost what required, there is only small changes, which need to
be done. Sorry its my mistake not giving right information on that.

The reason I am looking a macro is I can't educate others who are very
beginning stage of learning. Macro will be more easier for them to use than
conditional formatting.

I have added my comments in Final Tab. Please review and let me know if any
points are unclear.

Thanks
Putta


On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande  wrote:

> Hi,
>
> Why are you not using conditional formatting. If your main purpose is to
> display user duplicates and empty cells, conditional formatting is best
> solution.
>
> Have applied both solutions (conditional formatting as well as macro) in
> attached excel.
>
> Regards,
> Swapnil.
>
> On Wed, Jul 5, 2017 at 12:24 AM, Puttu *  wrote:
>
>> anyhelp please
>>
>> On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:
>>
>>> Thanks Sir, Formula match exactly my requirement, however I have more
>>> than 50 columns, quite difficult to input formula for every column. Thus
>>> the reason I am looking for macro.
>>>
>>> Please help
>>>
>>> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
>>> palande.swapni...@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> No need of macro, you can do it using formulas also. Attached is the
>>>> excel for your reference.
>>>>
>>>> Regards,
>>>> Swapnil
>>>>
>>>> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>>>>
>>>>> Experts, Any help on this will be much appreciated
>>>>>
>>>>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>>>>
>>>>>> Hi Experts
>>>>>>
>>>>>> Please help on this.
>>>>>>
>>>>>> Thanks
>>>>>> Putta
>>>>>>
>>>>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>>>>
>>>>>>> Hi Experts,
>>>>>>>
>>>>>>> I am not a vba expert and need your help me on the attached
>>>>>>> requirement.
>>>>>>>
>>>>>>> I have list of columns and from that I need to know based on the
>>>>>>> Model No. column filter if the other columns have any duplicate values, 
>>>>>>> if
>>>>>>> yes then it should display comments column as *Column Name +
>>>>>>> duplicate value (Ex: Category_description having duplicate value)*
>>>>>>>
>>>>>>> 2. If the any of the column is blank it should print Column Name is
>>>>>>> blank (*Ex: Parent Category ID has blank value).*
>>>>>>>
>>>>>>> Attached is the sample spread sheet. Please review and help me on it.
>>>>>>>
>>>>>>> --
>>>>>>> Putta
>>>>>>>
>>>>>>> --
>>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>>>> https://www.facebook.com/discussexcel
>>>>>>>
>>>>>>> FORUM RULES
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>> 5) Jobs posting is not allowed.
>>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>>
>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>>> and members are not responsible for any loss.
>>>>>>> ---
>>>>>>> You received this message because you are subscribed to the Google
>>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>>&

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

anyhelp please

On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:

> Thanks Sir, Formula match exactly my requirement, however I have more than
> 50 columns, quite difficult to input formula for every column. Thus the
> reason I am looking for macro.
>
> Please help
>
> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
> palande.swapni...@gmail.com> wrote:
>
>> Hi,
>>
>> No need of macro, you can do it using formulas also. Attached is the
>> excel for your reference.
>>
>> Regards,
>> Swapnil
>>
>> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>>
>>> Experts, Any help on this will be much appreciated
>>>
>>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>>
>>>> Hi Experts
>>>>
>>>> Please help on this.
>>>>
>>>> Thanks
>>>> Putta
>>>>
>>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>>
>>>>> Hi Experts,
>>>>>
>>>>> I am not a vba expert and need your help me on the attached
>>>>> requirement.
>>>>>
>>>>> I have list of columns and from that I need to know based on the Model
>>>>> No. column filter if the other columns have any duplicate values, if yes
>>>>> then it should display comments column as *Column Name + duplicate
>>>>> value (Ex: Category_description having duplicate value)*
>>>>>
>>>>> 2. If the any of the column is blank it should print Column Name is
>>>>> blank (*Ex: Parent Category ID has blank value).*
>>>>>
>>>>> Attached is the sample spread sheet. Please review and help me on it.
>>>>>
>>>>> --
>>>>> Putta
>>>>>
>>>>> --
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Putta
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. F

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

Thanks Sir, Formula match exactly my requirement, however I have more than
50 columns, quite difficult to input formula for every column. Thus the
reason I am looking for macro.

Please help

On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi,
>
> No need of macro, you can do it using formulas also. Attached is the excel
> for your reference.
>
> Regards,
> Swapnil
>
> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>
>> Experts, Any help on this will be much appreciated
>>
>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>
>>> Hi Experts
>>>
>>> Please help on this.
>>>
>>> Thanks
>>> Putta
>>>
>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>
>>>> Hi Experts,
>>>>
>>>> I am not a vba expert and need your help me on the attached
>>>> requirement.
>>>>
>>>> I have list of columns and from that I need to know based on the Model
>>>> No. column filter if the other columns have any duplicate values, if yes
>>>> then it should display comments column as *Column Name + duplicate
>>>> value (Ex: Category_description having duplicate value)*
>>>>
>>>> 2. If the any of the column is blank it should print Column Name is
>>>> blank (*Ex: Parent Category ID has blank value).*
>>>>
>>>> Attached is the sample spread sheet. Please review and help me on it.
>>>>
>>>> --
>>>> Putta
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macr

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

Experts, Any help on this will be much appreciated

On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:

> Hi Experts
>
> Please help on this.
>
> Thanks
> Putta
>
> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I am not a vba expert and need your help me on the attached requirement.
>>
>> I have list of columns and from that I need to know based on the Model
>> No. column filter if the other columns have any duplicate values, if yes
>> then it should display comments column as *Column Name + duplicate value
>> (Ex: Category_description having duplicate value)*
>>
>> 2. If the any of the column is blank it should print Column Name is blank
>> (*Ex: Parent Category ID has blank value).*
>>
>> Attached is the sample spread sheet. Please review and help me on it.
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

Hi Experts

Please help on this.

Thanks
Putta

On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:

> Hi Experts,
>
> I am not a vba expert and need your help me on the attached requirement.
>
> I have list of columns and from that I need to know based on the Model No.
> column filter if the other columns have any duplicate values, if yes then
> it should display comments column as *Column Name + duplicate value (Ex:
> Category_description having duplicate value)*
>
> 2. If the any of the column is blank it should print Column Name is blank 
> (*Ex:
> Parent Category ID has blank value).*
>
> Attached is the sample spread sheet. Please review and help me on it.
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Putta

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

FORUM RULES

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

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

$$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

[Puttu *]

Hi Experts,

I am not a vba expert and need your help me on the attached requirement.

I have list of columns and from that I need to know based on the Model No.
column filter if the other columns have any duplicate values, if yes then
it should display comments column as *Column Name + duplicate value (Ex:
Category_description having duplicate value)*

2. If the any of the column is blank it should print Column Name is blank (*Ex:
Parent Category ID has blank value).*

Attached is the sample spread sheet. Please review and help me on it.

-- 
Putta

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

FORUM RULES

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

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


Null & Duplicate.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

[Puttu *]

Hi Abhishek,

Please find the attached text file. let me know if you need any further
details.

On Sun, Jul 31, 2016 at 9:20 PM, Abhishek Jain 
wrote:

> Please send your sample txt file as attachment.
>
> On Sun, Jul 31, 2016 at 6:46 PM, Puttu *  wrote:
>
>> any help please :(
>>
>> On Sat, Jul 30, 2016 at 10:19 PM, Puttu *  wrote:
>>
>>> Some one look and help on this please
>>>
>>> On Sat, Jul 30, 2016 at 12:16 PM, Puttu *  wrote:
>>>
>>>> Experts... please please help me on my requirements
>>>>
>>>> On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:
>>>>
>>>>> Hi Experts,
>>>>>
>>>>> Need a help either in macro or formula anything is still fine. Below
>>>>> format I receive a text file, but I need to all the fields to be updated 
>>>>> in
>>>>> excel. Please advise is there any easy way to do this and let me know if
>>>>> you need more info from my end
>>>>>
>>>>> *Sample Records Input text File in the below format*
>>>>>
>>>>> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler
>>>>> 112 Bruce Road 1   Smooth Rock Falls ON
>>>>>   5195281464 8908781912 Morning at 'Work
>>>>> .43971 TX150472 V488581 0.043 1720 9.55
>>>>>   Self Employed  8919454877
>>>>>
>>>>> February 1, 2014   morrison darrenpaul.msecr...@earthlink.net
>>>>> JOHN SCANLON 112 Burry AveHavelock ON
>>>>>   7808882361 6651525797 Afternoon at Home
>>>>> Z678071 TX668289v621966 0.055  2200 1.2
>>>>>   Self Employed  9808782973
>>>>>
>>>>> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
>>>>> ROARK   112 Burry Ave  Toronto ON
>>>>>   7099447221 6198440169 Anytime
>>>>> QA234304MA484290  FF514882 0.055 2200 1.2
>>>>>   Self Employed  6243510114
>>>>>
>>>>> July 1, 2014   morrison david monalisachic...@hotmail.com
>>>>> JOSEPH PARKER 112 Camli P1 Orangeville
>>>>>   ON   4034603324 6177795117 Anytime
>>>>> Z677848 TX667768 V621868 0.067  2680 9.1
>>>>>   Self Employed  8807122072
>>>>>
>>>>> July 8, 2014   morrison darwinpaule...@jellsouth.net
>>>>> BRIAN EARLEY   112 Camli P1   Barrie   ON
>>>>>   7809393268 8281152822 Afternoon at Home
>>>>> Z677969 TX667768v621899 0.04   1600 2.5
>>>>>   Self Employed  6729199981
>>>>>
>>>>>
>>>>> *Output Excel File should be in the below format*
>>>>>
>>>>>
>>>>>
>>>>> *SALES DATE*
>>>>>
>>>>> *CUSTOMER NAME*
>>>>>
>>>>> *E-MAIL ADDRESS*
>>>>>
>>>>> *DEALER NAME*
>>>>>
>>>>> *CUSTOMER ADDRESS*
>>>>>
>>>>> *CITY*
>>>>>
>>>>> *STATE*
>>>>>
>>>>> *CUSTOMER PHONE*
>>>>>
>>>>> *DEALER PHONE*
>>>>>
>>>>> *DELIVERY TIME*
>>>>>
>>>>> *INVOICE NO*
>>>>>
>>>>> *INSURANCE POLICY NO*
>>>>>
>>>>> *CHESIS NO*
>>>>>
>>>>> *BASIC AMOUNT*
>>>>>
>>>>> *INSURANCE AMOUNT*
>>>>>
>>>>> *DISCOUNT*
>>>>>
>>>>> *EMPLOYER*
>>>>>
>>>>> *CREDIT CARD NO*
>>>>>
>>>>> 05/09/2014
>>>>>
>>>>> Dakin J V
>>>>>
>>>>> gel...@alliedinfo.net
>>>>>
>>>>> Sandra Schuler
>>>>>
>>>>> 112 Bruce Road 1
>>>>>
>>>>> Smooth Rock Falls
>>>>>
>>>>> ON
>>>>>
>>>>> 5195281464
>>>>>
>>>>> 8908781912
>>>>>
>>>>> Morning at Work
>>>>>
>>>>> Z243971
>>>>>
>>>>>

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

[Puttu *]

any help please :(

On Sat, Jul 30, 2016 at 10:19 PM, Puttu *  wrote:

> Some one look and help on this please
>
> On Sat, Jul 30, 2016 at 12:16 PM, Puttu *  wrote:
>
>> Experts... please please help me on my requirements
>>
>> On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> Need a help either in macro or formula anything is still fine. Below
>>> format I receive a text file, but I need to all the fields to be updated in
>>> excel. Please advise is there any easy way to do this and let me know if
>>> you need more info from my end
>>>
>>> *Sample Records Input text File in the below format*
>>>
>>> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
>>> Bruce Road 1   Smooth Rock Falls ON
>>>   5195281464 8908781912 Morning at 'Work
>>> .43971 TX150472 V488581 0.043 1720 9.55
>>>   Self Employed  8919454877
>>>
>>> February 1, 2014   morrison darrenpaul.msecr...@earthlink.net  JOHN
>>> SCANLON 112 Burry AveHavelock ON
>>>   7808882361 6651525797 Afternoon at Home
>>> Z678071 TX668289v621966 0.055  2200 1.2
>>>   Self Employed  9808782973
>>>
>>> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
>>> ROARK   112 Burry Ave  Toronto ON
>>>   7099447221 6198440169 Anytime
>>> QA234304MA484290  FF514882 0.055 2200 1.2
>>>   Self Employed  6243510114
>>>
>>> July 1, 2014   morrison david monalisachic...@hotmail.com
>>> JOSEPH PARKER 112 Camli P1 Orangeville
>>>   ON   4034603324 6177795117 Anytime Z677848
>>> TX667768 V621868 0.067  2680 9.1
>>>   Self Employed  8807122072
>>>
>>> July 8, 2014   morrison darwinpaule...@jellsouth.net
>>> BRIAN EARLEY   112 Camli P1   Barrie   ON
>>>   7809393268 8281152822 Afternoon at Home
>>> Z677969 TX667768v621899 0.04   1600 2.5
>>>   Self Employed  6729199981
>>>
>>>
>>> *Output Excel File should be in the below format*
>>>
>>>
>>>
>>> *SALES DATE*
>>>
>>> *CUSTOMER NAME*
>>>
>>> *E-MAIL ADDRESS*
>>>
>>> *DEALER NAME*
>>>
>>> *CUSTOMER ADDRESS*
>>>
>>> *CITY*
>>>
>>> *STATE*
>>>
>>> *CUSTOMER PHONE*
>>>
>>> *DEALER PHONE*
>>>
>>> *DELIVERY TIME*
>>>
>>> *INVOICE NO*
>>>
>>> *INSURANCE POLICY NO*
>>>
>>> *CHESIS NO*
>>>
>>> *BASIC AMOUNT*
>>>
>>> *INSURANCE AMOUNT*
>>>
>>> *DISCOUNT*
>>>
>>> *EMPLOYER*
>>>
>>> *CREDIT CARD NO*
>>>
>>> 05/09/2014
>>>
>>> Dakin J V
>>>
>>> gel...@alliedinfo.net
>>>
>>> Sandra Schuler
>>>
>>> 112 Bruce Road 1
>>>
>>> Smooth Rock Falls
>>>
>>> ON
>>>
>>> 5195281464
>>>
>>> 8908781912
>>>
>>> Morning at Work
>>>
>>> Z243971
>>>
>>> TX150472
>>>
>>> V488581
>>>
>>> 0.043
>>>
>>> 1720
>>>
>>> 9.55
>>>
>>> Self Employed
>>>
>>> 8919454877
>>>
>>> 02/01/2014
>>>
>>> morrison darren
>>>
>>> paul.msecr...@eathlink.net
>>>
>>> JOHN SCANLON
>>>
>>> 112 Burry Ave
>>>
>>> Havelock
>>>
>>> ON
>>>
>>> 7808882361
>>>
>>> 6651525797
>>>
>>> Afternoon at Home
>>>
>>> Z678071
>>>
>>> TX668289
>>>
>>> v621966
>>>
>>> 0.055
>>>
>>> 2200
>>>
>>> 1.2
>>>
>>> Self Employed
>>>
>>> 9808782973
>>>
>>> 09/01/2014
>>>
>>> Reid Roland
>>>
>>> klwatli...@aol.com
>>>
>>> JOAN B ROARK
>>>
>>> 112 Burry Ave
>>>
>>> Toronto
>>>
>>> ON
>>>
>>> 7099447221
>>>
>>> 6198440169
>

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

[Puttu *]

Some one look and help on this please

On Sat, Jul 30, 2016 at 12:16 PM, Puttu *  wrote:

> Experts... please please help me on my requirements
>
> On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> Need a help either in macro or formula anything is still fine. Below
>> format I receive a text file, but I need to all the fields to be updated in
>> excel. Please advise is there any easy way to do this and let me know if
>> you need more info from my end
>>
>> *Sample Records Input text File in the below format*
>>
>> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
>> Bruce Road 1   Smooth Rock Falls ON
>>   5195281464 8908781912 Morning at 'Work   .43971
>> TX150472 V488581 0.043 1720 9.55
>>   Self Employed  8919454877
>>
>> February 1, 2014   morrison darrenpaul.msecr...@earthlink.net  JOHN
>> SCANLON 112 Burry AveHavelock ON
>>   7808882361 6651525797 Afternoon at Home Z678071
>> TX668289v621966 0.055  2200 1.2
>>   Self Employed  9808782973
>>
>> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
>> ROARK   112 Burry Ave  Toronto ON
>>   7099447221 6198440169 Anytime
>> QA234304MA484290  FF514882 0.055 2200 1.2
>>   Self Employed  6243510114
>>
>> July 1, 2014   morrison david monalisachic...@hotmail.com JOSEPH
>> PARKER 112 Camli P1 Orangeville
>>   ON   4034603324 6177795117 Anytime Z677848
>> TX667768 V621868 0.067  2680 9.1
>>   Self Employed  8807122072
>>
>> July 8, 2014   morrison darwinpaule...@jellsouth.net   BRIAN
>> EARLEY   112 Camli P1   Barrie   ON
>>   7809393268 8281152822 Afternoon at Home Z677969
>> TX667768v621899 0.04   1600 2.5
>>   Self Employed  6729199981
>>
>>
>> *Output Excel File should be in the below format*
>>
>>
>>
>> *SALES DATE*
>>
>> *CUSTOMER NAME*
>>
>> *E-MAIL ADDRESS*
>>
>> *DEALER NAME*
>>
>> *CUSTOMER ADDRESS*
>>
>> *CITY*
>>
>> *STATE*
>>
>> *CUSTOMER PHONE*
>>
>> *DEALER PHONE*
>>
>> *DELIVERY TIME*
>>
>> *INVOICE NO*
>>
>> *INSURANCE POLICY NO*
>>
>> *CHESIS NO*
>>
>> *BASIC AMOUNT*
>>
>> *INSURANCE AMOUNT*
>>
>> *DISCOUNT*
>>
>> *EMPLOYER*
>>
>> *CREDIT CARD NO*
>>
>> 05/09/2014
>>
>> Dakin J V
>>
>> gel...@alliedinfo.net
>>
>> Sandra Schuler
>>
>> 112 Bruce Road 1
>>
>> Smooth Rock Falls
>>
>> ON
>>
>> 5195281464
>>
>> 8908781912
>>
>> Morning at Work
>>
>> Z243971
>>
>> TX150472
>>
>> V488581
>>
>> 0.043
>>
>> 1720
>>
>> 9.55
>>
>> Self Employed
>>
>> 8919454877
>>
>> 02/01/2014
>>
>> morrison darren
>>
>> paul.msecr...@eathlink.net
>>
>> JOHN SCANLON
>>
>> 112 Burry Ave
>>
>> Havelock
>>
>> ON
>>
>> 7808882361
>>
>> 6651525797
>>
>> Afternoon at Home
>>
>> Z678071
>>
>> TX668289
>>
>> v621966
>>
>> 0.055
>>
>> 2200
>>
>> 1.2
>>
>> Self Employed
>>
>> 9808782973
>>
>> 09/01/2014
>>
>> Reid Roland
>>
>> klwatli...@aol.com
>>
>> JOAN B ROARK
>>
>> 112 Burry Ave
>>
>> Toronto
>>
>> ON
>>
>> 7099447221
>>
>> 6198440169
>>
>> Anytime
>>
>> QA234304
>>
>> MA484290
>>
>> FF514882
>>
>> 0.055
>>
>> 2200
>>
>> 1.2
>>
>> Self Employed
>>
>> 6243510114
>>
>> 07/01/2015
>>
>> morrison david
>>
>> monalisachic...@hotmail.com
>>
>> JOSEPH PARKER
>>
>> 112 Camli Pl
>>
>> Orangeville
>>
>> ON
>>
>> 4034603324
>>
>> 6177795117
>>
>> Anytime
>>
>> Z677848
>>
>> TX667768
>>
>> V621868
>>
>> 0.067
>>
>> 2680
>>
>> 9.1
>>
>> Self Employed
>>
>> 8807122072
>>
>> 07/

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

[Puttu *]

Experts... please please help me on my requirements

On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:

> Hi Experts,
>
> Need a help either in macro or formula anything is still fine. Below
> format I receive a text file, but I need to all the fields to be updated in
> excel. Please advise is there any easy way to do this and let me know if
> you need more info from my end
>
> *Sample Records Input text File in the below format*
>
> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
> Bruce Road 1   Smooth Rock Falls ON
>   5195281464 8908781912 Morning at 'Work   .43971
> TX150472 V488581 0.043 1720 9.55
>   Self Employed  8919454877
>
> February 1, 2014   morrison darrenpaul.msecr...@earthlink.net  JOHN
> SCANLON 112 Burry AveHavelock ON
>   7808882361 6651525797 Afternoon at Home Z678071
> TX668289v621966 0.055  2200 1.2
>   Self Employed  9808782973
>
> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
> ROARK   112 Burry Ave  Toronto ON
>   7099447221 6198440169 Anytime
> QA234304MA484290  FF514882 0.055 2200 1.2
>   Self Employed  6243510114
>
> July 1, 2014   morrison david monalisachic...@hotmail.com JOSEPH
> PARKER 112 Camli P1 Orangeville
>   ON   4034603324 6177795117 Anytime Z677848
> TX667768 V621868 0.067  2680 9.1
>   Self Employed  8807122072
>
> July 8, 2014   morrison darwinpaule...@jellsouth.net   BRIAN
> EARLEY   112 Camli P1   Barrie   ON
>   7809393268 8281152822 Afternoon at Home Z677969
> TX667768v621899 0.04   1600 2.5
>   Self Employed  6729199981
>
>
> *Output Excel File should be in the below format*
>
>
>
> *SALES DATE*
>
> *CUSTOMER NAME*
>
> *E-MAIL ADDRESS*
>
> *DEALER NAME*
>
> *CUSTOMER ADDRESS*
>
> *CITY*
>
> *STATE*
>
> *CUSTOMER PHONE*
>
> *DEALER PHONE*
>
> *DELIVERY TIME*
>
> *INVOICE NO*
>
> *INSURANCE POLICY NO*
>
> *CHESIS NO*
>
> *BASIC AMOUNT*
>
> *INSURANCE AMOUNT*
>
> *DISCOUNT*
>
> *EMPLOYER*
>
> *CREDIT CARD NO*
>
> 05/09/2014
>
> Dakin J V
>
> gel...@alliedinfo.net
>
> Sandra Schuler
>
> 112 Bruce Road 1
>
> Smooth Rock Falls
>
> ON
>
> 5195281464
>
> 8908781912
>
> Morning at Work
>
> Z243971
>
> TX150472
>
> V488581
>
> 0.043
>
> 1720
>
> 9.55
>
> Self Employed
>
> 8919454877
>
> 02/01/2014
>
> morrison darren
>
> paul.msecr...@eathlink.net
>
> JOHN SCANLON
>
> 112 Burry Ave
>
> Havelock
>
> ON
>
> 7808882361
>
> 6651525797
>
> Afternoon at Home
>
> Z678071
>
> TX668289
>
> v621966
>
> 0.055
>
> 2200
>
> 1.2
>
> Self Employed
>
> 9808782973
>
> 09/01/2014
>
> Reid Roland
>
> klwatli...@aol.com
>
> JOAN B ROARK
>
> 112 Burry Ave
>
> Toronto
>
> ON
>
> 7099447221
>
> 6198440169
>
> Anytime
>
> QA234304
>
> MA484290
>
> FF514882
>
> 0.055
>
> 2200
>
> 1.2
>
> Self Employed
>
> 6243510114
>
> 07/01/2015
>
> morrison david
>
> monalisachic...@hotmail.com
>
> JOSEPH PARKER
>
> 112 Camli Pl
>
> Orangeville
>
> ON
>
> 4034603324
>
> 6177795117
>
> Anytime
>
> Z677848
>
> TX667768
>
> V621868
>
> 0.067
>
> 2680
>
> 9.1
>
> Self Employed
>
> 8807122072
>
> 07/08/2014
>
> morrison darwin
>
> paule...@jellsouth.net
>
> BRIAN EARLEY
>
> 112 Camli Pl
>
> Barrie
>
> ON
>
> 7809393268
>
> 8281152822
>
> Afternoon at Home
>
> Z677969
>
> TX667768
>
> v621899
>
> 0.04
>
> 1600
>
> 2.5
>
> Self Employed
>
> 6729199981
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the re

$$Excel-Macros$$ Excel Delimiter Help form text file excel file

[Puttu *]

Hi Experts,

Need a help either in macro or formula anything is still fine. Below format
I receive a text file, but I need to all the fields to be updated in excel.
Please advise is there any easy way to do this and let me know if you need
more info from my end

*Sample Records Input text File in the below format*

May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
Bruce Road 1   Smooth Rock Falls ON
  5195281464 8908781912 Morning at 'Work   .43971
TX150472 V488581 0.043 1720 9.55
  Self Employed  8919454877

February 1, 2014   morrison darrenpaul.msecr...@earthlink.net  JOHN
SCANLON 112 Burry AveHavelock ON
  7808882361 6651525797 Afternoon at Home Z678071
TX668289v621966 0.055  2200 1.2
  Self Employed  9808782973

September 1, 2014 Reid Roland klwatli...@aol.com JOAN B ROARK
112 Burry Ave  Toronto ON
  7099447221 6198440169 Anytime
QA234304MA484290  FF514882 0.055 2200 1.2
  Self Employed  6243510114

July 1, 2014   morrison david monalisachic...@hotmail.com JOSEPH
PARKER 112 Camli P1 Orangeville
  ON   4034603324 6177795117 Anytime Z677848
TX667768 V621868 0.067  2680 9.1
  Self Employed  8807122072

July 8, 2014   morrison darwinpaule...@jellsouth.net   BRIAN
EARLEY   112 Camli P1   Barrie   ON
  7809393268 8281152822 Afternoon at Home Z677969
TX667768v621899 0.04   1600 2.5
  Self Employed  6729199981


*Output Excel File should be in the below format*



*SALES DATE*

*CUSTOMER NAME*

*E-MAIL ADDRESS*

*DEALER NAME*

*CUSTOMER ADDRESS*

*CITY*

*STATE*

*CUSTOMER PHONE*

*DEALER PHONE*

*DELIVERY TIME*

*INVOICE NO*

*INSURANCE POLICY NO*

*CHESIS NO*

*BASIC AMOUNT*

*INSURANCE AMOUNT*

*DISCOUNT*

*EMPLOYER*

*CREDIT CARD NO*

05/09/2014

Dakin J V

gel...@alliedinfo.net

Sandra Schuler

112 Bruce Road 1

Smooth Rock Falls

ON

5195281464

8908781912

Morning at Work

Z243971

TX150472

V488581

0.043

1720

9.55

Self Employed

8919454877

02/01/2014

morrison darren

paul.msecr...@eathlink.net

JOHN SCANLON

112 Burry Ave

Havelock

ON

7808882361

6651525797

Afternoon at Home

Z678071

TX668289

v621966

0.055

2200

1.2

Self Employed

9808782973

09/01/2014

Reid Roland

klwatli...@aol.com

JOAN B ROARK

112 Burry Ave

Toronto

ON

7099447221

6198440169

Anytime

QA234304

MA484290

FF514882

0.055

2200

1.2

Self Employed

6243510114

07/01/2015

morrison david

monalisachic...@hotmail.com

JOSEPH PARKER

112 Camli Pl

Orangeville

ON

4034603324

6177795117

Anytime

Z677848

TX667768

V621868

0.067

2680

9.1

Self Employed

8807122072

07/08/2014

morrison darwin

paule...@jellsouth.net

BRIAN EARLEY

112 Camli Pl

Barrie

ON

7809393268

8281152822

Afternoon at Home

Z677969

TX667768

v621899

0.04

1600

2.5

Self Employed

6729199981

-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Required Macro

[Puttu *]

Thank you sooo much Mandeep :) You are really the best :) thanks again

On Wed, Jan 20, 2016 at 11:13 AM, Mandeep Baluja 
wrote:

> PFA !!
>
> Regards,
> Mandeep baluja
>
> --
> 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.
>



-- 
Putta

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

FORUM RULES

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

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

$$Excel-Macros$$ Required Macro

[Puttu *]

Hi Experts,

Please help me solve this problem through VBA Macro.


Problem Statement   In the Input sheet some names of the employees will be
populated in column A as shown below. The rows in which data will be
available is uncertain. Provide the output in Output sheet in column A.
First row should contain number of names, second row should contain number
of unique name and third onwards list all the unique names in Descending
order.   Blank and white characters(example space,tab,etc) values to be
eliminated from the output   The macro should read input from Input tab
and write the output in Output tab

-- 
Putta

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

FORUM RULES

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

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


Basic VBA Assignment1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Need an help on this Macros

[Puttu *]

could you please help on other assignment as well

On Tue, Jan 19, 2016 at 11:49 AM, Puttu *  wrote:

> Perfect :) Thank you so much Mandeep. Appreciate your quick help
>
> On Tue, Jan 19, 2016 at 11:37 AM, Mandeep Baluja 
> wrote:
>
>> Check this result of your first query. Second will done  after completing
>>> my ofc work :D Not have much time to involve today
>>>
>>
>> Regards,
>> Mandeep baluja
>>
>> --
>> 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.
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Need an help on this Macros

[Puttu *]

Perfect :) Thank you so much Mandeep. Appreciate your quick help

On Tue, Jan 19, 2016 at 11:37 AM, Mandeep Baluja 
wrote:

> Check this result of your first query. Second will done  after completing
>> my ofc work :D Not have much time to involve today
>>
>
> Regards,
> Mandeep baluja
>
> --
> 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.
>



-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Need an help on this Macros

[Puttu *]

Hi Experts,

Please help me on it. need it asap please

On Tue, Jan 19, 2016 at 2:58 AM, Puttu *  wrote:

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



-- 
Putta

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

FORUM RULES

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

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

$$Excel-Macros$$ Need an help on this Macros

[Puttu *]

Hi Team,

Please help on the two excel VBA assignments Macros. both are very simple
one, but I am not well versed in VBA.

-- 
Putta

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

FORUM RULES

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

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


2_assignment.xls
Description: MS-Excel spreadsheet


Basic VBA Assignment1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

[Puttu *]

Thanks Ashish, fantastic this works well well as per my requirements.

Great Appreciate all your support.


On Tue, Dec 24, 2013 at 9:21 PM, ashish koul  wrote:

> try this
>
> Sub test()
> Dim i As Long, j As Long, k As Long
> Dim wk As Worksheet
>
>
> For i = 1 To ThisWorkbook.Sheets.Count
> For j = 2 To Sheets(i).Range("a65356").End(xlUp).Row
> k = 1
> For Each wk In ThisWorkbook.Sheets
> If wk.Name <> Sheets(i).Name Then
> If Application.WorksheetFunction.CountIf(wk.Range("a:a"),
> Sheets(i).Range("a" & j).Value) >= 1 Then
> Sheets(i).Range("a" & j).Offset(0, k).Value = wk.Name
> k = k + 1
> End If
> End If
> Next
> Next
> Next
>
>
>
> End Sub
>
>
>
>
>
> On Tue, Dec 24, 2013 at 3:56 PM, Murali Nagarajan wrote:
>
>> Dear Puttu,
>>
>> As desired you i enclosed Report with formula.let me know your feedback.
>>
>> On Tue, Dec 24, 2013 at 2:07 PM, Puttu *  wrote:
>>
>>> please help
>>>
>>>
>>> On Tue, Dec 24, 2013 at 11:58 AM, Puttu *  wrote:
>>>
>>>> Experts please help on my query
>>>>
>>>>
>>>> On Tue, Dec 24, 2013 at 8:35 AM, Puttu *  wrote:
>>>>
>>>>>   Hi Experts,
>>>>>
>>>>> Need your help. I have workbook which will have n number of sheets.
>>>>> What I need is in each sheet column A we have listed some products, it 
>>>>> need
>>>>> to search cell value (Product) in each sheets and if the value found just
>>>>> need to enter the sheet name in next column, if the cell value (Product)
>>>>> available in many sheets, it just need to continue the sheet name next
>>>>> column.
>>>>>
>>>>> This activity need to continue till each sheets from sheet1 to sheet
>>>>> N, because the no. of sheets going to be differ every time.
>>>>>
>>>>> Let me know if you need any details. Attached is the sample workbook
>>>>> for your reference.
>>>>>
>>>>> --
>>>>> Putta
>>>>>
>>>>> --
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Putta
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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
&

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

[Puttu *]

Thanks Murali, this works out well, but if we have dynamic sheets, then
need to add vlookup formula every time.

Any how thanks for spending time and providing solution, really appreciate
that :)


On Tue, Dec 24, 2013 at 3:56 PM, Murali Nagarajan wrote:

> Dear Puttu,
>
> As desired you i enclosed Report with formula.let me know your feedback.
>
> On Tue, Dec 24, 2013 at 2:07 PM, Puttu *  wrote:
>
>> please help
>>
>>
>> On Tue, Dec 24, 2013 at 11:58 AM, Puttu *  wrote:
>>
>>> Experts please help on my query
>>>
>>>
>>> On Tue, Dec 24, 2013 at 8:35 AM, Puttu *  wrote:
>>>
>>>>   Hi Experts,
>>>>
>>>> Need your help. I have workbook which will have n number of sheets.
>>>> What I need is in each sheet column A we have listed some products, it need
>>>> to search cell value (Product) in each sheets and if the value found just
>>>> need to enter the sheet name in next column, if the cell value (Product)
>>>> available in many sheets, it just need to continue the sheet name next
>>>> column.
>>>>
>>>> This activity need to continue till each sheets from sheet1 to sheet N,
>>>> because the no. of sheets going to be differ every time.
>>>>
>>>> Let me know if you need any details. Attached is the sample workbook
>>>> for your reference.
>>>>
>>>> --
>>>> Putta
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are 

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

[Puttu *]

please help


On Tue, Dec 24, 2013 at 11:58 AM, Puttu *  wrote:

> Experts please help on my query
>
>
> On Tue, Dec 24, 2013 at 8:35 AM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> Need your help. I have workbook which will have n number of sheets. What
>> I need is in each sheet column A we have listed some products, it need to
>> search cell value (Product) in each sheets and if the value found just need
>> to enter the sheet name in next column, if the cell value (Product)
>> available in many sheets, it just need to continue the sheet name next
>> column.
>>
>> This activity need to continue till each sheets from sheet1 to sheet N,
>> because the no. of sheets going to be differ every time.
>>
>> Let me know if you need any details. Attached is the sample workbook for
>> your reference.
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

[Puttu *]

Experts please help on my query


On Tue, Dec 24, 2013 at 8:35 AM, Puttu *  wrote:

> Hi Experts,
>
> Need your help. I have workbook which will have n number of sheets. What I
> need is in each sheet column A we have listed some products, it need to
> search cell value (Product) in each sheets and if the value found just need
> to enter the sheet name in next column, if the cell value (Product)
> available in many sheets, it just need to continue the sheet name next
> column.
>
> This activity need to continue till each sheets from sheet1 to sheet N,
> because the no. of sheets going to be differ every time.
>
> Let me know if you need any details. Attached is the sample workbook for
> your reference.
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Putta

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

FORUM RULES

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

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

$$Excel-Macros$$ Macro for Search Range of Value in each sheets

[Puttu *]

Hi Experts,

Need your help. I have workbook which will have n number of sheets. What I
need is in each sheet column A we have listed some products, it need to
search cell value (Product) in each sheets and if the value found just need
to enter the sheet name in next column, if the cell value (Product)
available in many sheets, it just need to continue the sheet name next
column.

This activity need to continue till each sheets from sheet1 to sheet N,
because the no. of sheets going to be differ every time.

Let me know if you need any details. Attached is the sample workbook for
your reference.

-- 
Putta

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

FORUM RULES

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

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


Search Range of value in each sheets.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Puttu *]

Really i tried my best, but didn't worked out. thus the reason seeking for
help


On Tue, Jul 30, 2013 at 3:59 PM, De Premor  wrote:

>  Hi Putu,
>
> While you're waiting for a groups response, why dont you start writing your
> own code, you might want to read more about :
>
> Select a file using Application.GetOpenFilename
> Open a workbook using Workbooks.Open
> Assign a value to variable using Set ... = 
> Looping each worksheet using For Each ... in 
> Sheet Name validation using ...Name = ...Name
> comparing each value using if ... = ... then
> looping in a row
> looping in a column
> Assign value to a cell, ex: Range("A1").value = 
>
> You may ask it here one by one for your reference, i'am sure another
> members will help you and you got your learning step.
>
> Rgds,
> [dp]
>
> Pada 30/07/2013 16:43, Puttu * menulis:
>
> please please advise, it's very important for me...
>
>
> On Sat, Jul 27, 2013 at 4:55 PM, Puttu *  wrote:
>
>>  Hi Experts,
>>
>>  Need a help on copying the data from one workbook (Reference) to another
>> workbook (master). I know asking too much, appreciate could you please help
>> me on this coding.
>>
>>  The workbook name different each time, i need dynamic name selection
>> option to select both the work sheets and data range also dynamic.
>>
>>  1. Need a option or input box to select the two workbooks
>>
>> 2. Each workbook sheets names are not aligned properly, each time
>> worksheet name to cross verify and past as per the match.
>>
>> 3. Copy the data from reference (report 1) and past to Master (report 1)
>> next to the existing range (Example showed in Master sheet report 1
>> highlighted in yellow color)
>>
>>  4. After the paste Sales report header merged to complete header (shown
>> in master sheet report 1)
>>
>>  5. entire data need to auto fit
>>
>>  6. Need a report log after each sheet is pasted in new sheets in the
>> master work book.
>>
>>  Attached is the reports
>>
>>  --
>> Putta
>>   --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Putta
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> em

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

[Puttu *]

please please advise, it's very important for me...


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

> Hi Experts,
>
> Need a help on copying the data from one workbook (Reference) to another
> workbook (master). I know asking too much, appreciate could you please help
> me on this coding.
>
> The workbook name different each time, i need dynamic name selection
> option to select both the work sheets and data range also dynamic.
>
> 1. Need a option or input box to select the two workbooks
>
> 2. Each workbook sheets names are not aligned properly, each time
> worksheet name to cross verify and past as per the match.
>
> 3. Copy the data from reference (report 1) and past to Master (report 1)
> next to the existing range (Example showed in Master sheet report 1
> highlighted in yellow color)
>
> 4. After the paste Sales report header merged to complete header (shown in
> master sheet report 1)
>
> 5. entire data need to auto fit
>
> 6. Need a report log after each sheet is pasted in new sheets in the
> master work book.
>
> Attached is the reports
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Putta

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

FORUM RULES

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

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

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

[Puttu *]

Experts really need your help on this macro.. please please


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

> Hi Experts,
>
> Need a help on copying the data from one workbook (Reference) to another
> workbook (master). I know asking too much, appreciate could you please help
> me on this coding.
>
> The workbook name different each time, i need dynamic name selection
> option to select both the work sheets and data range also dynamic.
>
> 1. Need a option or input box to select the two workbooks
>
> 2. Each workbook sheets names are not aligned properly, each time
> worksheet name to cross verify and past as per the match.
>
> 3. Copy the data from reference (report 1) and past to Master (report 1)
> next to the existing range (Example showed in Master sheet report 1
> highlighted in yellow color)
>
> 4. After the paste Sales report header merged to complete header (shown in
> master sheet report 1)
>
> 5. entire data need to auto fit
>
> 6. Need a report log after each sheet is pasted in new sheets in the
> master work book.
>
> Attached is the reports
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Putta

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

FORUM RULES

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

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

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

[Puttu *]

please help me on the macro..


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

> Any updated on the macro team..
>
>
> On Sat, Jul 27, 2013 at 7:14 PM, Puttu *  wrote:
>
>> Experts your assistance is much appreciated.
>>
>>
>> On Sat, Jul 27, 2013 at 4:55 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> Need a help on copying the data from one workbook (Reference) to another
>>> workbook (master). I know asking too much, appreciate could you please help
>>> me on this coding.
>>>
>>> The workbook name different each time, i need dynamic name selection
>>> option to select both the work sheets and data range also dynamic.
>>>
>>> 1. Need a option or input box to select the two workbooks
>>>
>>> 2. Each workbook sheets names are not aligned properly, each time
>>> worksheet name to cross verify and past as per the match.
>>>
>>> 3. Copy the data from reference (report 1) and past to Master (report 1)
>>> next to the existing range (Example showed in Master sheet report 1
>>> highlighted in yellow color)
>>>
>>> 4. After the paste Sales report header merged to complete header (shown
>>> in master sheet report 1)
>>>
>>> 5. entire data need to auto fit
>>>
>>> 6. Need a report log after each sheet is pasted in new sheets in the
>>> master work book.
>>>
>>> Attached is the reports
>>>
>>> --
>>> Putta
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

FORUM RULES

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

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

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

[Puttu *]

Any updated on the macro team..


On Sat, Jul 27, 2013 at 7:14 PM, Puttu *  wrote:

> Experts your assistance is much appreciated.
>
>
> On Sat, Jul 27, 2013 at 4:55 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> Need a help on copying the data from one workbook (Reference) to another
>> workbook (master). I know asking too much, appreciate could you please help
>> me on this coding.
>>
>> The workbook name different each time, i need dynamic name selection
>> option to select both the work sheets and data range also dynamic.
>>
>> 1. Need a option or input box to select the two workbooks
>>
>> 2. Each workbook sheets names are not aligned properly, each time
>> worksheet name to cross verify and past as per the match.
>>
>> 3. Copy the data from reference (report 1) and past to Master (report 1)
>> next to the existing range (Example showed in Master sheet report 1
>> highlighted in yellow color)
>>
>> 4. After the paste Sales report header merged to complete header (shown
>> in master sheet report 1)
>>
>> 5. entire data need to auto fit
>>
>> 6. Need a report log after each sheet is pasted in new sheets in the
>> master work book.
>>
>> Attached is the reports
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

FORUM RULES

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

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

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

[Puttu *]

Experts your assistance is much appreciated.


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

> Hi Experts,
>
> Need a help on copying the data from one workbook (Reference) to another
> workbook (master). I know asking too much, appreciate could you please help
> me on this coding.
>
> The workbook name different each time, i need dynamic name selection
> option to select both the work sheets and data range also dynamic.
>
> 1. Need a option or input box to select the two workbooks
>
> 2. Each workbook sheets names are not aligned properly, each time
> worksheet name to cross verify and past as per the match.
>
> 3. Copy the data from reference (report 1) and past to Master (report 1)
> next to the existing range (Example showed in Master sheet report 1
> highlighted in yellow color)
>
> 4. After the paste Sales report header merged to complete header (shown in
> master sheet report 1)
>
> 5. entire data need to auto fit
>
> 6. Need a report log after each sheet is pasted in new sheets in the
> master work book.
>
> Attached is the reports
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Putta

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

FORUM RULES

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

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

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

[Puttu *]

Hi Experts,

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

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

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

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

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

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

5. entire data need to auto fit

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

Attached is the reports

-- 
Putta

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

FORUM RULES

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

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




Master.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Reference.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Amazing Excel Charts

[Puttu *]

really very useful. Thanks


On Sat, Jul 13, 2013 at 1:07 PM,  wrote:

> **
> Great collection. Thanks Ashish
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * ashish koul 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 12 Jul 2013 21:08:44 +0530
> *To: *excel-macros; excelvbamacros<
> excelvbamac...@googlegroups.com>
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Amazing Excel Charts
>
>  [image: Boxbe]  This message is eligible
> for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup 
> rule|
>  More
> info
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Thanks a lot Ashish, this is what exactly what i am looking.

I small addition required, Once the Formula is placed and formula resulted
converted to % format, the value should highlight in red font if the value
is more than > 10%  only for that result row.

Is this possible?

On Tue, Dec 11, 2012 at 10:57 PM, ashish koul  wrote:

> try the attachment
>
> paste the full path of files in column A and run the macro
>
> Regards
> Ashish
>
>
>
>
> On Tue, Dec 11, 2012 at 12:56 PM, Puttu *  wrote:
>
>> please help on this request..
>>
>>
>> On Mon, Dec 10, 2012 at 6:46 PM, Puttu *  wrote:
>>
>>> Any update experts?
>>>
>>>
>>> On Mon, Dec 10, 2012 at 2:02 PM, Puttu *  wrote:
>>>
>>>> Thanks for your response David,
>>>>
>>>> Sorry If I wasn't clear. Below is the answer for your questions.
>>>> Attached is the reports and master excel how i am expecting.
>>>> Let me know if you need any other details
>>>>  On Mon, Dec 10, 2012 at 12:52 PM, David Grugeon 
>>>> wrote:
>>>>
>>>>> Insufficient information provided.
>>>>>
>>>>> You have posted 4 apparently identical workbooks although Report1.xls
>>>>> is slightly larger than the others so there must be some difference.  What
>>>>> is it? --> *Attached is the new smaple 4 worksheets*
>>>>>
>>>>> Could you provide a workbook called, say, Result.xls with at least 2
>>>>> or the source reports included.  This will give us much more information.
>>>>> --> *Final all the 4 or 5 reports data should be saved in new
>>>>> worksheet called Master Workbook (Attached is the final result one*
>>>>>
>>>>> Will the source workbooks always have only 1 sheet called 16.0, or
>>>>> will there sometimes be more than one sheet in the workbooks or will the
>>>>> sheet names vary?* It will be the same every time*
>>>>>
>>>>> With regard to requirement 3 *(**3. This procedure should continue
>>>>> untile i say no more workbook to use)*.  Computers do not normally
>>>>> respond to spoken commands.  Do you want it to process all the files in 
>>>>> the
>>>>> folder, or do you want a message box to come up after each one with "Do 
>>>>> you
>>>>> want me to process another?" and yes and no buttons. *--> I need
>>>>> message box to popped up for every report Whether I need to process 
>>>>> another
>>>>> or not*
>>>>>
>>>>> Are the files to be consolidated in a single directory?  Is it the
>>>>> same directory as the summary file (with the code) will be in?  If not 
>>>>> what
>>>>> is its full path?  --> *Yes all the file in same directory and yes
>>>>> result/Master report also should be in same directory*
>>>>> Are they the only files in that directory? *Yes*
>>>>>
>>>>> Full answers to these questions will get us a lot nearer to being able
>>>>> to produce some workable code.
>>>>>
>>>>>
>>>>>  Regards
>>>>> David Grugeon
>>>>>
>>>>>
>>>>>
>>>>> On 10 December 2012 15:54, Puttu *  wrote:
>>>>>
>>>>>> can any one please...
>>>>>>
>>>>>> Need a macro to 5 workbook data to paste in single workbook, on one
>>>>>> by one in the same sheet
>>>>>>
>>>>>>
>>>>>> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>>>>>>
>>>>>>> SOME ONE HELP ME PLS
>>>>>>>
>>>>>>>
>>>>>>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>>>>>>
>>>>>>>> Yogananda thanks for your prompt response.
>>>>>>>>
>>>>>>>> My requiements is below
>>>>>>>>
>>>>>>>> 1. I have more than 5-10 work book in the folder
>>>>>>>> 2. Macro should open one workbook and copy the data and past it new
>>>>>>>> workbook called as master and close the source workbook
>>>>>>>> 3. Again it should open 2nd workbook and copy and past the data to
>>>>>>>> master workbook and close it.
>>

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

please help on this request..

On Mon, Dec 10, 2012 at 6:46 PM, Puttu *  wrote:

> Any update experts?
>
>
> On Mon, Dec 10, 2012 at 2:02 PM, Puttu *  wrote:
>
>> Thanks for your response David,
>>
>> Sorry If I wasn't clear. Below is the answer for your questions. Attached
>> is the reports and master excel how i am expecting.
>> Let me know if you need any other details
>>  On Mon, Dec 10, 2012 at 12:52 PM, David Grugeon wrote:
>>
>>> Insufficient information provided.
>>>
>>> You have posted 4 apparently identical workbooks although Report1.xls is
>>> slightly larger than the others so there must be some difference.  What is
>>> it? --> *Attached is the new smaple 4 worksheets*
>>>
>>> Could you provide a workbook called, say, Result.xls with at least 2 or
>>> the source reports included.  This will give us much more information. -->
>>> *Final all the 4 or 5 reports data should be saved in new worksheet
>>> called Master Workbook (Attached is the final result one*
>>>
>>> Will the source workbooks always have only 1 sheet called 16.0, or will
>>> there sometimes be more than one sheet in the workbooks or will the sheet
>>> names vary?* It will be the same every time*
>>>
>>> With regard to requirement 3 *(**3. This procedure should continue
>>> untile i say no more workbook to use)*.  Computers do not normally
>>> respond to spoken commands.  Do you want it to process all the files in the
>>> folder, or do you want a message box to come up after each one with "Do you
>>> want me to process another?" and yes and no buttons. *--> I need
>>> message box to popped up for every report Whether I need to process another
>>> or not*
>>>
>>> Are the files to be consolidated in a single directory?  Is it the same
>>> directory as the summary file (with the code) will be in?  If not what is
>>> its full path?  --> *Yes all the file in same directory and yes
>>> result/Master report also should be in same directory*
>>> Are they the only files in that directory? *Yes*
>>>
>>> Full answers to these questions will get us a lot nearer to being able
>>> to produce some workable code.
>>>
>>>
>>>  Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 10 December 2012 15:54, Puttu *  wrote:
>>>
>>>> can any one please...
>>>>
>>>> Need a macro to 5 workbook data to paste in single workbook, on one by
>>>> one in the same sheet
>>>>
>>>>
>>>> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>>>>
>>>>> SOME ONE HELP ME PLS
>>>>>
>>>>>
>>>>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>>>>
>>>>>> Yogananda thanks for your prompt response.
>>>>>>
>>>>>> My requiements is below
>>>>>>
>>>>>> 1. I have more than 5-10 work book in the folder
>>>>>> 2. Macro should open one workbook and copy the data and past it new
>>>>>> workbook called as master and close the source workbook
>>>>>> 3. Again it should open 2nd workbook and copy and past the data to
>>>>>> master workbook and close it.
>>>>>> 4. In the same way it should continioue untile i say no more workbook
>>>>>> for selction
>>>>>> 5. all the workbook data should be pasted in the same Master workbook
>>>>>> sheet1 one by one below giving the one row space.
>>>>>>
>>>>>> Let me know if you need any help.
>>>>>>
>>>>>>
>>>>>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>>>>>> yogananda.mutha...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> Please try this if this can work out for u
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>>>>>>
>>>>>>>> Experts please help me
>>>>>>>>
>>>>>>>> Need multiple data to pasted in one single workbook
>>>>>>>>
>>>>>>>>
>>>>>>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>>>>>>

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Yogananda thanks for your prompt response.

My requiements is below

1. I have more than 5-10 work book in the folder
2. Macro should open one workbook and copy the data and past it new
workbook called as master and close the source workbook
3. Again it should open 2nd workbook and copy and past the data to master
workbook and close it.
4. In the same way it should continioue untile i say no more workbook for
selction
5. all the workbook data should be pasted in the same Master workbook
sheet1 one by one below giving the one row space.

Let me know if you need any help.


On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:

> Hi,
>
> Please try this if this can work out for u
>
>
>
> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>
>> Experts please help me
>>
>> Need multiple data to pasted in one single workbook
>>
>>
>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>
>>> Hi Experts
>>>
>>> I need a macro where i can use multiple workbooks to in single new
>>> workbook
>>>
>>> 1. I have multiple workbook in perticular folder, all that workbook used
>>> range data need to be copied to single work book.
>>> 2. Every single workbook end of the data it should show the comparasion
>>> result formula =(B56-B55)/B55, row back ground coloured yellow and any
>>> thing more than >10% should be highlighted in different font color
>>> 3. This procedure should continue untile i say no more workbook to use
>>>
>>>
>>>
>>> Attached is the sample report with one example
>>>
>>> Any help is much appreciated.
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
>
>
>
> Regards
> Yogananda Muthaiah
> Ph : 973 123 7267
>
>  --
> 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, F

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Any update experts?

On Mon, Dec 10, 2012 at 2:02 PM, Puttu *  wrote:

> Thanks for your response David,
>
> Sorry If I wasn't clear. Below is the answer for your questions. Attached
> is the reports and master excel how i am expecting.
> Let me know if you need any other details
>  On Mon, Dec 10, 2012 at 12:52 PM, David Grugeon wrote:
>
>> Insufficient information provided.
>>
>> You have posted 4 apparently identical workbooks although Report1.xls is
>> slightly larger than the others so there must be some difference.  What is
>> it? --> *Attached is the new smaple 4 worksheets*
>>
>> Could you provide a workbook called, say, Result.xls with at least 2 or
>> the source reports included.  This will give us much more information. -->
>> *Final all the 4 or 5 reports data should be saved in new worksheet
>> called Master Workbook (Attached is the final result one*
>>
>> Will the source workbooks always have only 1 sheet called 16.0, or will
>> there sometimes be more than one sheet in the workbooks or will the sheet
>> names vary?* It will be the same every time*
>>
>> With regard to requirement 3 *(**3. This procedure should continue
>> untile i say no more workbook to use)*.  Computers do not normally
>> respond to spoken commands.  Do you want it to process all the files in the
>> folder, or do you want a message box to come up after each one with "Do you
>> want me to process another?" and yes and no buttons. *--> I need message
>> box to popped up for every report Whether I need to process another or not
>> *
>>
>> Are the files to be consolidated in a single directory?  Is it the same
>> directory as the summary file (with the code) will be in?  If not what is
>> its full path?  --> *Yes all the file in same directory and yes
>> result/Master report also should be in same directory*
>> Are they the only files in that directory? *Yes*
>>
>> Full answers to these questions will get us a lot nearer to being able to
>> produce some workable code.
>>
>>
>>  Regards
>> David Grugeon
>>
>>
>>
>> On 10 December 2012 15:54, Puttu *  wrote:
>>
>>> can any one please...
>>>
>>> Need a macro to 5 workbook data to paste in single workbook, on one by
>>> one in the same sheet
>>>
>>>
>>> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>>>
>>>> SOME ONE HELP ME PLS
>>>>
>>>>
>>>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>>>
>>>>> Yogananda thanks for your prompt response.
>>>>>
>>>>> My requiements is below
>>>>>
>>>>> 1. I have more than 5-10 work book in the folder
>>>>> 2. Macro should open one workbook and copy the data and past it new
>>>>> workbook called as master and close the source workbook
>>>>> 3. Again it should open 2nd workbook and copy and past the data to
>>>>> master workbook and close it.
>>>>> 4. In the same way it should continioue untile i say no more workbook
>>>>> for selction
>>>>> 5. all the workbook data should be pasted in the same Master workbook
>>>>> sheet1 one by one below giving the one row space.
>>>>>
>>>>> Let me know if you need any help.
>>>>>
>>>>>
>>>>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>>>>> yogananda.mutha...@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> Please try this if this can work out for u
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>>>>>
>>>>>>> Experts please help me
>>>>>>>
>>>>>>> Need multiple data to pasted in one single workbook
>>>>>>>
>>>>>>>
>>>>>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>>>>>
>>>>>>>> Hi Experts
>>>>>>>>
>>>>>>>> I need a macro where i can use multiple workbooks to in single new
>>>>>>>> workbook
>>>>>>>>
>>>>>>>> 1. I have multiple workbook in perticular folder, all that workbook
>>>>>>>> used range data need to be copied to single work book.
>>>>>>>> 2. Every s

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

any help

Moderator could you please help on this

On Mon, Dec 10, 2012 at 11:24 AM, Puttu *  wrote:

> can any one please...
>
> Need a macro to 5 workbook data to paste in single workbook, on one by one
> in the same sheet
>
>
> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>
>> SOME ONE HELP ME PLS
>>
>>
>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>
>>> Yogananda thanks for your prompt response.
>>>
>>> My requiements is below
>>>
>>> 1. I have more than 5-10 work book in the folder
>>> 2. Macro should open one workbook and copy the data and past it new
>>> workbook called as master and close the source workbook
>>> 3. Again it should open 2nd workbook and copy and past the data to
>>> master workbook and close it.
>>> 4. In the same way it should continioue untile i say no more workbook
>>> for selction
>>> 5. all the workbook data should be pasted in the same Master workbook
>>> sheet1 one by one below giving the one row space.
>>>
>>> Let me know if you need any help.
>>>
>>>
>>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>>> yogananda.mutha...@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> Please try this if this can work out for u
>>>>
>>>>
>>>>
>>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>>>
>>>>> Experts please help me
>>>>>
>>>>> Need multiple data to pasted in one single workbook
>>>>>
>>>>>
>>>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>>>
>>>>>> Hi Experts
>>>>>>
>>>>>> I need a macro where i can use multiple workbooks to in single new
>>>>>> workbook
>>>>>>
>>>>>> 1. I have multiple workbook in perticular folder, all that workbook
>>>>>> used range data need to be copied to single work book.
>>>>>> 2. Every single workbook end of the data it should show the
>>>>>> comparasion result formula =(B56-B55)/B55, row back ground coloured 
>>>>>> yellow
>>>>>> and any thing more than >10% should be highlighted in different font 
>>>>>> color
>>>>>> 3. This procedure should continue untile i say no more workbook to use
>>>>>>
>>>>>>
>>>>>>
>>>>>> Attached is the sample report with one example
>>>>>>
>>>>>> Any help is much appreciated.
>>>>>>
>>>>>> --
>>>>>> Putta
>>>>>>
>>>>>> --
>>>>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>>>>> To unsubscribe from this group, send email to
>>>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en
>>>>>> .
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Putta
>>>>>
>>>>> --
>>>>

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

can any one please...

Need a macro to 5 workbook data to paste in single workbook, on one by one
in the same sheet

On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:

> SOME ONE HELP ME PLS
>
>
> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>
>> Yogananda thanks for your prompt response.
>>
>> My requiements is below
>>
>> 1. I have more than 5-10 work book in the folder
>> 2. Macro should open one workbook and copy the data and past it new
>> workbook called as master and close the source workbook
>> 3. Again it should open 2nd workbook and copy and past the data to master
>> workbook and close it.
>> 4. In the same way it should continioue untile i say no more workbook for
>> selction
>> 5. all the workbook data should be pasted in the same Master workbook
>> sheet1 one by one below giving the one row space.
>>
>> Let me know if you need any help.
>>
>>
>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>> yogananda.mutha...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Please try this if this can work out for u
>>>
>>>
>>>
>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>>
>>>> Experts please help me
>>>>
>>>> Need multiple data to pasted in one single workbook
>>>>
>>>>
>>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>>
>>>>> Hi Experts
>>>>>
>>>>> I need a macro where i can use multiple workbooks to in single new
>>>>> workbook
>>>>>
>>>>> 1. I have multiple workbook in perticular folder, all that workbook
>>>>> used range data need to be copied to single work book.
>>>>> 2. Every single workbook end of the data it should show the
>>>>> comparasion result formula =(B56-B55)/B55, row back ground coloured yellow
>>>>> and any thing more than >10% should be highlighted in different font color
>>>>> 3. This procedure should continue untile i say no more workbook to use
>>>>>
>>>>>
>>>>>
>>>>> Attached is the sample report with one example
>>>>>
>>>>> Any help is much appreciated.
>>>>>
>>>>> --
>>>>> Putta
>>>>>
>>>>> --
>>>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>>>> To unsubscribe from this group, send email to
>>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Putta
>>>>
>>>> --
>>>> 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.
>&g

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

SOME ONE HELP ME PLS

On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:

> Yogananda thanks for your prompt response.
>
> My requiements is below
>
> 1. I have more than 5-10 work book in the folder
> 2. Macro should open one workbook and copy the data and past it new
> workbook called as master and close the source workbook
> 3. Again it should open 2nd workbook and copy and past the data to master
> workbook and close it.
> 4. In the same way it should continioue untile i say no more workbook for
> selction
> 5. all the workbook data should be pasted in the same Master workbook
> sheet1 one by one below giving the one row space.
>
> Let me know if you need any help.
>
>
> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
> yogananda.mutha...@gmail.com> wrote:
>
>> Hi,
>>
>> Please try this if this can work out for u
>>
>>
>>
>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>
>>> Experts please help me
>>>
>>> Need multiple data to pasted in one single workbook
>>>
>>>
>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>
>>>> Hi Experts
>>>>
>>>> I need a macro where i can use multiple workbooks to in single new
>>>> workbook
>>>>
>>>> 1. I have multiple workbook in perticular folder, all that workbook
>>>> used range data need to be copied to single work book.
>>>> 2. Every single workbook end of the data it should show the comparasion
>>>> result formula =(B56-B55)/B55, row back ground coloured yellow and any
>>>> thing more than >10% should be highlighted in different font color
>>>> 3. This procedure should continue untile i say no more workbook to use
>>>>
>>>>
>>>>
>>>> Attached is the sample report with one example
>>>>
>>>> Any help is much appreciated.
>>>>
>>>> --
>>>> Putta
>>>>
>>>> --
>>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> excel-macros+unsubscr...@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Experts please help me

Need multiple data to pasted in one single workbook

On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:

> Hi Experts
>
> I need a macro where i can use multiple workbooks to in single new workbook
>
> 1. I have multiple workbook in perticular folder, all that workbook used
> range data need to be copied to single work book.
> 2. Every single workbook end of the data it should show the comparasion
> result formula =(B56-B55)/B55, row back ground coloured yellow and any
> thing more than >10% should be highlighted in different font color
> 3. This procedure should continue untile i say no more workbook to use
>
>
>
> Attached is the sample report with one example
>
> Any help is much appreciated.
>
> --
> Putta
>
> --
> 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Putta

-- 
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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Creating Alarm/Alert MSG for every Hour

[Puttu *]

How to use this? getting error message.

On Tue, Oct 30, 2012 at 8:48 PM, Rajan_Verma wrote:

> *Execute it at 8 o clock*
>
> * *
>
> *Sub  ShowPopUp()*
>
> * *
>
> *Msgbox “Send Massange”*
>
> *Application.OnTime Now+Timevalue(“01:00:00”),”ShowPopUp”*
>
> * *
>
> *End Sub*
>
> * *
>
> *Sub StopPopUp()*
>
> *On Error Resume next*
>
> *Application.OnTime Now+Timevalue(“01:00:00”),”ShowPopUp”,,False*
>
> * *
>
> *End sub*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *mayur
> *Sent:* 30 October 2012 8:45
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Creating Alarm/Alert MSG for every Hour
>
> ** **
>
> Hi Team,
>
>  
>
> I have a report deliverable every hour of the day. Multiple users are
> working on it.
>
>  
>
> Delivery Start from 8:00 AM to 10 PM.
>
>  
>
> Is there any way I can set alert message (for all the users) wihtout using
> outlook, windows scheduler.
>
>  
>
> It will be helpful for me to deliver the reports on every hour and
> multiple users will get alert for the same (as same as net send  msg,
> something like that a pop should come).
>
>  
>
> Request you to put in your valuable inputs. 
>
>  
>
> Thanks,
>
> Mayur
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Putta

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-m

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Thanks Amresh, This is what i was looking. Appreciate your timely help.

Thanks again a lot :)
On Mon, Jul 23, 2012 at 3:06 PM, Amresh Maurya wrote:

> Hi ,
>
> find the attached file.
>
> use this code.
>
>  Function perfix(Outlet As String, Level As String, numbner As Integer)
>
> If Outlet = "FOOD" And Level = "REGION" Then
>
> perfix = Format("00200" & numbner, "")
>
>
> End If
>
>
> If Outlet = "DRUG" And Level = "REGION" Then
>
> perfix = Format("02200" & numbner, "")
>
>
> End If
>
>
> If Outlet = "MASS" And Level = "TOTUS" Then
>
> perfix = Format("0010" & numbner, "")
>
>
> End If
>
>
> If Outlet = "CLUB" And Level = "CUSTM" Then
>
> perfix = Format("01650" & numbner, "")
>
>
> End If
>
>
> If Outlet = "FOOD" And Level = "MKT" Then
>
> perfix = Format("003000" & numbner, "")
>
>
> End If
>
>
> If Outlet = "LIQ" And Level = "CUSTM" Then
>
> perfix = Format("08100" & numbner, "")
>
> End If
>
>
>
> End Function
>
>
>
> Regards
> Amresh
>
>
>
>
> On Mon, Jul 23, 2012 at 2:57 PM, Puttu *  wrote:
>
>> This is how the output I am looking for each creteria. with the VBA code
>>
>> If len is 3 and outlet is FOOD and Level is REGION then it should reflect
>> as 00200100
>> if len is 2 and outlet is FOOD and Level is REGION then it should reflect
>> as 00200010
>> If len is 4 and outlet is FOOD and Level is REGION then it should reflect
>> as 00201000
>> If len is 1 and outlet is FOOD and Level is REGION then it should reflect
>> as 0021
>>
>>
>>  number Outlet Level OUTPUT 100 FOOD REGION 00200100 10 FOOD REGION
>> 00200010 1000 FOOD REGION 00201000 1 FOOD REGION 0021
>>
>>  On Mon, Jul 23, 2012 at 2:08 PM, Puttu *  wrote:
>>
>>> Thanks Amresh,
>>>
>>> I think this serve my purpose, but need one more thing, since are vary
>>> one cell have 2 digits no. and one have 3 digit numbers and one have 4
>>> digit numbers in the cell, finally it should be ending with 8 digit no.  Is
>>> there any way to put in code?
>>>
>>>
>>> On Mon, Jul 23, 2012 at 1:52 PM, Amresh Maurya >> > wrote:
>>>
>>>> Hi ,
>>>>
>>>> I have attached a function for you kindly add it in your add-ins and
>>>> use.
>>>>
>>>>  Function perfix(Outlet As String, Level As String, numbner As Integer)
>>>>
>>>> If Outlet = "FOOD" And Level = "REGION" Then
>>>>
>>>> perfix = "00200" & numbner
>>>>
>>>> End If
>>>>
>>>>
>>>> If Outlet = "DRUG" And Level = "REGION" Then
>>>>
>>>> perfix = "02200" & numbner
>>>>
>>>>
>>>> End If
>>>>
>>>>
>>>> If Outlet = "MASS" And Level = "TOTUS" Then
>>>>
>>>> perfix = "0010" & numbner
>>>>
>>>> End If
>>>>
>>>>
>>>> If Outlet = "CLUB" And Level = "CUSTM" Then
>>>>
>>>> perfix = "01650" & numbner
>>>>
>>>>
>>>> End If
>>>>
>>>>
>>>> If Outlet = "FOOD" And Level = "MKT" Then
>>>>
>>>> perfix = "003000" & numbner
>>>>
>>>>
>>>> End If
>>>>
>>>>
>>>> If Outlet = "LIQ" And Level = "CUSTM" Then
>>>>
>>>> perfix = "008100" & numbner
>>>>
>>>>
>>>> End If
>>>>
>>>>
>>>>
>>>> End Function
>>>>
>>>>
>>>> Regards
>>>> Amresh
>>>>
>>>>
>>>> On Mon, Jul 23, 2012 at 1:18 PM, Puttu *  wrote:
>>>>
>>>>> Thanks Amresh, I need to run this multiple sheets, can i have this in
>>>>> macro. Which is going to help me a lot.
>>>>>
>>>>> Appreciate your help
>>>>>
>>>>>
>>>>> O

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

This is how the output I am looking for each creteria. with the VBA code

If len is 3 and outlet is FOOD and Level is REGION then it should reflect
as 00200100
if len is 2 and outlet is FOOD and Level is REGION then it should reflect
as 00200010
If len is 4 and outlet is FOOD and Level is REGION then it should reflect
as 00201000
If len is 1 and outlet is FOOD and Level is REGION then it should reflect
as 0021


 number Outlet Level OUTPUT 100 FOOD REGION 00200100 10 FOOD REGION
00200010 1000 FOOD REGION 00201000 1 FOOD REGION 0021

On Mon, Jul 23, 2012 at 2:08 PM, Puttu *  wrote:

> Thanks Amresh,
>
> I think this serve my purpose, but need one more thing, since are vary one
> cell have 2 digits no. and one have 3 digit numbers and one have 4 digit
> numbers in the cell, finally it should be ending with 8 digit no.  Is there
> any way to put in code?
>
>
> On Mon, Jul 23, 2012 at 1:52 PM, Amresh Maurya 
> wrote:
>
>> Hi ,
>>
>> I have attached a function for you kindly add it in your add-ins and use.
>>
>>  Function perfix(Outlet As String, Level As String, numbner As Integer)
>>
>> If Outlet = "FOOD" And Level = "REGION" Then
>>
>> perfix = "00200" & numbner
>>
>> End If
>>
>>
>> If Outlet = "DRUG" And Level = "REGION" Then
>>
>> perfix = "02200" & numbner
>>
>>
>> End If
>>
>>
>> If Outlet = "MASS" And Level = "TOTUS" Then
>>
>> perfix = "0010" & numbner
>>
>> End If
>>
>>
>> If Outlet = "CLUB" And Level = "CUSTM" Then
>>
>> perfix = "01650" & numbner
>>
>>
>> End If
>>
>>
>> If Outlet = "FOOD" And Level = "MKT" Then
>>
>> perfix = "003000" & numbner
>>
>>
>> End If
>>
>>
>> If Outlet = "LIQ" And Level = "CUSTM" Then
>>
>> perfix = "008100" & numbner
>>
>>
>> End If
>>
>>
>>
>> End Function
>>
>>
>> Regards
>> Amresh
>>
>>
>> On Mon, Jul 23, 2012 at 1:18 PM, Puttu *  wrote:
>>
>>> Thanks Amresh, I need to run this multiple sheets, can i have this in
>>> macro. Which is going to help me a lot.
>>>
>>> Appreciate your help
>>>
>>>
>>> On Mon, Jul 23, 2012 at 1:10 PM, Amresh Maurya >> > wrote:
>>>
>>>> Hi,
>>>> Kindly find the attached solutions.
>>>>
>>>> Regards
>>>> Amresh
>>>>
>>>>
>>>> On Mon, Jul 23, 2012 at 12:40 PM, Puttu *  wrote:
>>>>
>>>>> Experts please help me on this code.
>>>>>
>>>>> On Sat, Jul 21, 2012 at 7:15 PM, Puttu *  wrote:
>>>>>
>>>>>> Hi Experts,
>>>>>>
>>>>>> Please help on below macro need a macro to prefix on the below
>>>>>> numbers. I just took one one example for refeence, but i have huge no. 
>>>>>> like
>>>>>> this. Your help is much appreciated
>>>>>>
>>>>>>  *Number* *Outlet* *Level* *Code should some thing like this* *This
>>>>>> is how I am looking for output* 100 FOOD REGION If Outlet is "Food"
>>>>>> & Level is "Region, then Number should prefix  00200 00200100 150
>>>>>> DRUG REGION If Outlet is "DRUG" & Level is "Region, then Number
>>>>>> should prefix  02200 02200150  MASS TOTUS If Outlet is "MASS" &
>>>>>> Level is "TOTUS, then Number should prefix  0010 0010 300 CLUB
>>>>>> CUSTM If Outlet is "CLUB" & Level is "CUSTM, then Number should
>>>>>> prefix  01650 01650300 14 FOOD MKT If Outlet is "FOOD" & Level is
>>>>>> "MKT, then Number should prefix  003000 00300014 400 LIQ CUSTM If
>>>>>> Outlet is "LIQ" & Level is "CUSTM, then Number should prefix  008100
>>>>>> 08150400
>>>>>>
>>>>>> --
>>>>>> Putta
>>>>>>
>>>>>> --
>>>>>> --
>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urg

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Thanks Amresh,

I think this serve my purpose, but need one more thing, since are vary one
cell have 2 digits no. and one have 3 digit numbers and one have 4 digit
numbers in the cell, finally it should be ending with 8 digit no.  Is there
any way to put in code?

On Mon, Jul 23, 2012 at 1:52 PM, Amresh Maurya wrote:

> Hi ,
>
> I have attached a function for you kindly add it in your add-ins and use.
>
> Function perfix(Outlet As String, Level As String, numbner As Integer)
>
> If Outlet = "FOOD" And Level = "REGION" Then
>
> perfix = "00200" & numbner
>
> End If
>
>
> If Outlet = "DRUG" And Level = "REGION" Then
>
> perfix = "02200" & numbner
>
>
> End If
>
>
> If Outlet = "MASS" And Level = "TOTUS" Then
>
> perfix = "0010" & numbner
>
> End If
>
>
> If Outlet = "CLUB" And Level = "CUSTM" Then
>
> perfix = "01650" & numbner
>
>
> End If
>
>
> If Outlet = "FOOD" And Level = "MKT" Then
>
> perfix = "003000" & numbner
>
>
> End If
>
>
> If Outlet = "LIQ" And Level = "CUSTM" Then
>
> perfix = "008100" & numbner
>
>
> End If
>
>
>
> End Function
>
>
> Regards
> Amresh
>
>
> On Mon, Jul 23, 2012 at 1:18 PM, Puttu *  wrote:
>
>> Thanks Amresh, I need to run this multiple sheets, can i have this in
>> macro. Which is going to help me a lot.
>>
>> Appreciate your help
>>
>>
>> On Mon, Jul 23, 2012 at 1:10 PM, Amresh Maurya 
>> wrote:
>>
>>> Hi,
>>> Kindly find the attached solutions.
>>>
>>> Regards
>>> Amresh
>>>
>>>
>>> On Mon, Jul 23, 2012 at 12:40 PM, Puttu *  wrote:
>>>
>>>> Experts please help me on this code.
>>>>
>>>> On Sat, Jul 21, 2012 at 7:15 PM, Puttu *  wrote:
>>>>
>>>>> Hi Experts,
>>>>>
>>>>> Please help on below macro need a macro to prefix on the below
>>>>> numbers. I just took one one example for refeence, but i have huge no. 
>>>>> like
>>>>> this. Your help is much appreciated
>>>>>
>>>>>   *Number* *Outlet* *Level* *Code should some thing like this* *This
>>>>> is how I am looking for output*  100 FOOD REGION If Outlet is "Food"
>>>>> & Level is "Region, then Number should prefix  00200 00200100 150 DRUG
>>>>> REGION If Outlet is "DRUG" & Level is "Region, then Number should
>>>>> prefix  02200 02200150  MASS TOTUS If Outlet is "MASS" & Level is
>>>>> "TOTUS, then Number should prefix  0010 0010 300 CLUB CUSTM If
>>>>> Outlet is "CLUB" & Level is "CUSTM, then Number should prefix  01650
>>>>> 01650300 14 FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number
>>>>> should prefix  003000 00300014 400 LIQ CUSTM If Outlet is "LIQ" &
>>>>> Level is "CUSTM, then Number should prefix  008100 08150400
>>>>>
>>>>> --
>>>>> Putta
>>>>>
>>>>> --
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> --
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Thanks Amresh, I need to run this multiple sheets, can i have this in
macro. Which is going to help me a lot.

Appreciate your help

On Mon, Jul 23, 2012 at 1:10 PM, Amresh Maurya wrote:

> Hi,
> Kindly find the attached solutions.
>
> Regards
> Amresh
>
>
> On Mon, Jul 23, 2012 at 12:40 PM, Puttu *  wrote:
>
>> Experts please help me on this code.
>>
>> On Sat, Jul 21, 2012 at 7:15 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> Please help on below macro need a macro to prefix on the below numbers.
>>> I just took one one example for refeence, but i have huge no. like this.
>>> Your help is much appreciated
>>>
>>>   *Number* *Outlet* *Level* *Code should some thing like this* *This
>>> is how I am looking for output*  100 FOOD REGION If Outlet is "Food" &
>>> Level is "Region, then Number should prefix  00200 00200100 150 DRUG
>>> REGION If Outlet is "DRUG" & Level is "Region, then Number should prefix
>>> 02200 02200150  MASS TOTUS If Outlet is "MASS" & Level is "TOTUS,
>>> then Number should prefix  0010 0010 300 CLUB CUSTM If Outlet is
>>> "CLUB" & Level is "CUSTM, then Number should prefix  01650 01650300 14
>>> FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number should prefix
>>> 003000 00300014 400 LIQ CUSTM If Outlet is "LIQ" & Level is "CUSTM,
>>> then Number should prefix  008100 08150400
>>>
>>> --
>>> Putta
>>>
>>> --
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don&#x

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Experts please help me on this code.

On Sat, Jul 21, 2012 at 7:15 PM, Puttu *  wrote:

> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
>   *Number* *Outlet* *Level* *Code should some thing like this* *This
> is how I am looking for output*  100 FOOD REGION If Outlet is "Food" &
> Level is "Region, then Number should prefix  00200 00200100 150 DRUG
> REGION If Outlet is "DRUG" & Level is "Region, then Number should prefix
> 02200 02200150  MASS TOTUS If Outlet is "MASS" & Level is "TOTUS,
> then Number should prefix  0010 0010 300 CLUB CUSTM If Outlet is
> "CLUB" & Level is "CUSTM, then Number should prefix  01650 01650300 14
> FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number should prefix
> 003000 00300014 400 LIQ CUSTM If Outlet is "LIQ" & Level is "CUSTM, then
> Number should prefix  008100 08150400
>
> --
> Putta
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Putta

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Any update on the below help?

On Sat, Jul 21, 2012 at 7:15 PM, Puttu *  wrote:

> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
>  *Number* *Outlet* *Level* *Code should some thing like this* *This
> is how I am looking for output* 100 FOOD REGION If Outlet is "Food" &
> Level is "Region, then Number should prefix  00200 00200100 150 DRUG
> REGION If Outlet is "DRUG" & Level is "Region, then Number should prefix
> 02200 02200150  MASS TOTUS If Outlet is "MASS" & Level is "TOTUS,
> then Number should prefix  0010 0010 300 CLUB CUSTM If Outlet is
> "CLUB" & Level is "CUSTM, then Number should prefix  01650 01650300 14
> FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number should prefix
> 003000 00300014 400 LIQ CUSTM If Outlet is "LIQ" & Level is "CUSTM, then
> Number should prefix  008100 08150400
>
> --
> Putta
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Putta

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Please help me on this experts

On Sat, Jul 21, 2012 at 7:15 PM, Puttu *  wrote:

> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
>   *Number* *Outlet* *Level* *Code should some thing like this* *This
> is how I am looking for output*  100 FOOD REGION If Outlet is "Food" &
> Level is "Region, then Number should prefix  00200 00200100 150 DRUG
> REGION If Outlet is "DRUG" & Level is "Region, then Number should prefix
> 02200 02200150  MASS TOTUS If Outlet is "MASS" & Level is "TOTUS,
> then Number should prefix  0010 0010 300 CLUB CUSTM If Outlet is
> "CLUB" & Level is "CUSTM, then Number should prefix  01650 01650300 14
> FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number should prefix
> 003000 00300014 400 LIQ CUSTM If Outlet is "LIQ" & Level is "CUSTM, then
> Number should prefix  008100 08150400
>
> --
> Putta
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Putta

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Thanks Don, but i need a macro for this, because i have too many sheets in
the same format. Macro will help me a lot to save my time

On Sat, Jul 21, 2012 at 9:53 PM, dguillett1  wrote:

>   Modify to suit
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Puttu * 
> *Sent:* Saturday, July 21, 2012 8:45 AM
> *To:* MS EXCEL AND VBA MACROS 
> *Subject:* $$Excel-Macros$$ Required Prefix Macro for the numbers
>
>  Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
>  *Number* *Outlet* *Level* *Code should some thing like this* *This
> is how I am looking for output* 100 FOOD REGION If Outlet is "Food" &
> Level is "Region, then Number should prefix  00200 00200100 150 DRUG
> REGION If Outlet is "DRUG" & Level is "Region, then Number should prefix
> 02200 02200150  MASS TOTUS If Outlet is "MASS" & Level is "TOTUS,
> then Number should prefix  0010 0010 300 CLUB CUSTM If Outlet is
> "CLUB" & Level is "CUSTM, then Number should prefix  01650 01650300 14
> FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number should prefix
> 003000 00300014 400 LIQ CUSTM If Outlet is "LIQ" & Level is "CUSTM, then
> Number should prefix  008100 08150400
>
> --
> Putta
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Putta

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Required Prefix Macro for the numbers

[Puttu *]

Hi Experts,

Please help on below macro need a macro to prefix on the below numbers. I
just took one one example for refeence, but i have huge no. like this. Your
help is much appreciated

 *Number* *Outlet* *Level* *Code should some thing like this* *This is
how I am looking for output* 100 FOOD REGION If Outlet is "Food" & Level is
"Region, then Number should prefix  00200 00200100 150 DRUG REGION If
Outlet is "DRUG" & Level is "Region, then Number should prefix  02200
02200150  MASS TOTUS If Outlet is "MASS" & Level is "TOTUS, then Number
should prefix  0010 0010 300 CLUB CUSTM If Outlet is "CLUB" & Level is
"CUSTM, then Number should prefix  01650 01650300 14 FOOD MKT If Outlet is
"FOOD" & Level is "MKT, then Number should prefix  003000 00300014 400 LIQ
CUSTM If Outlet is "LIQ" & Level is "CUSTM, then Number should prefix
008100 08150400

-- 
Putta

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Required Prefix Macro for numbers.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Automatic Email from Excel

[Puttu *]

Hey Vish,

Could you please send code for me the details in attahed excel sheet

I am looking automated mail to be sent by excel to outlook by using the
excel defined time and date

1st - Subject --> Column A is Subject " What user defined
2nd - Date & Time -> Column B is Date and time " What is user defined in
excel
3rd Emails Ids --> Column C is contain email ids which mail should go again
this also user defined.



On Fri, Jun 29, 2012 at 11:34 AM, Vish  wrote:

> Hi Hemanth,
>
> Code given by Noorian and Lalit will work to send email on that given date.
>
> For that you need to open that excel file manually and trigger the code
> manually then only the mail will be sent.
> To make this process also automatic follow the below process:
>
> 1. Add a Module in your workbook
> 2. Paste the Noorian Code in Sub Auto_Open  ... End Sub
> 3. Save the workbook
> 4. Attached is a VBS file (which has the file name. Replace it with the
> complete path of the excel where you have saved above file)
> 5. Now schedule this VBS file in your system for daily on a certain time,
> when you know that your system will be Switched on.
>
> It will automatically open your excel workbook and send email.
>
> If you need help on Scheduling the VBS file in windows let me know.
>
> Thanks,
> Vish
> http://www.learnexcelmacro.com
>
> Thanks,
> Vish
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

[Puttu *]

most of the timings set only 8 hours window. It will create any unnecessary
problem

It would be great some one come with macro work on this.

On Thu, Jun 7, 2012 at 3:07 AM, netuser1110  wrote:

> Leaving Outlook + high speed Internet connection open 24/24, you put
> yourself at risk sending Buy Viagra spams or any other less or more serious
> risks!
>
>
> On Wednesday, June 6, 2012 11:48:03 AM UTC+1, bpascal123 wrote:
>>
>> I'm trying to figure out something related to Vba instead of a new
>> scripting language.
>>
>> I'm thinking about running a Vba script from Outlook. Outlook will open
>> the workbook and pick the time from there and set itself to send emails...
>> or better each time the workbook is updated (I broadly understand 3 emails
>> may be sent upon the status of the complete or work-in-progresss...), it
>> would call outlook so outlook picks up the time to send email and set
>> himself a schedule send email task.
>>
>> That is a lot of Outlook Vba object model.
>>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Experts,

Can you have look on my requirements and provide the solution.

On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:

> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
>  Need a macro based on the given date and time in 1st, 2nd & Final
> reminder columns to all the email ID  Subject mail should be content of
> cell text in the column B  This Task list shouldn't be limited to only
> for row 6 it should be never ending (B:B)  If Any Case column F status
> changed to Completed, after the 1st or 2 or Final Reminder, then there
> would be no more reminder mails
> Please help me on this. Appreciated all you support
>
> --
> Putta
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Can some one looking into details and provide me help.

On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:

> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
>  Need a macro based on the given date and time in 1st, 2nd & Final
> reminder columns to all the email ID  Subject mail should be content of
> cell text in the column B  This Task list shouldn't be limited to only
> for row 6 it should be never ending (B:B)  If Any Case column F status
> changed to Completed, after the 1st or 2 or Final Reminder, then there
> would be no more reminder mails
> Please help me on this. Appreciated all you support
>
> --
> Putta
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Hi Jeetendra,

Appreciate your efforts putting here, but my requirements are little
different, which will not serve the purpose from your macro. Thanks for
your help

On Mon, Jun 4, 2012 at 5:06 PM, Jitendra singh  wrote:

>
>
> Option Explicit
>
>
>
> Function RangetoHTML(rng As Range)
>
> ' Changed by Ron de Bruin 28-Oct-2006
>
> ' Working in Office 2000-2010
>
> Dim fso As Object
>
> Dim ts As Object
>
> Dim TempFile As String
>
> Dim TempWB As Workbook
>
>
>
> TempFile = Environ$("temp") & "\" & Format(Now, "dd-mm-yy h-mm-ss") &
> ".htm"
>
>
>
> 'Copy the range and create a new workbook to past the data in
>
> rng.Copy
>
> Set TempWB = Workbooks.Add(1)
>
> With TempWB.Sheets(1)
>
> .Cells(1).PasteSpecial Paste:=8
>
> .Cells(1).PasteSpecial xlPasteValues, , False, False
>
> .Cells(1).PasteSpecial xlPasteFormats, , False, False
>
> .Cells(1).Select
>
> Application.CutCopyMode = False
>
> On Error Resume Next
>
> .DrawingObjects.Visible = True
>
> .DrawingObjects.Delete
>
> On Error GoTo 0
>
> End With
>
>
>
> 'Publish the sheet to a htm file
>
> With TempWB.PublishObjects.Add( _
>
>  SourceType:=xlSourceRange, _
>
>  Filename:=TempFile, _
>
>  Sheet:=TempWB.Sheets(1).Name, _
>
>  Source:=TempWB.Sheets(1).UsedRange.Address, _
>
>  HtmlType:=xlHtmlStatic)
>
> .Publish (True)
>
> End With
>
>
>
> 'Read all data from the htm file into RangetoHTML
>
> Set fso = CreateObject("Scripting.FileSystemObject")
>
> Set ts = fso.GetFile(TempFile).OpenAsTextStream(1, -2)
>
> RangetoHTML = ts.readall
>
> ts.Close
>
> RangetoHTML = Replace(RangetoHTML, "align=center x:publishsource=", _
>
>   "align=left x:publishsource=")
>
>
>
> 'Close TempWB
>
> TempWB.Close savechanges:=False
>
>
>
> 'Delete the htm file we used in this function
>
> Kill TempFile
>
>
>
> Set ts = Nothing
>
> Set fso = Nothing
>
> Set TempWB = Nothing
>
> End Function
>
>
>
>
>
> Function GetBoiler(ByVal sFile As String) As String
>
> 'Dick Kusleika
>
> Dim fso As Object
>
> Dim ts As Object
>
> Set fso = CreateObject("Scripting.FileSystemObject")
>
> Set ts = fso.GetFile(sFile).OpenAsTextStream(1, -2)
>
> GetBoiler = ts.readall
>
> ts.Close
>
> End Function
>
>
>
> Option Explicit
>
>
>
> Sub Send_Row()
>
> ' Don't forget to copy the function RangetoHTML in the module.
>
> ' Working in Office 2000-2010
>
> Dim OutApp As Object
>
> Dim OutMail As Object
>
> Dim cell As Range
>
> Dim rng As Range
>
> Dim Ash As Worksheet
>
>
>
> Set Ash = ActiveSheet
>
> On Error GoTo cleanup
>
> Set OutApp = CreateObject("Outlook.Application")
>
>
>
> With Application
>
> .EnableEvents = False
>
> .ScreenUpdating = False
>
> End With
>
>
>
> For Each cell In
> Ash.Columns("B").Cells.SpecialCells(xlCellTypeConstants)
>
> If cell.Value Like "?*@?*.?*" And LCase(cell.Offset(0, 1).Value)
> = "yes" Then
>
>
>
> Ash.Range("A1:O100").AutoFilter Field:=2, Criteria1:=cell.Value
>
>
>
> With Ash.AutoFilter.Range
>
> On Error Resume Next
>
> Set rng = .SpecialCells(xlCellTypeVisible)
>
> On Error GoTo 0
>
> End With
>
>
>
> Set OutMail = OutApp.CreateItem(0)
>
>
>
>     On Error Resume Next
>
> With OutMail
>
> .To = cell.Value
>
>     .Subject = " Month Target vs Achievement"
>
> .HTMLBody = RangetoHTML(rng)
>
> .Display  'Or use Send
>
> End With
>
> On Error GoTo 0
>
>
>
> Set OutMail = Nothing
>
>     Ash.AutoFilterMode = False
>
> End If
>
> Next cell
>
>
>
> cleanup:
>
> Set OutApp = Nothing
>
> With Application
>
> .EnableEvents = True
>
> .ScreenUpdating = True
>

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Hi Rajan,

The date will most of the time current or future date.

On Mon, Jun 4, 2012 at 6:11 PM, Rajan_Verma wrote:

> When you want to send the mail?
>
> I mean when you will the date ? 
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Puttu *
> *Sent:* 04 June 2012 12:19
> *To:* MS EXCEL AND VBA MACROS
> *Subject:* $$Excel-Macros$$ Need a Email Macro based on the Cell time
>
> ** **
>
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
> 
>
> Need a macro based on the given date and time in 1st, 2nd & Final reminder
> columns to all the email ID
>
> Subject mail should be content of cell text in the column B
>
> This Task list shouldn't be limited to only for row 6 it should be never
> ending (B:B)
>
> If Any Case column F status changed to Completed, after the 1st or 2 or
> Final Reminder, then there would be no more reminder mails
>
>
> Please help me on this. Appreciated all you support
>
> --
> Putta
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Experts,

Could you please please help on the below request.

On Mon, Jun 4, 2012 at 2:00 PM, Puttu *  wrote:

> below is the required details for your reference once again.
>
>   Sr. No. Task (Subject Name) First Reminder Date & Time Second
> Reminder Date & Time Final Reminder Date & Time Status Email Group 1 Status
> Mail 6/4/12 17:00 6/5/12 20:00 6/6/12 22:00 Inprogress  puttu...@gmail.com
> puttu_...@yahoo.co.in  2 QC 6/5/12 17:00 6/5/12 17:00 
> 6/6/12
> 22:00 Completed puttu...@gmail.com
> puttu_...@yahoo.co.in  3 Buddy Check 6/6/12 18:00 6/6/12
> 18:00 6/6/12 22:00 Completed puttu...@gmail.com
> puttu_...@yahoo.co.in  4 Release 6/7/12 17:00 6/7/12
> 5:00 6/6/12 22:00 Inprogress  puttu...@gmail.com
> puttu_...@yahoo.co.in  5 Confirmation Mail 6/8/12
> 17:00 6/8/12 5:00 6/8/12 22:00 Completed puttu...@gmail.com
> puttu_...@yahoo.co.in 
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Need a macro based on the given date and time in 1st, 2nd & Final reminder
> columns to all the email ID
>
>
> Subject mail should be content of cell text in the column B
>
>
> This Task list shouldn't be limited to only for row 6 it should be never
> ending (B:B)
>
>
> If Any Case column F status changed to Completed, after the 1st or 2 or
> Final Remider, then there would be no more reminder mails
>
>
>
>
>
>
>
>
>
> On Mon, Jun 4, 2012 at 1:44 PM, Puttu *  wrote:
>
>> Hello Experts,
>>
>> Any update on the below macro? Your help is much appreciated. Thanks
>>
>>
>> On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:
>>
>>> Hi Excel Experts,
>>>
>>> Need a help on the macro for automated email reminders. below is the
>>> requirements. Attached is sheet for your reference
>>>
>>>
>>>Need a macro based on the given date and time in 1st, 2nd & Final
>>> reminder columns to all the email ID Subject mail should be content of
>>> cell text in the column B This Task list shouldn't be limited to only
>>> for row 6 it should be never ending (B:B) If Any Case column F status
>>> changed to Completed, after the 1st or 2 or Final Reminder, then there
>>> would be no more reminder mails
>>> Please help me on this. Appreciated all you support
>>>
>>> --
>>> Putta
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

below is the required details for your reference once again.

Sr. No. Task (Subject Name) First Reminder Date & Time Second Reminder
Date & Time Final Reminder Date & Time Status Email Group  1 Status Mail 6/4/12
17:00 6/5/12 20:00 6/6/12 22:00 Inprogress  puttu...@gmail.com
puttu_...@yahoo.co.in   2 QC 6/5/12 17:00 6/5/12
17:00 6/6/12
22:00 Completed puttu...@gmail.com
puttu_...@yahoo.co.in   3 Buddy Check 6/6/12 18:00 6/6/12
18:00 6/6/12 22:00 Completed puttu...@gmail.com
puttu_...@yahoo.co.in   4 Release 6/7/12 17:00 6/7/12
5:00 6/6/12 22:00 Inprogress  puttu...@gmail.com
puttu_...@yahoo.co.in   5 Confirmation Mail 6/8/12
17:00 6/8/12
5:00 6/8/12 22:00 Completed puttu...@gmail.com
puttu_...@yahoo.co.in 














Need a macro based on the given date and time in 1st, 2nd & Final reminder
columns to all the email ID


Subject mail should be content of cell text in the column B


This Task list shouldn't be limited to only for row 6 it should be never
ending (B:B)


If Any Case column F status changed to Completed, after the 1st or 2 or
Final Remider, then there would be no more reminder mails









On Mon, Jun 4, 2012 at 1:44 PM, Puttu *  wrote:

> Hello Experts,
>
> Any update on the below macro? Your help is much appreciated. Thanks
>
>
> On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:
>
>> Hi Excel Experts,
>>
>> Need a help on the macro for automated email reminders. below is the
>> requirements. Attached is sheet for your reference
>>
>>
>>  Need a macro based on the given date and time in 1st, 2nd & Final
>> reminder columns to all the email ID  Subject mail should be content of
>> cell text in the column B  This Task list shouldn't be limited to only
>> for row 6 it should be never ending (B:B)  If Any Case column F status
>> changed to Completed, after the 1st or 2 or Final Reminder, then there
>> would be no more reminder mails
>> Please help me on this. Appreciated all you support
>>
>> --
>> Putta
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Hello Experts,

Any update on the below macro? Your help is much appreciated. Thanks

On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:

> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
>  Need a macro based on the given date and time in 1st, 2nd & Final
> reminder columns to all the email ID  Subject mail should be content of
> cell text in the column B  This Task list shouldn't be limited to only
> for row 6 it should be never ending (B:B)  If Any Case column F status
> changed to Completed, after the 1st or 2 or Final Reminder, then there
> would be no more reminder mails
> Please help me on this. Appreciated all you support
>
> --
> Putta
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Need a Email Macro based on the Cell time

[Puttu *]

Hi Excel Experts,

Need a help on the macro for automated email reminders. below is the
requirements. Attached is sheet for your reference


 Need a macro based on the given date and time in 1st, 2nd & Final reminder
columns to all the email ID  Subject mail should be content of cell text in
the column B  This Task list shouldn't be limited to only for row 6 it
should be never ending (B:B)  If Any Case column F status changed to
Completed, after the 1st or 2 or Final Reminder, then there would be no
more reminder mails
Please help me on this. Appreciated all you support

-- 
Putta

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Email-Macro based on cell timings.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

[Puttu]

Hi Experts,

I want to learn excel, VBA in bangalore, I have basic knowledge in
both. Please advise any complete training institues where I can learn
and became master on this courses.

Also let me know how do I get MIS certified?? Do we have any online
video training for Excel and VBA & MIS which is worth full. If yes let
me know the website details.

Any help will be much appreciated.

Thanks
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

Can you please please help any one

On Fri, Apr 1, 2011 at 5:40 PM, Puttu *  wrote:

> sorry again, please hep me in the formula
>
>
> On Fri, Apr 1, 2011 at 5:12 PM, Puttu *  wrote:
>
>> awaiting for your replay please.
>>
>>
>> On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:
>>
>>> Experts please help me on this it's bit urgent sorry to bother.
>>>
>>>
>>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>>>
>>>> Hi Experts,
>>>>
>>>> I have list of items which have not full codes. I need them to convert
>>>> full code. Could you please help me.
>>>>
>>>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>>>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>>>> get that output. Item Full Code output column has the correct answers
>>>> which I manually entered. I want the same way answer using the formulas
>>>>
>>>>
>>>> Item Full Code output
>>>>
>>>> Give the formula for output
>>>>
>>>> Item Code
>>>>
>>>> 200990
>>>>
>>>>  990
>>>>
>>>> 200991
>>>>
>>>>  991
>>>>
>>>>300011
>>>>
>>>>  11
>>>>
>>>> 300014
>>>>
>>>>  14
>>>>
>>>> 300104
>>>>
>>>>  104
>>>>
>>>>520901
>>>>
>>>>  20901
>>>>
>>>> 520902
>>>>
>>>>  20902
>>>>
>>>> 500450
>>>>
>>>>  450
>>>>
>>>> 500451
>>>>
>>>>  451
>>>>
>>>>203529
>>>>
>>>>  3529
>>>>
>>>> 203538
>>>>
>>>>  3538
>>>>
>>>>8515959
>>>>
>>>>  15959
>>>>
>>>> 8516271
>>>>
>>>>  16271
>>>>
>>>>8203892
>>>>
>>>>  3892
>>>>
>>>> 8203893
>>>>
>>>>  3893
>>>>
>>>>1620224
>>>>
>>>>  224
>>>>
>>>> 1620225
>>>>
>>>>  225
>>>>
>>>>
>>>> --
>>>> Putta
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

sorry again, please hep me in the formula

On Fri, Apr 1, 2011 at 5:12 PM, Puttu *  wrote:

> awaiting for your replay please.
>
>
> On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:
>
>> Experts please help me on this it's bit urgent sorry to bother.
>>
>>
>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I have list of items which have not full codes. I need them to convert
>>> full code. Could you please help me.
>>>
>>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>>> get that output. Item Full Code output column has the correct answers
>>> which I manually entered. I want the same way answer using the formulas
>>>
>>>
>>> Item Full Code output
>>>
>>> Give the formula for output
>>>
>>> Item Code
>>>
>>> 200990
>>>
>>>  990
>>>
>>> 200991
>>>
>>>  991
>>>
>>>300011
>>>
>>>  11
>>>
>>> 300014
>>>
>>>  14
>>>
>>> 300104
>>>
>>>  104
>>>
>>>520901
>>>
>>>  20901
>>>
>>> 520902
>>>
>>>  20902
>>>
>>> 500450
>>>
>>>  450
>>>
>>> 500451
>>>
>>>  451
>>>
>>>203529
>>>
>>>  3529
>>>
>>> 203538
>>>
>>>  3538
>>>
>>>8515959
>>>
>>>  15959
>>>
>>> 8516271
>>>
>>>  16271
>>>
>>>8203892
>>>
>>>  3892
>>>
>>> 8203893
>>>
>>>  3893
>>>
>>>1620224
>>>
>>>  224
>>>
>>> 1620225
>>>
>>>  225
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

awaiting for your replay please.

On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:

> Experts please help me on this it's bit urgent sorry to bother.
>
>
> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I have list of items which have not full codes. I need them to convert
>> full code. Could you please help me.
>>
>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>> get that output. Item Full Code output column has the correct answers
>> which I manually entered. I want the same way answer using the formulas
>>
>>
>> Item Full Code output
>>
>> Give the formula for output
>>
>> Item Code
>>
>> 200990
>>
>>  990
>>
>> 200991
>>
>>  991
>>
>>300011
>>
>>  11
>>
>> 300014
>>
>>  14
>>
>> 300104
>>
>>  104
>>
>>520901
>>
>>  20901
>>
>> 520902
>>
>>  20902
>>
>> 500450
>>
>>  450
>>
>> 500451
>>
>>  451
>>
>>203529
>>
>>  3529
>>
>> 203538
>>
>>  3538
>>
>>8515959
>>
>>  15959
>>
>> 8516271
>>
>>  16271
>>
>>8203892
>>
>>  3892
>>
>> 8203893
>>
>>  3893
>>
>>1620224
>>
>>  224
>>
>> 1620225
>>
>>  225
>>
>>
>> --
>> Putta
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

Experts please help me on this it's bit urgent sorry to bother.

On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:

> Hi Experts,
>
> I have list of items which have not full codes. I need them to convert full
> code. Could you please help me.
>
> Item code column has either 3, 2, 4 & 5 digits no. but by default they
> should be either 6 or 7 or 8 digits code. What best formul I need to use to
> get that output. Item Full Code output column has the correct answers
> which I manually entered. I want the same way answer using the formulas
>
>
> Item Full Code output
>
> Give the formula for output
>
> Item Code
>
> 200990
>
>  990
>
> 200991
>
>  991
>
>300011
>
>  11
>
> 300014
>
>  14
>
> 300104
>
>  104
>
>520901
>
>  20901
>
> 520902
>
>  20902
>
> 500450
>
>  450
>
> 500451
>
>  451
>
>203529
>
>  3529
>
> 203538
>
>  3538
>
>8515959
>
>  15959
>
> 8516271
>
>  16271
>
>8203892
>
>  3892
>
> 8203893
>
>  3893
>
>1620224
>
>  224
>
> 1620225
>
>  225
>
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

Hi Experts,

I have list of items which have not full codes. I need them to convert full
code. Could you please help me.

Item code column has either 3, 2, 4 & 5 digits no. but by default they
should be either 6 or 7 or 8 digits code. What best formul I need to use to
get that output. Item Full Code output column has the correct answers
which I manually entered. I want the same way answer using the formulas


Item Full Code output

Give the formula for output

Item Code

200990

 990

200991

 991

   300011

 11

300014

 14

300104

 104

   520901

 20901

520902

 20902

500450

 450

500451

 451

   203529

 3529

203538

 3538

   8515959

 15959

8516271

 16271

   8203892

 3892

8203893

 3893

   1620224

 224

1620225

 225


-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

[Puttu *]

Thanks a lot it worked out me. Cold you please help on my second question
in Attached is the sheet

On Fri, Feb 25, 2011 at 5:42 PM, Vikas Chouhan  wrote:

> Hi Puttu,
>
>
> if you are using Excel 2007 then
>
> use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "),"")
>
> AND 2003 then
>
> =ISERROR((IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "),"",(IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "))
>
>
>
>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I have two questions
>>
>> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
>> this if any error it shows as #N/A, insted of this i want it show as balnk,
>> how to do this?
>>
>> 2. In Vlookup formula if the result is found in different excel, i want
>> that sheet name to be visibled in the result
>>
>> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
>> Sheet 1
>> Your help will be greatly appriciated.
>> --
>> Putta
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> *Vikas Chauhan*
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_*ccess *without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Vlookup_SOLVED_ROHAN.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

[Puttu *]

Attached is the question with attachment. Please help me out

On Fri, Feb 25, 2011 at 5:22 PM, Puttu *  wrote:

> No Still not working
>
>
> 2678
>
>  YES
>
> This is fine
>
> 2558
>
>  #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
> 
>
>  #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
>
>   On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young wrote:
>
>> Hi Puttu,
>>
>> it is working well see the attachment, r u sure you are putting right
>> criteria in your data, pls. send the sample sheet for understanding,
>>
>> Thanks & Regd
>>
>> ROHAN
>>
>>
>> On Thu, Feb 24, 2011 at 8:16 PM, Puttu *  wrote:
>>
>>> Team, Please help me on this
>>>
>>>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>>>
>>>> Hi Experts,
>>>>
>>>> I have two questions
>>>>
>>>> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
>>>> this if any error it shows as #N/A, insted of this i want it show as balnk,
>>>> how to do this?
>>>>
>>>> 2. In Vlookup formula if the result is found in different excel, i want
>>>> that sheet name to be visibled in the result
>>>>
>>>> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
>>>> Sheet 1
>>>> Your help will be greatly appriciated.
>>>> --
>>>> Putta
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>   --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Vlookup_SOLVED_ROHAN.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

[Puttu *]

No Still not working


2678

 YES

This is fine

2558

 #N/A

This one I want as blank (if the data doesn't match then it should show
blank cell)



 #N/A

This one I want as blank (if the data doesn't match then it should show
blank cell)


On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young  wrote:

> Hi Puttu,
>
> it is working well see the attachment, r u sure you are putting right
> criteria in your data, pls. send the sample sheet for understanding,
>
> Thanks & Regd
>
> ROHAN
>
>
> On Thu, Feb 24, 2011 at 8:16 PM, Puttu *  wrote:
>
>> Team, Please help me on this
>>
>>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I have two questions
>>>
>>> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
>>> this if any error it shows as #N/A, insted of this i want it show as balnk,
>>> how to do this?
>>>
>>> 2. In Vlookup formula if the result is found in different excel, i want
>>> that sheet name to be visibled in the result
>>>
>>> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
>>> Sheet 1
>>> Your help will be greatly appriciated.
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>   --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

[Puttu *]

Team, Please help me on this

On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:

> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it show as balnk, how
> to do this?
>
> 2. In Vlookup formula if the result is found in different excel, i want
> that sheet name to be visibled in the result
>
> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
> Sheet 1
> Your help will be greatly appriciated.
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Very Urgent Help required in Excel formula

[Puttu *]

Hi Experts,

I have two questions

1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
if any error it shows as #N/A, insted of this i want it show as balnk, how
to do this?

2. In Vlookup formula if the result is found in different excel, i want that
sheet name to be visibled in the result

XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
Sheet 1
Your help will be greatly appriciated.
-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Looking for VBA Training

[Puttu *]

Any body have any suggetion

On Wed, Feb 2, 2011 at 9:30 AM, Puttu *  wrote:

> Hi Experts,
>
> Required your advise on VBA training, I am looking for VBA best training in
> Basavanagude or Gandhibazr Bangalore. Could any body have any good training
> institute please provide me the address or phone no. to contact.
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Looking for VBA Training

[Puttu *]

Your suggetion is much appriciateable

On Wed, Feb 2, 2011 at 9:30 AM, Puttu *  wrote:

> Hi Experts,
>
> Required your advise on VBA training, I am looking for VBA best training in
> Basavanagude or Gandhibazr Bangalore. Could any body have any good training
> institute please provide me the address or phone no. to contact.
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Looking for VBA Training

[Puttu *]

Hi Experts,

Required your advise on VBA training, I am looking for VBA best training in
Basavanagude or Gandhibazr Bangalore. Could any body have any good training
institute please provide me the address or phone no. to contact.

-- 
Putta

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need a code or macro urgent

[Puttu]

Hi Experts,

I need help , I need a macro or formula where as in excel where ever I
found YES it should insert additional row bleow to that YES.

Can you please help me.

Thanks
Puttu

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Code or Formula Required

[Puttu]

Hi Group,

I have sheet where I get a details of the company in different format,
which the output need in one excel row.

Example

Jamrut Trading Co.  Send Mail 

    BusinessEstablished Sales

Manufacturer    1977    250,000 to 1 million USD  

 Deals In Export Of :
Spices, grounded spices, processed foods, canned vegetables, dals,
rice, pickles, chutneys, jam, papads, agarbattis


 Email: Send Mail   Contact Person: Rajesh Jesrani
605, Cotton Exchange Building
175, Kalbadevi Rd
Mumbai 41
Maharashtra India


Output Should Be:-

Company NameAddress CityState   Phone   Mobile  Fax Email   Website 
Contact
Person  Bussiness Details
Jamrut Trading Co.  "605, Cotton Exchange Building
175, Kalbadevi Rd
Mumbai 41
Maharashtra India"  Mumbai  Maharashtra 
Rajesh Jesrani  Spices,
grounded spices, processed foods, canned vegetables, dals, rice,
pickles, chutneys, jam, papads, agarbattis


Could you please advise how to do that.

Thanks
Puttu

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.

$$Excel-Macros$$ Urgent Badly help needed Excel formula

[Puttu]

Hello Team,

I need a formula or VB macro where as I have two different sheets with
Same data, when it match the result should show in other sheet next
column as YES

If one value match then the answere should be YES in different xl.

example

XX #XX Name
100 NORTH FAFA
500 NORTHFA
700 SOUTHFA
900 WESTERNFA
910 CALIFORNIAFA
912 WESTFA
922 PLAINSFA
933 SOUTHXMS
944 GREAT

In Different Sheet I have same above details, if it match then the
result should show as "YES"

912 WESTFA

If theis match then it should show as

912 WESTFA  YES

If would be great help if any one send formula or macro code for this.

Thanks
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Need either excel formula or Macro

[Puttu]

Hi Team

I need help either in excel formula or macro for the product code need
to splits in different sheets.

1. Data Sheet contains All product codes
2. Goods No.1 & 2 contain selected goods code item.
3. Other Goods sheet blank

I need what ever the product available in Data Sheet it should
highlight as "YES" in Goods No. 1 and 2 Sheets.

Goods No. 1 & 2 Sheet "NA" product don't want to change YES becaseu
they are no more available. It should retain as NA only

Remaining all other goods should which are not listed in Goods No.1 &
2 Sheet should go to Other Goods Tab sheet with Goods Code.

It would be great help if any help out on this.

Thanks
Puttu

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ VBA Vedio Tutorial

[Puttu]

Hi Team,

Can you send me any step by step procedure Document to learn Basic VBA
2006.

Is there any document which i can go through? or else any video
tutorial website to learn VBA?

It would be great help if provide those details.

Thanks
Puttu

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ I lossed my password how to recover that

[Puttu]

Hi Team,

Can any hlep me how recover my password, I lossed it. If i want to
attach let me know how can i attach to this blog?

Thanks
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe