Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

[Mohammed Muneer]

  

Dear Friend, 

Rajan Congratulations to you for u r successful efforts.

Keep the same track and be the no. 1 always.

Excellent works!

 

Praises & Prosperity,

Muneer,

CC...

 

On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh 
wrote:

Congrats dude!




Karan Singh





On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad <
aamirshahza...@gmail.com> wrote:

Congrates Rajan

Aamir Shahzad

On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh 
wrote:

 

Congratulations Rajan Sir. 

 

Regards,
Kuldeep Singh

Back Office Executive (MIS)

Info Edge India Limited (naukri.com  )

Phone.: +91-120-4763789  , Extn.: 789, 971615535
naukrikuld...@gmail.com || www.naukri.com   || 
www.naukrigulf.com  
Please Consider the environment. Please don't print this e-mail unless
you really need to. 

 

On Tue, Oct 2, 2012 at 11:32 PM, Christi Jacob 
wrote:

Congrats Rajan,

Worthy winner!

 

CVJ

On Tue, Oct 2, 2012 at 9:40 PM,  wrote:

Congrats... Rajan..

Keep it up buddy by sharing your exceptional knowledge..

Rgds//Vabs

Sent on my BlackBerry(r) from Vodafone



From: "Rajan_Verma"  

Sender: excel-macros@googlegroups.com 

Date: Tue, 2 Oct 2012 21:38:08 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: RE: $$Excel-Macros$$ Rajan Verma - Most Helpful Member
September 2012

 

Thank you sam.

 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: 02 October 2012 9:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member
September 2012

 

Congratulations Rajan

Regards,
Sam

On Tue, Oct 2, 2012 at 9:03 PM, Ayush Jain 
wrote:

Dear members,

 
Rajan Verma has been selected as 'Most Helpful Member' for the month of
Sep'12. He has posted 137 posts in last month and helped forum members
through his excel expertise.

I truly appreciate his knowledge, consistency and commitment to the
group.


Rajan, please find enclosed the award certificate in honor of your
contribution. Congratulations and thanks for your contribution.


Thanks to Vabz, Don, Paul, Prince, Noorain, Kuldeep, David and all other
folks for helping excel enthusiasts voluntarily !! 
Keep posting.
 
Regards,

Ayush Jain

Group Manager

P.S. If you have any feedback, please share your thoughts by filling the
survey form
 . 

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

-- 
Join official face

RE: $$Excel-Macros$$ Data validation.xls

[Mohammed Muneer]

Dear Excel Learner,

 

Thank you yea buddy!

 

Happy!

Fulfills the need!

 

More than expected, Good!

 

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.

RE: $$Excel-Macros$$ Data validation.xls

[Mohammed Muneer]

Hi Muneer,

The formula will get the result, unless and until the criteria's are
matching. The main purpose of implementing the data validation is to
restrict the user from entering any kind of data.  In this case the user
is allowed to select only the items which is present in the drop down.
But the drop down data is having lot of duplicated data and which is not
the fair way.

Any how, formula will work fine without the need of data validation,
when the the criteria's are matching.

Hope that helps!
<><><><><><>
Ms.Exl.Learner
<><><><><><>

 

 

 

 

Dear Friend

Excel Learner,

 

Except the month col, the other like Description (in separate place in
the col itself - as I have the repeated items in Description col, Sweet,
Sewage, Garbage, Potable & Bottles) column if I apply data validation.

 

Finally I come to the decision I will put halt to this problem, by
keeping the - Month col data validated, Description col data validated &
Cost Code col by calling vlookup formula that will result into
automation with Description (means Description if gets active, then cost
code also be active).

 

 

 

Very very thanks for u r reply..

 

 

Please suggest in ur way to finish.

 

 

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.

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

[Mohammed Muneer]

Dear Joseph,

 

I haven't done any research on this; I will give u simple idea about.

 

I don't have perfect understanding (but I can say, there are 2 arguments
that form one entity here-"come under single bracket". Broadly that
might be the reason we use the (--) like this. 

 

sorry not now when I am free I will give u little more explanation. I
think the experts already now they will help u meanwhile. Wait for the
explanation from others also.

 

Now I am little busy, when I get time I'll do this help for u.

 

Regards,

Muneer,

CC

 

Hi Muneer, could you please share your understanding for my benefit.

Thanks,
Joseph 

Sent on my BlackBerry(r) from Vodafone

____

From: "Mohammed Muneer"  

Sender: excel-macros@googlegroups.com 

Date: Mon, 24 Sep 2012 17:19:12 +0300

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: RE: $$Excel-Macros$$ Sum() formula considering multiple values!

 

