Re: $$Excel-Macros$$ subtracting time

2010-04-18 Thread rf1234 rf1234
Dear Rahul Your suggestion is appreciable,But how can 1 know that other person is new and he/she wants fundamentals first. I think new member should ask for fundamental study material with introducing himself. On Mon, Apr 19, 2010 at 11:11 AM, lal rahul wrote: >> >>> Hi Group, >>> To

Re: $$Excel-Macros$$ subtracting time

2010-04-18 Thread lal rahul
> > > Hi Group, >> >> To begin with i m the newest member of this Group and would like to >> APPRECIATE the efforts of the owners of this Group. >> >> SUGGESTION - Would it not be good to start a Tutorial step by step which >> any one can join >> >> like i m in intermediate in excel would like to

$$Excel-Macros$$ Need Urgent Help - Distance Calculator

2010-04-18 Thread Manoj Kumar
Hi Guys, I need a macro to calculate total distance between two states or cities or both from a distance search engine.For example:- http://www.mapquest.com/. Appreciate ur help. Thanks, Manoj Kumar -- -- Some im

RE: $$Excel-Macros$$ Data requeired please help me

2010-04-18 Thread Dave Bonallack
Hi, This can be done with data validation. Any particular reason you want to do it with a macro? Dave. Date: Mon, 19 Apr 2010 04:11:02 +1300 Subject: Re: $$Excel-Macros$$ Data requeired please help me From: mam...@gmail.com To: excel-macros@googlegroups.com Hi all, I wanted to write a m

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

2010-04-18 Thread rf1234 rf1234
Hello CrazyBond Actually this was my private project,perhapes that's the reason it will be locked. ok if u like this,i will try to send again without any lock On Mon, Apr 19, 2010 at 12:37 AM, crazybond wrote: > hi Shyam, > > Can I get the unprotected version of the said macro(Invo

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

2010-04-18 Thread crazybond
hi Shyam, Can I get the unprotected version of the said macro(Invoice loader with Sample Invoice.rar) ? Regds. On Thu, Apr 8, 2010 at 10:16 AM, rf1234 rf1234 wrote: > Hello Dear > Attached is the macro and sample xls,you can append or import, > > > > > > > > > > > > > > > Hope it Will Help > H

Re: $$Excel-Macros$$ Data requeired please help me

2010-04-18 Thread Mamtha Nagaraj
Hi all, I wanted to write a macro, to validate the data, as in in col a i want only numbers to be entered, in col b i want only text, col c i want alpha numeric.is it possible??if we try to enter wrong data a msg box should pop up..am a beginner , pls help me with simple code. Mamtha Nagaraj

Re: $$Excel-Macros$$ Data requeired please help me

2010-04-18 Thread Vijay Aggarwal
Hi Rajesh, Please check attached file. regards, Vijay On Fri, Apr 16, 2010 at 4:18 AM, Rajesh Nair wrote: > Please help > > -- Forwarded message -- > From: Rajesh Nair > Date: Fri, Apr 16, 2010 at 4:16 AM > Subject: $$Excel-Macros$$ Data requeired please help me > To: excel-ma

Re: $$Excel-Macros$$ Date Issue

2010-04-18 Thread Harsh Gharpure
Use the formula D5=text(C5,"mmm-yy") to display text in desired format. regards, Harsh On Wed, Sep 2, 2009 at 5:20 PM, Putta Madaiah wrote: > Hi Friends, > > I want a solution (Preferably formula) as expained in the attached sheet.. > > Thanks in Advance, > > Putta- Bangalore > > --~--~---

Re: $$Excel-Macros$$ subtracting time

2010-04-18 Thread Harsh Gharpure
If you know the time difference, following formula would work ( for example in India, i.e. + 5:30 GMT) : A1= IF(B1<"5:30",B1+"18:30",B1-"5:30") Where A1 is the time difference between "input time (B1)" and fix time ("5:30"). The cells are formatted as hh:mm and time in "B1" will have to be enter

Re: $$Excel-Macros$$ Extracting data from another workbook based on criteria

2010-04-18 Thread Mahesh parab
Hi Please find required info on below mention links http://www.exceltip.com/exceltips.php?view=category&ID=213 http://www.exceluser.com/explore/msquery1_5.htm On Sat, Apr 17, 2010 at 12:46 PM, OSA wrote: > *Dear Group,* > > I attached a sample worksheet which i used to extract data from it. T