hiya i'm having trouble, i have a workbook with 3 sheet on

in sheet 1 i have a list off numbers, i need them numbers to be copied into
sheet 2,
here's the problem i only want the numbers showing to be copied.
i.e
sheet1
a: i filter this down to a:
1001 1001
1002 1003
1003
this list is over 1000 lines long.

what i need is for the filtered amounts to be transfered to sheet 2 without
leaving spaces in the new column.

please help

--
deejay