View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AnMalivoire AnMalivoire is offline
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