Excel 2007 : Copy Visible Filtered Rows between worksheets

Hi
Attached is a simplified version of a spreadsheet and macro I'm trying to create. There are 2 tabs:

1) BUSINESS TERMS: New Business terms are added to the "business terms" tab/table and, and all the other columns are filled in via formulas - if the data item is new then "Not yet mapped" is populated in the columns, and "N" is populated in the "Transferred to CDM?" column

2) CANONICAL DATA MAPPING: This tab is used to define the business term in terms of entities and attributes. The macro attached to the button on the "Canonical Data Mapping" copies unmapped business terms from the business terms tab to the canonical data mapping tab so that the entity name, attribute name and definitions can be filled in. These are then automatically populated back to the Business Terms tab via lookups.
It might seem a bit strange, but there is a reason for this!!

There are 2 areas of the macro that aren't working - one of which was and now isn't....
1) If no new business terms are found ie the filter doesn't display any rows, then a message should be displayed and nothing copied. I’ve used “If rng Is Nothing Then” ……this DID work by now isn't.....what have I done??

2) If data IS visible on the filtered table, then I want to copy the visible Business Terms (ie only the values in that one column) into the Canonical Data Mapping table - values only.

Can anyone help with either question?

Thanks in advance
Lisa