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