code for Copying rows based on a value
 

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

code for Copying rows based on a value
 

Just a little more info and we could help you.

"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

code for Copying rows based on a value
 

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