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.

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.

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.