copy,pasting and deleting rows
Posted by jojo on January 04, 2002 2:52 AM
i have some 250 rows.i have some rows in which the
word "SOLD" appears.The word SOLD appears only in column 1.i have to cut these rows and paste them from row253.
Posted by Jaquenetta on January 04, 2002 3:19 AM
Sort by column 1, then cut and paste the rows containing "SOLD". Delete the cut rows.
If you have to keep the other rows in the original sequence :-
- Insert a column and enter consecutive numbers
- Sort by col 1, cut/paste the "sold" rows, and delete the cut rows.
- Delete the numbers in the inserted column that appear against the "Sold" rows
- Sort by the inserted column
- Delete the inserted column