=SUMPRODUCT(--($A$3:$A$85=G5),--($B$3:$B$85=H5),--($C$3:$C$85=I5)*($D$3:
$D$85)) [your's]

 

=SUMPRODUCT(--($A$3:$A$85=F5),--($B$3:$B$85=G5),--($C$3:$C$85=H5)*($D$3:
$D$85)) [mine]

 

Small change is made.

The only difference as per the attachment, is F5 in place of G5 and as
follows for all the remaining.

 

Anyway u did well.

 

Last time I pass the question in my posting regarding the two dash (--)
now I understand where it is used and for what purpose.

 

These two dashes are jewels in this formula.

 

Well my friend that made my work easier.

 

 

 

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

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

[Mohammed Muneer]

=SUMPRODUCT(--($A$3:$A$85=G5),--($B$3:$B$85=H5),--($C$3:$C$85=I5)*($D$3:
$D$85)) [your's]

 

=SUMPRODUCT(--($A$3:$A$85=F5),--($B$3:$B$85=G5),--($C$3:$C$85=H5)*($D$3:
$D$85)) [mine]

 

Small change is made.

The only difference as per the attachment, is F5 in place of G5 and as
follows for all the remaining.

 

Anyway u did well.

 

Last time I pass the question in my posting regarding the two dash (--)
now I understand where it is used and for what purpose.

 

These two dashes are jewels in this formula.

 

Well my friend that made my work easier.

 

 

 

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.

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

[Mohammed Muneer]

Dear,

 

Ashish & David thank u friends both of u.

 

 

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.

RE: $$Excel-Macros$$ -- (what does it mean?) in the formula.

[Mohammed Muneer]

Dear Noor,

Thanx for u r help.

I come to know about this before itself, my question directs you to
glance my knowledge.

I don't have anything now to do with it but if I have anything later.

 

It doesn't bear any urgency only for clarification.

 

 

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.

$$Excel-Macros$$ -- (what does it mean?) in the formula.

[Mohammed Muneer]

  

 
=IF($B$3:$B$22=$M4,SUMPRODUCT(--($H$3:$K$12=1)),SUMPRODUCT(--($H$13:$K$2
2=1)))

 

Dear Group,

 

Please explain in short or little elaborate and tell.

 

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.


<>

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

[Mohammed Muneer]

Dear Noor,

 

Congratulations friend, this is a really a landmark on whole excel
platform.

 

U r doing a tremendously great job, by bringing untiring efforts from u
r side to help all the group members - when they are at a stage of
feeling helpless to solve the problems arising in excel formula,
functions and vba.

 

The problem in excel are mountain in size when coming to solve them by
ourselves, but for u the problem is trivial and of mole sized.

 

I am happy to hear from Mr. Ayush the excel macros group MVP.

 

Fairly it's worth sharing this moment with all of us, and getting the
greetings from the group members.

 

At last keep it up!

 

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.

RE: $$Excel-Macros$$ Word Wrap in Excel.....

[Mohammed Muneer]

Dear Paul,

 

Your solution is good to some extent, but the thing is I don't want to
use the merge or any option that is default in excel.

 

I need a vba coding to control the text flow unto the page break only,
when one line is finish it should go to  the another line.

 

Ur example for merge and make the text to flow in a defined region is
itself a good example, what I am trying to explain in the worksheet.

 

Anyway I have done the major part of my work still part of it left
undone, this I will complete it within two days.

 

U know along with the line to line flow I need to justify the text
written.

 

 

Regards,

Muneer,

CC...

 

 

 

 

 

I think part of the problem is that you're not using the proper
terminology and are not describing your issue accurately.

In addition, your examples do not demonstrate the problem.

 

After spending WAY too much time trying to figure out what you're trying
to do,

I think I finally see your problem

 

First of all.. "Word Wrap" is the ability for a SINGLE PARAGRAPH to

"wrap" to an additional line within the same CELL when the 

sentence exceeds the with of the CELL.

 

So... "Word Wrap" is a property assigned to a CELL or a group of MERGED
CELLS.

 

Not to a group of cells in different rows.

(Unless, of course, you merge the rows, then it treats it as a single
cell)

 

 

So.. in column E, rows 11-15 you have:

E11: To be held accountable for the construction of their work packages
and tasks and ensure their
E12: participation  in  implementing  proper  control  for  the
completion of their scope of work within 
E13: budget and schedule. Each task controller and each work package
supervisor  is  accountable 
E14: for his participation in cost control process in his area of work.
This leads to more awareness, 
E15: economical working methods, and timely corrective actions.

 

Excel doesn't have any way of knowing that the contents of the
successive

rows are part of the same "paragraph".

 

Excel, by default, does not "break" a single row into two pages.

 

So, the first thing you need to do is to put your entire paragraph into
one cell.

that means, you need to "merge" the cells in columns E-K 

(or E-L, if you're going to the edge) 

 

I would do this for all rows so that you can easily fill out future
documents.

 

Next.. Excel doesn't auto-fit row heights for merged cells.

(which is unfortunate, it would make my life SO much easier)

 

To get around that, what I've done is create another cell (off to the
right)

that is the same width as the combined cells you've merged.

then, use the formula: =E# (i.e. =E11)

to display the contents in this cell.

You'll need to make sure the font size in this cell is the same as
you're using

in the document cells.

 

You can hide this column so that it doesn't confuse people.

 

This will cause the row height to adjust to the contents of the
paragraph you insert.

 

hopefully, the file I've attached will come across and show you what I
mean.

 

 

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: Mohammed Muneer 
To: excel-macros@googlegroups.com
Sent: Tue, August 14, 2012 8:33:42 AM
Subject: $$Excel-Macros$$ Word Wrap in Excel.

 

  Dear Group,

  

  Please make haste, if u can! 

 

  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.

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

$$Excel-Macros$$ Hightlight the text for day Fridays only.....

[Mohammed Muneer]

Dear Group, 
 
Please highlight the text in column B based on Friday.
 
 
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.




hi-lite based on date.xls
Description: hi-lite based on date.xls

$$Excel-Macros$$ Word Wrap in Excel......

[Mohammed Muneer]

  

  Dear Rajan,

 

  See the attached sheet (Word Wrap 1)

  

  Ref: to the reply

 

  And thanx for the reply

 

  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.


<>

word wrap 1.xls
Description: word wrap 1.xls

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.

$$Excel-Macros$$ Happy independence day

[Mohammed Muneer]

Dear Ayush,

 

Please allow me to send the greetings to my friends for a moment.

 

 Happy independence day to all

my Indian brothers

 

   Happy Independence Day 

-

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.


<>

$$Excel-Macros$$ Activate the word wrap option in excel......

[Mohammed Muneer]

  

  

Dear friends,

 

I want to make active the word wrap option here so that the text train
should not cross the page break while typing.

  

  Any formula or vba code is there to be adopted to apply on this.

  

  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.


<>

word wrap in excel.xls
Description: word wrap in excel.xls

$$Excel-Macros$$ Make Bold the relevant data.....

[Mohammed Muneer]

  

  Dear Group,

 

  Make bold the data relevant in the below rows that follows the yellow
highlighted in cell A1.

 

 

 

  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.


<>

Make Bold the relevant.xls
Description: Make Bold the relevant.xls

RE: $$Excel-Macros$$ Sumif / Sumproduct formula required.

[Mohammed Muneer]

Thanx Noor for this also,

But I need to change the description in same cell to get individual
total.

Sewage/Sweet/Garbage all this totals from one cell.

Hope u understand this time.

Regards,

Muneer,

CC...

see attached sheet.

On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI
 wrote:

Dear Muneer,

Please use below formula 

=SUMPRODUCT((A2:A8=D5)*(B2:B8))

or 

=Sumif(A2:A8,d5,B2:B8) 

 

On Thu, Jul 12, 2012 at 3:49 PM, Mohammed Muneer 
wrote:

Dear friends,

 

I want to call a function/formula here that show me the sum of the each
item separately from the given descriptions.

 

 

 

 

Regards,

Muneer,

CC.

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

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

 



 




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

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

$$Excel-Macros$$ Sumif / Sumproduct formula required.

[Mohammed Muneer]

Dear friends,
 
I want to call a function/formula here that show me the sum of the each
item separately from the given descriptions.
 
 
 
 
Regards,
Muneer,
CC.

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

Book1.xls
Description: Book1.xls

RE: $$Excel-Macros$$ Extracting a word from the cell.......

[Mohammed Muneer]

 

Good Morning,

Hi Priti,

 

Ya working fine!

 

Thanks to u,

 

Regards,

Muneer,

CC...

__

Hi Muneer

 

To Extract 1st Word use this : =LEFT(A2,FIND(" ",A2,1)-1)

To Extract Last word use this :  =MID(A2,FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2,"
","",LEN(A2)-FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2," ",""+1)

 

I think the better way is  to extract All word in different columns use
Text To Column Delimited by Space character , 

See the attached file.

 

Thanks 

Priti Verma

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: 11 July 2012 10:20
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Extracting a word from the cell...

 

Dear Rajan & Priti Verma,

 

Any one word, left / right / middle.

 

Thanx both of u, for the reply.

 

Like - Sweet, Sewage & Portable.

 

In order to filter my data easily.

 

 

Regards,

Muneer,

CC...

__

Which word you want to extract?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]



 

Hi, Muneer , I want  to ask u ,which word u want to extract , last or
middle

 

Regards 

Priti verma

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com]
<mailto:%5bmailto:excel-macros@googlegroups.com%5d>  On Behalf Of
Mohammed Muneer
Sent: 10 July 2012 7:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extracting a word from the cell...

 

  

Hi! Everybody,

Dear Group, 

 

I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment.

 

 

 

Regards,

Muneer,

CC

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

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

RE: $$Excel-Macros$$ Extracting a word from the cell.......

[Mohammed Muneer]

Wow! Superb here r the efforts.

 

 

Regards,

Muneer,

CC

 

Muneer Ji,

PFA.

For First Word:- 
=IFERROR(LEFT(G2,FIND(" ",G2,1)),"G2")

For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND(" ",G2,1)),FIND("
",RIGHT(G2,LEN(G2)-FIND(" ",G2,1,"")

For third:-
=IFERROR(IF(LEN(C2&F2)+2>=LEN(G2),"",MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2&F2)
-7)),"")

