I have a list of trades that I keep track of. The file just keeps
getting longer and longer. At the end of the day I would like to click
a macro that looks at Sheet1 and checks to see if the date (in column B)
is today’s date. If it is copy that line to Sheet2 and continue to
check until the end of the list of trades on Sheet1.

I can do a macro that uses sort but that’s not really efficient. Any
help you can give as always is very much appreciated.


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=544324