View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Pearson Mike Pearson is offline
external usenet poster
 
Posts: 2
Default 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?