I use the sort and filter function regularly on worksheets with line items in
excess off 400 000. 1. Once filtered, to copy and paste the filtered area
pose to be a problem. I highlight the selection as normally done in excel
2003, by highlighting the row. When I "ctrl"+"c" the selection is copied as a
block and the complete sheet is copied in stead of the selected filtered
portion. I have to hold down "crtl" and select each line individualy. What do
I do wrong? 2. Once highlighted I have to open a new sheet in the workbook in
order to copy the selected line items. Only to copy and paste again from the
new sheet in order to get the information on a seperate workbook. Is there
any other way?