Re: $$Excel-Macros$$ Immediate hire for SAP PO Consultant at Branchburg, NJ

2018-05-02 Thread Ahmed Honest
SRIKANTH: THIS IS NOT JOB PUBLISHING PORTAL. KINDLY STOP SENDING EMAILS TO THE GROUP..!!! On Wed, May 2, 2018 at 4:32 PM, Srikanth HCL Global < srikanth.recruitm...@gmail.com> wrote: > Hello, > > > > Greetings of the day!!! > > > > *Please share resumes to* *s...@hclglobal.com* * at >

Re: $$Excel-Macros$$ Immediate hire for SAP PO Consultant at Branchburg, NJ

2018-05-02 Thread Ahmed Honest
SRIKANTH: THIS IS NOT JOB PUBLISHING PORTAL. KINDLY STOP SENDING EMAILS TO THE GROUP..!!! On Wed, May 2, 2018 at 4:32 PM, Srikanth HCL Global < srikanth.recruitm...@gmail.com> wrote: > Hello, > > > > Greetings of the day!!! > > > > *Please share resumes to* *s...@hclglobal.com* * at > ea

Re: $$Excel-Macros$$ RE: Excel to Link to Word

2017-11-09 Thread Ahmed Honest
Sleek Use Mail Merge to do it i.e build up your data in Excel and then in Ms word the option available is Mail merge. When you use Mail Merge as option you get the opportunity to bring your Excel data to Ms word. Just google Mail merge with Excel - I'm sure you will get it. Regards, On Thu, Nov

$$Excel-Macros$$ Sending Emails using Outlook with Attachment

2017-11-07 Thread Ahmed Honest
Dear Experts, Per attached Excel file database - based on the information typed From Column A to F and once clicked "Send emails" - emails should be sent. I need VBA code to send Emails by Outlook Kindly help. -- *Ahmed Bawazir* *احمد باوزير* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Excel VBA Training

2017-07-28 Thread Ahmed Honest
Hi Send details On Friday, July 28, 2017, Rajan Verma wrote: > > [image: Inline image 1] > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

2014-10-09 Thread Ahmed Honest
use a helper column to convert the data (to numeric) and then apply Max formula you shall get the answer.. Hope this helps​ On Thu, Oct 9, 2014 at 3:54 PM, Sundarvelan N wrote: > Dear Friends, > > Please help me in finding the maximum value in a non numeric column, > example below > > A

Re: $$Excel-Macros$$ Change date format

2014-07-15 Thread Ahmed Honest
use this formula : CONCATENATE(DAY(C4),"-",MONTH(C4),"-",YEAR(C4))​ On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara wrote: > Dear experts, > > I have a data in which date format is Text, I want to change in date > format to filter data date and month wise. I have change manually this > thing by

$$Excel-Macros$$ Fwd: Lists Output request

2014-03-25 Thread Ahmed Honest
Dear All: Please see attach excel file and if you can help me with a formula to generate OUTPUT in 2 different ways from List 1 and List 2. *Thanks in advance!* -- *Ahmed Bawazir* *احمد باوزير* -- *Ahmed Bawazir* *احمد باوزير* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Months between two dates.

2014-02-13 Thread Ahmed Honest
Thanks Ashish but Please observe my initial draft. Datedif I know very well on the usage and it fails. Regards On Thu, Feb 13, 2014 at 5:58 PM, Ashish Kumar wrote: > Hi Ahmed, > > PFA..!!! > > > Thanks > Ashish > > > > On 13 February 2014 20:15, A

$$Excel-Macros$$ Months between two dates.

2014-02-13 Thread Ahmed Honest
Dear All, Please see below and kindly help. Requirement : How to get no. of years, months and Dates between 2 dates. Example : Start date : 1-Oct-2012 suppose in cell A1, End Date : 30-Jun-2013 suppose in cell B1 Then used formula is : 1. Datedif(a1,b1,"Y") for years = Output is zero 2. Datedif

Re: $$Excel-Macros$$

2013-07-23 Thread Ahmed Honest
*Simply Bravo!*​ Mr. Paul. On Tue, Jul 23, 2013 at 2:29 PM, Paul Schreiner wrote: > "these type of cases"? > I'm not sure your situation falls into a "type" of case. > > In YOUR case, Excel is interpreting your string "> 7 days" > as: GREATER than " 7 days" > or: GREATER THAN [space]7[space]"d

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Ahmed Honest
​Dear Priti, Please find attach the solution. It is too simple On Mon, Jul 15, 2013 at 1:34 PM, priti verma wrote: > Hi group , > > Please try to solve this. > > Queri based on conditional formating > > If b2 >a2 then up arrow and coluor should be green . > > if b2 > See PFA For more cl

