Thread
:
Conditional Search & Cut and Paste *VBA?
View Single Post
#
1
Posted to microsoft.public.excel.programming
AnMalivoire
external usenet poster
Posts: 1
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
Reply With Quote
AnMalivoire
View Public Profile
Find all posts by AnMalivoire