For Forth:-
=IFERROR(RIGHT(G2,LEN(G2)-FIND("#",SUBSTITUTE(G2,"
","#",LEN(G2)-LEN(SUBSTITUTE(G2," ",""),"G2")


 

Thanks & Regards,
Deba Ranjan P

 





On Wed, Jul 11, 2012 at 10:21 AM, Deba Ranjan 
wrote:

Hi Shai,

For First Word:- 
=IFERROR(LEFT(G2,FIND(" ",G2,1)),"G2")

For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND(" ",G2,1)),FIND("
",RIGHT(G2,LEN(G2)-FIND(" ",G2,1,"")

For third:-
=IFERROR(IF(LEN(C2&F2)+2>=LEN(G2),"",MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2&F2)
-7)),"")

For Forth:-
=IFERROR(RIGHT(G2,LEN(G2)-FIND("#",SUBSTITUTE(G2,"
","#",LEN(G2)-LEN(SUBSTITUTE(G2," ",""),"G2")


 

Thanks & Regards,
Deba Ranjan P

 





On Wed, Jul 11, 2012 at 10:02 AM, Abdulgani Shaikh
 wrote:

This is really great ! 

 

Suppose I want extract 2nd or 3rd or 4th word, then ?

 

Regards 

 

 

On Wed, Jul 11, 2012 at 9:39 AM, Mohammed Muneer 
wrote:

Dear Don,

Superb & Innovative.

Keep it up!

Both code and formula good.

 

 

"Experience is the mother of Knowledge"

 

Whenever I receive a help from u people, in a fraction of seconds I feel
myself why I can't do this magic by myself.

But I keep trying to do some until I get an idea.

 

But I never felt unhappy on my failure.

 

Pray for me, I will be one among u who r active hands for these group
members.

 

Lots of thanks...

 

 

Regards,

Muneer,

CC



 

If you are saying you want the first word in a string then 

=LEFT(D10,FIND(" ",D10))

or

 

Sub fw()

For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row

Cells(i, "c").Value = Left(Cells(i, "d"), InStr(1, Cells(i, "d"), " "))

Next i

End Sub

 

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Tuesday, July 10, 2012 9:25 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Extracting a word from the cell...

 

  

Hi! Everybody,

Dear Group, 

 

I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment.

 

 

 

Regards,

Muneer,

CC

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

RE: $$Excel-Macros$$ Extracting a word from the cell.......

[Mohammed Muneer]

Dear Rajan & Priti Verma,

 

Any one word, left / right / middle.

 

Thanx both of u, for the reply.

 

Like - Sweet, Sewage & Portable.

 

In order to filter my data easily.

 

 

Regards,

Muneer,

CC...

__

Which word you want to extract?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]



 

Hi, Muneer , I want  to ask u ,which word u want to extract , last or
middle

 

Regards 

Priti verma

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: 10 July 2012 7:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extracting a word from the cell...

 

  

Hi! Everybody,

Dear Group, 

 

I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment.

 

 

 

Regards,

Muneer,

CC

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

RE: $$Excel-Macros$$ Extracting a word from the cell.......

[Mohammed Muneer]

Dear Don,

Superb & Innovative.

Keep it up!

Both code and formula good.

 

 

"Experience is the mother of Knowledge"

 

Whenever I receive a help from u people, in a fraction of seconds I feel
myself why I can't do this magic by myself.

But I keep trying to do some until I get an idea.

 

But I never felt unhappy on my failure.

 

Pray for me, I will be one among u who r active hands for these group
members.

 

Lots of thanks...

 

 

Regards,

Muneer,

CC



 

If you are saying you want the first word in a string then 

=LEFT(D10,FIND(" ",D10))

or

 

Sub fw()

For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row

Cells(i, "c").Value = Left(Cells(i, "d"), InStr(1, Cells(i, "d"), " "))

Next i

End Sub

 

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Tuesday, July 10, 2012 9:25 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Extracting a word from the cell...

 

  

Hi! Everybody,

Dear Group, 

 

I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment.

 

 

 

Regards,

Muneer,

CC

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

$$Excel-Macros$$ Extracting a word from the cell.......

[Mohammed Muneer]

  

  

Hi! Everybody,

Dear Group, 

 

I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment.

 

 

 

Regards,

Muneer,

CC

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

Exerciseformula.xls
Description: Exerciseformula.xls

$$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

[Mohammed Muneer]

  

Good Mornings

Dear Ashish & Dilip Congrats for both of you, have a nice journey in
future and greater the talents.

 

 

 

 

Prayers & Blessings,

Muneer,

CC...

 .

-- 
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$$ FW: Highlighting the Text based on the Week day.....

[Mohammed Muneer]

Dear Friends,

 

Its working, thanks for the instant help.

 

I finish my task this morning, I kick the ball in their ground to let
the other department play.

 

So happy!

 

I thought I could not finish. But done!

 

 

 

Regards,

Muneer,

CC

-- 
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$$ FW: Highlighting the Text based on the Week day.....

[Mohammed Muneer]

Sorry I forgot to attaché the file...

 

 

Regards,

Muneer,

CC...

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

Dear Friends,  

 

If the day in col - A is Friday the Text in col - B should get
highlighted - please help me I need a VBA code in this to solve.

 

My file carry large no.of this kind of data in my excel sheet. That's
the reason I need to approach this method.

 

If necessary please do it little urgent.

 

 

Regards,

Muneer,

CC

<>--- End Message ---


hi-lite based on date.xls
Description: hi-lite based on date.xls

$$Excel-Macros$$ Highlighting the Text based on the Week day.....

[Mohammed Muneer]

  

Dear Friends,  

 

If the day in col - A is Friday the Text in col - B should get
highlighted - please help me I need a VBA code in this to solve.

 

My file carry large no.of this kind of data in my excel sheet. That's
the reason I need to approach this method.

 

If necessary please do it little urgent.

 

 

Regards,

Muneer,

CC

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

FW: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

[Mohammed Muneer]

Dear Rajan, 

 

Congratulations..

 

Keep the same stream always...

 

 

 

Regards,

Muneer,

CC

-- 
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$$ NEW RULE : No more job postings in this forum.

[Mohammed Muneer]

Mr. Ayush I also support u r decision to ban those who post the job
offer applications.

 

 

 

Regards,

Muneer,

CC...

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

FW: $$Excel-Macros$$ Find the number missing in other cols

[Mohammed Muneer]

HI, Rajan its working that's what I exactly want to do.

 

Thanx Buddy

 

 

 

Regards,

Muneer,

CC

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

Put this in F2 and Drag

 

=IF(COUNTIF($A$2:$C$11,E2),"","Not Present")

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: 19 May 2012 6:42
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find the number missing in other cols

 

You need to make this clear

 

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Saturday, May 19, 2012 7:32 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Find the number missing in other cols

 

Dear friends,

 

I have a set of cols called A B C & D can please help me to solve the issue..

 

Note: please check the attached copy for further understanding.

 

 

 

Regards,

Muneer,

CC..

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

--- End Message ---

$$Excel-Macros$$ Find the number missing in other cols

[Mohammed Muneer]

Dear friends,

 

I have a set of cols called A B C & D can please help me to solve the
issue..

 

Note: please check the attached copy for further understanding.

 

 

 

Regards,

Muneer,

CC..

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


Book1.xls
Description: Book1.xls

RE: $$Excel-Macros$$ Table data fit the page size..(auto)

[Mohammed Muneer]

Ya, u r right.

 

 

Regards,

Muneer,

CC.

 

 

 

 

Are you talking about fitting when viewing or printing. 

 

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Tuesday, May 08, 2012 11:32 PM

To: excel-macros@googlegroups.com 

Subject: RE: $$Excel-Macros$$ Table data fit the page size..(auto)

 

Ya, but it doesn't zoom to the margin, and fit all the four sides.

 

 

Regards,

Muneer,

CC

 

 

 

 

I see you already have it fit to page when printed - 

 

Do you mean you want to have the table forced into the shape of the page
to completely fill the page?

 

If so, I think you will need a macro, and it could be a bit tricky.

 

You currently have a macro adjusting the margins in the
Worksheet.SelectionChange event -- that will slow your worksheet down --
there is no need to reset the margins every time the cursor moves.  It
should be enough to just set them once in the Page Setup dialog, but if
you want to reset them with a macro, use Worksheet.Activate or
Workbook.BeforePrint (in Workbook.BeforePrint you might check if the
worksheet is in ActiveWindow.SelectedSheets to determine if it is one
being printed -- if needed -- it should be reliable in most cases).

 

To resize the table, I would use the Page Setup oftion to Fit to 1 Page
TALL, and leave the Fit to pages wide blank.  This will only scale the
table automatically to fit based on length, and take up as many pages
wide as required.  Then in your macro adjust the column widths to makke
it fit on the one page.  I am not experienced with this, so I will leave
the details for you or others, unless I find the time to experiment with
it.

 

Asa

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: Monday, May 07, 2012 11:02 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Table data fit the page size..(auto)

 

Dear friends,

 

I want the Table margin fit the page size - by equally grow to all the
four sides irrespective of the data consistency.

 

 

 

Regards,

Muneer,

CC...

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

RE: $$Excel-Macros$$ Table data fit the page size..(auto)

[Mohammed Muneer]

Ya, but it doesn't zoom to the margin, and fit all the four sides.

 

 

Regards,

Muneer,

CC

 

 

 

 

I see you already have it fit to page when printed - 

 

Do you mean you want to have the table forced into the shape of the page
to completely fill the page?

 

If so, I think you will need a macro, and it could be a bit tricky.

 

You currently have a macro adjusting the margins in the
Worksheet.SelectionChange event -- that will slow your worksheet down --
there is no need to reset the margins every time the cursor moves.  It
should be enough to just set them once in the Page Setup dialog, but if
you want to reset them with a macro, use Worksheet.Activate or
Workbook.BeforePrint (in Workbook.BeforePrint you might check if the
worksheet is in ActiveWindow.SelectedSheets to determine if it is one
being printed -- if needed -- it should be reliable in most cases).

 

To resize the table, I would use the Page Setup oftion to Fit to 1 Page
TALL, and leave the Fit to pages wide blank.  This will only scale the
table automatically to fit based on length, and take up as many pages
wide as required.  Then in your macro adjust the column widths to makke
it fit on the one page.  I am not experienced with this, so I will leave
the details for you or others, unless I find the time to experiment with
it.

 

Asa

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: Monday, May 07, 2012 11:02 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Table data fit the page size..(auto)

 

Dear friends,

 

I want the Table margin fit the page size - by equally grow to all the
four sides irrespective of the data consistency.

 

 

 

Regards,

Muneer,

CC...

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

$$Excel-Macros$$ labels for Y-axis is not get printed..

[Mohammed Muneer]

  

Dear Friends, 

 

   I am unable to find the solution for this silly
problem, when I am printing the chart for S_curve from system the Y-axis
labels go missing? Could u please tell me what will be the problem from
other system its quite easy and no trouble bearing thing,Why its from my
system only?

 

I request the I.T also but they also can't fix the problem.

 

Any one who can acknowledge the problem, please share with me...

 

Waiting for u r reply

 

 

 

Regards,

Muneer,

CC..

-- 
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$$ Rajan verma : Most Helpful Member- Apr'2012

[Mohammed Muneer]

Mr. Rajan congratulations dear, keep it up

 

 

Regards,

Muneer,

CC.

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

$$Excel-Macros$$ Mr. Ayush - Many Happy Returns of the Day!

[Mohammed Muneer]

  

 

-- 
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$$ Most helpful Member - March 12- Don Guillett

[Mohammed Muneer]

Happy Birthday Mr. Don,

 

May God Bless you with Long Life & Happy Future. At the same time enrich
your knowledge with more talents.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ Fwd: If data in One then another cell to be unlock

[Mohammed Muneer]

Mr. Don Congrats,

 

Well done! Keep it up

 

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ count formula problem...

[Mohammed Muneer]

Thank u Noor...

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ count formula problem...

[Mohammed Muneer]

Thanks Group..

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ count formula problem...

[Mohammed Muneer]

Dear friends can u please check the attached for the above subject.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ format a cell

[Mohammed Muneer]

# \ : ##

 

Dear Rajan use this,

 

 

 

Regards,

Muneer,

CC...

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

$$Excel-Macros$$ the password for the file is ($resident$)....

[Mohammed Muneer]

Password for the file (Projmon Entry Record Card)..  

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

[Mohammed Muneer]

Dear Mr. Ayush congratulations for successful completion of 5 years of
tenure in helping the others it's a remarkable achievement that
cannot be taught by teachers, lecturers & their successors in any of the
circumstances in our future life.

 

Our teachers have done! their job to keep their profession alive, to
complete the syllabus for their part and to render financial help to
their family.  But you people carry the position some thing greater than
them anyway thanx Mr. Ayush and party for utmost help.

 

This generation machines & medicines cant show effect the sooner than
this Excel Macro Group.

 

Heads up to U Mr. Ayush & Party...and thanx to all my Group
Members..

 

Special thanx to those who r active in helping others

 

I can say we the learners are hesitant to say our problems but the speed
of the Experts doesn't rest at the same place

 

Really great to join this group..

 

Again thanx..

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$

[Mohammed Muneer]

Dear Mr. Ayush congratulations for successful completion of 5 years of
tenure in helping the others it's a remarkable achievement that
cannot be taught by teachers, lecturers & their successors in any of the
circumstances in our future life.

 

Our teachers have done! their job to keep their profession alive, to
complete the syllabus for their part and to render financial help to
their family.  But you people carry the position some thing greater than
them anyway thanx Mr. Ayush and party for utmost help.

 

This generation machines & medicines cant show effect the sooner than
this Excel Macro Group.

 

Heads up to U Mr. Ayush & Party...and thanx to all my Group
Members..

 

Special thanx to those who r active in helping others

 

I can say we the learners are hesitant to say our problems but the speed
of the Experts doesn't rest at the same place

 

Really great to join this group..

 

Again thanx..

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ cells shifting to Up!

[Mohammed Muneer]

Dear Sir, Mr. Don really amaazing!

 

I am not getting words to praise u'r talent

 

Again again & again thanx

 

I am thankful to u both Mr. Noor & you Mr. Don

 

U people r OXFORD of our group..

 

I think u unearthed all that are not seen by this generation

 

My outlook page is not enough to praise u people..

 

 

 

Regards,

Muneer,

CC

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Tuesday, March 20, 2012 4:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ cells shifting to Up!

 

A small primer in the use of specialcells

 

Sub DeleteBlanksUsingSpecialCellsSAS()

  Cells.SpecialCells(xlBlanks).Delete

End Sub

 

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Tuesday, March 20, 2012 2:13 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ cells shifting to Up!

 

Dear Noor Good Morning,

Still I did not understand the
procedure, please again I repeat the same thing I want to shift the
cells below to top to form a single line order.

 

Please any code that can help me.

 

I write one but it doesn't seem to work properly.

 

Sub Button3_Click()

Worksheets("Sheet1").activate

Range("A1:d1").Select

Range("range1_2").activate

Worksheets("Sheet1").Range("A1:d4").FillUp

End Sub

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Monday, March 19, 2012 8:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ cells shifting up!

 

Dear Muneer,

 

Please follow below step and see attached Sample sheet.

 

Select A1:D4 Range

Press ctrl+G->goto Special-Check Blank

Press ctrl- and Shieft Cell Up



-- 

Thanks & regards,

Noorain Ansari

http://noorainansari.com/

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

 


 

On Mon, Mar 19, 2012 at 9:54 AM, Mohammed Muneer 
wrote:

Dear Friends, I need to shift the cells up to bring them in one single
line.

 

TR1

 

 

 

 

1

 

 

 

 

2

 

 

 

 

3

 

 

 

 

 

TR1

1

2

3

 

 

 

 

 

 

 

 

 

 

this is my target...

 

 

 

Regards,

Muneer,

CC...

 

 

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

RE: $$Excel-Macros$$ cells shifting to Up!

[Mohammed Muneer]

Dear Noorain,

 

Excellent!

 

Regards,

Muneer,

CC

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Tuesday, March 20, 2012 11:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ cells shifting to Up!

 

Dear Muneer,

 

Please use it..

Sub Button3_Click()

With Sheet1
.Range("A1").Select
.Range(Selection, Selection.End(xlToRight)).Select
.Range("A1:D4").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete Shift:=xlUp
.Range("A1").Select
End With

End Sub



-- 

Thanks & regards,

Noorain Ansari

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

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

On Tue, Mar 20, 2012 at 12:43 PM, Mohammed Muneer 
wrote:

Dear Noor Good Morning,

Still I did not understand the
procedure, please again I repeat the same thing I want to shift the
cells below to top to form a single line order.

 

Please any code that can help me.

 

I write one but it doesn't seem to work properly.

 

Sub Button3_Click()

Worksheets("Sheet1").activate

Range("A1:d1").Select

Range("range1_2").activate

Worksheets("Sheet1").Range("A1:d4").FillUp

End Sub

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Monday, March 19, 2012 8:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ cells shifting up!

 

Dear Muneer,

 

Please follow below step and see attached Sample sheet.

 

Select A1:D4 Range

Press ctrl+G->goto Special-Check Blank

Press ctrl- and Shieft Cell Up



-- 

Thanks & regards,

Noorain Ansari

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

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

 


 

On Mon, Mar 19, 2012 at 9:54 AM, Mohammed Muneer 
wrote:

Dear Friends, I need to shift the cells up to bring them in one single
line.

 

TR1

 

 

 

 

1

 

 

 

 

2

 

 

 

 

3

 

 

 

 

 

TR1

1

2

3

 

 

 

 

 

 

 

 

 

 

this is my target...

 

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ cells shifting to Up!

[Mohammed Muneer]

Dear Noor Good Morning,

Still I did not understand the
procedure, please again I repeat the same thing I want to shift the
cells below to top to form a single line order.

 

Please any code that can help me.

 

I write one but it doesn't seem to work properly.

 

Sub Button3_Click()

Worksheets("Sheet1").activate

Range("A1:d1").Select

Range("range1_2").activate

Worksheets("Sheet1").Range("A1:d4").FillUp

End Sub

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Monday, March 19, 2012 8:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ cells shifting up!

 

Dear Muneer,

 

Please follow below step and see attached Sample sheet.

 

Select A1:D4 Range

Press ctrl+G->goto Special-Check Blank

Press ctrl- and Shieft Cell Up



-- 

Thanks & regards,

Noorain Ansari

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

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

 


 

On Mon, Mar 19, 2012 at 9:54 AM, Mohammed Muneer 
wrote:

Dear Friends, I need to shift the cells up to bring them in one single
line.

 

TR1

 

 

 

 

1

 

 

 

 

2

 

 

 

 

3

 

 

 

 

 

TR1

1

2

3

 

 

 

 

 

 

 

 

 

 

this is my target...

 

 

 

Regards,

Muneer,

CC...

 

 

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

Sample(Muneer).xlsx
Description: Sample(Muneer).xlsx

$$Excel-Macros$$ cells shifting up!

[Mohammed Muneer]

Dear Friends, I need to shift the cells up to bring them in one single
line.

 

TR1

 

 

 

 

1

 

 

 

 

2

 

 

 

 

3

 

 

 

 

 

TR1

1

2

3

 

 

 

 

 

 

 

 

 

 

this is my target...

 

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Noor Congrats!

[Mohammed Muneer]

Have success at all times with great improvement in u r knowledge and
many thanx also to elevate our knowledge.

 

The drop of water makes mighty ocean.

Similarly, let every attempt of your help should come true to make u r
knowledge mightier than now.

 

 

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ Goal Seek option from Tools menu....(little urgent)

[Mohammed Muneer]

U r Welcome!

 

Regards,

Muneer,

CC..

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Ferry H Sitohang
Sent: Tuesday, March 13, 2012 3:27 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Goal Seek option from Tools
menu(little urgent)

 

Thanks Muneer..this is good for me

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: 12 March, 2012 05:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Goal Seek option from Tools
menu(little urgent)

 

Dear Muneer,

See attached pdf, hope it will help to you

On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer 
wrote:

Dear Group, I want to select multiple cell values(a1 & b1) to change the
target cell "C1".

 

Can I do it like this? Plz suggest?

 

If any formula or code, anyway that can do well plz send.

 

 

Regards,

Muneer,

CC...

 

 

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

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

$$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

[Mohammed Muneer]

Dear Group, I want to select multiple cell values(a1 & b1) to change the
target cell "C1".

 

Can I do it like this? Plz suggest?

 

If any formula or code, anyway that can do well plz send.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ Pivot multisheet how to use? for what purpose?

[Mohammed Muneer]

Thanx Rajan for suggesting, I will try as u said.

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma
Sent: Sunday, March 11, 2012 6:17 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Pivot multisheet how to use? for what
purpose?

 

It's a pre posted solution

 

Ok..

 

Its an add-ins which can take input from multiple worksheets within a
workbook .. when you will press shift+ctrl+P a dialogue box will open to
take input ranges you can add multiple range (All range should have same
format and no column should have blank heading) , then create pivot
table .. it will create pivot after consolidate that data .

 

Methodology is while you add Range it copy that range
and add in a temp sheets and when you create pivot table it create and
delete that temp file.. [you can not refresh the pivot again]

   

 

Regards

Rajan.

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: Mar/Sat/2012 10:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

 

Dear Group Plz,  tell me how I can use it? And for what purpose?

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ conditinal formatting - based on date col.....(plz help)

[Mohammed Muneer]

Mr. Sam yes I understand u, at first some of the top rows I copy the
badge nos with the fill handle.

The badge nos changed like : 

1

105427

5-Oct-11

salnap

1

2

105428

5-Oct-11

trachisa

6

 

In the Sr. no 2 the badge no should be 105427 only, same like the first
one.

 

I did not check it before sorry.

But the logic is clear to u I think so.

 

 

Regards,

Muneer,

CC

 

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: Thursday, March 08, 2012 9:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date
col.(plz help)

 

:) I understand that!

 

I am asking for the logic

 

Regards,

Sam

On Thu, Mar 8, 2012 at 12:26 PM, Mohammed Muneer 
wrote:

Dear Sam,

Thanx for reply,

 

Conditional formatting to change the color.

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: Thursday, March 08, 2012 9:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date
col.(plz help)

 


A few rows on the top has a logic that is different from the logic in a
few rows below. Either that, or I am not able to understand your
conditional format rule. Please let us know what is the logic used.

 

Regards,

Sam

On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer 
wrote:

Friends plz, formula through conditional formatting can be applicable.

Now I am doing it manually everytime the date change.

 

 

 

Regards,

Muneer,

CC...

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




-- 
Sam Mathai Chacko

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




-- 
Sam Mathai Chacko

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

RE: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

[Mohammed Muneer]

Dear Sam, 

I want to know on this particular date how many people took the
medicines and what's their badge no's. (only to differentiate them from
other dates).

 

Regards,

Muneer,

CC...



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: Thursday, March 08, 2012 9:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date
col.(plz help)

 

:) I understand that!

 

I am asking for the logic

 

Regards,

Sam

On Thu, Mar 8, 2012 at 12:26 PM, Mohammed Muneer 
wrote:

Dear Sam,

Thanx for reply,

 

Conditional formatting to change the color.

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: Thursday, March 08, 2012 9:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date
col.(plz help)

 


A few rows on the top has a logic that is different from the logic in a
few rows below. Either that, or I am not able to understand your
conditional format rule. Please let us know what is the logic used.

 

Regards,

Sam

On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer 
wrote:

Friends plz, formula through conditional formatting can be applicable.

Now I am doing it manually everytime the date change.

 

 

 

Regards,

Muneer,

CC...

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




-- 
Sam Mathai Chacko

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




-- 
Sam Mathai Chacko

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

RE: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

[Mohammed Muneer]

Dear Sam,

Thanx for reply,

 

Conditional formatting to change the color.

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: Thursday, March 08, 2012 9:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date
col.(plz help)

 


A few rows on the top has a logic that is different from the logic in a
few rows below. Either that, or I am not able to understand your
conditional format rule. Please let us know what is the logic used.

 

Regards,

Sam

On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer 
wrote:

Friends plz, formula through conditional formatting can be applicable.

Now I am doing it manually everytime the date change.

 

 

 

Regards,

Muneer,

CC...

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




-- 
Sam Mathai Chacko

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

$$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)

[Mohammed Muneer]

Friends plz, formula through conditional formatting can be applicable.
Now I am doing it manually everytime the date change.
 
 
 
Regards,
Muneer,
CC...

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


conditinal format.xls
Description: conditinal format.xls

RE: $$Excel-Macros$$ Extract the numbers....

[Mohammed Muneer]

Thanx!

 

Regards,

Muneer,

CC.

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Tuesday, March 06, 2012 4:23 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Extract the numbers

 

Dear Muneer,

 

You can also use..

 

=MID(A1,FIND("-",A1,1)+1,LEN(A1)-LEN(FIND("-",A1,1)+1))

-- 

Thanks & regards,

Noorain Ansari

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

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

On Mon, Mar 5, 2012 at 4:17 PM, Mohammed Muneer 
wrote:

Dear Group,

 please help to extract the numbers in one cell to
another through formula.

 

 

Regards,

Muneer,

CC

-- 
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$$ Add-ins for pivot table data.....

[Mohammed Muneer]

Thanx Dear.

 

 

Regards,

Muneer,

CC

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Tuesday, March 06, 2012 3:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Add-ins for pivot table data.

 

Dear Muneer,

 

You can use attached Add-ins for pivota table.

On Tue, Mar 6, 2012 at 5:02 PM, Mohammed Muneer 
wrote:

Dear Experts, 

 

Please pass some add-ins for pivot data automation.

 

 

Regards,

Muneer,

CC...

 

 

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

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

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

$$Excel-Macros$$ Add-ins for pivot table data.....

[Mohammed Muneer]

Dear Experts, 

 

Please pass some add-ins for pivot data automation.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ how to subscribe?

[Mohammed Muneer]

Thanx Noorain,

 

I will try once and let u know.

 

 

Regards,

Muneer,

CC...



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Tuesday, March 06, 2012 8:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ how to subscribe?

 

Dear Muneer,

 

Please use below link to subscriobe Email ID munnu130134...@gmail.com

http://groups.google.com/group/excel-macros/subscribe

Hope it will help to you.

 

-- 

Thanks & regards,

Noorain Ansari

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

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


 

On Tue, Mar 6, 2012 at 9:20 AM, Mohammed Muneer 
wrote:

Dear Friends,

 

I want to subscribe this group with another mail id not Outlook -
munnu130134...@gmail.com

 

Can u please tell me how to subscribe?

 

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ how to subscribe?

[Mohammed Muneer]

Mr. Seraj I try, this way last night but not working.

 

Reply me

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Seraj Alam
Sent: Tuesday, March 06, 2012 7:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ how to subscribe?

 

Hi,

 

Please find below link to join this group.

 

http://groups.google.com/group/excel-macros 

 

On Mon, Mar 5, 2012 at 7:50 PM, Mohammed Muneer 
wrote:

Dear Friends,

 

I want to subscribe this group with another mail id not Outlook -
munnu130134...@gmail.com

 

Can u please tell me how to subscribe?

 

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ how to subscribe?

[Mohammed Muneer]

Dear Friends,

 

I want to subscribe this group with another mail id not Outlook -
munnu130134...@gmail.com

 

Can u please tell me how to subscribe?

 

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ Extract the numbers....

[Mohammed Muneer]

Dear Maries,   thanx for the help.

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Maries
Sent: Monday, March 05, 2012 1:52 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Extract the numbers

 

Hi,

 

Try it...

 

=RIGHT(A1,LEN(A1)-FIND("-",A1,1))

 

Regards,

 

MARIES.

On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer 
wrote:

Dear Group,

 please help to extract the numbers in one cell to
another through formula.

 

 

Regards,

Muneer,

CC

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

$$Excel-Macros$$ Extract the numbers....

[Mohammed Muneer]

Dear Group,
 please help to extract the numbers in one cell to
another through formula.
 
 
Regards,
Muneer,
CC

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


yn2.xls
Description: yn2.xls

RE: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

[Mohammed Muneer]

Dear Group, thanx for the information for how to unsubscribe.

 

 

 

Regards,

Muneer,

CC

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Finos Edavanna
Sent: Thursday, March 01, 2012 7:57 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If I input Letter Y is should show the
current date...(28-Feb-2012) like this..

 

please unsubscribe .to stop mails need to subscribe new mail id
finux...@gmail.com

On Wed, Feb 29, 2012 at 11:50 AM, Mohammed Muneer 
wrote:

Hi, Don thanx.

 

 

Regards,

Muneer,

CC..

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Tuesday, February 28, 2012 4:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If I input Letter Y is should show the
current date...(28-Feb-2012) like this..

 

Right click sheet tab>view code> insert this

Now whenever you input y or Y in col B, col A will get the date

 

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Or Target.Column <> 2 Then Exit Sub

If UCase(Target) = "Y" Then Target.Offset(, -1) = Date

End Sub

 

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

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Monday, February 27, 2012 9:55 PM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ If I input Letter Y is should show the current
date...(28-Feb-2012) like this..

 

Dear Friends have a nice day,

 

I have a small question.

 

For example, I have two cols A and B as shown below one is for date &
the other have letter "Y".

 

A  B

 

28-feb-2012   Y

 

Can I do it like this? If I input letter "Y" in the column B I can
display the current date.

 

Regards,

Muneer,

CC...



 

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





 

-- 
Regards
  Finos Edavanna
   00971501193753
   AbuDhabi-UAE
* Save Earth. Think about the Environment before printing this e-mail! P

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

RE: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

[Mohammed Muneer]

Hi, Don thanx.

 

 

Regards,

Muneer,

CC..

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Tuesday, February 28, 2012 4:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If I input Letter Y is should show the
current date...(28-Feb-2012) like this..

 

Right click sheet tab>view code> insert this

Now whenever you input y or Y in col B, col A will get the date

 

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Or Target.Column <> 2 Then Exit Sub

If UCase(Target) = "Y" Then Target.Offset(, -1) = Date

End Sub

 

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

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Monday, February 27, 2012 9:55 PM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ If I input Letter Y is should show the current
date...(28-Feb-2012) like this..

 

Dear Friends have a nice day,

 

I have a small question.

 

For example, I have two cols A and B as shown below one is for date &
the other have letter "Y".

 

A  B

 

28-feb-2012   Y

 

Can I do it like this? If I input letter "Y" in the column B I can
display the current date.

 

Regards,

Muneer,

CC...



 

-- 
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$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

[Mohammed Muneer]

Thanx Asa,

 

 

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff
Sent: Tuesday, February 28, 2012 8:09 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ If I input Letter Y is should show the
current date...(28-Feb-2012) like this..

 

Hello Mohammed,

 

Not without using VBA.

 

Several people have asked similar questions recently.  It is possible to
do this using VBA macros, but I would suggest using the CTRL-; keyboard
shortcut to enter the current date instead.

 

A simple formula using DATE() will not work because it will be
recalculated frequently, and will use the current date each day.

 

For your solution, you could use a Worksheet_Change event like this:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng As Range, cell As Range



' SUPPLY DATE FOR COLUMN A WHEN "Y" ENTERED IN COLUMN B.

' Identify changed cells in column B.

Set rng = Application.Intersect(Me.Range("B:B"), Target)

' if cells were identified...

If Not rng Is Nothing Then

For Each cell In rng

If UCase(cell.Value2) = "Y" Then

' disable events to avoid another worksheet_change event

Application.EnableEvents = False

cell.Value2 = Empty

Application.EnableEvents = True

cell.Offset(, -1).Value = Date

End If

Next cell

End If

 

End Sub

Asa

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: Monday, February 27, 2012 7:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If I input Letter Y is should show the current
date...(28-Feb-2012) like this..

 

Dear Friends have a nice day,

 

I have a small question.

 

For example, I have two cols A and B as shown below one is for date &
the other have letter "Y".

 

A  B

 

28-feb-2012   Y

 

Can I do it like this? If I input letter "Y" in the column B I can
display the current date.

 

Regards,

Muneer,

CC...



 

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

$$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

[Mohammed Muneer]

Dear Maries & Assa,

 

Thanx for u r help , the code is working.

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ plz, check the attached file for good explanation.....

[Mohammed Muneer]

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


Book1.xls
Description: Book1.xls

$$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

[Mohammed Muneer]

Dear Friends have a nice day,

 

I have a small question.

 

For example, I have two cols A and B as shown below one is for date &
the other have letter "Y".

 

A  B

 

28-feb-2012   Y

 

Can I do it like this? If I input letter "Y" in the column B I can
display the current date.

 

Regards,

Muneer,

CC...



 

-- 
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$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

[Mohammed Muneer]

Hi, thanx for the reply , I did as u r saying but it still fails to
execute in the manner I like.

 

 

Regards,

Muneer,

CC

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose
Sent: Saturday, February 25, 2012 10:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ plz check and help on the attached sheet
the Call Macro to combine the macros is not working...

 

Hi

 

You need to  make the names of the macros in the call routine the same
as the name in the Tools/Macro list.  That is Fill1, Fill2 etc and not
Macro1, Macro2 etc

 



 

On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer 
wrote:

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

$$Excel-Macros$$ Ok - I will sir, anyway Mr. Assa thanx for the help!

[Mohammed Muneer]

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

[Mohammed Muneer]

How to merge the Multiple Macro's in single program?

My question is little jovial - but still it is trying to learn some
thing from u masters. Thanx anyway

 

This is only an example, that I put it here to show u exactly what I
want u to help me for. ( in fact, I need the logic - How I can merge the
multiple macros to form a single programming code).

Or else u can do a help by providing me with any website like this that
can fetch me the right/full explanation about the steps involved in
doing so?

 

 

 

 

If my data is like this: (with Filter buttons are on): (filtering
process taken up in anyway with the help of the "Cell" reference (or)
"Button". Its u r choice).

 

Ename

Start Date

End Date

Hours wor

Tot pay

Ded

Net pay

AA

1-Jan-12

31-Jan-12

  40.0 

 2,600.0 

  650.0 

1,950.0 

BB

1-Jan-12

31-Jan-12

  45.0 

 1,800.0 

  450.0 

1,350.0 

CC

1-Jan-12

31-Jan-12

  32.0 

 1,472.0 

  368.0 

1,104.0 

DD

1-Jan-12

31-Jan-12

  60.0 

 2,100.0 

  525.0 

1,575.0 

EE

1-Jan-12

31-Jan-12

  52.0 

 1,664.0 

  416.0 

1,248.0 

FF

1-Jan-12

31-Jan-12

  80.0 

 2,000.0 

  500.0 

1,500.0 

 

 

 

309.0 

   11,636.0 

   2,909.0 

8,727.0 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Hi, Friends I have a ?

[Mohammed Muneer]

How to merge the Multiple Macro's in single program?

 

 

 

 

 

If my data is like this: (with Filter buttons are on): (filtering
process taken up in anyway with the help of the "Cell" reference (or)
"Button". Its u r choice).

 

Ename

Start Date

End Date

Hours wor

Tot pay

Ded

Net pay

AA

1-Jan-12

31-Jan-12

  40.0 

 2,600.0 

  650.0 

1,950.0 

BB

1-Jan-12

31-Jan-12

  45.0 

 1,800.0 

  450.0 

1,350.0 

CC

1-Jan-12

31-Jan-12

  32.0 

 1,472.0 

  368.0 

1,104.0 

DD

1-Jan-12

31-Jan-12

  60.0 

 2,100.0 

  525.0 

1,575.0 

EE

1-Jan-12

31-Jan-12

  52.0 

 1,664.0 

  416.0 

1,248.0 

FF

1-Jan-12

31-Jan-12

  80.0 

 2,000.0 

  500.0 

1,500.0 

 

 

 

309.0 

   11,636.0 

   2,909.0 

8,727.0 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ RE: Mr. Don I am really really really thankful to u for help!

[Mohammed Muneer]

Excellent, u r so nice.

 

Really I was struggling with this bloody problem..

Good bye to the problemblemblemblemblemblem...

 

Thanks & Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Saturday, February 18, 2012 5:35 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Mr.Noorain there is again some problem in
u r solved book - plz check.

 

See attached for this AUTOMATIC macro that does not need formulas. Just
change a1

Private Sub Worksheet_change(ByVal Target As Range)

If Target.Address <> Range("a1").Address Then Exit Sub

Dim lr As Long

 

Rows(8).Resize(Cells(Rows.Count, 1).End(xlUp).Row).Delete

lr = Sheets("Data!").Cells(1, 1).End(xlDown).Row

With Sheets("Data!").Range("a2:p" & lr)

.AutoFilter Field:=1, Criteria1:=Target

.SpecialCells(xlCellTypeVisible).Copy Range("A8")

.AutoFilter

End With

End Sub

 

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

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Friday, February 17, 2012 10:38 PM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Mr.Noorain there is again some problem in u r
solved book - plz check.

 

Dear Noorain can u plz check again there is a some problem confronting
to execute properly.

 

 

 

 

 

Regards,

Muneer,

CC...

-- 
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$$ Mr.Noorain there plz send attachment its not there!

[Mohammed Muneer]

 

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Saturday, February 18, 2012 6:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Mr.Noorain there is again some problem in
u r solved book - plz check.

 

Dear Muneer,

 

Please find attached sheet.

It's working fine as per your requirement.

 


-- 

Thanks & regards,

Noorain Ansari

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

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

 

On Sat, Feb 18, 2012 at 10:08 AM, Mohammed Muneer 
wrote:

Dear Noorain can u plz check again there is a some problem confronting
to execute properly.

 

 

 

 

 

Regards,

Muneer,

CC...

-- 
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$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

[Mohammed Muneer]

Thank You, Mr. Noorain for u r help, praises to u r full presence of
mind and salute to knowledge..

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Wednesday, February 15, 2012 11:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ plz, check how many categories are there
in the column A totally by formula that is applied in single cell to
display the result?

 

Dear Muneer,

 

Please use..

 

=SUM(1/COUNTIF(A1:A356,A1:A356)
with ctrl+shift+ENter.

 

See attached sheet.

On Wed, Feb 15, 2012 at 1:23 PM, Mohammed Muneer 
wrote:




-- 

Thanks & regards,

Noorain Ansari

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

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

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

$$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

[Mohammed Muneer]

Book3.xls
Description: Book3.xls

$$Excel-Macros$$ Thanx in advance!

[Mohammed Muneer]

Ok Don I understand u what u want to get from me.

Hope this will serve u to understand what I want to say, means (aa),
(bb) & (cc) are the 3 separate macros ok. If I want to merge these 3
macros into 1. what could be the process?

How I can merge them?

What code is applicable in doing so?

(aa)   macro1

(bb)  macro2

(cc)macro3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Jai plz, give me 2003 format to make work easy.....

[Mohammed Muneer]

Dear Jai, how to use the file i.e., in some .xlam format.

U have any vba code to change the file format (2003 - 2007).

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Hi everyone,

[Mohammed Muneer]

See I have something to aks u?

Can we convert the office 2007 file into office 2003 format, currently
being in the office 2003.

 

 

Any help is appreciated. 

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Plz, suggest can we do like this for the macro's. (for better explanation if u need plz check the attached file (Grm Details here) and Grm is the main file with two command buttons (F

[Mohammed Muneer]

1. This is original macro.

Sub fill()

 

 

 

'

 

 

 

' fill Macro

 

 

' Macro recorded 2/7/2012 by mmuneer

'

 

 

 

' Keyboard Shortcut: Ctrl+Shift+N

 

'

 

 

 

ActiveCell.FormulaR1C1 = "aa"

 

Selection.AutoFilter Field:=2, Criteria1:="aa"

End Sub

 

 

 

 

 

1. Can we do alterations in the original macro.

Sub fill()

 

 

 

'

 

 

 

' fill Macro

 

 

' Macro recorded 2/7/2012 by mmuneer

'

 

 

 

' Keyboard Shortcut: Ctrl+Shift+N

 

'

 

 

 

ActiveCell.FormulaR1C1 = "aa"

 

Selection.AutoFilter Field:=2, Criteria1:="aa"

---

ActiveCell.FormulaR1C1 = "bb"

 

Selection.AutoFilter Field:=2, Criteria1:="bb"

---

ActiveCell.FormulaR1C1 = "cc"

 

Selection.AutoFilter Field:=2, Criteria1:="cc"

 

End Sub

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Regards,

Muneer,

CC...

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

$$Excel-Macros$$ Hi friends, now its clear.....

[Mohammed Muneer]

del cell   

bel cell del

cell bel del

cell ell llec

blood consist of red cell and white cell

simos is a cell

max cell

sony cell

a cell is a source of energy for some electronic devices and stands as a
two way power.

 

Above mentioned lines are having the word "cell" in common, Ok I want to
extract the same in the cell beside (the highlighted).

For example, we are at first line del cell and if I can do this to
extract the word cell.

 

cell

del cell

cell

bel cell del

cell

cell bel del

cell

cell ell llec

cell

blood consist of red cell and white cell

cell

simos is a cell

cell

max cell

cell

sony cell

cell

a cell is a source of energy for some electronic devices and stands as a
two way power.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ Extract the single word called "cell" from the corresponding Rows().

[Mohammed Muneer]

Sorry Don, please check the attachment its very clear in it.

 

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Monday, February 06, 2012 6:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Extract the single word called "cell" from
the corresponding Rows().

 

I'm confused. Start over with a better explanation and before/after
examples

 

 

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

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Monday, February 06, 2012 8:08 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Extract the single word called "cell" from the
corresponding Rows().

 

 

 

 

 

Regards,

Muneer,

CC...

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

$$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

[Mohammed Muneer]

 
 
 
 
Regards,
Muneer,
CC...

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


Book1.xls
Description: Book1.xls

$$Excel-Macros$$ plz, check the attachment it clearly tells u what I need in actually.

[Mohammed Muneer]

 
 
 
 
 
Regards,
Muneer,
CC...

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


Book1.xls
Description: Book1.xls

$$Excel-Macros$$

[Mohammed Muneer]

Dear Sir,

 

I am using Bathtext function in excel sheet, by this I want to write the
value (1,234), in words (One Thousand Two hundred & Thirty four).

But it is showing in the Thailandi text.

 

Pls, suggest how to apply this function properly.

 

 

Regards,

Muneer,

CC...

 

 

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

$$Excel-Macros$$ Congrates.

[Mohammed Muneer]

Mr. Noorain, I felicitate u for u r cooperation to our group members. 

May God bless u with more  greater talent than u possess know.

Well done! Keep it up! Really I had no interest learn myself this sort
of things and had no importance to try to educate myself in macro's or
vba before I join this group.

I am really thankful to everyone of our group.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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$$ IS.xls

[Mohammed Muneer]

That's what I want!

Thanx.

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Monday, January 30, 2012 7:35 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ IS.xls

 

Dear Muneer,

 

Pls see attached sheet.

On Mon, Jan 30, 2012 at 7:16 PM, dguillett1 
wrote:

 =B3*($F$6/100) 

and copy down

 

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

 

From: Mohammed Muneer <mailto:mmun...@ccc.com.qa>  

Sent: Monday, January 30, 2012 2:01 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ IS.xls

 

plz, check I write clearly now. I was little busy doing something other
than this.

 

I need the same in formula.

 

 

 

Regards,

Muneer,

CC...

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

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

http://noorain-ansari.blogspot.com/
<http://noorain-ansari.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

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

$$Excel-Macros$$ IS THERE ANY OTHER EQUATION TO DO LIKE THIS.

[Mohammed Muneer]

 

 

 

Regards,

Muneer,

CC...

 

 

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


IS.xls
Description: IS.xls

RE: $$Excel-Macros$$ plz, help me to drive out this sort of problem!

[Mohammed Muneer]

Ya, that's what I want!

 

Thanx, Sam (u r so nice!)

 

Good keep it up!

 

 

Regards,

Muneer,

CC..

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko
Sent: Thursday, January 26, 2012 3:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ plz, help me to drive out this sort of
problem!

 

Try this.

B8
=IF(INDEX($H$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8)=chik,INDEX($H
$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8),"")
C8
=IF(INDEX($H$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8)=chik,INDEX($I
$1:$I$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8),"")

Regards,

Sam Mathai Chacko

On Thu, Jan 26, 2012 at 12:56 PM, Mohammed Muneer 
wrote:

Plz, check the the sheet 1 and follow the sheet 2 do the same.

 

 

 

 

 

Regards,

Muneer,

CC

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




-- 
Sam Mathai Chacko

-- 
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$$ How to make use of this (Command Button & Text Box), as I want to insert the values in no's for identification of the employee.....

[Mohammed Muneer]

Hi,

 

Santhosh very very thanx for the help!

 

Good Keep it up!

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi
Sent: Saturday, January 21, 2012 11:10 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to make use of this (Command Button &
Text Box), as I want to insert the values in no's for identification of
the employee.

 

Hi Muneer,

 

Hope the attached file helps you.

 

Regards

Santosh Kumar Subudhi

santoshkumar.subu...@gmail.com

Subject: $$Excel-Macros$$ How to make use of this (Command Button & Text
Box), as I want to insert the values in no's for identification of the
employee.
Date: Sat, 21 Jan 2012 16:47:04 +0300
From: mmun...@ccc.com.qa
To: excel-macros@googlegroups.com

How to make use of this (Command Button & Text Box), as I want to insert
the values in no's for identification of the employee.

 

note: my explanation here add some more information for u r convenience
what I mean is - the values entered in text box should reach the the
"Col A everyrow" one by one irrespective of the ascending order, when we
click/enter the update button and the cursor by default should always
keep blinking in the text box itself as and when we finish one of the
entry.

 

its something I consider it as magic for me, but some one from u will
definitely will help me to solve this!

 

 

 

 

Regards,

Muneer,

CC...

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


 

-- 
Regards
Santosh 
santoshkumar.subu...@gmail.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

$$Excel-Macros$$ How to make use of this (Command Button & Text Box), as I want to insert the values in no's for identification of the employee.....

[Mohammed Muneer]

How to make use of this (Command Button & Text Box), as I want to insert
the values in no's for identification of the employee.
 
note: my explanation here add some more information for u r convenience
what I mean is - the values entered in text box should reach the the
"Col A everyrow" one by one irrespective of the ascending order, when we
click/enter the update button and the cursor by default should always
keep blinking in the text box itself as and when we finish one of the
entry.
 
its something I consider it as magic for me, but some one from u will
definitely will help me to solve this!
 
 
 
 
Regards,
Muneer,
CC...

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


Book1.xls
Description: Book1.xls

$$Excel-Macros$$ Mr. Neeraj for this window u have to first go to the windows explorer and from that say Tools from menu there exactly u will find this....

[Mohammed Muneer]

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan
Sent: Friday, January 20, 2012 9:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hidden file

 

Dear sir,

 

Kindly see the attached screen shot. The file is hidden. 

I want to unhide the file.

 

 

 

 

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

[Mohammed Muneer]

Mr. Noorain excellent! job,

 

Keep it up!

 

Miraculous, I was fed with the previous one whenever I prepared the
monthly reports.

 

Anyway Thanx a lot,

 

 

Praises, Prosperity & Prayers,

Muneer,

CC..

 

 

 

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Thursday, January 19, 2012 8:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ code

 

Dear Muneer,

You can use finally this formula in G1
=LEFT(A1,2)&"."&MID(A1,5,3)&"."&RIGHT(A1,1)
hope it help to you..
otherwise i wll send you macro(VBA Code)..

See attached sheet.
-- 

Thanks & regards,

Noorain Ansari

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

http://noorain-ansari.blogspot.com/
<http://noorain-ansari.blogspot.com/> 

 

On Thu, Jan 19, 2012 at 9:56 AM, Mohammed Muneer 
wrote:

I want to change this column A to column G (means I want to remove the
additional zero figures from column A),

I have to pass through the cols - B, C, D, E and F.

 

steps involved here are very lengthy!

 

How can I avoid this lengthy process and do it in short!!

Finally I have to do again some manual work in the 'col G'.

 

Plz, help me to come out from this problem.

 

 

Regards,

Muneer,

CC...

 

 

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