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

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

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

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

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

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 t

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

uld 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@googlegroup

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

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

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 Pl

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

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

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

=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+ me

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

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,

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

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

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

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 ti

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

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 violatio

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

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

$$Excel-Macros$$ Happy independence day

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 (

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

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

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

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 viol

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

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

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

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

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

ifferent 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

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

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

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

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

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

en =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 dgui

$$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, lik

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

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

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

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 BANNE

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

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 at

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

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

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

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

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

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,

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

os@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 dguill

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

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

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

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

e 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$$ labels for Y-axis is not get printed..

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

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

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 ge

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

-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the

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

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

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 wil

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

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 n

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

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 ma

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

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

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

# \ : ## 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 att

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

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

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

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 the

$$Excel-Macros$$

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 the

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

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

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

quot;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, M

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

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

$$Excel-Macros$$ cells shifting up!

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 f

$$Excel-Macros$$ Noor Congrats!

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)

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 sugge

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

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?

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

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

@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

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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

@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

$$Excel-Macros$$ how to subscribe?

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

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

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

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

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

@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

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

gt; 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 Subje

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

alue = 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 Lett

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

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

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

-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread

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

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

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

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

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, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

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

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

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 p

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

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

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

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

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?

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

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

Book3.xls Description: Book3.xls

$$Excel-Macros$$ Thanx in advance!

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$$ Jai plz, give me 2003 format to make work easy.....

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$$ Hi everyone,

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 title

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

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

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

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,

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

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

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

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

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

$$Excel-Macros$$

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 R

$$Excel-Macros$$ Congrates.

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 thi

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

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

$$Excel-Macros$$ IS THERE ANY OTHER EQUATION TO DO LIKE 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

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

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

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, 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@g

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

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

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

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

RE: $$Excel-Macros$$ code

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