copying only cells in a filter with data
 

Hi,

if I filter a worksheet based on the data in one column, how do I use a
macro to copy data in other columns (and the filtered column) into another
worksheet? I only want the data which has been filtered, not blank cells
below the filter. Then the macro would need to copy the detail from some
other columns and paste the data alongside the filtered data in the new
sheet. What code, stops the process at the end of the filtered data and then
moves to the next step of the macro? Also it would need to copy the same
amount of rows for each column so the data remains intact.

Hope I have made some sense.

Matt