Re: $$Excel-Macros$$ Vertical Option in excel

[Sandeep Sharma]

​Dear Sir,

You should try first Select All rows then copy and paste special there
option Transpose then click
​

With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Tue, May 9, 2017 at 1:45 AM,  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Urgent need solution

[Sandeep Sharma]

Thanks Maciej Piotrowicz very nice solution.



With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Wed, Mar 4, 2015 at 12:07 PM, Maciej Piotrowicz 
wrote:

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

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

FORUM RULES

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

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

$$Excel-Macros$$ Urgent need solution

[Sandeep Sharma]

Dear Sir,

Please find attached herewith and give solution.

With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

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

FORUM RULES

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

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


rate1.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Export Data on new Sheet with same Id of that column

[Sandeep Sharma]

Dear Harpreet Singh:-

You should Try to Merge and Cell for this select cell A2:A10 then Click
Right through mouse go to Format Cells then Alignment then tick Merge cells


With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Sat, Feb 21, 2015 at 1:35 PM, Harpreet Singh 
wrote:

> First of all let me tell you all that i am totally new to Excel. I never
> used it before.. I am in a little trouble, so i need help of your guyz...
> Hope you guyz will help me.
>
> My Problem is :
>
>
> 
>
> I have two columns "Sr.No" and "Previous Posting" as showing in the image
> 1 (Current Situation). Sr.No columns contains numbers in series and
> "Previous posting" contains all the posting details in the same column but
> in different rows..
>
> Now i want to save all these posting details in a new sheet but not in a
> single column. Every posting detail should be in a new row with same Serial
> Number which belongs to that column, rather than all the posting record in
> a single column.
>
> Results should be like as showing in image 2:
>
> I hope you will understand my question and suggest me how to do this as i
> am totally new.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

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

[Sandeep Sharma]

​Hi,

Myself Sandeep Sharma from Punjab, i am working in ​Steel manufacturing
company as accounts officer. I want to learn VBA macros through this group.

Regards

With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Mon, Feb 16, 2015 at 1:45 AM, Ahmad Mustfa  wrote:

> How can I help you raj?
> On 15 Feb 2015 19:55, "vidhu raj"  wrote:
>
>> Hi , How are you ?
>>
>> I am  Vidhuraj  from Kerala,
>>
>> I am working as an accountant at ITL World Travel Management Company In
>> KSA,
>>
>>
>>
>>
>> Regards,
>> Vidhuraj M.
>>
>> On Friday, June 8, 2012 at 10:21:59 PM UTC+3, Ayush Jain wrote:
>>>
>>> Hey all new and current posters,
>>>
>>> Welcome to excel group,one of the largest online community of excel Fans!
>>>
>>> I hope you enjoy your time here & find this forum to be a friendly and
>>> knowledgeable community. Please feel free to post a small introduction, a
>>> friendly hello or tell us a bit about yourself. Why not tell us where are
>>> you from, what you do, what your interests are, how old you are, which is
>>> your favourite excel site or blog is or anything else that comes to mind!
>>>
>>> Thanks for your time
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

Re: $$Excel-Macros$$ Require function for lookup value on condition.

[Sandeep Sharma]

Thanks Vaibhav. Sir, I want to learn VBA so, suggest me where from start.

With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Sun, Feb 8, 2015 at 10:39 PM, Vaibhav Joshi  wrote:

> really good Sandeep
>
>
> On Sun, Feb 8, 2015 at 3:37 PM, Sandeep Sharma <
> sandeepsharma4...@gmail.com> wrote:
>
>> Kindly check this Non-Array solution.
>>
>>
>>
>> With Regards
>> Sandeep Kumar Sharma
>>
>> *“Always laugh when you can. It is cheap medicine.*”
>>
>> On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi  wrote:
>>
>>> Check this...
>>>
>>> On Fri, Feb 6, 2015 at 11:08 AM, Ashish Bhalara <
>>> ashishbhalar...@gmail.com> wrote:
>>>
>>>> Dear experts,
>>>>
>>>> I require function to lookup value on consider of two particular
>>>> condition.
>>>> Pls. see attached file for example.
>>>>
>>>> Regards.
>>>> Ashish Bhalara
>>>> 9624111822
>>>> P*Please do not print this email unless it is absolutely necessary.
>>>> Spread environmental üawareness.♣♣♣*
>>>>
>>>>  --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urge

