Adding Cell Value to another Sheet if...
On Sheet1 I have a column of account names and a column of dates of last vist
ie:
abc company 6/1/2007
xwz corp 4/15/2007
exl inc. 2/12/2007
aaa corp 6/5/2007
bbb inc. 6/11/2007
What I want to do is if the date of last visit is equal to month(today())
then I want it to list all of those accounts seperated by a comma on sheet2.
ie:
abc company, aaa corp, bbb inc.
Is that possible, if so how?
|