I got solution to this on rondebruin's web page.
Thanks
Ron
"Mir Khan" wrote:
> Hi Mike,
>
> Information on the sheet 2 is about the agents and i would like to know
> about the full time employees, this information is stored in column I of
> sheet 2. I need to to pull the information of full time agents and the
> infomation that i need to pull is in column J (Firstname), columnK (Lastname)
> and column L(Manager).
>
> Sheet 1 has floor plan (it is an outline of the floor with the cube numbers
> and agent names to see who is sitting where) the floor plan covers top 45
> rows of the sheet 1. i want the three field names --Firstname, Lastname and
> Manager to display on row 49 column F, column G and column H of sheet 1.
>
> i need a macro to look for "Full Time" in column I and copy information from
> column J, K and L from sheet 2 to column F, G and H on sheet 1. so that i can
> have list of all Full time associates.
>
> Thanks
>
> Mir Khan
>
>
>
> "Mir Khan" wrote:
>
> > Hi, I have an Excel workbook with two worksheets.
> > Sheet1 has Floor Plan that cover top 45 rows
> >
> > Sheet 2 has Agent information.
> >
> > One of the column is Job Type that store "Full time" or "Part Time". I want
> > to list column J, K and L of rows that has job Type "Full Time" at any
> > giving time in Sheet 1 (at Row 50, column F,G and H) by using a macro. Also I
> > need Row 49 to display Field Name of column J, K and L.
> >
> > Thanks
> >
> > Mir
|
Similar Threads
