$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

Dear Deepak, Thanks a ton !! Iqbal On 8/11/09, Deepak Rai daksh1...@gmail.com wrote: Hi, In the Developer Tools click on More Controls then select Calender Control 12.0. Please follow the below steps to get the Calender Control: 1. Right Click on Menu Bar 2. Select Customize

$$Excel-Macros$$ Help Reg User form.

Dear All, Greetings of the day, I want to develop a user form with following condition. a) PO#. b) Po validity. e.g from (31/7/2009 to 25/4/2010) c) Po Amount. d) PO Description. e.g (this po is generated for work so on.) e) Search PO (eg by Po Number ) F) po STATUS ( e.g Closed or open

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

Vivek, Sorry to bother. Can we create drafts with attachement of New workbook generate by below macro as per client. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message-

$$Excel-Macros$$ Re: Remove starting letters

Hi, If you will have a . and space separating the supplier name, you can try: =RIGHT(A1,(LEN(A1)-FIND(CHAR(46),A1,1)-1)) where A1 is the cell with the supplier name. Hope it helps! CC On Aug 11, 3:43 am, Suhas chet...@gmail.com wrote: Hi, We have a file which is downloaded from HTML page.

$$Excel-Macros$$ Re: Hii..

Hi Ruchi, Attached workbook has two solutions for this problem. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi Friends,

$$Excel-Macros$$ Re: Count consecutive negative values

Hi Giorgio, Solved workbook is attached. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Aug 10, 2009 at 3:09 PM, Giorgio giorgioros...@googlemail.comwrote: Hi all, I have a series of %

$$Excel-Macros$$ Re: Anyone know this?

Hi Sandeep, I have given two ways in the following worksheet. Note:- If you have any test scenario, pls share. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Aug 10, 2009 at 10:37 AM, Sandeep

$$Excel-Macros$$ NAMED Range

Hi All, I have selected A1 to A5 and given some name(In Named Range). Now I want to remove it. Anyone know how to do it??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important

$$Excel-Macros$$ Re: NAMED Range

Most one knows..(Joke.) Simply go to Insert-Name-Define. Select the given name and click delete ( if you are using excel 2003) OR Go to Formulas-Name Manager. Select the given name and click delete (if you are using excel 2007) Regards, Upendra Singh +91-9910227325,

$$Excel-Macros$$ Re: vlookup help

yes, please email me at fahe...@gmail.com thanks On Aug 7, 1:06 am, fongie alvin.c.s.f...@gmail.com wrote: Hi Osiso You sent me an email today with another query. I tried to send back to paraport email but got mail server rejections. Is there another email I can email you on? Alvin On

$$Excel-Macros$$ Re: Outlook

thank for the reply. But I do not want to use excel to send email. May I know if there is a work around to automatically fill subject line, TO and CC field whenever I click on reply or forward? Regards On Aug 2, 7:10 pm, mahesh parab mahes...@gmail.com wrote: Hi Sahil below mention link will

$$Excel-Macros$$ Re: Hii..

Hi, Check the attached sheet to find how to use concatenate. For vertical look select wrap text in alignment tab in format cells. Anurag On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi Friends, I have data in three cell A1= My Name A2= is A3= Ruchi can i

$$Excel-Macros$$ Re: Hii..

Hi Ruchi Here is formula for your reference =A1 A2 A3 On Aug 11, 4:27 pm, Ruchi Saxena ruchi.saxe...@gmail.com wrote: Hi Friends, I have data in three cell A1= My Name A2= is A3= Ruchi can i have a formula wherein the below info in cell A1,A2 A3 appears in *single cell * i.e.