copy of certain rows

[climate]

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.

 

[Roger Govier]

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:43>Copy>move to new SheetA1

Paste

Repeat the process having selected rows 367:408 and pasting to cell A42

For Cut
Select rows 367:408>Cut>Move to new sheet A1>Paste
Select Rows 3:43>Cut>Move to new sheet cell A1>Insert Cut cells

 

[climate]

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