Re: $$Excel-Macros$$ Insurance Calculation sheet

2010-06-14 Thread Ahmedhonest
Dear Nandkumar, You have given specification for Model Year and what about the specifications for I.D.V, i mean on what basis you want to make it. Say for model year you have given like 2003 & below 1.342%, 2004 - 2005 1.310% ... In the same way give for I.D.V More over

Re: $$Excel-Macros$$ Required Formula

2010-05-23 Thread Ahmedhonest
Dear All, Thanks to all those who helped me out, but i am shock why Mr. Lineesh K S is saying to deposit the money into his account. :( Lineesh where are the formula that you made use to do it as i need that as well but sorry to say that i cant send you any amount. Dear Dave, Special Thanks f

$$Excel-Macros$$ Certification in Ms Office 2007 (Ms Word, Ms Excel, Ms Outlook, Ms Powerpoint, Ms Access).

2010-05-19 Thread Ahmedhonest
Dear All, I wish to get Certification in Ms Office 2007 (Ms Word, Ms Excel, Ms Outlook, Ms Powerpoint, Ms Access). How do i prepare for it. Any how I am almost familiar with all the advance options of Ms Word and Ms Excel but still would prefer to take up a preparation and wish to score the HIGHE

Re: $$Excel-Macros$$ Do not request or provide copyrighted eBook in group.

2010-05-16 Thread Ahmedhonest
Dear Ayush, Good to see the way that you are managing and leading the Group. I have one doubt regarding banning the Spammer in the group, may be the spammer is banned becoz of his behaviour, What if, the spammer create new email id and join the group? Please correct me if i am wrong. Regards Ah

$$Excel-Macros$$ Ms Office 2007 Certification

2010-05-15 Thread Ahmedhonest
Dear All, I wish to get Certification in Ms Office 2007 (Ms Word, Ms Excel, Ms Outlook, Ms Powerpoint, Ms Access). How do i prepare for it. Any how I am almost familiar with all the advance options of Ms Word and Ms Excel but still would prefer to take up a preparation and wish to score the HIGHE

Re: $$Excel-Macros$$ Kndly Solve my Problem

2010-05-02 Thread Ahmedhonest
gt;<><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Ahmedhonest solve.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Need Help

2010-04-28 Thread Ahmedhonest
Dear Balbir, Copy the column values and in the destination wile pasting give it Paste Special - in paste special choose "Transpose" your task will be done. Let me know if you still need in detail the steps. This should solve your query On Wed, Apr 28, 2010 at 2:50 PM, balbirkumar . wrote: > D

Re: $$Excel-Macros$$ Extracting numbers from a string

2010-04-26 Thread Ahmedhonest
Bawazir On Sun, Apr 25, 2010 at 8:48 PM, Vikas Chouhan wrote: > Hi, > > Dear Just Chk this formula > > *=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),100)* > > > On Sun, Apr 25, 2010 at 7:46 PM, Ahmedhonest wrote: > >> Dear Team, >&

$$Excel-Macros$$ Extracting numbers from a string

2010-04-25 Thread Ahmedhonest
Dear Team, Pleasure seeing and Tons of thanks serving the members with your valuable suggestions and ideas. My query is that how to extract numbers from a given string, please revert with examples. Appreciate your suggestions in advance -- Ahmed Bawazir -- ---

$$Excel-Macros$$ Please help

2010-02-08 Thread Ahmedhonest
Dear All Please find the attach file where i have 2 sheets in he sheet2 i need the formula for extracting the values from sheet1. I need the values withou using vlookup formula. please relply me to the following email addresses: ahmedhon...@gmail.com AND abawa...@solexplus.net $10,000 Thanks

Re: $$Excel-Macros$$ Sum Based on date criteria

2010-01-21 Thread Ahmedhonest
Dear Mahesh, You if you are familiar with SumIfs formula you can make use of this, else make use of help in the excel to understand how sumifs can be effectively used. I hope this SUMIFS will solve your query Regards Ahmed Bawazir On Wed, Jan 20, 2010 at 8:29 AM, mahesh parab wrote: > Dear Al

Re: $$Excel-Macros$$ Need help on Validation

2009-12-21 Thread Ahmedhonest
Dear Mahesh Bisht, What i can suggest you is that make use of Pivot Tables for your data if you are familiar. Regards Ahmed Bawazir On Tue, Dec 22, 2009 at 6:53 AM, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Lo

$$Excel-Macros$$ Plzzzzz GUIDE ITS Urgent

2009-11-24 Thread Ahmedhonest
Hi everyone there, I would like to know about a Guy who is going for a Job Interview with the following Job Description, what is that one have to prepare himself to make it successful for getting Selected.* Plzzz Guide me As Soon as possible, Eagerly waiting for PROMPT REPLY:* Det

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

