Re: $$Excel-Macros$$ Help to create transport Cab roster

On 14 June 2013 11:13, Prabhu Pinky prabhupin...@gmail.com wrote: Hi asish..i can give inputs for you. Gimme some till will prepare a document and share to you..hope it may help you... On Jun 14, 2013 10:57 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Seniors, How to create a

$$Excel-Macros$$ Date conversion to other format

Hi, I want to convert the date =Today() to this format : DD.MM. Formula =Today() 6/14/2013 In next cell, it should display as : 14.06.2013 Sample file is attached. Thanks. Regards Pravin Gunnjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Date conversion to other format

Dear Pravin try it =TEXT(TODAY(),dd.mm.) or select cell and press ctrl+1 and type in custom format dd.mm. On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I want to convert the date =Today() to this format : DD.MM. Formula =Today() 6/14/2013

Re: $$Excel-Macros$$ Date conversion to other format

refer.. On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I want to convert the date =Today() to this format : DD.MM. Formula =Today() 6/14/2013 In next cell, it should display as : 14.06.2013 Sample file is attached. Thanks. Regards Pravin Gunnjal

Fwd: $$Excel-Macros$$ Date conversion to other format

Fantastic... Thanks Vaibhav Noorain. Regards Pravin. -- Forwarded message -- From: VBA VABZ v...@vabs.in Date: Fri, Jun 14, 2013 at 12:15 PM Subject: Re: $$Excel-Macros$$ Date conversion to other format To: excel-macros@googlegroups.com refer.. On Fri, Jun 14, 2013 at 12:10

$$Excel-Macros$$ Preserving OLD values

I have a requirement like this If I enter some new value in cell A2, the previous value should get copied or backed up in cell b2. like wise for next 2000 rows. Any help greatly appreciated. Eugene -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Preserving OLD values

The way I've accomplished something similar is:   Create a Public Variable Create a SelectionChange event   The Event macro checks to see if the selected cell is in column A.  If it is, save the current content in the Public Variable. Create a CHANGE event   In the Change Event, if the cell

$$Excel-Macros$$ Excel Template

Need an excel template to manage multiple IT vendors relationship. Can anyone help? -- 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 1) Use