$$Excel-Macros$$ Formula to Separate Company name and Email Address

2012-08-28 Thread Zibraan
Hi Team, I am looking for a formula to separate Company's name and email address from IDs. Please refer the snap shot below IDS Company Email Address Accord Soft asiapaci...@accord-soft.com

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

2012-08-28 Thread Zibraan
k until it finds a space. This will define the point to split the >> string. No time to do it at the moment. >> >> >> On 28 August 2012 20:39, Zibraan wrote: >> >>> >>> PFA... >>> >>> >>> On Tue, Aug 28, 2012 at 4:08 PM, NOORA

$$Excel-Macros$$ How to get Last Saved time in Cell B1

2012-09-07 Thread Zibraan
Hi Team, How do i get the last saved time in (HH:MM:SS) format in cell B2. Thanks and Regards, -- 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 tit

Re: $$Excel-Macros$$ How to get Last Saved time in Cell B1

2012-09-07 Thread Zibraan
t; Regards, > Kuldeep Singh > > On Fri, Sep 7, 2012 at 12:30 PM, Zibraan wrote: > >> >> Hi Team, >> >> How do i get the last saved time in (HH:MM:SS) format in cell B2. >> >> Thanks and Regards, >> >> -- >> Join official facebook

Re: $$Excel-Macros$$ How to get Last Saved time in Cell B1

2012-09-07 Thread Zibraan
Hi Team, How do i get the last saved time in (HH:MM:SS) format in cell B2 in a shared workbook. Thanks and Regards, On Fri, Sep 7, 2012 at 12:30 PM, Zibraan wrote: > > Hi Team, > > How do i get the last saved time in (HH:MM:SS) format in cell B2. > > Thanks and Regar

Re: $$Excel-Macros$$ How to get Last Saved time in Cell B1

2012-09-07 Thread Zibraan
but paul now() will give me the current time even if the file is not saved On Fri, Sep 7, 2012 at 5:37 PM, Paul Schreiner wrote: > Zibraan, > As mentioned, you can use a BeforeSave event macro: > > Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As > Boolea

Re: $$Excel-Macros$$ formual to separate data from a cell

2012-10-12 Thread Zibraan
PFA... On Fri, Oct 12, 2012 at 5:24 PM, Munshi, Anwar wrote: > Hi, > > ** ** > > How can I separate data in a cell with no space, comma etc.? I have > attached file for reference > > ** ** > > ** ** > > Regards > *Anwar* > > > > ** ** > > -- > Join official facebook page of this f

$$Excel-Macros$$ Projects Pipeline sheet updation

2012-10-29 Thread Zibraan
Hi Team, Attached is the sheet where in i need some formula to get the below result. 1.) Create links so that if data is entered under an individual tab(eg for Steve, Srivats, Anders, etc.) it is reflected in the All Up tab. We want the All up tab to be the one place where you, me and anyone who

Re: $$Excel-Macros$$ Re: Projects Pipeline sheet updation

2012-10-29 Thread Zibraan
Exactly my point is the same but all sheets come from different circle offices, i just need to check it manually and forward the same to boss. Regards, Lucky On Mon, Oct 29, 2012 at 6:34 PM, Don Guillett wrote: > Why not make your life easier and use ONE sheet for all wtih an extra > column fo

Re: $$Excel-Macros$$ Re: Projects Pipeline sheet updation

2012-10-29 Thread Zibraan
Good Morning Don, Thanks a lot this stuff worked for me, but minute update is required in this macro can we get the source tab name inserted in a column in the summary sheet. Regards, Lucky S On Mon, Oct 29, 2012 at 7:52 PM, Don Guillett wrote: > Should do it in .xlsM workbook. > Sub getallSA

Re: $$Excel-Macros$$ Successfully passed the microsoft digital certification course.

2013-02-01 Thread Zibraan
Good Work and thanks a lot anil for sharing this gr8 info but plz be sure to share any such future opportunity Thanks once again On Fri, Feb 1, 2013 at 2:03 PM, अनिल नारायण गवली wrote: > its free of cost and take half an hour to complete > go to http://dsaksharta.in/ > register and go.. >

$$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-26 Thread Zibraan
Hi Team, Please refer the Sheet in which I need a formula which can calculate and show the planned leaves in date format and should highlight in Red. Thanks & Regards, Lucky -- 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 Facebo

Re: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-26 Thread Zibraan
s would be available with me in case anyone wants to refer in future. Hope you understand this explanation. Please reply. Thanks, Lucky S On Mon, Aug 26, 2013 at 9:10 PM, ashish koul wrote: > Do you want to show date rather than "L" sign? > > > On Mon, Aug 26, 201

Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-27 Thread Zibraan
Hi Team, Awaited for your expertise advice. Thanks & Regards, Lucky S -- Forwarded message -- From: Zibraan Date: Mon, Aug 26, 2013 at 7:36 PM Subject: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating To: excel-macros@googlegroups.com Hi

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread Zibraan
ld be available with me in case anyone wants to refer in future. Hope you understand this explanation. Please reply. Thanks, Lucky S On Wed, Aug 28, 2013 at 3:37 PM, ravinder negi wrote: > pls advise where you want answer and what exactly. > > ------ >

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread Zibraan
ak > > > On Wed, Aug 28, 2013 at 4:05 PM, Zibraan wrote: > >> Actually I want to show L whichever dates I have taken leave. >> >> But it should be automated by formula so that I just need to enter the >> dates in the sheet named "Database" and it will aut