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

2012-10-03 Thread 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 karan1...@gmail.com wrote: Congrats dude! Karan Singh On

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

2012-09-29 Thread 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,

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

2012-09-28 Thread 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

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

2012-09-24 Thread 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

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

2012-09-24 Thread 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

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

2012-09-24 Thread Mohammed Muneer
understanding for my benefit. Thanks, Joseph Sent on my BlackBerry(r) from Vodafone From: Mohammed Muneer mmun...@ccc.com.qa Sender: excel-macros@googlegroups.com Date: Mon, 24 Sep 2012 17:19:12 +0300 To: excel-macros@googlegroups.com ReplyTo: excel-macros

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

2012-09-19 Thread 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+

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

2012-09-19 Thread 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... --

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

2012-09-02 Thread 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

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

2012-08-15 Thread Mohammed Muneer
- From: Mohammed Muneer mmun...@ccc.com.qa 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

$$Excel-Macros$$ Happy independence day

2012-08-14 Thread 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

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

2012-08-14 Thread Mohammed Muneer
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

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

2012-08-14 Thread 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

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

2012-08-08 Thread 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

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

2012-08-08 Thread 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

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

2012-07-12 Thread 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

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

2012-07-12 Thread Mohammed Muneer
...@gmail.com 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 mmun...@ccc.com.qa wrote: Dear friends, I want to call a function/formula here that show me the sum of the each item

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

2012-07-11 Thread Mohammed Muneer
-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

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

2012-07-10 Thread Mohammed Muneer
( ,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

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

2012-07-10 Thread Mohammed Muneer
, ,),G2) Thanks Regards, Deba Ranjan P On Wed, Jul 11, 2012 at 10:02 AM, Abdulgani Shaikh itpabdulg...@gmail.com 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 mmun

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

2012-07-02 Thread 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

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

2012-06-14 Thread 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

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

2012-06-11 Thread 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

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

2012-06-11 Thread 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

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

2012-06-04 Thread 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

RE: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-21 Thread 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

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

2012-05-19 Thread 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.

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

2012-05-19 Thread Mohammed Muneer
] 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

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

2012-05-09 Thread 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

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

2012-05-08 Thread 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

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

2012-05-08 Thread Mohammed Muneer
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

RE: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-03 Thread 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

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

2012-04-25 Thread 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

RE: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-15 Thread 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

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

2012-04-09 Thread 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

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

2012-04-09 Thread 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

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

2012-04-07 Thread 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,

RE: $$Excel-Macros$$ format a cell

2012-04-02 Thread 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

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

2012-03-25 Thread 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

$$Excel-Macros$$

2012-03-23 Thread 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

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

2012-03-23 Thread 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

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

2012-03-20 Thread Mohammed Muneer
- 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 mmun...@ccc.com.qa wrote: Dear Friends, I

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

2012-03-20 Thread Mohammed Muneer
-- 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 mmun...@ccc.com.qa wrote: Dear Noor Good Morning

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

2012-03-20 Thread Mohammed Muneer
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

$$Excel-Macros$$ cells shifting up!

2012-03-18 Thread 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

$$Excel-Macros$$ Noor Congrats!

2012-03-16 Thread 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...

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

2012-03-13 Thread Mohammed Muneer
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 mmun...@ccc.com.qa 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

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

2012-03-12 Thread 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

RE: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

2012-03-11 Thread Mohammed Muneer
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

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

2012-03-08 Thread Mohammed Muneer
@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 mmun...@ccc.com.qa wrote: Dear Sam, Thanx for reply, Conditional

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

2012-03-07 Thread 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,

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

2012-03-07 Thread Mohammed Muneer
what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer mmun...@ccc.com.qa 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

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

2012-03-07 Thread Mohammed Muneer
:26 PM, Mohammed Muneer mmun...@ccc.com.qa 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

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

2012-03-06 Thread 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

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

2012-03-06 Thread Mohammed Muneer
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 mmun...@ccc.com.qa wrote: Dear Experts, Please pass some add-ins for pivot data automation. Regards, Muneer, CC... -- FORUM RULES (986

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

2012-03-05 Thread 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,

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

2012-03-05 Thread Mohammed Muneer
Hi, Try it... =RIGHT(A1,LEN(A1)-FIND(-,A1,1)) Regards, MARIES. On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Group, please help to extract the numbers in one cell to another through formula. Regards, Muneer, CC

$$Excel-Macros$$ how to subscribe?

2012-03-05 Thread 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.

RE: $$Excel-Macros$$ how to subscribe?

2012-03-05 Thread Mohammed Muneer
@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 mmun...@ccc.com.qa wrote: Dear Friends, I want to subscribe

RE: $$Excel-Macros$$ how to subscribe?

2012-03-05 Thread Mohammed Muneer
://noorainansari.com/ http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ On Tue, Mar 6, 2012 at 9:20 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Friends, I want to subscribe this group with another mail id not Outlook - munnu130134...@gmail.com Can u

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

2012-03-02 Thread Mohammed Muneer
@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 mmun...@ccc.com.qa wrote: Hi

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

2012-02-28 Thread 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

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

2012-02-28 Thread Mohammed Muneer
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

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

2012-02-28 Thread Mohammed Muneer
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

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

2012-02-27 Thread 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

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

2012-02-27 Thread 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

RE: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

2012-02-25 Thread Mohammed Muneer
. That is Fill1, Fill2 etc and not Macro1, Macro2 etc On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer mmun...@ccc.com.qa 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

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

2012-02-20 Thread 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

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

2012-02-19 Thread 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

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

2012-02-19 Thread 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

RE: $$Excel-Macros$$ Mr.Noorain there plz send attachment its not there!

2012-02-18 Thread Mohammed Muneer
://excelmacroworld.blogspot.com/ On Sat, Feb 18, 2012 at 10:08 AM, Mohammed Muneer mmun...@ccc.com.qa 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

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

2012-02-18 Thread Mohammed Muneer
:=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

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?

2012-02-15 Thread Mohammed Muneer
+shift+ENter. See attached sheet. On Wed, Feb 15, 2012 at 1:23 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorainansari.com/ http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.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?

2012-02-14 Thread Mohammed Muneer
Book3.xls Description: Book3.xls

$$Excel-Macros$$ Hi everyone,

2012-02-08 Thread 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

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

2012-02-08 Thread 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,

$$Excel-Macros$$ Thanx in advance!

2012-02-08 Thread 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)

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

2012-02-06 Thread 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)

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

2012-02-06 Thread Mohammed Muneer
@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

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

2012-02-06 Thread 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,

$$Excel-Macros$$

2012-02-03 Thread 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

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

2012-02-03 Thread 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)

$$Excel-Macros$$ Congrates.

2012-02-01 Thread 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

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

2012-01-30 Thread Mohammed Muneer
$$ IS.xls Dear Muneer, Pls see attached sheet. On Mon, Jan 30, 2012 at 7:16 PM, dguillett1 dguille...@gmail.com 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

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

2012-01-29 Thread 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

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

2012-01-26 Thread Mohammed Muneer
)+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 mmun...@ccc.com.qa wrote: Plz, check the the sheet 1 and follow the sheet 2 do the same. Regards, Muneer, CC -- FORUM

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

2012-01-21 Thread 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

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

2012-01-21 Thread 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$$ 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....

2012-01-19 Thread 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,

RE: $$Excel-Macros$$ code

2012-01-18 Thread Mohammed Muneer
, Mohammed Muneer mmun...@ccc.com.qa 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