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

this code is VERY slow, is it the code or perhaps a worksheet issue 32
MACRO THAT BUILDS ON ANOTHER MACRO'S DATA 6
Copy/paste in based on duplicate value in previous row 0
converting a for next loop into a for each loop 2
copying if value in cell from range of cells 4
A Huge Conditional Format Challenge.... 2
New topic from discussion "Align cells with same value - vba almostworking" in this group 0
Copy rows to new sheet based on value in column A 0

Top