LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Greater than, less than, cut and paste rows to sheet3

Hello
I am looking for a way to grab data in sheet1 column Y that is 0 or <0 (ie
any number that isnt 0). I then want to take those rows where data is
located, cut and paste them into Sheet3, starting at B23.
Does anyone know a good way of doing this? Thank you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1? Simon[_2_] Excel Programming 1 October 3rd 08 02:47 PM
Copy rows if greater than zero AndyB Excel Worksheet Functions 3 October 31st 07 02:52 AM
Delete Rows with Value greater than X STEVEB Excel Programming 4 July 26th 05 09:08 PM
Extract and copy Rows where value is Greater than 0 (zero) [email protected] Excel Programming 9 March 29th 05 02:03 PM
Auto-lookup values between Sheet3 & UserForm & paste to Sheet1 duBedat68 Excel Programming 2 December 22nd 04 01:37 PM


All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"