$$Excel-Macros$$ combined formula required.

2013-09-08 Thread Kenil Gala
Hi group, I want a combination of IF and AND formula, or any other other suitable formula for inserting some indicators between fixed set of values. Pls find the file attached. Thanks Regards, -- 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)

Re: $$Excel-Macros$$ combined formula required.

2013-09-08 Thread xlstime
can u please share full condition . Enjoy Team XLS On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote: Hi group, I want a combination of IF and AND formula, or any other other suitable formula for inserting some indicators between fixed set of

Re: $$Excel-Macros$$ combined formula required.

2013-09-08 Thread Kenil Gala
Hope this helps, Thanks in Adv. From: xlstime xlst...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, September 8, 2013 3:47 PM Subject: Re: $$Excel-Macros$$ combined formula required. can u please share full condition  .

Re: $$Excel-Macros$$ copy data paste into new worksheet or book save into folder

2013-09-08 Thread black panther
Hi Anil, Thanks for your help i Appreciate On Tuesday, September 3, 2013 8:38:17 AM UTC+4, अनिल नारायण गवली wrote: Dear Prajakt Pande, Has it has lots of rows init. It will take nearly 5 min, so have patients. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software

Re: $$Excel-Macros$$ copy data paste into new worksheet or book save into folder

2013-09-08 Thread De Premor
Try This Sub WbSpliter() Dim Sh As Worksheet, Keys, LRow As Long Const SavePath As String = C:\Workbook Set Sh = ActiveSheet Key = Sh.Range(R2: Sh.Range(R2).End(xlDown).Address).Value2 Application.DisplayAlerts = False MakeDir SavePath For LRow = LBound(Key) To

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-09-08 Thread gaurav sethia
Hi guys, I get the #value error inspite of running it for the first time in the day. That is as soon as I enable the macro. When the macro is disabled, which is when i just downloaded the file, I can see the distance perfectly well. Can someone please help? Regards Gaurav On Saturday,