I am facing a problem with a macro. Here we have 4 sheet , say sheet1
sheet2 sheet3.(data)
sheet(output sheet) ..PLEASE TO REFER TO THE ATTACHED XLS
Target is a common variable and first column in all the sheets.
The macro which I have created asks me to first manually enter the Target
and any
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 sheet.
>
>
>
> Also I ne
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 column can increase or
> d
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 o
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 <> ""
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 L1. Xlsx
>
> Pls suggest
