Re: $$Excel-Macros$$ Re: Vlookup Help required

2015-01-10 Thread Vaibhav Joshi
hi what is your requirement? there is already formula in Sheet1 K2 & L2 cell On Sat, Jan 10, 2015 at 11:42 PM, Rakesh wrote: > Kindly with suitable formula urgenly required > > Rakesh > -- Forwarded message -- > From: "Mandeep Baluja" > Date: 06-Jan-2015 5:52 PM > Subject: $$Ex

Re: $$Excel-Macros$$ TIme format

2015-01-10 Thread Vaibhav Joshi
Hi try =TEXT(A2,"h") in cell c2 & drag down... Cheers!! ᐧ On Sun, Jan 11, 2015 at 11:52 AM, Rakesh wrote: > Dear experts > > kindly help me to change start time format . > > *StartTime* required format *10/26/14 3:08 AM* 3 *10/26/14 3:09 AM* 3 > *10/26/14 > 3:45 PM* 15 *10/26/14 3:45 PM

$$Excel-Macros$$ TIme format

2015-01-10 Thread Rakesh
Dear experts kindly help me to change start time format . *StartTime* required format *10/26/14 3:08 AM* 3 *10/26/14 3:09 AM* 3 *10/26/14 3:45 PM* 15 *10/26/14 3:45 PM* 15 *10/26/14 3:46 PM* 15 *10/26/14 8:11 AM* 8 *10/26/14 4:23 AM* 4 *10/26/14 4:15 AM* 4 *10/26/14 6:16 PM* 18 *10/26

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Rupesh Patil
Yes Vaibhav This group is rocking. On Sun, Jan 11, 2015 at 9:24 AM, Vaibhav Joshi wrote: > Namaskar Rupeah Patil Bhau, > > Good to hear that, this group is always rocking. > > Cheers!! > On Jan 10, 2015 10:49 PM, "Rupesh Patil" > wrote: > >> Hello group members. >> >> I am Rupesh Patil, I am wo

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Vaibhav Joshi
Namaskar Rupeah Patil Bhau, Good to hear that, this group is always rocking. Cheers!! On Jan 10, 2015 10:49 PM, "Rupesh Patil" wrote: > Hello group members. > > I am Rupesh Patil, I am working with Ayushman. Pvt as CSE. I learnt so > many Excel Formulas, VBA macros things from this group. > Tha

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Vaibhav Joshi
Hey Siegfried Warm welcome!! Cheers!! On Jan 10, 2015 10:25 PM, "Siegfried Schulte" wrote: > Hello esteemed group members: > > I am a retired staff member of the University of Toronto. More than 40 > years ago I did a lot of programming using Fortran, Pl/1 and Assembly. > About three years ago

$$Excel-Macros$$ How to apply validation in Open office 3.1

2015-01-10 Thread Kamal Ganeshan
Hi All, Can you please help me to apply validation in Open Office 3.1 Regards, Ganeshan -- 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 con

Fwd: $$Excel-Macros$$ Re: Vlookup Help required

2015-01-10 Thread Rakesh
Kindly with suitable formula urgenly required Rakesh -- Forwarded message -- From: "Mandeep Baluja" Date: 06-Jan-2015 5:52 PM Subject: $$Excel-Macros$$ Re: Vlookup Help required To: Cc: , Try this. > Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/v

Re: $$Excel-Macros$$ How to set a default in "Page setup > Sheet"

2015-01-10 Thread ashish koul
Hi In page setup - go to sheet - and choose none... See if it helps [image: Inline image 1] On Sat, Jan 10, 2015 at 11:02 PM, Siegfried Schulte wrote: > > > When printing a sheet that has comments one can choose how to handle the > comments > >1. [None] >2. At end of sheet >3.

$$Excel-Macros$$ How to set a default in "Page setup > Sheet"

2015-01-10 Thread Siegfried Schulte
When printing a sheet that has comments one can choose how to handle the comments 1. [None] 2. At end of sheet 3. As displayed n sheet. On my computer the default is set to 2; I would like to set it to choice 1 {None]. Anybody knows the answer? Siegfried -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Rupesh Patil
Hello group members. I am Rupesh Patil, I am working with Ayushman. Pvt as CSE. I learnt so many Excel Formulas, VBA macros things from this group. Thanks thank you all groups members. On Sat, Jan 10, 2015 at 10:23 PM, Siegfried Schulte wrote: > Hello esteemed group members: > > I am a retired

$$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Siegfried Schulte
Hello esteemed group members: I am a retired staff member of the University of Toronto. More than 40 years ago I did a lot of programming using Fortran, Pl/1 and Assembly. About three years ago I learned Visual Basics (for Excel). I wrote and maintain a DB for a charitable organization. Occasio

Re: $$Excel-Macros$$ Conditional format from different sheet - Macros

2015-01-10 Thread Vaibhav Joshi
Great.. Cheers!! On Jan 10, 2015 5:27 PM, "Haresh doley" wrote: > Great solution !! Perfect working > > > Thanks a ton for this. will try to learn how exactly code written. > > On Sat, Jan 10, 2015 at 2:56 PM, Vaibhav Joshi wrote: > >> Yes indeed... >> >> Check this file... >> >> Cheers!! >

Re: $$Excel-Macros$$ Conditional format from different sheet - Macros

2015-01-10 Thread Haresh doley
Great solution !! Perfect working Thanks a ton for this. will try to learn how exactly code written. On Sat, Jan 10, 2015 at 2:56 PM, Vaibhav Joshi wrote: > Yes indeed... > > Check this file... > > Cheers!! > ᐧ > > On Fri, Jan 9, 2015 at 10:04 AM, Haresh doley > wrote: > >> Dearest all, >

Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file

2015-01-10 Thread Vaibhav Joshi
is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal wrote: > Hello Friends, > > I have an excel file with many sheets which is attached for your reference. > > In this file there is a sheet called: "Mahavir" ( you may go to this sheet > by clicking on c

Re: $$Excel-Macros$$ Conditional format from different sheet - Macros

2015-01-10 Thread Vaibhav Joshi
Yes indeed... Check this file... Cheers!! ᐧ On Fri, Jan 9, 2015 at 10:04 AM, Haresh doley wrote: > Dearest all, > > Can we write macro for conditional format which is being refer from > another sheet as enclosed. > > Please help !! thanks in advance. > > > > Regards, > Harsh > > -- > Are y

Re: $$Excel-Macros$$ need help with looping a find - cut - paste macro Excel 2013

2015-01-10 Thread Vaibhav Joshi
Hi Try below code.. Sub blah() Dim fRow As Range, lRow As Range, rRange As Range Dim c As Range Set fRow = Range("K2") Set lRow = Range("K" & Rows.Count).End(3) Debug.Print lRow.Row Set rRange = Range(fRow.Address & ":" & lRow.Address) Debug.Print rRange.Address For Each c In rRange If IsEmpty(c)

Re: $$Excel-Macros$$ Copy Range From Files to Sheets

2015-01-10 Thread Zafar Iqbal
Dear Expert. Excellent Work. Bundle of thanks for it. Regards, Zafar Iqbal On Saturday, 10 January 2015 10:51:39 UTC+3, Vabz wrote: > > Hi Zafar, > > check this attachment.. > > Macro will chk for sheet name exist for filename for file string > -001.xls > > If exist then data will b