Re: $$Excel-Macros$$ Functions name in Calculated field of Pivot

2013-07-03 Thread Ahmed Honest
Dear... Search the youtube or just google it with the keywords that you have posted here in the group you shall get plenty of examples and videos to understand you will find helping yourself...​ On Wed, Jul 3, 2013 at 4:20 PM, Vijay Kr. Aggarwal wrote: > I want to know that can we use

Re: $$Excel-Macros$$ Concatenate range of cells in excel

2013-07-02 Thread Ahmed Honest
Kaushik, PFA, to see the formula. ​ On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA wrote: > Hi Team, > > I am having some data in Cell A1 to A100 and I want to concatenate > range of data from A1 to A100 with comma as seperator. > > Example: > > Cells > A1 10 > A2 20 > A3

Re: $$Excel-Macros$$ Concatenate range of cells in excel

2013-07-02 Thread Ahmed Honest
Kaushik: As your values are in Cells A1 to A2 write in Cell B1 formula =A1 and in cell B2 = concatenate(B1,",",B2) and now this cell B2 formula copy and paste from cell B3 to B100 then finally the result you are looking for will be in B100. Hope this helps On Tue, Jul 2, 2013 at 5:15 PM

Re: $$Excel-Macros$$ Date format to be changed

2013-06-22 Thread Ahmed Honest
Dear Pravin : Use the below =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")​ On Sat, Jun 22, 2013 at 3:15 PM, Pravin Gunjal wrote: > Dear Vaibhav > > It's not working,. please check the attachment. > Thanks, > > Pravin. > > -- Forwarded message -- > From: VBA VABZ

Re: $$Excel-Macros$$ Attrition Tracker

2013-06-20 Thread Ahmed Honest
Hi Santhosh: left / Avg. Head count = Attrition % can be done, where Avg. Headcount is Open + close / 2 and where Opening = No. of headcount on start of the month and Close = no. of headcount on end of the month. So pull the raw data in excel and do it. Hope this shall help you! Thanks, Ahmed B

Re: $$Excel-Macros$$ Average

2013-06-15 Thread Ahmed Honest
Try to use Average ifs if you are using Excel 2007 you shall get it. Thanks, Ahmed Bawazir​ On Sat, Jun 15, 2013 at 1:34 AM, Dheeraj Bankoti wrote: > Hi Experts, > PFA a sample file, in which I need average quantity. > > Appreciate any inputs. > > Regards > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Change to numbers

2013-05-07 Thread Ahmed Honest
Hi Danial : Press Ctrl + H and then in find what box keep comma , and in replace leave it empty and click Replace All it shall help... On Tue, May 7, 2013 at 10:55 AM, danial mansoor wrote: > dear Experts: > > Kindly look at my file,there are some numbers kindly convert this into > numb

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Ahmed Honest
Rakesh: Run Pivot table, if no Idea just google it to learn Pivot tables / go to youtube to learn pivot table. You will learn less time. Start exploring. Thanks, On Tue, Apr 30, 2013 at 2:04 PM, Rakesh kumar wrote: > Hi Friends, > > I have some problem in excel, please help me. > > column A

Re: $$Excel-Macros$$ Source Link updation error

2013-03-26 Thread Ahmed Honest
Pravin: Just Copy > Paste Special > Values the soure code will be removed and no Edit link errror will appear. On Tue, Mar 26, 2013 at 4:16 PM, Pravin Gunjal wrote: > Pl inform me how to remove those files. > > -- Forwarded message -- > From: xlstime > Date: Tue, Mar 26, 201

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Ahmed Honest
Dear Pravin, Use the solution which suit your need and meets your requirement. But my solution will be something like this : By holding Ctrl Key and by using Mouse click select the sheets you wish to delete. Once the selection of sheets is done --- right click and choose delete --- this will dele

Fwd: $$Excel-Macros$$ Automation in excel

2012-10-10 Thread Ahmed Honest
Here is the first one to help and elighten us Actually I don't know about the coding in vba where I can learn coding for vba. I know only record macro. I want to do coding in my way. What I want I get it from my data. Thanks Manoj On Oct 10, 2012 11:20 PM, "Rajan_Verma" wrote: > *Just a q

Re: $$Excel-Macros$$ Fun with Chart

