Hi Roger
I want perform it automatically not manualy,because i have many matrix with
different data and little time for it.
regards

"Roger Govier" wrote:

Hi

If you are going to Copy, then the order that you do the operation does not
matter, but if you are to Cut then it does as if you cut the 3:43 range
first, then the row numbers will alter on you.

For Copy
Select the rows by selecting the row numbers, 3:43Copymove to new SheetA1
Paste
Repeat the process having selected rows 367:408 and pasting to cell A42

For Cut
Select rows 367:408CutMove to new sheet A1Paste
Select Rows 3:43CutMove to new sheet cell A1Insert Cut cells

--
Regards
Roger Govier

"climate" wrote in message
...
I have a matrix (16071 * 40), and i want copy or cut rows 3 to 43 and 367
to
408 and to the end to another worksheet.
Any help will be greatly appreciated.
regards.