Search : in
By :

Copy paste and delete rows based on a criteri

Last answer on Jul 8, 2009 9:03:50 pm BST giovana, on Apr 30, 2009 7:06:06 pm BST 
 Report this message to moderators

Hello,
I have a worksheet that contain these information:

RIG # DATE RECEIVED WORK ORDER TOTAL READY? SHIP DATE ST #
25 3/26/2008 WO 349618 $6,666.00 OK 3/27/2008 69375
1 2/5/2008 WO 342215 $708.00
12 2/27/2008 WO 345263 $108.00 OK
53 3/17/2008 WO 348715 $1,925.00
5 3/20/2008 WO 348906 $441.00 OK 5/12/2008 69583
4 4/28/2008 WO 355758 $6,528.00 OK 5/12/2008 69529

And I wanna copy and paste the whole row to other columns located in the same sheet and then delete the rows that I mark "OK" in the "Ready?" column. Do you think is any possible?? I have no idea how can I do this!
Thanks for your help!!

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Copy paste and delete rows based on a criteri » in :
Vi/Vim - Avoid tabs when making a copy/paste Show [VI/VIM] Avoid tabs when making a copy/paste By default, when you make a copy and paste in vi or vim (through an remote SSH session), it adds incremented tabs at each line. To solve this problem,simply type: set paste in the window or add the...
Copy Paste Option is not working Show
Cut & Paste Coloured Rows to another workshee Show
Copy/Paste problems when using Firefox ShowCopy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Quick Copy/Paste under Ubuntu ShowQuick Copy/Paste under Ubuntu Intro Uses: Intro Under Ubuntu there is a quicker alternative to make a Copy/Paste other than using the native CTRL V and CTRL C combinations . You simply select the target text (it is uploaded in...
Copy, Paste and Cut not functioning ShowCopy, Paste and Cut not functioning Issue Solution Issue I am having a problem, every time i want to copy, paste and cut my files, it's not working. Even am trying to use the keyboard combinations, CTRL+X, CTRL+C, and CTRL+V but it's...
Download FastPaste Show
Download Quicknote Show
Download Fonter viewer ShowFonter viewer is a tool to view fonts. The program uses HTML to view the installed fonts on your computer. View all the fonts and print the font list or an example of a font text. Use the clipboard of Windows and copy/paste to compare various...
UNIX - Files ShowIntroduction to UNIX files In UNIX systems any element is represented in the form of a file. All files are architectured around a single tree structure where the base, called the root, is written "/". File types UNIX systems define different...
UNIX Commands ShowTable of the main UNIX commands Unix Commands Description Options ls lists the content of a directory -a Displays all files, including hidden files -I Displays a...
Linux - The Vi editor ShowIntroduction to Vi Despite its very limited ergonomics, Vi i is one of the most popular text editors texte under Unix type systems (with Emacs and pico). Under Linux, there is a free version of Vi called Vim (Vi Improved). Vi (pronounced vee-eye)...
Ask your question Reply

1

Excelguru, on May 2, 2009 9:05:07 am BST

Use autofilter to get all "OK" rows to be displayed
then select all these rows and press CTRL- G and then "SPECIAL" then "Visible cells only"
Then you can delete the "OK" rows

   
Reply to Excelguru

2

Alex, on Jul 8, 2009 8:56:36 pm BST

Dont forget to mention which Office version you are using.
I am using Office 2003 and hitting ctrl-g brings up the "Goto" box.
-Alex

   
Reply to Alex

3

 adelara, on Jul 8, 2009 9:03:50 pm BST

Ah, got it.

The "Goto" is kinda misleading, but clicking on "Special" on the bottom of the panel
brings several options to chose from... pick "Visible Cells Only".

-Alex

   
Reply to adelara
Ask your question Reply
They need your help