Multiple selection copy - how??

[covehithe]

I am trying to make multiple selections of rows in a 450 row workbook,
the rows I want are random and not related. The idea is to select these
rows (approx 75) copy them and paste to a new workbook. I can make the
selections but get error saying copy is not available for multiple
selections.
How can I achieve the multiple selection, copy & paste.

 

[Dave Peterson]

Are you selecting the whole row?

When I'm doing this kind of stuff, I'll insert a new column and mark the rows I
want to copy with an X in that column of that row.

Then I can apply data|filter|autofilter and just show the X's. Then I can
copy|paste the visible rows.

It makes it easier to select/deselect when I make a mistake, too.

 

[covehithe]

Dave

Excellent, it worked as I wanted it
Many thanks

Covehithe