I cannot do the oopy paste command in multiple selections in the .

I am trying to copy different rows of a sheet (not one below the other) and
to paste them in another sheet but I received a message saying: command
cannot be used on multiple selections. Is any way to do it because it takes
too long for a sheet of 7000 rows

If you select entire rows, it should work.

--
Regards,
Tom Ogilvy

"Penny" <Penny @discussions.microsoft.com> wrote in message
news:0D09F9A7-7E3B-416C-8E96-79B06D5E495C@microsoft.com...
> I am trying to copy different rows of a sheet (not one below the other)
and
> to paste them in another sheet but I received a message saying: command
> cannot be used on multiple selections. Is any way to do it because it
takes
> too long for a sheet of 7000 rows

Penny wrote:
> I am trying to copy different rows of a sheet (not one below the other) and
> to paste them in another sheet but I received a message saying: command
> cannot be used on multiple selections. Is any way to do it because it takes
> too long for a sheet of 7000 rows

It might be done with a VBA macro if there is a pattern to the rows
you're copying. I.e., is it every other row, every third row? Or, do
the rows you want to copy and paste all have a certain number or text
string in a predictable location? If so, a macro could probably do it.