Re: $$Excel-Macros$$ please help with array formula

[ashish koul]

can you send us the attachment

On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:

> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
> of all the candidate who has 40 marks in 1st sheet. can it done with array
> forumla. please help.
>
>
> *Name* *Marks CT-1*  SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> 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.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

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

$$Excel-Macros$$ please help with array formula

[maksood alam]

Hi experts,

I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd sheet i want a formula if i enter 20 its should show me the name
of all the candidate who has 40 marks in 1st sheet. can it done with array
forumla. please help.


*Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L
35 SENSENBRENNER,
SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 ROMEO,
CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100



   *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*

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

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[David Grugeon]

Now I understand why the first requirement was first. This is a fair
implementation of that requirement IMHO.

Some weird things seem to happen if you edit a line after it has been
wrapped.  That may not be an issue for MM.

I still think Excel is not cut out to be a word processor and for dealing
with large amounts of text it might be better to use Word which does all
this in its sleep - either within tables or in the full page.

On 16 August 2012 07:55, Sam Mathai Chacko  wrote:

> Maybe not 100% fool proof, but this should work to some extent.
>
> Regards,
> Sam
>
> On Thu, Aug 16, 2012 at 2:12 AM, David Grugeon wrote:
>
>> Hi Paul
>>
>> I try to avoid putting chunks of text in merged cells (if possible)
>> because the cell does not adjust its height so you can easily end up with
>> text which is hidden and may be important.  I know you can kludge this by
>> having a copy of the cell off to the right made the same width as the
>> merged cell but really!
>>
>> MM specifically said he wanted to go into the next row so I looked at
>> that possibility.  I think there are so many Gotchas I don't really want to
>> do it.
>>
>> The end point IMO is that Excel is a spreadsheet, not a word processor
>> and it does not do wrapped text well.
>>
>>
>> Regards
>> David Grugeon
>>
>> --
>> 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.
>>
>>
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> 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.
>
>
>



-- 
Regards
David Grugeon

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

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[David Grugeon]

Hi Paul

I try to avoid putting chunks of text in merged cells (if possible) because
the cell does not adjust its height so you can easily end up with text
which is hidden and may be important.  I know you can kludge this by having
a copy of the cell off to the right made the same width as the merged cell
but really!

MM specifically said he wanted to go into the next row so I looked at that
possibility.  I think there are so many Gotchas I don't really want to do
it.

The end point IMO is that Excel is a spreadsheet, not a word processor and
it does not do wrapped text well.


Regards
David Grugeon

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

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[Paul Schreiner]

David,
 
I've spent time in the past in an exercise much as you've described.
I actually did work out something one time, but it did not work with 
Proportional Width fonts.
Which means that HOOD and ILLS may contain the same number of characters,
but some letters are wider than others.
 
MM has an additional problem.
According to his attached example, he's not putting the paragraph in a single 
sell.
Not only is his paragraph in successive rows, he has not merged the cells
in adjacent columns, so he's allowing the first line to overflow the cell and 
into the next 5 or 6 cells.
 
I posted a suggestion about merging the cells and getting the row height to 
adjust.
 
hopefully, that solves his problem. 

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





From: David Grugeon 
To: excel-macros@googlegroups.com
Sent: Wed, August 15, 2012 3:06:05 AM
Subject: Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).


Hi Muneer 

In essence this is almoost impossible.  

The width of each letter varies so if you type 
 and

they each contain the same number of characters but the width of each is very 
different.

The only way I know of to work out how much of a particular string will fit in 
a 
given cell width is by accessing the font table which is part of each font.  As 
far as I know there is no way to access this from within excel so you are down 
to writing a program in C to do it.

In theory you could start with a string which overfilled the cell, having set 
the cell to wordwrap and autoheight.  you could test its height until it held 
only one line of text.while you deleted characters one at a time from the end 
of 
the string.  It would be a slow process as you would need to redisplay the 
screen after each letter was chopped off.

Then you could put the balance of the string in the next cell down ad start 
again on that cell.

This could not be reasonably done as you typed.  It would have to be done, at 
the earlies, when you pressed enter to complete the cell.Then you would be 
locked out of the spreadsheet for a time until the program had done its thing.

It would probably be better to do all the typing just not minding that you were 
overfilling the cells and then have a button to run the macro to do the line 
breaks.

By the way this method would not work on merged cells.

If you subsequently wanted to change what had been entered this would cause a 
lot of problems.

I have no idea what you mean in your first condition.  What do you mean by a 
"train"  Is this the first condition or is it a test to be carried out after 
the 
text has been split into separate cells?

What do you want to happen if the "train" would otherwise cross the page break? 
 Do you want to delete any excess text?  Do you want to go to the top of the 
next column on that page? Blow a whistle to alert the user? Move to the next 
sheet? increase the column width and try again?  (incidentally determining 
where 
page breaks will occur is very difficult in Excel unless you predetermine that 
there will be a set number of rows/columns on each page.)

As you can see there are a lot of problems in this exercise which is probably 
why you have had little response as yet.


I do not have the skills to do this using the font tables method and do not 
want 
to spend the time doing it in excel as I suspect it would be unsatisfactory 
anyhow.

Word might be a better program to use for your purpose. Perhaps putting your 
data into a table.  Woird is much better at wrapping text than Excel is.

RegardsDavid Grugeon
-- 
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 thi

Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[David Grugeon]

Hi Muneer

In essence this is almoost impossible.

The width of each letter varies so if you type
 and

they each contain the same number of characters but the width of each is
very different.

The only way I know of to work out how much of a particular string will fit
in a given cell width is by accessing the font table which is part of each
font.  As far as I know there is no way to access this from within excel so
you are down to writing a program in C to do it.

In theory you could start with a string which overfilled the cell, having
set the cell to wordwrap and autoheight.  you could test its height until
it held only one line of text.while you deleted characters one at a time
from the end of the string.  It would be a slow process as you would need
to redisplay the screen after each letter was chopped off.

Then you could put the balance of the string in the next cell down ad start
again on that cell.

This could not be reasonably done as you typed.  It would have to be done,
at the earlies, when you pressed enter to complete the cell.Then you would
be locked out of the spreadsheet for a time until the program had done its
thing.

It would probably be better to do all the typing just not minding that you
were overfilling the cells and then have a button to run the macro to do
the line breaks.

By the way this method would not work on merged cells.

If you subsequently wanted to change what had been entered this would cause
a lot of problems.

I have no idea what you mean in your first condition.  What do you mean by
a "train"  Is this the first condition or is it a test to be carried out
after the text has been split into separate cells?

What do you want to happen if the "train" would otherwise cross the page
break?  Do you want to delete any excess text?  Do you want to go to the
top of the next column on that page? Blow a whistle to alert the user? Move
to the next sheet? increase the column width and try again?  (incidentally
determining where page breaks will occur is very difficult in Excel unless
you predetermine that there will be a set number of rows/columns on each
page.)

As you can see there are a lot of problems in this exercise which is
probably why you have had little response as yet.

I do not have the skills to do this using the font tables method and do not
want to spend the time doing it in excel as I suspect it would be
unsatisfactory anyhow.

Word might be a better program to use for your purpose. Perhaps putting
your data into a table.  Woird is much better at wrapping text than Excel
is.

Regards
David Grugeon

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

RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[Mohammed Muneer]

I want word wrap option to be active in excel - its effect should be
like this.

 

  Condition 1 :  the word / font train should not cross the page break
line.

 

  Condition 2 : on the completion of one line the font should adjust the
line previous and jump to the another cell or row to continue doing the
next line.

 

 

If your work fulfill this two conditions then it will be a great help to
me to carry on my further work because I have lots of data to be written
in excel following to the WBS (Work Break   Down System)

 

 

Note: See the attached file word wrap 1. ( I want to share an example
also with u)

 

Help me: please share the answered attachment in 2003 format as my
system doesn't have dual operating system.

 

 

Regards,

Muneer,

CC.


--

 

What is your issue.? Please explain

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel).

 

Dear Group,

 

Please help to solve this issue'

 

 

Regards,

Muneer,

CC  

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

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

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

RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[Rajan_Verma]

What is your issue.? Please explain

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel).

 

Dear Group,

 

Please help to solve this issue'

 

 

Regards,

Muneer,

CC..  

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

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


<>

Re: $$Excel-Macros$$ Please help..

[Manoj Kumar]

ok
thanks


On Fri, Jul 20, 2012 at 6:00 PM, NOORAIN ANSARI wrote:

> Manoj Please change reference of range, As per need otherwise it will show
> same result.
>
>
> On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar 
> wrote:
>
>> Dear Noorain Ji,
>>
>> when i drag this formula it show same result...
>>
>>
>> On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Manoj,
>>>
>>> Please see attachment without Array Function.
>>>
>>>
>>> On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar >> > wrote:
>>>
 Dear Noorain Ji,

 Thanks for reply

 Your formula is correct but can you do it without Erry..

 Regard
 Manoj


 On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Manoj,
>
> Please see attached sheet, Change range as per State Name
>
> Hope it help to you.
>
>
> On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar <
> kumarmanoj.11...@gmail.com> wrote:
>
>> Dear Noorain Ji.
>>
>> I need 1st,2nd and 3rd Max sealing model name in every state...
>>
>> Regard
>> Manoj
>>
>>
>> On Fri, Jul 20, 2012 at 11:21 AM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Manoj,
>>>
>>> Need more clarification..
>>> What is criteria of Model1,Model2,Model3
>>>
>>> Please explain
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar <
>>> kumarmanoj.11...@gmail.com> wrote:
>>>

 Dear Expert,

 Please help me

 Query file attached with mail...

 Regard
 Manoj


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



>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelvbaclinic.blogspot.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
>>>
>>>
>>>
>>
>>  --
>> --
>> 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 confid

Re: $$Excel-Macros$$ Please help..

[NOORAIN ANSARI]

Manoj Please change reference of range, As per need otherwise it will show
same result.

