PC Review


Reply
Thread Tools Rate Thread

cut rows from worksheet based on cell isdate value

 
 
rod
Guest
Posts: n/a
 
      19th Oct 2006

I am using a shared workbook with info in Columns A to S.
Info in rows usually at least 600 rows used.

Current Date is typed in Column A4 to A600 when task is complete for data
in Row 3.
So may have at random, Current Date in many Rows in Colums A .

Would like a function or macro to scan down the Column A and cut out the
complete row
and insert past into another shared workbook .


Rather than having to sort the worksheet by Coulmn A and cutting out all of
the
Rows of completed data, and then pasting into another shared workbook.
Several
times aday ..


A B C D E
1 comp part part part material
2 date number rev qty number
3
4 10/18 123456 A 45 913-104R



thanks
rod


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing rows based on isDate =?Utf-8?B?TWF0dCBQLg==?= Microsoft Excel Programming 1 19th Oct 2007 10:56 PM
Copying rows from worksheet A to worksheet B based on criteria =?Utf-8?B?am1tMDYyNg==?= Microsoft Excel Programming 2 11th Apr 2007 01:36 AM
Moving rows to another worksheet based on content of cell 5tin@ Microsoft Excel Programming 2 21st Nov 2005 02:22 PM
Auto-Hiding rows based on cell in seperate worksheet James C Microsoft Excel Programming 2 23rd Jul 2004 05:16 PM
Deleting Rows based on text in cell & formatting cell based on text in column beside it =?Utf-8?B?U3RldmU=?= Microsoft Excel Programming 4 26th Feb 2004 03:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:12 AM.