Re: $$Excel-Macros$$ Require function for lookup value on condition.

[Sandeep Sharma]

Kindly check this Non-Array solution.



With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi  wrote:

> Check this...
>
> On Fri, Feb 6, 2015 at 11:08 AM, Ashish Bhalara  > wrote:
>
>> Dear experts,
>>
>> I require function to lookup value on consider of two particular
>> condition.
>> Pls. see attached file for example.
>>
>> Regards.
>> Ashish Bhalara
>> 9624111822
>> P*Please do not print this email unless it is absolutely necessary.
>> Spread environmental üawareness.♣♣♣*
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


query of lookup value (3).xlsx
Description: MS-Excel 2007 spreadsheet

Fwd: $$Excel-Macros$$ Happy New 2015

[Sandeep Sharma]

Welcome and wish u Happy new year all Group members.


With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

-- Forwarded message --
From: Ganesh N 
Date: Thu, Jan 1, 2015 at 9:41 AM
Subject: Re: $$Excel-Macros$$ Happy New 2015
To: "excel-macros@googlegroups.com" 


Happy New Year to all


Regards,
Ganesh N

On Thu, Jan 1, 2015 at 8:58 AM, Ashish Bhalara 
wrote:

> A very very Happy New Year to all Group members.
>
>
> On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi  wrote:
>
>> Joyous January –Fabulous February
>>
>> Magical March –Adorable April
>>
>> Magnificent May –Jolly June
>>
>> Jubilant July –Awesome August
>>
>> ScintillatingSeptember –Outstanding October
>>
>> Naughty November –Dazzling December
>>
>> This is how I sincerely wish your New Year to be!
>>
>> Yu Year – Happy Year..
>>
>> A Very Happy New Year 2015! To all group members.
>>
>> Cheers!!
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, l

Re: $$Excel-Macros$$ validation

[Sandeep Sharma]

Dear Sir,

PFA as per requirement

On sheet 1. Cell b2

With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Thu, Dec 18, 2014 at 2:51 PM, Rakesh  wrote:
>
> On sheet 1. Cell b2
>
> On 18-Dec-2014 2:16 PM, "Victor Momoh"  wrote:
> >
> > On what sheet and on what cell do you get that error
> >
> > On Thu, Dec 18, 2014 at 9:28 AM, Rakesh  wrote:
> >>
> >> Dear Experts
> >>
> >> I received the following data validation error: Source evaluates to an
> error. Do you wish to continue?
> >>
> >> and when i continue nothing will changed. :(
> >>
> >> KIndly help
> >>
> >> reference sheet attached
> >> br//
> >> rakesh
> >>
> >>
> >> --
> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
> >>
> >> FORUM RULES
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> >> 2) Don't post a question in the thread of another member.
> >> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> >> 4) Acknowledge the responses you receive, good or bad.
> >> 5) Jobs posting is not allowed.
> >> 6) Sharing copyrighted material and their links is not allowed.
> >>
> >> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> >> ---
> >> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> >> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> >> To post to this group, send email to excel-macros@googlegroups.com.
> >> Visit this group at http://groups.google.com/group/excel-macros.
> >> For more options, visit https://groups.google.com/d/optout.
> >
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
> >
> > FORUM RULES
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> > 2) Don't post a question in the thread of another member.
> > 3) Don't post questions regarding breaking or bypassing any security
> measure.
> > 4) Acknowledge the responses you receive, good or bad.
> > 5) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros.
> > For more options, visit https://groups.google.com/d/optout.
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2)

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

[Sandeep Sharma]

Dear

PFA as per desired u


With Regards
Sandeep Kumar Sharma

*“Always laugh when you can. It is cheap medicine.*”

On Sun, Sep 7, 2014 at 6:16 AM, NOORAIN ANSARI 
wrote:

