Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder

Hey, I understood you're question that's why I replied bro. Okay let me tell you a trick. > Go to that folder open in window explorer on right side you will see the > search option enter the number you're are looking for it will show you > those files which contains the text present

Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder

Check this out and let me know !! Regards, Mandeep baluja Sub SearchDir() Dim i As Long: i = 2 'A variable to paste values in main sheet Dim Searchword As Variant 'Search value to be used Dim Wbmain As Workbook 'Main workbook Dim fldAs Object

$$Excel-Macros$$ Client in Houston TX need Tableau SME

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Position: Tableau SME* *Location: Spring (north of Houston), TX* *Job Type: Contract (3-6 months)* *Description: * Acts as a technical lead on projects. Responsible for solving highly technical and

$$Excel-Macros$$ Client need VOIP Systems Engineer in Chevy Chase , MD

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :VOIP Systems Engineer* *Location :Chevy Chase , MD* Hands on knowledge of *Cisco Unified Contact Center Enterprise (UCCE), * *JD:-* Telecommunications Team is seeking a highly motivated and

$$Excel-Macros$$ Client in Chevy Chase, MD need SOA Architect(.Net) role-Preferred LOCALS

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :Application Architect* *Location: Chevy Chase, MD* *Duration: 6+ months* *Notes: Looking for 30% architect + 70% hands on developer* *Prefer consultant from DC metro area or near by.* *Job

$$Excel-Macros$$ Re: Having trouble with INDEX and INDIRECT

> > Hey, > The Error you are getting is just because the defined array is not Correct in INDEX,Let me Explain it to you Why !! Indirect Syntax is =INDEX(Array,Rownum,Column) For example you want to go two rows down and 2 columns wide then formula would be = index(A1:D10,2rows down,3columns

Re: $$Excel-Macros$$ Re: Required Macro

Thank you sooo much Mandeep :) You are really the best :) thanks again On Wed, Jan 20, 2016 at 11:13 AM, Mandeep Baluja wrote: > PFA !! > > Regards, > Mandeep baluja > > -- > 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) !

$$Excel-Macros$$ Re: Required Macro

PFA !! Regards, Mandeep baluja -- 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 concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Required Macro

Hi Experts, Please help me solve this problem through VBA Macro. Problem Statement In the Input sheet some names of the employees will be populated in column A as shown below. The rows in which data will be available is uncertain. Provide the output in Output sheet in column A. First row

$$Excel-Macros$$ Re: add date instantly when there is update in worksheet

Hi Mandeep, I've already got the database in the worksheet1. User can add data in row or column after the available data on current worksheet. When user add data in either row or column, I want it to automatically write the word 'new' in A column and compare worksheet1 with worksheet2 and add

$$Excel-Macros$$ Reminer -- Prompt / Ask the value & then calculate value

Hello Friends Any solution for my query . Is this possible ?? Then please take some time to resolve my query. Thanks & have a nice day ... Respected Friends Information --- >> This is sample file for the premium calcualtion as per Age & sum Insured If any body age is more then 70 then I have

$$Excel-Macros$$ add date instantly when there is update in worksheet

Hi all, I was wondering how to have the date being added automatically when there is new update in the worksheet either by column or by row. Cheers -- 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 @

$$Excel-Macros$$ Re: add date instantly when there is update in worksheet

> > Use the worksheet event to trigger, It depends on you where you want to > place date. > Private Sub Worksheet_Change(ByVal Target As Range) 'Application.EnableEvents = False Range("E1").Value = Date 'Application.EnableEvents = True End Sub Regards, Mandeep baluja -- Are you

$$Excel-Macros$$ Required formula for 52 week high & low as per attach sheet

Dear Sir Please find the attachment and provide solution as per requirement mentioned. Regards -- *Rajesh Kumar Agarwal* *9811063001* -- 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 @

$$Excel-Macros$$ Having trouble with INDEX and INDIRECT

Hello, I've struggled with building a INDEX formula that would reference dynamic file names and tabs which I'm hoping that someone can help with. I'm building a file that would consolidate hours entered into a schedule by a shop. Each week I would define which week from which I would pull the

$$Excel-Macros$$ edges swapped problem

this is my small code I want some help .. in this sheet I have some input about userid,subjectid,rowid, that the output is source ,target,label..it hepled me to find the combinations of two users ...but it's give me the swapped too..how can I fixed it any idea plz...!! -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Prompt / Ask the value & then calculate value

Respected Friends Information --- >> This is sample file for the premium calcualtion as per Age & sum Insured If any body age is more then 70 then I have to write in Cell -- G26 For example age is 72 I have written in G26 -- Age 72 But the premium calculates only if I mention E26 as 70 Otherwise

$$Excel-Macros$$ Client in Bethpage, NY need WebLogic/JBoss Admin C2H role

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : WebLogic/JBoss Admin * *Location: Bethpage, NY* *Duration: 6 months Contract to hire- Will sponsor H1B* *Skype/Telephone Interview * Strong knowledge of UNIX operating systems (HP-UX,