Copying non-consecutive rows is tough because Excel usually wants to
copy/paste continguous block of cells. But there is a trick you can use:

1. select an unused column and enter 1 in every row you want copied
2. switch on AutoFilter
Data Filter Autofilter and pick 1 from the pull-down
this will hide all the rows you don't want to copy
3. select the visible rows and then do the copy/paste.
--
Gary''s Student - gsnu200714