I'm completely new to VBA in Excel but need to create a functionality to
copy rows from one sheet to another - but only if there is a 'n' in
Column A of the row. Then when it's copied into the new sheet I need to
be able to sort it by Column B (a date) and if the date is older than
today's it ideally needs to be deleted or hilighted in some way - but
this part is not essential. This seems like a tall order to me, but
then hopefully someone out there can help me! P.S. This can be put into
a macro button rather than just 'happen automatically'. Hope this makes
sense.


--
flurry
------------------------------------------------------------------------
flurry's Profile: http://www.excelforum.com/member.php...o&userid=34303
View this thread: http://www.excelforum.com/showthread...hreadid=540705