PDA

View Full Version : copy filter cells



inajica
07-06-2010, 12:10 PM
I usually have 30 or more records visible shown in column A using an autofilter. I want to copy the first ten cells and paste to another workbook. thank you.

p45cal
07-07-2010, 03:37 AM
Untested ('cos I think there are differences between xl2007 and xl2003):
Select the top ten lines, then press F5, click Special.., choose Visible cells only, OK, then press Ctrl+c to copy, move to your other workbook, select a cell and press Ctrl+v.

domfootwear
07-07-2010, 03:47 AM
Select the top ten lines, then press Alt+; and then Ctrl+C, and then goto other workbook, select a cell and press Ctrl+V