$$Excel-Macros$$ Re: If item x found in column Then copy

wsS.Rows(i).Copy wsD.Rows(j) j = j + 1 End If Next i End Sub Roger Govier Microsoft Excel MVP 2009/5/1 Souriane > > Hi, > > I would like to build a macro that does the following: > > I am in Sheet 1. > If the cell of "Column E" = &

$$Excel-Macros$$ Re: Skipping holidays

have a list of Holiday dates in cells A1:A12, then use =WORKDAY(B3,F3-1,$A$1:$A$12) Regards Roger Govier Microsoft Excel MVP 2009/4/30 Harmeet Singh > > > On Thu, Apr 30, 2009 at 7:33 PM, Praveen Khunte > wrote: > >> Hi All Excel Lovers >> >> I have at

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

Hi The formula is saying If the value in cell C8 is not equal to the value in cell C7, then return the value of 1, otherwise, return the value of 0. Regards Roger Govier Microsoft Excel MVP 2009/4/27 Ahmedhonest > Dear Fabio Lemos, > > I appreciate your solution to the Query but m

$$Excel-Macros$$ Re: Dynamic range for pivot table

Hi I think the problem is that you are enclosing rng within quotes as your Source data. Try removing the quotes and it should work. ActiveWorkbook.PivotCaches. > > Create(SourceType:=xlDatabase, SourceData:= rng, > Regards Roger Govier Microsoft Excel MVP 2009/4/29 Govind Kedia