2012-10-10 Thread Ahmed Honest
Dear Rajan, Salute for your Support and Talent. Will it not be better to enlight us with your skills by having a list of topic to educate the group from that list one by one, so that we become more productive in our daily life work. For sure, I believe you too believe that Sharing Knowledge alway

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Ahmed Honest
Dear Pravin, PFA with Revised and Swapnil one solution is also the same but it is disturbing the Date Column which has been undisturbed in my file. Choose which ever suits your requirement. Thanks, On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote: > Dear Pravin. > > *PFA* > >

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

2012-10-04 Thread Ahmed Honest
Dear Pravin. *PFA* On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote: > *Hello Friends,* > * > * > *I require a help on the subject matter. The file is attached for your > reference.* > * > * > *I have used the conditional formatting as mentioned in the excel file. > And I required that the

Re: $$Excel-Macros$$ DATE Conversion - Gregorian to Hijri

2012-09-25 Thread Ahmed Honest
de my day. Regards Ahmed Bawazir On Tue, Sep 25, 2012 at 8:14 PM, >>Excel Beginner<< wrote: > Hi Ahmed, > > Find the attachment. > > > > > > -- > *Regards,* > * > * > *Excel Beginner* > > On Tue, Sep 25, 2012 at 3:27 PM, Ahmed

$$Excel-Macros$$ DATE Conversion - Gregorian to Hijri

2012-09-25 Thread Ahmed Honest
Dear All, Please find attach the Raw Data sheet from which I need to convert a Gregorian Date to a Hijri Date and pull out the Day, Month, Year from the Hijri Date. Any help on this will be appreciated. Thanks, -- Ahmed Bawazir *احمد باوزير* -- Join official facebook page of this forum @ ht

Re: $$Excel-Macros$$ Need help in mandays

2012-08-06 Thread Ahmed Honest
Dear Deepak, Looking at your sample data one of your Outlet name : Janata Stores(S) starting from 9 to 15-Jul status is available only for 14 and 15-July as Off and Working, *what shall be considered as status for rest of the days i.e from 9 to 13-July ??* ** * * * * On Mon, Aug 6, 2012 at 2:5

Re: $$Excel-Macros$$ analysis

2012-07-11 Thread Ahmed Honest
Use Pivot Table you should get the desired On Wed, Jul 11, 2012 at 1:00 PM, Priti_Verma wrote: > * * > > *Hi,* > > *To all,* > > *I am new here,please help me ,to find out all details about the country > ,which is selected by drop down list.* > > *See the attached file.* > > ** ** > > -- > FORU

Re: $$Excel-Macros$$ My Submission- Chandoo's Dashboard Contest

2012-07-07 Thread Ahmed Honest
Hi Hilary, Just to have a look I have downloaded your file and enabled the macros in my computer. But since then My ribbon is has dissappeared and I'm unable to get it back. Please give me the steps to unlock and make my excel to normal one. Thanks, On Sat, Jul 7, 2012 at 5:14 PM, Hilary Lomot

Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

2012-06-28 Thread Ahmed Honest
Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I t

Re: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet

2012-06-27 Thread Ahmed Honest
Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I th

Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward

2012-06-27 Thread Ahmed Honest
Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: > > Dear all, > > Iam using Office 2007, when iam need to use Cr

Re: $$Excel-Macros$$ Macro for column size reduction

2012-06-17 Thread Ahmed Honest
Dear Amit, May be I'm not sure whether you are familiar with this Or this is what you are looking for i.e for making all columns adjust according to the Raw Data in a sheet you do this >> Ctrl + A to select entire sheet and after this Alt + O + C + A. Hope this helps. On Sun, Jun 17, 2012 at

Re: $$Excel-Macros$$ Seems Like comments but Not

2012-06-15 Thread Ahmed Honest
Dear Deba, That's INput message defined using Data Validation. For your information click in the cell where the message is coming up go to Data tab and select Data Validation and in Data Validation Check for Input message. Hope you shbould understand. Moreover, it's one of the way to guide the en

Re: $$Excel-Macros$$ No. of years and months

2012-06-13 Thread Ahmed Honest
A1, Try below formula, > * > =INT(A1/12)&" Years "&A1-INT(A1/12)*12& " Months"* > > > On Wed, Jun 13, 2012 at 5:56 AM, Ahmed Honest wrote: > >> Hi Experts, >> >> Based on a given number I need the result to be something like below:

$$Excel-Macros$$ No. of years and months

2012-06-13 Thread Ahmed Honest
Hi Experts, Based on a given number I need the result to be something like below: Given Number : 200 Answer should be 16 Years 8 Months. Is there any way of doing it in Ms Excel by Formula? Thanks, Ahmed Bawazir -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accu

