$$Excel-Macros$$ Urgent need SAS Developer (68265)-Oakland, CA-LOCALS only

2015-11-02 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Sr. SAS Developer* *Location: Oakland, CA-LOCALS * *Duration: 13 months* *See attached job description* *JD:-* PM / tech combo Need someone who can program in SAS in a MVS mainframe

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-02 Thread Paul Schreiner
Dates should be displayed as the Windows settings dictate. So, when *I* open it, the date displays as 11/2/2015. you can change it to 02-Nov-2015 if you want, and the dates should calculate correctly.  Paul- “Do all the good you can, By all the means you

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-02 Thread Will Sob
the date seems to be a problem it appears as 2/11/2015 on my computer it wont work On Mon, Nov 2, 2015 at 12:45 PM, Paul Schreiner wrote: > Attached, I created a function to locate the most recent occurrence. > =Find_Num() > > > *Paul* >

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-02 Thread Will Sob
Hi paul how do i change the date to 31/10/2015 On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner wrote: > Dates should be displayed as the Windows settings dictate. > > So, when *I* open it, the date displays as 11/2/2015. > > you can change it to 02-Nov-2015 if you want,

Re: $$Excel-Macros$$ Running Macro from Task Scheduler

2015-11-02 Thread yogananda muthaiah
send the file will change it and send it back​ On Tue, Nov 3, 2015 at 12:22 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Am trying to run macro from task scheduler which will send mails from > outlook but its working fine when I run it manually but if I schedule it >

$$Excel-Macros$$ Help with Custom Vlookup

2015-11-02 Thread Abhishek Jain
Hi All, I intend to use this piece of UDF I found on internet for my requirement - Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long) Dim r As Range Dim result As String result = "" For Each r In lookuprange If r = lookupval Then result = result & " " & r.Offset(0,

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-02 Thread Will Sob
i keep getting #Name result On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner wrote: > Dates should be displayed as the Windows settings dictate. > > So, when *I* open it, the date displays as 11/2/2015. > > you can change it to 02-Nov-2015 if you want, and the dates should

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-02 Thread Will Sob
Paul I dont seem to understand these formulas given when l change the data the formula does not change On Mon, Nov 2, 2015 at 8:51 PM, Will Sob wrote: > i keep getting #Name result > > On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner > wrote: > >>

Re: $$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach Sheet..

2015-11-02 Thread Paul Schreiner
I think I understand your requirement. You want to select the two columns in "Sheet1"and have the macro hide all columns except those selected. The attached file creates a pull-down list in each of the cellsso that they are updated with the list of categories.Once selected, the Change Event

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-02 Thread Paul Schreiner
Attached, I created a function to locate the most recent occurrence.=Find_Num() Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as