copy of certain rows

C

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.
 
R

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
Click to expand...
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
 
C

climate

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