On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar wrote:

> Dear Noorain Ji,
>
> when i drag this formula it show same result...
>
>
> On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Manoj,
>>
>> Please see attachment without Array Function.
>>
>>
>> On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar 
>> wrote:
>>
>>> Dear Noorain Ji,
>>>
>>> Thanks for reply
>>>
>>> Your formula is correct but can you do it without Erry..
>>>
>>> Regard
>>> Manoj
>>>
>>>
>>> On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Manoj,

 Please see attached sheet, Change range as per State Name

 Hope it help to you.


 On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar <
 kumarmanoj.11...@gmail.com> wrote:

> Dear Noorain Ji.
>
> I need 1st,2nd and 3rd Max sealing model name in every state...
>
> Regard
> Manoj
>
>
> On Fri, Jul 20, 2012 at 11:21 AM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Manoj,
>>
>> Need more clarification..
>> What is criteria of Model1,Model2,Model3
>>
>> Please explain
>>
>>
>>
>>
>>
>> On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar <
>> kumarmanoj.11...@gmail.com> wrote:
>>
>>>
>>> Dear Expert,
>>>
>>> Please help me
>>>
>>> Query file attached with mail...
>>>
>>> Regard
>>> Manoj
>>>
>>>
>>>  --
>>> --
>>> 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
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelvbaclinic.blogspot.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
>>
>>
>>
>
>  --
> --
> 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 e

Re: $$Excel-Macros$$ Please help..

[NOORAIN ANSARI]

Dear Manoj,

Please see attachment without Array Function.

On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar wrote:

> Dear Noorain Ji,
>
> Thanks for reply
>
> Your formula is correct but can you do it without Erry..
>
> Regard
> Manoj
>
>
> On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Manoj,
>>
>> Please see attached sheet, Change range as per State Name
>>
>> Hope it help to you.
>>
>>
>> On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar > > wrote:
>>
>>> Dear Noorain Ji.
>>>
>>> I need 1st,2nd and 3rd Max sealing model name in every state...
>>>
>>> Regard
>>> Manoj
>>>
>>>
>>> On Fri, Jul 20, 2012 at 11:21 AM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Manoj,

 Need more clarification..
 What is criteria of Model1,Model2,Model3

 Please explain





 On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar <
 kumarmanoj.11...@gmail.com> wrote:

>
> Dear Expert,
>
> Please help me
>
> Query file attached with mail...
>
> Regard
> Manoj
>
>
>  --
> --
> 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
>
>
>



 --
 Thanks & regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelvbaclinic.blogspot.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



>>>
>>>  --
>>> --
>>> 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
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelvbaclinic.blogspot.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 bypa

Re: $$Excel-Macros$$ Please help..

[NOORAIN ANSARI]

Dear Manoj,

Please see attached sheet, Change range as per State Name

Hope it help to you.

On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar wrote:

> Dear Noorain Ji.
>
> I need 1st,2nd and 3rd Max sealing model name in every state...
>
> Regard
> Manoj
>
>
> On Fri, Jul 20, 2012 at 11:21 AM, NOORAIN ANSARI  > wrote:
>
>> Dear Manoj,
>>
>> Need more clarification..
>> What is criteria of Model1,Model2,Model3
>>
>> Please explain
>>
>>
>>
>>
>>
>> On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar > > wrote:
>>
>>>
>>> Dear Expert,
>>>
>>> Please help me
>>>
>>> Query file attached with mail...
>>>
>>> Regard
>>> Manoj
>>>
>>>
>>>  --
>>> --
>>> 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
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelvbaclinic.blogspot.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
>>
>>
>>
>
>  --
> --
> 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
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.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




Copy of Model Details(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help..

[NOORAIN ANSARI]

Dear Manoj,

Need more clarification..
What is criteria of Model1,Model2,Model3

Please explain




On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar wrote:

>
> Dear Expert,
>
> Please help me
>
> Query file attached with mail...
>
> Regard
> Manoj
>
>
>  --
> --
> 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
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.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

Re: $$Excel-Macros$$ Please help me.

[Mangesh Vimay]

Thanks Deba. Its very nice even before using it I never know that Excel
could do all these stuff so nicely.
Thanks again Dear.

On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan  wrote:

> Dear Mangesh,
>
> To create this calendar in the range B2:H9, follow these steps:
>
>
> 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
> Center.
>
> 2. Enter a date into the merged range. The day of the month isn’t
> important.
>
> 3. Enter the abbreviated day names in the range B3:H3.
>
> Performing Magic with Array Formulas
>
> 4. Select B4:H9 and enter this array formula. Remember: To enter an array
> formula, press
> Ctrl+Shift+Enter (not just Enter).
>
> {=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
> MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
> {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
> DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
> H(B2),1))-1)+
>
> {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}
>
>
> 5. Format the range B4:H9 to use this custom number format: d. This step
> formats the
> dates to show only the day. Use the Custom category in the Number tab of
> the Format
> Cells dialog box to specify this custom number format.
>
> 6. Adjust the column widths and format the cells as you like.
>
>
> 7. Change the month and year in cell B2. The calendar updates
> automatically.
> After creating this calendar, you can copy the range to any other
> worksheet or workbook.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
>
>
> On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote:
>
>> Please tell us so that we can edit and learn it. How to make ?
>> calender_Simple.xls file
>>
>>
>> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Manoj,
>>>
>>> Please find attached simple Calender.
>>>
>>> You can create it simply.
>>>
>>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar <
>>> kumarmanoj.11...@gmail.com> wrote:
>>>
 Dear Expert,


 I want to make Calender on excel

 when i enter year & month in a coll it show me date wise calender...



 Regard
 Manoj

 --
 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
>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.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
>>>
>>
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> 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.

Re: $$Excel-Macros$$ Please help me.

[Deba Ranjan]

Dear Mangesh,

To create this calendar in the range B2:H9, follow these steps:


1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
Center.

2. Enter a date into the merged range. The day of the month isn’t important.

3. Enter the abbreviated day names in the range B3:H3.

Performing Magic with Array Formulas

4. Select B4:H9 and enter this array formula. Remember: To enter an array
formula, press
Ctrl+Shift+Enter (not just Enter).

{=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
H(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}


5. Format the range B4:H9 to use this custom number format: d. This step
formats the
dates to show only the day. Use the Custom category in the Number tab of
the Format
Cells dialog box to specify this custom number format.

6. Adjust the column widths and format the cells as you like.


7. Change the month and year in cell B2. The calendar updates
automatically.
After creating this calendar, you can copy the range to any other worksheet
or workbook.




Thanks & Regards,
*Deba Ranjan P*





On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote:

> Please tell us so that we can edit and learn it. How to make ?
> calender_Simple.xls file
>
>
> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI  > wrote:
>
>> Dear Manoj,
>>
>> Please find attached simple Calender.
>>
>> You can create it simply.
>>
>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > > wrote:
>>
>>> Dear Expert,
>>>
>>>
>>> I want to make Calender on excel
>>>
>>> when i enter year & month in a coll it show me date wise calender...
>>>
>>>
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> 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
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.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
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> 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

Re: $$Excel-Macros$$ Please help me.

[Mangesh Vimay]

Please tell us so that we can edit and learn it. How to make ?
calender_Simple.xls file

On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI
wrote:

> Dear Manoj,
>
> Please find attached simple Calender.
>
> You can create it simply.
>
> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar 
> wrote:
>
>> Dear Expert,
>>
>>
>> I want to make Calender on excel
>>
>> when i enter year & month in a coll it show me date wise calender...
>>
>>
>>
>> Regard
>> Manoj
>>
>> --
>> 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
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.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
>



-- 
With regards,

MaNgEsH

-- 
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$$ Please help me.

[Deba Ranjan]

Dear Manoj,

Calender in excel can be prepared by Array formula too, its purely full
array for whole the months and years.

=IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)


Thanks & Regards,
*Deba Ranjan P*





On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar wrote:

> Dear Expert,
>
>
> I want to make Calender on excel
>
> when i enter year & month in a coll it show me date wise calender...
>
>
>
> Regard
> Manoj
>
> --
> 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

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

RE: $$Excel-Macros$$ Please help me.

[Rajan_Verma]

 

 

=IFERROR(FIND([@Particulars],[@[Specification Marks, If Any]],1)>0,FALSE)

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 11 July 2012 2:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help me.

 

Dear Suman,

It is working fine with table, Pls see the attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

 <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com

 

On Wed, Jul 11, 2012 at 1:43 PM, Suman  wrote:

Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!

Regards,
@Suman
Send on the move with Galexy y.

On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI"  wrote:

Dear Manoj,

You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
wrote:

Dear Expert.

 

i have 2 Coll A1 & B2

 

A1 Contain (Foto Fast Elec)

B1 Contain (Fast)

 

I want khow B1 is in A1 or not...

 

Regard

Manoj

-- 
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
<mailto:excel-macros%2bunsubscr...@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
<mailto:excel-macros%2bunsubscr...@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
<mailto:excel-macros%2bunsubscr...@googlegroups.com> 




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

 <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.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

Re: $$Excel-Macros$$ Please help me.

[NOORAIN ANSARI]

Dear Suman,

It is working fine with table, Pls see the attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Wed, Jul 11, 2012 at 1:43 PM, Suman  wrote:

> Hi,
> Guru Ji,
> Its not working when i applying in table. Please guide...!!
>
> Regards,
> @Suman
> Send on the move with Galexy y.
> On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI" 
> wrote:
>
>> Dear Manoj,
>>
>> You can also try
>> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>>
>> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
>> wrote:
>>
>>> Dear Expert.
>>>
>>> i have 2 Coll A1 & B2
>>>
>>> A1 Contain (Foto Fast Elec)
>>> B1 Contain (Fast)
>>>
>>> I want khow B1 is in A1 or not...
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> 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
>
>  --
> 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
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.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

Suman(test).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me.

[Suman]

Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!