> Dear Saleem,
>
> Please find the attachment. hope it will help to you.
> now you can convert number to word by excel formula or vba UDF.
>
>
> On Sat, Sep 6, 2014 at 12:01 PM, Saleem Ansari 
> wrote:
>
>> Dear Noorain SIr,
>>
>> Please Help,
>>
>> My Query ho to convert number to word
>>
>>
>> Please Help Sir,,
>>
>>
>>
>>
>>
>>
>> On Saturday, August 30, 2014 7:18:44 PM UTC+5:30, Ayush Jain wrote:
>>>
>>> Dear members,
>>>
>>> We’d like to invite members of the discussexcel.com community to the
>>> annual Excel and Financial Modeling World Championship 2014 Event 
>>> (*ModelOff,
>>> www.modeloff.com *). The Advanced Excel
>>> educational competition helps celebrate Excel in Financial Services. The
>>> fun, challenging and innovative competition has a mission to inspire skill
>>> development with Microsoft Excel, Financial Modeling and Financial Analysis
>>> which is central to global businesses and communities. The competition
>>> showcases some of the fastest, hard-working and talented Excel minds from
>>> 100+ countries. Round 1 starts on 25th October 2014 (8 weeks away)
>>>
>>> *Summary of Event*
>>>
>>> Over 3,000 participants competed in the ModelOff 2013 event. Major
>>> Global Partners and Sponsors are: Microsoft, Intralinks, S&P Capital IQ,
>>> Kaplan Education, Bloomberg, AMT Training, Corality and Ernst &
>>> Young.  Participants come from diverse companies and jobs – such as
>>> Analysts, Associates and Managers at Investment Firms and Accounting Firms,
>>> CFOs, Analytics Professionals, In-House Excel Gurus and Consultants with a
>>> shared passion for Microsoft Excel and Finance.  Students comprise ~35% of
>>> all entrants worldwide – most studying Commerce, Accounting, Finance and
>>> Masters university qualifications. The countries most represented have
>>> typically been: United States, UK, Poland, Russia, Canada, Australia, India
>>> and Hong Kong.  Female participation is ~20% of all competitors - hopefully
>>> higher this year (the reigning champion is Hilary Smart 26yo from London).
>>>
>>>
>>>
>>> *How It Works*
>>>
>>> The ModelOff competition involves two online qualification rounds (2
>>> hours each) conducted simultaneously around the world. The Top 16
>>> performers are flown to New York for the Live Finals at the offices of
>>> Microsoft and Bloomberg in early December 2014.  Questions are mostly case
>>> study and multiple choice format – with some ranging from a basic
>>> understanding of discounted cash flow (DCF) analysis, 3-way integrated cash
>>> flow models to more complex project finance and simulation
>>> techniques.  Some basic Accounting, Finance and Excel knowledge is likely
>>> needed to progress to Round 2.
>>>
>>>
>>>
>>> *Free Training and Preparation*
>>>
>>> All past questions and tests from ModelOff 2012 and 2013 are free and
>>> available on the ModelOff website. The organizers believe in accessible
>>> excellence and this can be a great starting point for anyone looking to
>>> become involved for the first time and improve their Advanced Excel skills
>>> in Financial Services and Financial Modeling.  We actively encourage all
>>> participants to visit all our community partners, bloggers, our major
>>> global sponsors during and following the event for their own learning,
>>> mentoring and professional development. Competitors in the Top 10% of
>>> ModelOff 2014 will be eligible for exciting local and international
>>> opportunities, offers from community partners and fun learning experiences
>>> (e.g. Trips to Microsoft Excel in Redmond). We're also hosting free
>>> networking events in major Financial Centres including Hong Kong, London,
>>> Sydney, New York and Regional Meetups in the coming months for anyone
>>> interested in networking and mentoring with Excel-users in their local
>>> cities. Entry to the competition is $20 for students and $30 for
>>> professionals.
>>>
>>>
>>> John R Persico is one of the lead organizers of the ModelOff event. John
>>> can be contacted at jo...@modeloff.com.  Get involved at:
>>> www.modeloff.com
>>>
>>> Thanks
>>>
>>> Regards
>>>
>>> Ayush Jain (Owner and moderator @ discussexcel.com)
>>>
>>>
>>>
>>>
>>> 
>>>
>>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// noorainansari.com
> 
> http:// excelvbaclinic.com
> 
> 
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help