Dynamically Copy Sub-Totalled group to worksheet if criteria met

Hi,
I'm putting together a spreadsheet for reconciliations and I'm having a major headache with the final part.

A little background

The information to be reconciled is held in seven worksheets (one for each staff member). Each sheet has the same layout - 14 columns containing various product information.

The rows have been grouped using the sub-total function, based on the product code (Column D) and this gives us a total in Column J. Staff then would enter counts in Column K. Column L then displays the difference between K & L as a figure. Column N then displays "OK" or "Rec" depending on whether the total difference is below a certain percentage.

Where I need the help.

What I would like is to have another worksheet named 'Recs' that consolidates all the groups for which column N is showing as "Rec". Ideally this would be done on the fly, rather then manually running a script. My issue is that I'm really not too sure how to do this. The groups do not have a set number of rows, so can run from a single row to over fifty and will vary from month to month. I'd also like to only copy the groups to the new sheets, not remove them from their original locations.

If anyone could point me in the right direction as to how I can make a start on this, I'd be very grateful.

Thanks

attach an example with the correct format, layout and some sample data.
also, provide the output as you would want to see it. even if you have to manually create a small sample.
it's difficult to know your exact requirements without seeing an example.
you'll get faster results.
modytrane

Hi,

Please help for my post on 12.10.09 @ 11.20pm

Thanks