I would like to create a macro that copies data (based on cell formatting) on
one sheet (Qry Data) and pastes this data (paste special values) to the next
available line on another sheet (Audit Data). It is like that rows of data
won't be adjacent, but the column data will always be adjacent.

Does anyone have a macro that could do this?
--
Drew