code for Copying rows based on a value

M

Mir Khan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO THAT BUILDS ON ANOTHER MACRO'S DATA 6
copying if value in cell from range of cells 4
this code is VERY slow, is it the code or perhaps a worksheet issue 32
Copying a row to new sheet based on column value 5
create macro - delete all rows with zero in column L 2
Inserting and copying Rows based on a variable 2
Problem with Chnaging fonts to Strikethrough 1
coding for variable rows 1

Top