Regards,
@Suman
Send on the move with Galexy y.
On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI"  wrote:

> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A1 Contain (Foto Fast Elec)
>> B1 Contain (Fast)
>>
>> I want khow B1 is in A1 or not...
>>
>> Regard
>> Manoj
>>
>> --
>> 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
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.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

-- 
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$$ Please help me.

[Manoj Kumar]

Thanks Noorain Ji...
its working..


On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote:

> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A1 Contain (Foto Fast Elec)
>> B1 Contain (Fast)
>>
>> I want khow B1 is in A1 or not...
>>
>> Regard
>> Manoj
>>
>> --
>> 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
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.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
>

-- 
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$$ Please help me.

[NOORAIN ANSARI]

Dear Manoj,

You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote:

> Dear Expert.
>
> i have 2 Coll A1 & B2
>
> A1 Contain (Foto Fast Elec)
> B1 Contain (Fast)
>
> I want khow B1 is in A1 or not...
>
> Regard
> Manoj
>
> --
> 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




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.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

Re: $$Excel-Macros$$ Please help me.

[Amresh Maurya]

Hi,

use below formula

=find(B1,A1)

Regards
Amresh

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar  wrote:
> Dear Expert.
>
> i have 2 Coll A1 & B2
>
> A1 Contain (Foto Fast Elec)
> B1 Contain (Fast)
>
> I want khow B1 is in A1 or not...
>
> Regard
> Manoj
>
> --
> 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

Re: $$Excel-Macros$$ PLease Help

[Mangesh Vimay]

Thanks Noorain

On 7/4/12, NOORAIN ANSARI  wrote:
> Dear Mangesh,
>
> Please use it..
>
> =TEXT(B2-A2,"[H]:mm:ss")
>
> On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay
> wrote:
>
>> I need diff in between these two dates in Hours
>> Start Date  End Date
>> 4/1/2012 5:01   4/3/2012 6:15
>> Whatever the diff in between these two dats in terms of hours (hh:mm)
>>
>> Please help
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> 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
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.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


-- 
With regards,

MaNgEsH

-- 
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$$ PLease Help

[NOORAIN ANSARI]

Dear Mangesh,

Please use it..

=TEXT(B2-A2,"[H]:mm:ss")

On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay wrote:

> I need diff in between these two dates in Hours
> Start Date  End Date
> 4/1/2012 5:01   4/3/2012 6:15
> Whatever the diff in between these two dats in terms of hours (hh:mm)
>
> Please help
>
> --
> With regards,
>
> MaNgEsH
>
> --
> 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




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.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

$$Excel-Macros$$ PLease Help

[Mangesh Vimay]

I need diff in between these two dates in Hours
Start Date  End Date
4/1/2012 5:01   4/3/2012 6:15
Whatever the diff in between these two dats in terms of hours (hh:mm)

Please help

-- 
With regards,

MaNgEsH

-- 
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$$ Please help : Use of Criteria & Rule1-2

[santosh subudhi]

Hi Suyog,

I have used the name ranges in the sheet.

If function starts with logical reason, to view the name ranges press
CTRL+F3

So I have defined each logic a diffrent name like criteria 2 ,criteria3
like that

Hope I have cleared you doubt, if you still have any queries please feel
free to contact me.

Regards
Santosh
santoshkumar.subu...@gmail.com



--
Date: Tue, 19 Jun 2012 06:32:56 -0700
From: nashi...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help : Use of Criteria & Rule1-2

Hello Expert,

I've studied Attendance register made by Santosh. I have not understood how
excel is using criteria2, criteria3 etc & Rule 1 & 2.
I've tried to find same in excel function list to read help but I've not
found.

Please advice or share syntax. Please share good book for excel 2007 for
study.

Thanks & regards,
Suyog

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

$$Excel-Macros$$ Please help : Use of Criteria & Rule1-2

[Suyog]

Hello Expert,

I've studied Attendance register made by Santosh. I have not understood how 
excel is using criteria2, criteria3 etc & Rule 1 & 2.
I've tried to find same in excel function list to read help but I've not 
found.

Please advice or share syntax. Please share good book for excel 2007 for 
study.

Thanks & regards,
Suyog

-- 
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$$ Please help on the data validation

[Naresh V]

Smitha,

 Using developer tab Insert Combo box from Activex controls.
Then right click on the combo box, select properties. Now write the
source opposit to  "Listfillrange". It works

Thanks,
Naresh V

On Tue, May 29, 2012 at 10:04 AM, Bé Trần Văn wrote:

>
>
> 2012/5/29 Mangesh Dayne 
>
>> Check mails of this group.
>>
>> It has been already answered some days before.
>>
>>
>> ManGesh
>>
>>
>> On Tue, May 29, 2012 at 1:36 PM, Smitha S R  wrote:
>>
>>> Hi,
>>>
>>> I have a drop down list which is  created using menu 'data validation'.
>>>
>>> Is it possible to get the items in the first line in the drop down while
>>> start entering the letters of the items.
>>> Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
>>> entering P itself Pen and pencils should come in the first line.
>>>
>>> Please help on this, if this is possible in  data validation
>>>
>>> Thanks
>>> Smitha
>>>
>>> --
>>> 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
>>
>
> Create List by name:
> Place Name.
> Step 1: Select a region from A5 to A22
>  Step 2: Select Insert > Name > Define...
> Step 3: Names in workbook frame type List1, click Add and click OK
>  Step 4: Create List by name:
> Select Cell to create List, Select Data > Validation. Select tab Settings,
> click the arrow to select List (Allow frame), in the frame Source type =
> List1 (List the Name was placed on top). Ok button is finished successfully
> creating List.
>
> See Attachment
>
> --
> 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  : 

Re: $$Excel-Macros$$ Please help on the data validation

[Mangesh Dayne]

Check mails of this group.

It has been already answered some days before.


ManGesh

On Tue, May 29, 2012 at 1:36 PM, Smitha S R  wrote:

> Hi,
>
> I have a drop down list which is  created using menu 'data validation'.
>
> Is it possible to get the items in the first line in the drop down while
> start entering the letters of the items.
> Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
> entering P itself Pen and pencils should come in the first line.
>
> Please help on this, if this is possible in  data validation
>
> Thanks
> Smitha
>
> --
> 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

$$Excel-Macros$$ Please help on the data validation

[Smitha S R]

Hi,

I have a drop down list which is  created using menu 'data validation'.

Is it possible to get the items in the first line in the drop down while
start entering the letters of the items.
Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
entering P itself Pen and pencils should come in the first line.

Please help on this, if this is possible in  data validation

Thanks
Smitha

-- 
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$$ Please help

[NOORAIN ANSARI]

Dear Rajendra,

Waheed solution is nice, you can also use...vlookup with approximate match

=VLOOKUP(B2,$G$3:$I$5,3,*1*)

On Tue, May 8, 2012 at 3:03 PM, Shaik Waheed  wrote:

> Hi,
> PFA
>
> On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender wrote:
>
>> Dear Team
>>
>> Please go through the attached excel sheet and help me in the calculation
>> of* discount* (Column - D) based on the *discount criteria *(Column G:I)
>>
>> Regards
>> Rajender Soni
>>
>> --
>> 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
>>
>
>  --
> 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
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.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

Re: $$Excel-Macros$$ Please help

[Shaik Waheed]

Hi,
PFA

On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender wrote:

> Dear Team
>
> Please go through the attached excel sheet and help me in the calculation
> of* discount* (Column - D) based on the *discount criteria *(Column G:I)
>
> Regards
> Rajender Soni
>
> --
> 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
>

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


test(1) - Solved.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Please help

[Soni.Rajender]

Dear Team
 
Please go through the attached excel sheet and help me in the calculation of
* discount* (Column - D) based on the *discount criteria *(Column G:I)
 
Regards
Rajender Soni

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


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

Re: $$Excel-Macros$$ Please help on basic Excel

[Aruna jayaram]

Thanks a lot Rajan for such quick solution

On Sun, Apr 8, 2012 at 11:23 PM, Rajan_Verma wrote:

> See the attached sheet
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Aruna jayaram
> *Sent:* Apr/Sun/2012 11:21
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Please help on basic Excel
>
> ** **
>
> Hi Rajan,
>
> In the M column it should appear as 1600 and not -1600.
>
> Thanks
>
> Aruna
>
> On Sun, Apr 8, 2012 at 11:12 PM, Rajan_Verma 
> wrote:
>
> See the attached file
>
>  
>
> Rajan.
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Aruna jayaram
> *Sent:* Apr/Sun/2012 11:09
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Please help on basic Excel
>
>  
>
> Hi
>
> Attached is a file in which in the loss column ( M Column ) the amount
> appears with the - ( Minus ) in the beginning. Kindly advise what can be
> done by which the minus will not appear.
>
> Thanks and Regards
>
> Aruna
>
> --
> 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
>
> --
> 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
>
> ** **
>
> --
> 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
>
> --
> 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 m

RE: $$Excel-Macros$$ Please help on basic Excel

[Rajan_Verma]

See the attached sheet

 

Rajan.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Apr/Sun/2012 11:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help on basic Excel

 

Hi Rajan,

In the M column it should appear as 1600 and not -1600.

Thanks

Aruna

On Sun, Apr 8, 2012 at 11:12 PM, Rajan_Verma 
wrote:

See the attached file

 

Rajan.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Apr/Sun/2012 11:09
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help on basic Excel

 

Hi

Attached is a file in which in the loss column ( M Column ) the amount
appears with the - ( Minus ) in the beginning. Kindly advise what can be
done by which the minus will not appear.

Thanks and Regards

Aruna

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

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

 

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

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


Copy of Copy of exercise.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help on basic Excel

[Aruna jayaram]

Hi Rajan,

In the M column it should appear as 1600 and not -1600.

Thanks

Aruna

On Sun, Apr 8, 2012 at 11:12 PM, Rajan_Verma wrote:

> See the attached file
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Aruna jayaram
> *Sent:* Apr/Sun/2012 11:09
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Please help on basic Excel
>
> ** **
>
> Hi
>
> Attached is a file in which in the loss column ( M Column ) the amount
> appears with the - ( Minus ) in the beginning. Kindly advise what can be
> done by which the minus will not appear.
>
> Thanks and Regards
>
> Aruna
>
> --
> 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
>
> --
> 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
>

-- 
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$$ Please help on basic Excel

[Rajan_Verma]

See the attached file

 

Rajan.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Apr/Sun/2012 11:09
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help on basic Excel

 

Hi

Attached is a file in which in the loss column ( M Column ) the amount
appears with the - ( Minus ) in the beginning. Kindly advise what can be
done by which the minus will not appear.

Thanks and Regards

Aruna

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

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


Copy of exercise.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Please help on basic Excel

[Aruna jayaram]

Hi

Attached is a file in which in the loss column ( M Column ) the amount
appears with the - ( Minus ) in the beginning. Kindly advise what can be
done by which the minus will not appear.

Thanks and Regards

Aruna

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


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

Re: $$Excel-Macros$$ please help

[NOORAIN ANSARI]

Dear Anil,

Please see attached sheet,
Maries solution is good but You can do it without using helping column




On Fri, Feb 24, 2012 at 3:41 PM, anil panchal  wrote:

> Hi,
>
> Please help me how to show percentage in bar chart like value
>
>
>
>
> --
>
>
>
> Thanks & Regards
> Anil Kumar
>
> --
> 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
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.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


SHOW PERCENTAGE(Without Helping COlumn).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ please help

[Maries]

Hi,

Find the attached file.


On Fri, Feb 24, 2012 at 2:11 PM, anil panchal  wrote:

> Hi,
>
> Please help me how to show percentage in bar chart like value
>

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


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

$$Excel-Macros$$ please help

[anil panchal]

Hi,

Please help me how to show percentage in bar chart like value




-- 



Thanks & Regards
Anil Kumar

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


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

$$Excel-Macros$$ Please Help me to create summary and Macro.

[Avinash Patil]

thank you so much thnx thnx thnx thnx thnx it works awesome gre8 work thank
u once again.

On Monday, January 30, 2012, dguillett1  wrote:
> The formula simply reformats your entry to an entry that excel will use
and then uses INDIRECT. Google or look in the help index for EXCEL:INDIRECT
> See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
>
> Dear Don,
>
>
>
> Thanks for your help but can u please explain me how this formula works I
have tried to search for the information on Google
>
> but I din understand anything so can u please explain.
>
> and by the u have given exact solution for my query. I just want another
addition in the results.
>
>
>
> like hyperlink to that day it means if the data is for 4 Jan then there
should b a link which will be useful to navigate to that sheet
>
> but it should not be in default hyperlink format like blue font and
underline it should be in red font.
>
> please reply if it is possible attached is the sample of the result and
>
>
>
> Results Based On Links but not useful if I have to show details for 10
days
>
>
>
> it means if I create a link for total product 05 (='Jan 04'!B14)   then I
have to use same technique for every result and if I there will be data for
10 days then It will take a lot of time.
>
> please see the attachment.
>
>
>
> Thanks for your help and u r genius man.
>
>
>
> Regards,
>
>
>
> Avinash
>
>
>
> On Sun, Jan 29, 2012 at 8:20 PM, dguillett1  wrote:
>
> Since ALL requests are important and serious, please do NOT mention that
in your post as it offends some of us.
> See attached using
>
> '=INDIRECT("'" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Friday, January 27, 2012 7:41 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
>
> --
> 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
>

-- 
Sent from Gmail Mobile

-- 
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$$ Please Help me to create summary and Macro.

[Avinash Patil]

thank you so much thnx thnx thnx thnx thnx it works awesome gre8 work thank
u once again.

On Monday, January 30, 2012, dguillett1  wrote:
> The formula simply reformats your entry to an entry that excel will use
and then uses INDIRECT. Google or look in the help index for EXCEL:INDIRECT
> See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
>
> Dear Don,
>
>
>
> Thanks for your help but can u please explain me how this formula works I
have tried to search for the information on Google
>
> but I din understand anything so can u please explain.
>
> and by the u have given exact solution for my query. I just want another
addition in the results.
>
>
>
> like hyperlink to that day it means if the data is for 4 Jan then there
should b a link which will be useful to navigate to that sheet
>
> but it should not be in default hyperlink format like blue font and
underline it should be in red font.
>
> please reply if it is possible attached is the sample of the result and
>
>
>
> Results Based On Links but not useful if I have to show details for 10
days
>
>
>
> it means if I create a link for total product 05 (='Jan 04'!B14)   then I
have to use same technique for every result and if I there will be data for
10 days then It will take a lot of time.
>
> please see the attachment.
>
>
>
> Thanks for your help and u r genius man.
>
>
>
> Regards,
>
>
>
> Avinash
>
>
>
> On Sun, Jan 29, 2012 at 8:20 PM, dguillett1  wrote:
>
> Since ALL requests are important and serious, please do NOT mention that
in your post as it offends some of us.
> See attached using
>
> '=INDIRECT("'" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Friday, January 27, 2012 7:41 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
>
> --
> 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
>

-- 
Sent from Gmail Mobile

-- 
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$$ Please Help me to create summary and Macro.

[Avinash Patil]

yes dilip, i guess u r  right. i want the results as per the results
highlighted in red border. and hyperlink format in red font.

regards,
Avinash



On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey  wrote:

> Hi Avinash,
>
> Not entirely getting your point.
> Please confirm if you need following < which I can understand per your
> post> :)
>
> 1) Following results as per Date in first field < this you have
> already attached>
>
> DateTotal Product   Actual PriceTotal Number Of Products
>  Grand
> Total   Sheet Location
>
> 2) Hyperlink in last field to each row entered
> ?
>
> I believe either you are explained too much in your post or missed to
> put the crux of your issue in lime light.  :)
>
> Regards,
> DILIPandey
>
> On 1/27/12, Avinash Patil  wrote:
> > Hi Experts,
> >
> >
> > i am currently facing very serious problem cuz every day i have to
> generate
> > data from various workbooks wich is bassed on the daily reports.
> >
> > and i have to show any increase or decrease on any perticular day
> >
> > to get this done i have to insert 1 sheet called summary it contains
> > following details like day wise details.
> >
> > but to show the day wise performance i have to link specific cells
> >
> >
> > e.g
> >
> > sheet name jan 01
> >
> >
> > total products = 06  (D14)
> >
> > so if the client wants to see performance for the specific day i have to
> > vlookup for the results
> >
> > and the lookup is bassed on summary sheet
> >
> >
> > plus if there there will be uncertain increase or decrease in the data i
> > have to create link for that specific day.
> >
> > but link should not be in hyperlink format it should b  in normal format
> > but only highlited in red font.
> >
> >
> > and by the way i have to create summary sheet for my refrence not for
> client
> >
> > client want result only for specific day like for increase and decrease.
> >
> > client result is using red border.
> >
> >
> > i have attached the sheet for your refrence
> >
> > please see the attached file and kindly help me in this regards.
> >
> >
> > if possible can anyone please prepare a macro/formula  to get the details
> >
> > --
> >
> > Thanks and Regards,
> >
> >  Avinash
> >
> > "Love does not happen its a choice. Its not magic or fate, but it is
> when a
> > person takes their natural affinity/attraction for someone and translates
> > it into commitment and actions that express love."
> >
> >
> > Disclaimer: The information transmitted is intended only for the
> person(s)
> > or entity to which it is addressed and may contain confidential and/or
> > privileged material. If you are not the intended recipient of this
> message
> > you are hereby notified that any use, review, retransmission,
> > dissemination, distribution, reproduction or any action taken in reliance
> > upon this message is prohibited. If you receive this in error, please
> > contact the sender
> >
> > --
> > 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
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> 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
>



-- 

Thanks and Regards,

 Avinash Patil

"Love does not happen it

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

[Dilip Pandey]

Hi Avinash,

Not entirely getting your point.
Please confirm if you need following < which I can understand per your post> :)

1) Following results as per Date in first field < this you have
already attached>

DateTotal Product   Actual PriceTotal Number Of ProductsGrand
Total   Sheet Location

2) Hyperlink in last field to each row entered
?

I believe either you are explained too much in your post or missed to
put the crux of your issue in lime light.  :)

Regards,
DILIPandey

On 1/27/12, Avinash Patil  wrote:
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to generate
> data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
> to get this done i have to insert 1 sheet called summary it contains
> following details like day wise details.
>
> but to show the day wise performance i have to link specific cells
>
>
> e.g
>
> sheet name jan 01
>
>
> total products = 06  (D14)
>
> so if the client wants to see performance for the specific day i have to
> vlookup for the results
>
> and the lookup is bassed on summary sheet
>
>
> plus if there there will be uncertain increase or decrease in the data i
> have to create link for that specific day.
>
> but link should not be in hyperlink format it should b  in normal format
> but only highlited in red font.
>
>
> and by the way i have to create summary sheet for my refrence not for client
>
> client want result only for specific day like for increase and decrease.
>
> client result is using red border.
>
>
> i have attached the sheet for your refrence
>
> please see the attached file and kindly help me in this regards.
>
>
> if possible can anyone please prepare a macro/formula  to get the details
>
> --
>
> Thanks and Regards,
>
>  Avinash
>
> "Love does not happen its a choice. Its not magic or fate, but it is when a
> person takes their natural affinity/attraction for someone and translates
> it into commitment and actions that express love."
>
>
> Disclaimer: The information transmitted is intended only for the person(s)
> or entity to which it is addressed and may contain confidential and/or
> privileged material. If you are not the intended recipient of this message
> you are hereby notified that any use, review, retransmission,
> dissemination, distribution, reproduction or any action taken in reliance
> upon this message is prohibited. If you receive this in error, please
> contact the sender
>
> --
> 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
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
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$$ Please help...!!