2009-04-27 Thread Ahmedhonest
Dear Fabio Lemos, I appreciate your solution to the Query but may i know the logic of this formula how it works plzzz *=IF(C8<>C7,1,0) <- Explain this plz* Regards Ahmed On Mon, Apr 27, 2009 at 4:31 PM, Fabio Lemos wrote: > Hi, > You can use: > > =IF(C8<>C7,1,0) > > regar

$$Excel-Macros$$ Re: Help-Excel files formula

2009-02-04 Thread Ahmedhonest
Dear Rabindra Thapa Make use of Pivot table i Hope it can solve your problem but before this see what others has to say on this group Regards Ahmed Bawazir On Tue, Feb 3, 2009 at 8:09 PM, Rabindra Thapa wrote: > > Please help me on attach files. > -- > > Regards, > Rabindra Thapa > ¨`·.·´¨) Alw

$$Excel-Macros$$ How to find out Date of Joining the group

2009-02-03 Thread Ahmedhonest
How to find the date of Joining to this group . if anyone knows it kindly help me out plzzz -- Ahmed Bawazir --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email t

$$Excel-Macros$$ 3 million affected mobile phones

2008-12-31 Thread Ahmedhonest
Dear All, If you receive a phone call on your Mobile from any person saying that they are checking your mobile line, and you have to press #90 or #09 or any other number. End this call immediately without pressing any numbers. Friends there is a fraud company using a device that once you press #90

$$Excel-Macros$$ How to Deleted Zpharaoh.exe

2008-12-23 Thread Ahmedhonest
Hello to everyone, The below Question may be out of Context but i need help. I sincerely Thanks you guys in advance Problem is that I am unable to open my D,E,F Drives when i am double clicking on it, It gives an error message stating that Zpharaoh.exe file is missing. When I searched on the G

$$Excel-Macros$$ Re: excel ebook

2008-12-22 Thread Ahmedhonest
Hello, Naveen Sharma Felt happy to see your kindness for sharing the book. However I request you to please forward me the books to the following mail id plzzz 8.ah...@in.com Regards Ahmed On Sun, Dec 21, 2008 at 7:40 PM, Naveen Sharma wrote: > Hey sunil, > > Thank you very much. I thi

$$Excel-Macros$$ Re: How do I create formula to return row number of search result...

2008-12-19 Thread Ahmedhonest
Hello there, What ever i have understood from your question and providing you the answer for it *" type =row()" *to get the required result i.e row number If this is not the case try others answers to get what you are expecting. Regards Ahmedhonest On Thu, Dec 18, 2008 at 10:32 PM,

$$Excel-Macros$$ request to forward 39_excelmacros.pdf

2008-12-15 Thread Ahmedhonest
Dear all, Plz forward me the book if one of you received from Swapnilsagar i.e 39_excelmacros.pdf Waiting for a prompt reply Thanks in advance -- Ahmed Bawazir --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.

$$Excel-Macros$$ Request for Office Stationery Samples files

2008-12-11 Thread Ahmedhonest
Hi all Guys, A Humble request from my side is that i need Samples of Office Stationery maintaining format Examples like A4, Legal Papers purchased and how much utilized by which person, In a similar format whole office Stationery how much the staff is utilizing i am supposed to maintain the recor

$$Excel-Macros$$ Re: Required Formula

2008-12-06 Thread Ahmedhonest
Hi you all Cool Guys, Felt happy to see answers from many of you and got the enough result as i was expecting. A Special Thanks to Manoj S Negi & Lohith Regards Ahmedhonest On Fri, Dec 5, 2008 at 2:46 PM, Manoj S Negi < [EMAIL PROTECTED]> wrote: > Hi Dude, > Please find t

$$Excel-Macros$$ Required Formula

2008-12-04 Thread Ahmedhonest
Please find the attach file and suggest your valuable answers Expecting for a faster reply -- Ahmed Bawazir --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macro

$$Excel-Macros$$ Help plz

2008-11-27 Thread Ahmedhonest
Hello, I searched for a sample database that would involve keeping records of employees attendance. I have no luck and was woundering if someone had such a database I could use? -- Ahmed Bawazir --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at

$$Excel-Macros$$ Re: help on splitting into columns

2008-11-13 Thread Ahmedhonest
Dear Tom Jeffries, I really felt happy to see the macro code you have build up for solving the problem of separating Bold Strings for your reference is BoldParse Macro. Tom just i need one help from you is that can you tell if a person doesnt knows about the Macros for building up the code and ge

$$Excel-Macros$$ Re: Number of sheets in workbook equal to number of days in a month

2008-11-13 Thread Ahmedhonest
Hello Tom, The coding for the macro which you have written is good and I would like to draw your attention is that The first when the Macro is runned then there is no problem at all and it inserts the given input for inserting the sheets. If the macro is runned for the second time for inserting mo

$$Excel-Macros$$ Request for Formula

2008-10-18 Thread Ahmedhonest
Dear All, A warm Greetings to all. Please find the attach file to this mail and request you all Guys to provide me the solution and have patients in reading the file throughly. Hoping that there is a Prompt reply and I Thanks each and every individual in advance for all your suggestions. Regards