Copy rows if a cell value is matched

[DaveUK]

I have 2 workbooks

DailySchedules.xls

BB.xls

On a worksheet on "Schedules" on "DailySchedules.xls" i have data which starts at "A3" and can be an unspecified number of rows down.

I want to copy all row data for any row where column G, of that row, contains the value "NOT STARTED".(I also want to copy all cell formatting and values)

The destination is a worksheet "No Start" on workbook "BB.xls". Also though there will already be data on this worksheet (which also starts at "A3") and will have empty rows to seperate each days data. So i need some way to paste the data by first starting at row 65536 then up until the row is not empty then leave an empty row before pasting the copied rows. The copied rows do not want empty rows between them.
Column E contains the date (formatted as d-mmm-yyyy) so maybe a check for the same value in this column between pasting could establish if an empty row needs leaving before pasting the data.

btw :Both worksheets will already be be open.

TIA

 

[tactps]

Record a macro to filter and copy the first worksheet and paste into the second.

Then edit the macro and replace the paste detination with:
[a65536].end(xlup).offset(1,0)

This will paste it at the bottom.

If you need more help post what you have back.