Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Thanks once again.Madam On Fri, Jun 21, 2013 at 11:48 AM, priti verma wrote: > Yes you can do it with macro, > See pfa > > > > On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav > wrote: > >> Dear Madam, >> >> Thanks a lot ... >> >> Can we make it from macro ... >> >> Regards, >> Prafull Jadha

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav wrote: > Dear Madam, > > Thanks a lot ... > > Can we make it from macro ... > > Regards, > Prafull Jadhav. > > On Fri, Jun 21, 2013 at 11:24 AM, priti verma wrote: > >> Hi prafull, >> >> PFA >> >> >> On Fri,

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Dear Madam, Thanks a lot ... Can we make it from macro ... Regards, Prafull Jadhav. On Fri, Jun 21, 2013 at 11:24 AM, priti verma wrote: > Hi prafull, > > PFA > > > On Fri, Jun 21, 2013 at 11:16 AM, Prafull Jadhav > wrote: > >> Dear Expert, >> Dear All, My date is horizontal ..i want to pul

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Hi prafull, PFA On Fri, Jun 21, 2013 at 11:16 AM, Prafull Jadhav wrote: > Dear Expert, > Dear All, My date is horizontal ..i want to pull it in one column . thanks > in advance Regards, > Prafull Jadhav. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =T

$$Excel-Macros$$ Horizontal to Vertical in One colume

Dear Expert, Dear All, My date is horizontal ..i want to pull it in one column . thanks in advance Regards, Prafull Jadhav. -- 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/

Re: $$Excel-Macros$$ formula require

Hi Vinay, You are really expert in excel. can you explain me how this formula works. Also share me your mobile no pls. On Tuesday, June 18, 2013 4:55:08 PM UTC+5:30, Vinay Saraf wrote: > Revised File > > On Tue, Jun 18, 2013 at 4:47 PM, priti verma > > > wrote: > >> pfa >> You can use this

Re: $$Excel-Macros$$ Need help

thank you On Fri, Jun 21, 2013 at 5:50 AM, Anoop K Sharma wrote: > use conditional formatting. > > > On Thu, Jun 20, 2013 at 2:02 PM, thameem wrote: > >> Dear Members, >> >> plz help me to get formuale for high-lighting selected cells >> automatically, when value of one cell get 0 or 1 etc >> >

Re: $$Excel-Macros$$ Need a Fastest way

I haven't studied above macro provided by De Premor, Nice work!. You can make it better by collecting all the highlighted cells address in different worksheet Or you can also use application.Goto "Reference". On Thu, Jun 20, 2013 at 1:07 PM, De Premor wrote: > How about this macro, is this stil

Re: $$Excel-Macros$$ Need help

use conditional formatting. On Thu, Jun 20, 2013 at 2:02 PM, thameem wrote: > Dear Members, > > plz help me to get formuale for high-lighting selected cells > automatically, when value of one cell get 0 or 1 etc > > > regards > Thameem.M > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Add me

Welcome on the Borad!! On Thu, Jun 20, 2013 at 4:16 PM, Muralidharan Thangavelu < muralika...@gmail.com> wrote: > -- > Regards, > > T.Muralidharan, > Asst Manager (Electrical), > L&T ECC Division, > Krishnagiri Walajabad Road Project, > Bargur, > Krishnagiri Dist, > Tamilnadu. > Phone-9489202217

$$Excel-Macros$$ Add me

-- Regards, T.Muralidharan, Asst Manager (Electrical), L&T ECC Division, Krishnagiri Walajabad Road Project, Bargur, Krishnagiri Dist, Tamilnadu. Phone-9489202217 E-Mail:muralidha...@lntecc.com muralika...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b

Re: $$Excel-Macros$$ Extract Unique Values with VBA

Beautiful , its working very nicely, thanks Boss, will study your code. On Thu, Jun 20, 2013 at 9:49 AM, ravinder negi wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (ravi_colw...@yahoo.com) Add cleanup > rule

$$Excel-Macros$$ Need help

Dear Members, plz help me to get formuale for high-lighting selected cells automatically, when value of one cell get 0 or 1 etc regards Thameem.M -- 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 @ htt

Re: $$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

Hi PFA, there are other solution for this. HTH On Thu, Jun 20, 2013 at 11:53 AM, Ali wrote: > Hi all, > > I have a worksheet that need to allocate the number of nights spent by a > guest in the relevant Columns designed for the purpose. I can't seem to > find the right formula to do this. > >

Re: $$Excel-Macros$$ Need a Fastest way

How about this macro, is this still to slow for your requirement ? Sub HiLightSelect() Dim HiSelect As String On Error Resume Next For Each i In Selection If Len(HiSelect) = 0 Then HiSelect = i.Address Else HiSelect = HiSelect & ", " & i.Address Next Cells(2, 5) = Hi

Re: $$Excel-Macros$$ Attrition Tracker

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