[Rajan_Verma]

Hi..
Please attach sample file with output what you want by Formula..

Rajan.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Satvik
Sent: Jan/Mon/2012 09:33
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help...!!

Dear Excel Members,

Please help me how to calculate the Tenurity of a agent.

Regards,
Satvik
Sent from BlackBerryR on Airtel

-- 
FORUM RULES (934+ 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

-- 
FORUM RULES (934+ 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$$ Please help...!!

[sunil bn]

Hi Satvik,

use the below formula .

=(today()-A1)/30.5

On Mon, Jan 2, 2012 at 9:32 PM, Satvik  wrote:

> Dear Excel Members,
>
> Please help me how to calculate the Tenurity of a agent.
>
> Regards,
> Satvik
> Sent from BlackBerry® on Airtel
>
> --
> FORUM RULES (934+ 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
>



-- 

*Regards*
**Sunil B.N
***9035858585

-- 
FORUM RULES (934+ 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

$$Excel-Macros$$ Please help...!!

[Satvik]

Dear Excel Members,

Please help me how to calculate the Tenurity of a agent.

Regards,
Satvik
Sent from BlackBerry® on Airtel

-- 
FORUM RULES (934+ 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$$ PLEASE HELP ME

[dguillett1]

You need to tell us what you want and why
This cell _on this sheet___in this file_
needs to come from
This cell _on this sheet___in this file_
and WHY

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Chandra Singh Bora 
Sent: Friday, December 09, 2011 11:40 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ PLEASE HELP ME

DEAR ALL MY EXCEL FRND.
PLEASE SEND SOME FORMULA FOR MEDAL TALLY & CHAMPIANSHIP


 


Chandra Singh Bohra
Champawat
Uttrakhand



-- 
FORUM RULES (934+ 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

-- 
FORUM RULES (934+ 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

$$Excel-Macros$$ Please help

[Sanjay Kumar Maurya]

Dear Friends

Anyone has solved assignment of SMU first semester. if you have then Please
forward.

amreshkushw...@gmail.com, mail2sanja...@gmail.com, always...@gmail.com

Please this is very urgent.

-- 
***Thanks
Sanjay Kumar Maurya*

-- 
FORUM RULES (934+ 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

$$Excel-Macros$$ please help

[hanna habiel]

that the first time i send for help thanks


From: hanna habiel 
To: "excel-macros@googlegroups.com" 
Sent: Saturday, October 29, 2011 1:40 PM
Subject: $$Excel-Macros$$ 


Dear All,

good day for all ,

i need your help for the attached file 

thanks
hanna -- 
FORUM RULES (925+ 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

-- 
FORUM RULES (925+ 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$$ Please help to convert tables from PDF to Excel.

[Pravesh verma]

Thnaks yaar, but i am new in Macro world so dont know even ABC of it, can u
plz send the final file. I will be very thankful to you. its very urgent for
me plz

On Mon, Oct 24, 2011 at 8:59 PM, NOORAIN ANSARI wrote:

> Dear Pravesh,
>
> Please try through below code..
>
> Sub ImportPDFFileData()
> 'Author: Steve Lipsman
> 'Purpose: Import PDF File Data Into Excel Worksheet
> 'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References
> 'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After
> Reference Is Saved
>
> 'Declare Variable(s)
> Dim appAA As Acrobat.CAcroApp, docPDF As Acrobat.CAcroPDDoc
> Dim strFileName As String, intNOP As Integer, arrI As Variant
> Dim intC As Integer, intR As Integer, intBeg As Integer, intEnd As Integer
>
> 'Initialize Variables
> Set appAA = CreateObject("AcroExch.App"): Set docPDF =
> CreateObject("AcroExch.PDDoc")
>
> 'Set PDF FileName
> strFileName = "Your Full PDF File Pathname Here.pdf"
>
> 'Read PDF File
> docPDF.Open (strFileName)
>
> 'Extract Number of Pages From PDF File
> intNOP = docPDF.GetNumPages
>
> 'Select First Data Cell
> Range("A1").Select
>
> 'Open PDF File
> ActiveWorkbook.FollowHyperlink strFileName, , True
>
> 'Loop Through All PDF File Pages
> For intC = 1 To intNOP
> 'Go To Page Number
> SendKeys ("+^n" & intC & "{ENTER}")
>
> 'Select All Data In The PDF File's Active Page
> SendKeys ("^a"), True
>
> 'Right-Click Mouse
> SendKeys ("+{F10}"), True
>
> 'Copy Data As Table
> SendKeys ("c"), True
>
> 'Minimize Adobe Window
> SendKeys ("%n"), True
>
> 'Paste Data In This Workbook's Worksheet
> ActiveSheet.Paste
>
> 'Select Next Paste Cell
> Range("A" & Range("A1").SpecialCells(xlLastCell).Row + 2).Select
>
> 'Maximize Adobe Window
> SendKeys ("%x")
> Next intC
>
> 'Close Adobe File and Window
> SendKeys ("^w"), True
>
> 'Empty Object Variables
> Set appAA = Nothing: Set docPDF = Nothing
>
> 'Select First Cell
> Range("A1").Select
> End Sub
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Mon, Oct 24, 2011 at 4:46 PM, Pravesh verma wrote:
>
>>
>>
>> Hi Group, please find 2 files in which below one is a pdf file, and it
>> contain some tables, which i have to convert in excel , after googlng i am
>> able to convert them in excel but still not fully converted, as all rows of
>> pdf file come in one row in excel file as u can see in excel file, and i
>> want each row separately , can you please help. in waiting
>>
>> --
>>
>> --
>> 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
>



-- 
Thanks & Regards
Pravesh

-- 
--
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$$ Please help to convert tables from PDF to Excel.

[NOORAIN ANSARI]

Dear Pravesh,

Please try through below code..

Sub ImportPDFFileData()
'Author: Steve Lipsman
'Purpose: Import PDF File Data Into Excel Worksheet
'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References
'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After Reference
Is Saved

'Declare Variable(s)
Dim appAA As Acrobat.CAcroApp, docPDF As Acrobat.CAcroPDDoc
Dim strFileName As String, intNOP As Integer, arrI As Variant
Dim intC As Integer, intR As Integer, intBeg As Integer, intEnd As Integer

'Initialize Variables
Set appAA = CreateObject("AcroExch.App"): Set docPDF =
CreateObject("AcroExch.PDDoc")

'Set PDF FileName
strFileName = "Your Full PDF File Pathname Here.pdf"

'Read PDF File
docPDF.Open (strFileName)

'Extract Number of Pages From PDF File
intNOP = docPDF.GetNumPages

'Select First Data Cell
Range("A1").Select

'Open PDF File
ActiveWorkbook.FollowHyperlink strFileName, , True

'Loop Through All PDF File Pages
For intC = 1 To intNOP
'Go To Page Number
SendKeys ("+^n" & intC & "{ENTER}")

'Select All Data In The PDF File's Active Page
SendKeys ("^a"), True

'Right-Click Mouse
SendKeys ("+{F10}"), True

'Copy Data As Table
SendKeys ("c"), True

'Minimize Adobe Window
SendKeys ("%n"), True

'Paste Data In This Workbook's Worksheet
ActiveSheet.Paste

'Select Next Paste Cell
Range("A" & Range("A1").SpecialCells(xlLastCell).Row + 2).Select

'Maximize Adobe Window
SendKeys ("%x")
Next intC

'Close Adobe File and Window
SendKeys ("^w"), True

'Empty Object Variables
Set appAA = Nothing: Set docPDF = Nothing

'Select First Cell
Range("A1").Select
End Sub

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Mon, Oct 24, 2011 at 4:46 PM, Pravesh verma wrote:

>
>
> Hi Group, please find 2 files in which below one is a pdf file, and it
> contain some tables, which i have to convert in excel , after googlng i am
> able to convert them in excel but still not fully converted, as all rows of
> pdf file come in one row in excel file as u can see in excel file, and i
> want each row separately , can you please help. in waiting
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Please help

[dguillett1]

I sent the original answer. I should have told you to save your file as an 
.xlsM (macro enabled file)

From: Sundarvelan N 
Sent: Monday, August 22, 2011 6:59 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Please help

  Hi Team,

  Still i'm notable to find the solution for this task. Please find the 
attachments.


  Thanks
  N.Sundarvelan 
  9600160150




  On Thu, Aug 11, 2011 at 3:18 AM, dguillett1  wrote:


Or with col 8 formatted as desired place this in the SHEET module

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column <> 7 Then Exit Sub
If UCase(Target) = "DONE" Then Target.Offset(, 1) = Date
End Sub
-Original Message- From: XLS S
Sent: Wednesday, August 10, 2011 1:19 PM 

To: excel-macros@googlegroups.com

    Subject: Re: $$Excel-Macros$$ Please help 


Hey Sundaryelan,

Please find the attachment

.

On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N  wrote:

  Hi Friends,

  Please refer the attached image. Please help on this scenatio.
  Thanks
  N.Sundarvelan
  9600160150

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

-- 


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

-- 
--
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$$ Please help

[Sundarvelan N]

>
> Hi Team,
>
> Still i'm notable to find the solution for this task. Please find the
> attachments.
>


> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Thu, Aug 11, 2011 at 3:18 AM, dguillett1  wrote:
>
>>
>> Or with col 8 formatted as desired place this in the SHEET module
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> If Target.Row < 2 Or Target.Column <> 7 Then Exit Sub
>> If UCase(Target) = "DONE" Then Target.Offset(, 1) = Date
>> End Sub
>> -Original Message- From: XLS S
>> Sent: Wednesday, August 10, 2011 1:19 PM
>>
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Please help
>>
>>
>> Hey Sundaryelan,
>>
>> Please find the attachment
>>
>> .
>>
>> On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N 
>> wrote:
>>
>>> Hi Friends,
>>>
>>> Please refer the attached image. Please help on this scenatio.
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>> --**--**
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/**exceldailytip <http://twitter.com/exceldailytip>
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/**
>>> groups?gid=1871310 <http://www.linkedin.com/groups?gid=1871310>
>>> 3. Excel tutorials at 
>>> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com/>
>>> 4. Learn VBA Macros at 
>>> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com/>
>>> 5. Excel Tips and Tricks at 
>>> http://exceldailytip.blogspot.**com<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<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 <http://twitter.com/exceldailytip>
>> 2. Join our LinkedIN group @ 
>> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
>> 3. Excel tutorials at 
>> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com/>
>> 4. Learn VBA Macros at 
>> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com/>
>> 5. Excel Tips and Tricks at 
>> http://exceldailytip.blogspot.**com<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<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 <http://twitter.com/exceldailytip>
>> 2. Join our LinkedIN group @ 
>> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
>> 3. Excel tutorials at 
>> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com/>
>> 4. Learn VBA Macros at 
>> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com/>
>> 5. Excel Tips and Tricks at 
>> http://exceldailytip.blogspot.**com<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<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


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

Re: $$Excel-Macros$$ Please help

[dguillett1]

Or with col 8 formatted as desired place this in the SHEET module

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column <> 7 Then Exit Sub
If UCase(Target) = "DONE" Then Target.Offset(, 1) = Date
End Sub
-Original Message- 
From: XLS S

Sent: Wednesday, August 10, 2011 1:19 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help

Hey Sundaryelan,

Please find the attachment

.

On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N  wrote:

Hi Friends,

Please refer the attached image. Please help on this scenatio.
Thanks
N.Sundarvelan
9600160150

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


--
--
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$$ Please help

[XLS S]

Hey Sundaryelan,

Please find the attachment

.

On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N  wrote:
> Hi Friends,
>
> Please refer the attached image. Please help on this scenatio.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> --
> 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


TestDT.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help

[dguillett1]

Attach a file

From: Sundarvelan N 
Sent: Tuesday, August 09, 2011 11:52 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Please help

Hi Friends,

Please refer the attached image. Please help on this scenatio.

Thanks
N.Sundarvelan 
9600160150

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

RE: $$Excel-Macros$$ Please help

[Rajan_Verma]

Please Attach Your excel file.. 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Wednesday, August 10, 2011 10:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help

 

Hi Friends,

 

Please refer the attached image. Please help on this scenatio.


Thanks

N.Sundarvelan 

9600160150

 

-- 

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

Re: $$Excel-Macros$$ Please help me(Combo box)

[always online]

Dear Friends

Thank your very much for your great reply.
may u define this formula. I can not find any source for *Groups* . I am
using that other place that function is not working.

Thanks again
Sanjay Kumar Maurya

On Thu, Aug 4, 2011 at 5:18 AM, XLS S  wrote:

> Hey Sanjay
>
> Try to use Indirect Functionplease find the attachment
>
>
>
> On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya 
> wrote:
> > Dear Frd
> >
> > Thanks for your reply and solution but I have more data so pivot table
> > is not possible for it. if u have any easy format please tell me.
> >
> > Thanks
> > Sanjay Kumar Maurya
> >
> > On 8/3/11, sreejith k.s  wrote:
> >> hi Sanjay,
> >>
> >> just see whether this helps...i created a pivot according to my
> >> understanding of the quwestion...just get back to me if it is not enough
> >>
> >> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
> >> wrote:
> >>
> >>> Hi frds
> >>>
> >>> Please help me.
> >>>
> >>> --
> >>> ***Thanks
> >>> Sanjay Kumar Maurya*
> >>>
> >>> --
> >>>
> >>>
> --
> >>> 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
> >>
> >
> >
> > --
> > ***Thanks
> > Sanjay Kumar Maurya*
> >
> > --
> >
> --
> > 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
>

-- 
--
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$$ Please help me(Combo box)

[XLS S]

Hey Sanjay

Try to use Indirect Functionplease find the attachment



On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya  wrote:
> Dear Frd
>
> Thanks for your reply and solution but I have more data so pivot table
> is not possible for it. if u have any easy format please tell me.
>
> Thanks
> Sanjay Kumar Maurya
>
> On 8/3/11, sreejith k.s  wrote:
>> hi Sanjay,
>>
>> just see whether this helps...i created a pivot according to my
>> understanding of the quwestion...just get back to me if it is not enough
>>
>> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
>> wrote:
>>
>>> Hi frds
>>>
>>> Please help me.
>>>
>>> --
>>> ***Thanks
>>> Sanjay Kumar Maurya*
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
> --
> 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


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

Re: $$Excel-Macros$$ Please help me(Combo box)

[Sanjay Maurya]

Dear Frd

Thanks for your reply and solution but I have more data so pivot table
is not possible for it. if u have any easy format please tell me.

Thanks
Sanjay Kumar Maurya

On 8/3/11, sreejith k.s  wrote:
> hi Sanjay,
>
> just see whether this helps...i created a pivot according to my
> understanding of the quwestion...just get back to me if it is not enough
>
> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
> wrote:
>
>> Hi frds
>>
>> Please help me.
>>
>> --
>> ***Thanks
>> Sanjay Kumar Maurya*
>>
>> --
>>
>> --
>> 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
>


-- 
***Thanks
Sanjay Kumar Maurya*

-- 
--
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$$ Please help me(Combo box)

[Rupesh Shrivastava]

Hi,
Please find the attached sheet with solution.

Thanks
Rupesh Kr.

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
>  --
>
> --
> 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


Copy of problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me(Combo box)

[sreejith k.s]

hi Sanjay,

just see whether this helps...i created a pivot according to my
understanding of the quwestion...just get back to me if it is not enough

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
>
> --
> 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


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

Re: $$Excel-Macros$$ Please help me(Combo box)

[ashish koul]

see if it helps

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
>  --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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


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

$$Excel-Macros$$ Please help me(Combo box)

[Sanjay Maurya]

Hi frds

Please help me.

-- 
***Thanks
Sanjay Kumar Maurya*

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


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

Re: RE: $$Excel-Macros$$ Please help

[Haseeb Avarakkan]

Hello Anil,
 
Also, If you have other text or charracters other than #n/a and just need to 
count the numbers only, use this,
 
=COUNT(INDEX(MID(C2,ROW(INDEX(C:C,1):INDEX(C:C,LEN(C2))),1)+0,0))
 
Copy down
 
HTH
Haseeb
 
For tips visit;
http://www.excelfox.com/forum/forum.php

-- 
--
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$$ Please help

[Rajan_Verma]

 

Try this

 

=LEN(SUBSTITUTE(C3,"#n/a",""))

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil panchal
Sent: Tuesday, July 26, 2011 6:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help

 

Dear Experts,

 

Please find the attached file . my questions is i have alphabets & Numbers
both in one cell now i want only count numbers like 123#n/aabcd345677 now i
want 9

 

 

 

Thanks & Regards

Anil Kumar

113784

-- 

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

Re: $$Excel-Macros$$ Please help

[ashish koul]

=LEN(SUBSTITUTE(a1,"#n/a",""))

On Tue, Jul 26, 2011 at 6:05 PM, anil panchal  wrote:

> Dear Experts,
>
> Please find the attached file . my questions is i have alphabets & Numbers
> both in one cell now i want only count numbers like 123#n/aabcd345677 now i
> want 9
>
>
>
> Thanks & Regards
> Anil Kumar
> 113784
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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$$ Please help

[anil panchal]

Dear Experts,

Please find the attached file . my questions is i have alphabets & Numbers
both in one cell now i want only count numbers like 123#n/aabcd345677 now i
want 9



Thanks & Regards
Anil Kumar
113784

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


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

$$Excel-Macros$$ Please help to create a excel macro code

[Crazy Guy]

Can u please help me in writing a macro in excel as below:

1) When we click on the command button, it should prompt for entering
the number in the input box.

2) After entering the number, it should take us to the cell that has
the numer.

3) and coresponding cell should be filled with current time.

Template is as below:

When i click the command button and enter the number 307304 in the
input box. it should take me to the particular cell and that start
time should be captured. if i click again end time should be captured.
(these times should be current time).

Employee # Start Time End Time
307301
307302
307303
307304
307305
307306
307307
307308
307309
307310

-- 
--
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: RE: $$Excel-Macros$$ Please help to make my project good.

[Susan]

Thank you!

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of GoldenLance
Sent: Monday, June 13, 2011 7:14 AM
To: excel-macros@googlegroups.com
Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.

 

=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2,
and then copy across to other cells

-- 

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

Re: RE: $$Excel-Macros$$ Please help to make my project good.

[GoldenLance]

=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2, 
and then copy across to other cells

-- 
--
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$$ Please help to make my project good.

[Susan]

Hi,

Please see attached spreadsheet in sheet named Practice OFFSET for my question. 
 Basically, how do you edit the formula to keep summing the column if you skip 
a cell in the column and enter numbers at random cells in the same column.

 

Thanks

~Sunnie

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of §»VIPER«§
Sent: Wednesday, May 11, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

pfa




On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

Hi

 

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be 
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another 
career i.e. Building and Construction so In sub career list data should comes 
from the Building and construction's sheet and If I select another career i.e. 
Catering and Hospitality so data should comes from its list (Catering and 
Hospitality) and scroll bar should work with the same. I have 16 careers so 
please tell me how can I do this.


Thnx in Advance



ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

 

-- 
--
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 
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com 
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 
<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




-- 
Thanks & Regards

Thamu

 

 

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


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

Re: $$Excel-Macros$$ please help me Urgent

[Sixthsense]

Hi Sukumar,

I am not sure whether this is what you are looking for.. Have a look in the
attached file whether it suits your requirement.

---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*


On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:

> Hi,
>
> Students English maths sceience   Grades
> suresha 45 80 90 90-100 A
> srinivas 25 36 60 80-90  b
> sunyana 38 65 70   60-80c
> sunitha 80 90 68 36-60  d
> vinay 40 28 60  0-35  fail
> Need to slove using multiple ifs (please give some more examples like this)
>
> pls see the attached file
>
>
>
> Thanks in advance
>
>
> sukumar
>
> --
>
> --
> 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


Solution File - Student Mark.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ please help me Urgent

[mohd saber]

hi sukumar,

please find attached.

regards,
saber

On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:

> Hi,
>
> Students English maths sceience   Grades
> suresha 45 80 90 90-100 A
> srinivas 25 36 60 80-90  b
> sunyana 38 65 70   60-80c
> sunitha 80 90 68 36-60  d
> vinay 40 28 60  0-35  fail
> Need to slove using multiple ifs (please give some more examples like this)
>
> pls see the attached file
>
>
>
> Thanks in advance
>
>
> sukumar
>
> --
>
> --
> 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


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

$$Excel-Macros$$ please help me Urgent

[vijayajith VA]

Hi,

Students English maths sceience   Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90  b
sunyana 38 65 70   60-80c
sunitha 80 90 68 36-60  d
vinay 40 28 60  0-35  fail
Need to slove using multiple ifs (please give some more examples like this)

pls see the attached file



Thanks in advance


sukumar

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


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

$$Excel-Macros$$ Please help to make my project good.

[Zafar Iqbal]

Dear Mr. Fabio Lemos,

 

I replaced ; with , and got the result. Thanks for this short formula.
Please discard my previous e-mail for sample file. Thanks

 

Regards,

ZAFAR IQBAL

From: Zafar Iqbal [mailto:ziqba...@gmail.com] 
Sent: Sunday, May 15, 2011 10:15 AM
To: 'Fabio Lemos'
Cc: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Please help to make my project good.

 

Dear Mr. Fabio Lemos,

 

Thanks for your interest. 

I tried to apply your below mentioned formula. I am getting error message. 

Can you please send me sample file with formula. Thanks a lot for this
kindness.

 

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Fabio Lemos
Sent: Saturday, May 14, 2011 7:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

You also could simplify the formula by inserting the following in the E2
cell:

 

=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0)

 

And tham just copy to the other

 

2011/5/13 Zafar Iqbal 

-- 
--
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$$ Please help to make my project good.

[Zafar Iqbal]

Dear Mr. Fabio Lemos,

 

Thanks for your interest. 

I tried to apply your below mentioned formula. I am getting error message. 

Can you please send me sample file with formula. Thanks a lot for this
kindness.

 

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Fabio Lemos
Sent: Saturday, May 14, 2011 7:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

You also could simplify the formula by inserting the following in the E2
cell:

 

=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0)

 

And tham just copy to the other

 

2011/5/13 Zafar Iqbal 

Dear, With due respect to your effort, I tried with a simplified formula and
got the same result. Please find the attached file with both formulas.
Thanks

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of §»VIPER«§
Sent: Thursday, May 12, 2011 8:36 AM

To: excel-macros@googlegroups.com

Subject: Re: $$Excel-Macros$$ Please help to make my project good.

pfa

On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

Hi

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another
career i.e. Building and Construction so In sub career list data should
comes from the Building and construction's sheet and If I select another
career i.e. Catering and Hospitality so data should comes from its list
(Catering and Hospitality) and scroll bar should work with the same. I have
16 careers so please tell me how can I do this.

-- 
--
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$$ Please help to make my project good.

[Fabio Lemos]

You also could simplify the formula by inserting the following in the E2
cell:

=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0)

And tham just copy to the other

2011/5/13 Zafar Iqbal 

>  Dear, With due respect to your effort, I tried with a simplified formula
> and got the same result. Please the attached file with both formulas. Thanks
>
>
>
> Regards,
>
> ZAFAR IQBAL
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *§»VIPER«§
> *Sent:* Thursday, May 12, 2011 8:36 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Please help to make my project good.
>
>
>
> pfa
>
>  On Thu, May 12, 2011 at 12:31 AM, Mahesh parab 
> wrote:
>
> Hi
>
>
>
> check whether attach file helps.
>
> On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:
>
> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
> --
>
> --
> 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
>



-- 
Fabio Lemos

e-mail: flnle...@gmail.com

-- 
--
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$$ Please help to make my project good.

[Zafar Iqbal]

Dear, With due respect to your effort, I tried with a simplified formula and 
got the same result. Please the attached file with both formulas. Thanks

 

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of §»VIPER«§
Sent: Thursday, May 12, 2011 8:36 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

pfa



On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

Hi

 

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be 
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another 
career i.e. Building and Construction so In sub career list data should comes 
from the Building and construction's sheet and If I select another career i.e. 
Catering and Hospitality so data should comes from its list (Catering and 
Hospitality) and scroll bar should work with the same. I have 16 careers so 
please tell me how can I do this.

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


Simplified IF with Offset.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help to make my project good.

[§»VIPER«§]

pfa



On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

> Hi
>
> check whether attach file helps.
>
> On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:
>
>> Respected Sirs/Mam,
>>
>> I need your help making my project good.  Please find attachment. I will
>> be very obliged if someone can help me as earlier as possible.
>>
>> --
>> Basically I have to do that when I click on drop down list & select
>> another career i.e. Building and Construction so In sub career list data
>> should comes from the Building and construction's sheet and If I select
>> another career i.e. Catering and Hospitality so data should comes from its
>> list (Catering and Hospitality) and scroll bar should work with the same. I
>> have 16 careers so please tell me how can I do this.
>>
>>
>> Thnx in Advance
>>
>> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>>
>> --
>>
>> --
>> 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
>



-- 
*Thanks & Regards

Thamu
*

*
*

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


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

RE: $$Excel-Macros$$ Please help to make my project good.

[Anil Bhange]

Hi Karan,

Use this formula,

=OFFSET(IF($A$2="Administration, Business and Office Work",'Administration, 
Business and Of'!A1,IF($A$2="Building and Construction",'Building and 
Construction'!B1,'Catering and Hospitality'!A1)),'Building and 
Construction'!$I$2,0)

And copy in all your gray cells

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of karan 1237
Sent: Wednesday, May 11, 2011 3:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help to make my project good.

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be 
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another 
career i.e. Building and Construction so In sub career list data should comes 
from the Building and construction's sheet and If I select another career i.e. 
Catering and Hospitality so data should comes from its list (Catering and 
Hospitality) and scroll bar should work with the same. I have 16 careers so 
please tell me how can I do this.


Thnx in Advance

ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

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

Re: $$Excel-Macros$$ Please help to make my project good.

[Mahesh parab]

Hi

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
>
> Thnx in Advance
>
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
> --
>
> --
> 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


Help_Required_Solution.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help to make my project good.

[STDEV(i)]

please check the attachment if it helps..

best regards,
STDEV(i)


note:
we need dynamic* Max Value* of ScrollBar
so we use Scroolbar from ActiveX Control, instead of from FORM.
A little macro wil work each time you change the "career"



On Wed, May 11, 2011 at 5:21 PM, karan 1237  wrote:

> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
>
> Thnx in Advance
>
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>

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


ctv_Indirect And Address FUNCTION.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Please help to make my project good.

[karan 1237]

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another
career i.e. Building and Construction so In sub career list data should
comes from the Building and construction's sheet and If I select another
career i.e. Catering and Hospitality so data should comes from its list
(Catering and Hospitality) and scroll bar should work with the same. I have
16 careers so please tell me how can I do this.


Thnx in Advance

ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

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


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

$$Excel-Macros$$ please help me

[Satish Bandaru]

hi experts

please help me to get my requirements to maintain my drugdata.please find
the attachment.if it possible in excel please helpme.

thanx in advance.

regards
jasmin

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


drugdata.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please Help

[karan 1237]

*Thank you so much. I am very grateful to you.

*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı



On Sun, May 8, 2011 at 6:59 AM, STDEV(i)  wrote:

>
> try to use this UDF (user defined function)
> Function UniqueList(Dat As Range)
>' List of UnSorted Unique Values  '
>'-'
>Dim Cel As Range, vArr(), n As Long, Tx As String
>Tx = ", "
>For Each Cel In Dat
>   If InStr(1, Tx, ", " & Cel & ", ") = 0 Then
>  Tx = Tx & Cel & ", "
>   End If
>Next Cel
>If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2)
>If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2)
>UniqueList = Tx
> End Function
>
>
>
> On Sat, May 7, 2011 at 3:50 PM, karan 1237  wrote:
>
>>   *
>> LIST1* *LIST1* *LIST1* *RESULT*  BACK SIDE FRONT BACK, SIDE, FRONT  FRONT
>> SIDE FRONT FRONT, SIDE  BACK FRONT BACK BACK, FRONT  FRONT FRONT FRONT
>> FRONT
>> *Hi Experts,
>>
>> I want like this. Please help.
>>
>> Thnx in Advance.
>>
>>
>> *
>> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>>
>>  --
>>
>> --
>> 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
>

-- 
--
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$$ Please Help

[STDEV(i)]

try to use this UDF (user defined function)
Function UniqueList(Dat As Range)
   ' List of UnSorted Unique Values  '
   '-'
   Dim Cel As Range, vArr(), n As Long, Tx As String
   Tx = ", "
   For Each Cel In Dat
  If InStr(1, Tx, ", " & Cel & ", ") = 0 Then
 Tx = Tx & Cel & ", "
  End If
   Next Cel
   If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2)
   If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2)
   UniqueList = Tx
End Function



On Sat, May 7, 2011 at 3:50 PM, karan 1237  wrote:

>   *
> LIST1* *LIST1* *LIST1* *RESULT*  BACK SIDE FRONT BACK, SIDE, FRONT  FRONT
> SIDE FRONT FRONT, SIDE  BACK FRONT BACK BACK, FRONT  FRONT FRONT FRONT
> FRONT
> *Hi Experts,
>
> I want like this. Please help.
>
> Thnx in Advance.
>
>
> *
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
>  --
>
> --
> 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


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

Re: $$Excel-Macros$$ Please Help

[ashish koul]

try the attachment



On Sat, May 7, 2011 at 2:20 PM, karan 1237  wrote:

> *
> LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT
> SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT
> *Hi Experts,
>
> I want like this. Please help.
>
> Thnx in Advance.
>
>
> *
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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


Help(1).xlsm
Description: Binary data

$$Excel-Macros$$ Please Help

[karan 1237]

  *
LIST1* *LIST1* *LIST1* *RESULT*  BACK SIDE FRONT BACK, SIDE, FRONT  FRONT
SIDE FRONT FRONT, SIDE  BACK FRONT BACK BACK, FRONT  FRONT FRONT FRONT FRONT
*Hi Experts,

I want like this. Please help.

Thnx in Advance.


*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

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


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

Re: $$Excel-Macros$$ Please Help

[ashish koul]

try this

=B3/(RIGHT(C3,LEN(C3)-FIND("~",SUBSTITUTE(C3,"
","~",LEN(C3)-LEN(SUBSTITUTE(C3," ","")*1)

On Wed, Apr 27, 2011 at 7:32 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:

> Dear Gurus,
>
> Please advise any formula to calculate the Book Value in given attachment.
>
> Thanks in Advance
>
> Regards,
> Shrinivas
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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$$ Please Help

[Chidurala, Shrinivas]

Dear Gurus,

Please advise any formula to calculate the Book Value in given attachment.

Thanks in Advance

Regards,
Shrinivas

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


Help.xls
Description: Help.xls

Re: $$Excel-Macros$$ Please Help.................

[NOORAIN ANSARI]

Thanks a lot of Setiywati(STDEV). and Ashish...
it's working fine

On Wed, Apr 27, 2011 at 3:50 PM, STDEV(i)  wrote:

> by hiding application objec at time of userform initialized or activated
> Application.visible = False
>
> and don' forget to unhide the aplication (excel) at time of userform
> deactivated or unloaded
> Application.visible = False
>
> se attachaed workbook
>
>
>
> On Wed, Apr 27, 2011 at 1:38 PM, NOORAIN ANSARI 
> wrote:
>
>>  Dear Experts,
>>
>> How can Hide only workbook but userform should be visilble and work as it,
>> when we click on "*Eng In out Report*"  button.
>> Please see attached sheet..
>>
>> Thanks in Advance
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>
> --
>
> --
> 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
>



-- 
Thanks & regards,
Noorain Ansari

-- 
--
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$$ Please Help.................

[STDEV(i)]

by hiding application objec at time of userform initialized or activated
Application.visible = False

and don' forget to unhide the aplication (excel) at time of userform
deactivated or unloaded
Application.visible = False

se attachaed workbook



On Wed, Apr 27, 2011 at 1:38 PM, NOORAIN ANSARI wrote:

> Dear Experts,
>
> How can Hide only workbook but userform should be visilble and work as it,
> when we click on "*Eng In out Report*"  button.
> Please see attached sheet..
>
> Thanks in Advance
>
> --
> Thanks & regards,
> Noorain Ansari
>

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


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

$$Excel-Macros$$ Please Help.................

[NOORAIN ANSARI]

 Dear Experts,

How can Hide only workbook but userform should be visilble and work as it,
when we click on "*Eng In out Report*"  button.
Please see attached sheet..

Thanks in Advance

-- 
Thanks & regards,
Noorain Ansari




-- 
Thanks & regards,
Noorain Ansari

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


Query.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Please Help

[Umesh Dev]

Hi Sudhir,

In the excel sheet which you have send me, for the party name "b"  on 14th
March you have mentioned 1700 as the pending amount.
My question is How do you come to arrive at this figure? 1700


Regards
Umesh



On Mon, Mar 21, 2011 at 9:13 PM, sudhir kumar  wrote:

> Hi,
>
> Thanx and It's feel good to see done with macro. And how to copy it to my
> main
> workbook.
>
> Meaning of Pending Amount : It mean's payment which was not collected yet.
>
> Regards
> Sudhir
>
> On 21/03/2011, Umesh Dev  wrote:
> > Hi Sudhir,
> >
> > Check if its working. I have done it for only "Running Balance". I am not
> > clear with the " Pending Amount" the numbers are contradicting in the
> format
> > which you had attached. if you can let me know how it is done. I can
> rework
> > the code.
> >
> >
> > Regards
> > Umesh Dev
> >
> > On Sat, Mar 19, 2011 at 12:15 PM, sudhir kumar  >wrote:
> >
> >> Hi
> >>
> >> Running balance mean's outstanding of Parties on left side display date.
> >> Pending amount mean's pending bills upto outstanding.
> >>
> >> thanx
> >>
> >>
> >>
> >>
> >> On 19 March 2011 05:27, Umesh Dev  wrote:
> >>
> >>> Hi Sudhir,
> >>>
> >>> It is still not clear, how to get the Running Bal and the Pending
> Amount.
> >>>
> >>>
> >>> Regards
> >>> Umesh
> >>>
> >>>
> >>> On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar
> >>> wrote:
> >>>
>  Dear Experts,
> 
> 
>  Please read my attachment and solve it.
> 
>  thanx
> 
> 
> 
>  <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
>  Sudhir Verma
>  Asstt. Mngr. A/c's
>  9818479722
> 
>  --
> 
> 
> --
>  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
> >>>
> >>
> >>
> >>
> >> --
> >> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> >> Sudhir Verma
> >> Asstt. Mngr. A/c's
> >> 9818479722
> >> *
> >> P think Before you print
> >> *
> >> *
> >> **
> >> Life is Very beautiful !!!
> >> *
> >> *
> >> ¨`•.•´¨) Always
> >> `•.¸(¨`•.•´¨) Keep
> >> (¨`•.•´¨)¸.•´ Smiling!
> >>  `•.¸.•´.
> >> *
> >> *
> >>  *
> >>  *Happy **Valentine** Day  *
> >>  \ ¦ /
> >> (ò ó)
> >> _ ___o0o___(_)___o0o__
> >> ___¦_¦_¦_¦_¦
> >> ¦_¦_¦_¦_¦__
> >> ___¦_¦_¦_¦_¦
> >> *Drink Bear Save Water*
> >> *
> >> *
> >>
> >>  --
> >>
> >>
> --
> >> 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

Re: $$Excel-Macros$$ Please Help

[sudhir kumar]

Hi,

Thanx and It's feel good to see done with macro. And how to copy it to my main
workbook.

Meaning of Pending Amount : It mean's payment which was not collected yet.

Regards
Sudhir

On 21/03/2011, Umesh Dev  wrote:
> Hi Sudhir,
>
> Check if its working. I have done it for only "Running Balance". I am not
> clear with the " Pending Amount" the numbers are contradicting in the format
> which you had attached. if you can let me know how it is done. I can rework
> the code.
>
>
> Regards
> Umesh Dev
>
> On Sat, Mar 19, 2011 at 12:15 PM, sudhir kumar wrote:
>
>> Hi
>>
>> Running balance mean's outstanding of Parties on left side display date.
>> Pending amount mean's pending bills upto outstanding.
>>
>> thanx
>>
>>
>>
>>
>> On 19 March 2011 05:27, Umesh Dev  wrote:
>>
>>> Hi Sudhir,
>>>
>>> It is still not clear, how to get the Running Bal and the Pending Amount.
>>>
>>>
>>> Regards
>>> Umesh
>>>
>>>
>>> On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar
>>> wrote:
>>>
 Dear Experts,


 Please read my attachment and solve it.

 thanx



 <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
 Sudhir Verma
 Asstt. Mngr. A/c's
 9818479722

 --

 --
 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
>>>
>>
>>
>>
>> --
>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
>> Sudhir Verma
>> Asstt. Mngr. A/c's
>> 9818479722
>> *
>> P think Before you print
>> *
>> *
>> **
>> Life is Very beautiful !!!
>> *
>> *
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>>  `•.¸.•´.
>> *
>> *
>>  *
>>  *Happy **Valentine** Day  *
>>  \ ¦ /
>> (ò ó)
>> _ ___o0o___(_)___o0o__
>> ___¦_¦_¦_¦_¦
>> ¦_¦_¦_¦_¦__
>> ___¦_¦_¦_¦_¦
>> *Drink Bear Save Water*
>> *
>> *
>>
>>  --
>>
>> --
>> 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
>


-- 
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.
*
*
*
 *Happy **Valentine** Day  *
 \ ¦ /
 

Re: $$Excel-Macros$$ Please Help

[Umesh Dev]

Hi Sudhir,

Check if its working. I have done it for only "Running Balance". I am not
clear with the " Pending Amount" the numbers are contradicting in the format
which you had attached. if you can let me know how it is done. I can rework
the code.


Regards
Umesh Dev

On Sat, Mar 19, 2011 at 12:15 PM, sudhir kumar wrote:

> Hi
>
> Running balance mean's outstanding of Parties on left side display date.
> Pending amount mean's pending bills upto outstanding.
>
> thanx
>
>
>
>
> On 19 March 2011 05:27, Umesh Dev  wrote:
>
>> Hi Sudhir,
>>
>> It is still not clear, how to get the Running Bal and the Pending Amount.
>>
>>
>> Regards
>> Umesh
>>
>>
>> On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar wrote:
>>
>>> Dear Experts,
>>>
>>>
>>> Please read my attachment and solve it.
>>>
>>> thanx
>>>
>>>
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
>>> Sudhir Verma
>>> Asstt. Mngr. A/c's
>>> 9818479722
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
>  *
>  *Happy **Valentine** Day  *
>  \ ¦ /
> (ò ó)
> _ ___o0o___(_)___o0o__
> ___¦_¦_¦_¦_¦
> ¦_¦_¦_¦_¦__
> ___¦_¦_¦_¦_¦
> *Drink Bear Save Water*
> *
> *
>
>  --
>
> --
> 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


Day Book-1.xlsm
Description: Binary data