Re: $$Excel-Macros$$ Date

2012-06-12 Thread Ahmed Honest
Hi Chandra, PFA and see if it helps Thanks, On Tue, Jun 12, 2012 at 4:45 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Can you please help me with attached excel. > > Thanks in advance. > > Regards, > > Chandra Shekar B > > -- > FORUM RULES (986+ members already BANN

Re: $$Excel-Macros$$ Date format change by running the macro

2012-06-12 Thread Ahmed Honest
Dear Ankur, Please if you don't mind will you make your font sytle and size as a simple Or plain one. It looks too ODD. Thanks for your understanding. Regards, On Tue, Jun 12, 2012 at 11:38 AM, ankur wrote: > *HI ASHISH > **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbec

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Ahmed Honest
; > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest > *Sent:* 11 June 2012 6:26 > > *To:* excel-macros@googl

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Ahmed Honest
is already attached in this group. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest wrote: > >> . > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise

Re: $$Excel-Macros$$ Concatenate Problem.

2012-06-11 Thread Ahmed Honest
Hi Deba, the same can be achieved without VBA let me know if you wish to have that. Just send me your file. I will send you the solution. On Mon, Jun 11, 2012 at 3:54 PM, Deba Ranjan wrote: > Thanks.. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Mon, Jun 11, 2012

Re: $$Excel-Macros$$ Records found but unable to get proper result.

2012-06-03 Thread Ahmed Honest
Hi, Use Vlookup formula, I think it should help you. Rgds On Sun, Jun 3, 2012 at 1:08 PM, Sourabh Salgotra wrote: > > Dear sir, >i am using index/match formula. in my problem i am getting the > 1st occurrence result only. > Sr. No. Subject Code Subject/Paper code 1 BF 1 MAT

Re: $$Excel-Macros$$ How to pick values from particular table/list

2012-05-29 Thread Ahmed Honest
Dear Amit, Use the Drop Down list options which is available in the Data Validation. I hope you know it. If not just google how to create drop down list you shall get the desired that you are looking for. Or revert to the group to help you out with this. Thanks, On Tue, May 29, 2012 at 10:18

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

2012-03-10 Thread Ahmed Honest
Dear Ashish, Click on below link to learn about Multi Sheet Pivot. http://office.microsoft.com/en-us/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx Thanks Ahmed Bawazir On Sat, Mar 10, 2012 at 3:09 PM, Ashish Bhalara wrote: > Dear sir, > > Please tell me

Fwd: $$Excel-Macros$$ Solution Request

2011-10-12 Thread Ahmed Honest
Hi, Hope these help, Drag the file down untill last row of the data sheet. On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest wrote: > Dear Mr. Shiek, > > Tons of thanks for your help. I hope that U achieved it by VBA but is there > any formula of excel to achieve this? > > De

Re: $$Excel-Macros$$ Solution Request

2011-10-12 Thread Ahmed Honest
it helps. > > Regards > > Shiek > > On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 wrote: > >> You say “single LINE”. Do you mean one cell ? If so, NO. >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Ahm

$$Excel-Macros$$ Solution Request

2011-10-12 Thread Ahmed Honest
Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@

Re: $$Excel-Macros$$ Max Value Required for Each half hour

2011-09-25 Thread Ahmed Honest
ust be entered using ctrl+shift+enter > > *=MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000 > *From:* Ahmed Honest > *Sent:* Sunday, September 25, 2011 8:02 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Max Value Required for Each half hour > > Dear Gr

Re: $$Excel-Macros$$ Two columns and three criteria

2011-09-15 Thread Ahmed Honest
Dear Arty, Run a pivot table and make the count of Passed, Failed on the specific date by removing the N/A from the filters. I hope you know how to run the pivot table. Regards Ahmed Bawazir On Thu, Sep 15, 2011 at 7:09 PM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (un

Re: $$Excel-Macros$$

2011-09-15 Thread Ahmed Honest
Hi Viper, you have viped away the attachment lol, there is no attachment attached. *Great day, Bawazir * On Thu, Sep 15, 2011 at 2:52 PM, §»VIPER«§ wrote: > hi > > pfa > > > -- > *Great day,* > *viper > > * > On Thu, Sep 15, 2011 at 5:05 PM, Abhishek Jain wrote: > >> Dear Naanu, >> >> P

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread Ahmed Honest
Dear Varun, Try to use Datedif function, if you are familiar with it or just google it you will get the solution in seconds. On Thu, Sep 8, 2011 at 11:27 AM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards > > Varun

Re: $$Excel-Macros$$ Admin & HR Management

2011-04-10 Thread Ahmed Honest
Dear Mr. Vasi, I hope this will be help you for sure. Kindly register yourself on www.citehr.com and you will be able to post your queries and get solutions for them. Anyways Congrats for your New Job in a new Destination. Regards Ahmed Bawazir On Sun, Apr 10, 2011 at 11:16 AM, vasisd wrote:

Re: $$Excel-Macros$$ Calculate Time

2011-03-07 Thread Ahmed Honest
Dear Paul, What an excllent way of explanation for the below. Hai there Maestro. Regards Ahmed Bawazir On Mon, Mar 7, 2011 at 8:49 PM, Paul Schreiner wrote: > Excel has it's own internal date/time functionality. > A "date" is the number of days since 1/1/1900. > "time" is a fractional part of

$$Excel-Macros$$ Covnersion of Hijri Date to Georgian Date

2011-01-31 Thread Ahmed Honest
Dear Group, A very good day to you guys, I have the following query for which i have searched internet as well and unable to get a formula or soultion and looking forward from you guys and i am sure any one will answer for the below: I want to convert a Hijri Date to Georgian Date with a formula.

Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

2011-01-23 Thread Ahmed Honest
Dear, That's possible. Please do a favour by sending a sample sheet of your query. I am sure you will get answer from the group. Regards Ahmed Bawazir On Sun, Jan 23, 2011 at 10:10 AM, kush sharma wrote: > Dear All, > > I have a query in which i need your help. Lets Say, I am using an Excel

Re: $$Excel-Macros$$ Need urgent help!

2011-01-04 Thread Ahmed Honest
Dear Sharma, I have no idea of your requirement but the file seems to be like willing to know the password predictions algorithms. Or Hacking password techniques. Please clarify on this or correct me if i failed to understand your file. Thanks & Regards Ahmed Bawazir On Mon, Jan 3, 2011 at 11:14

Re: $$Excel-Macros$$ Re: headcout dashboard report

2010-11-30 Thread Ahmed Honest
Dear Anand, As per your below mail i think that you have mailed to concerned person personal email. But would request you to be kind enough to send me as well. Appreciate and thanks in advance..!! Regards Ahmed Bawazir On Tue, Nov 30, 2010 at 8:30 AM, anandydr wrote: > Hi, > > Just mailed you

Re: $$Excel-Macros$$ Increment flags

2010-10-02 Thread Ahmed Honest
Dear Send a sample file to the group, hope you will get solution to your query. Regards Ahmed Bawazir On Thu, Sep 30, 2010 at 8:35 PM, Shah wrote: > Hi, > I need some HELP with increment flagging. > By flag I mean a One appears when an even happens, and a Zero appears > when it doesn't > > And

Re: $$Excel-Macros$$ Need help list box

2010-09-26 Thread Ahmed Honest
Dear Mohammed Idhrees, Please find attach, i hope this is your requirement, i have done only for the 2 rows which are colored in yellow, if you wish you can copy paste and tak the values from the list. If this is not your requirement you can revert to the group for more help. Regards Ahmed Bawaz

Re: $$Excel-Macros$$ Question asked in Interview...

2010-08-08 Thread Ahmed Honest
Hai, Our Favourite buddy in this group Mr. Dave has already given attention and replied to your query please see it again. I hope you might not have seen it. Regards Ahmed On Sun, Aug 8, 2010 at 6:51 AM, Vijay Kr. Aggarwal wrote: > Hi Friends, > > > If question is not clear in attached file th

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

2010-08-03 Thread Ahmed Honest
Hey Pankaj, The File is password protected, provide password to unlock and get the required. Group is waiting On Tue, Aug 3, 2010 at 7:13 PM, Intelligent But Crazy wrote: > Hi group, > > My self pankaj, > currentally I m working on a project, I have created

$$Excel-Macros$$ Need Formula

2010-07-28 Thread Ahmed Honest
Dear All, Please find attach the sheet wherein I need the Data from "Tracking Sheet" should go the each individual sheets the data. Please see attach file for more understanding. Waiting for your ideas and suggestions... -- Ahmed Bawazir -- ---

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

2010-07-13 Thread Ahmed Honest
Dear Dilip, Can you explain the logic, of getting the Unit Price 25-30, 30-35. as the source date holds no such units. Regards Ahmed Bawazir On Tue, Jul 13, 2010 at 12:59 PM, Dilip Pandey wrote: > Hey mr. Soni.. > > Two Charts has been created as per your requirements