Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Experts!!! Any Hope regarding on this?? Warm Regards, Vikkhe1 On Thu, Apr 28, 2016 at 6:55 PM, vikas khen wrote: > Hi Team, > > > > Please find the attached sheet in which there are two different sheets one > is INPUT and other one is required OUTPUT based on input

Re: $$Excel-Macros$$ Finding Overlapping dates

Hi Team, Just wanted to check if you have found any solution. Regards Atuk On Wed, Apr 27, 2016 at 10:35 PM, Atul Kesaria wrote: > Hello Team, > > I need a help to fit in a formula to find if there are any overlapping > dates for multiple date range. Please note that

$$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Team, Please find the attached sheet in which there are two different sheets one is INPUT and other one is required OUTPUT based on input sheet. Also I need specific word from Input sheet (ENTRY or EXIT) and reflect the same in to status row i.e. on E Column respectively. Your help

Re: $$Excel-Macros$$ Macro error in opening file

I simplified the macros wrote two versions.One using Dir() and another with the FileSystem object. they both work just fine: Sub First_Macro()     Dim MyFile As String     Dim path As String         path = "D:\For Pankaj\Dump\"     MyFile = Dir(path & "*L1.xlsx")         Do While MyFile <> ""   

Re: $$Excel-Macros$$ Macro error in opening file

It is working perfectly fine at my end. On Thu, Apr 28, 2016 at 11:36 AM, Secret Shot wrote: > I tried that option... When I am using > > Workbooks.Open (path & MyFile) > > Then my loop is going in infinity and every time it is reopening the first > file only.. Which 04

Re: $$Excel-Macros$$ Macro error in opening file

I tried that option... When I am using Workbooks.Open (path & MyFile) Then my loop is going in infinity and every time it is reopening the first file only.. Which 04 L1. Xlsx Pls suggest On Apr 28, 2016 11:02 AM, "Abhishek Jain" wrote: > In your first macro, instead