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: 1
Default Conditional Search & Cut and Paste *VBA?



Hi There
I am looking to put the following pseudo code into VBA or macro in
excel.
It's been years since I've actually coded anything so your help is
appreciated.

PS Will I get emailed when there is a posting to my question? If not,
please email me at

OK here's what I need

At the click of a button the code will search a worksheet (could be
hundreds of rows deep.

(in OriginalWorkbook)
If cell in column B = "READY" and cell in column D = <Todays Date
Then cut row and paste/add to StorageWorkbook
(in StorageWorkbook) If row is not blank then check next row
else paste row from
OriginalWorkbook)
End If
End If


--
AnMalivoire
------------------------------------------------------------------------
AnMalivoire's Profile:
http://www.excelforum.com/member.php...o&userid=24350
View this thread: http://www.excelforum.com/showthread...hreadid=379485

 
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
Search, Copy & Paste Formula chanse25 Excel Discussion (Misc queries) 1 March 13th 08 05:44 PM
Search, cut & paste chrisk Excel Worksheet Functions 0 November 22nd 07 03:13 PM
Search, copy and paste help [email protected] Excel Discussion (Misc queries) 0 June 15th 07 02:48 AM
VBA-code for search,copy and paste TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 December 12th 05 12:40 PM
search/copy/paste macro M Excel Programming 1 December 29th 03 07:26 PM


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

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

About Us

"It's about Microsoft Excel"