searching all sheets in a wb
 

i have 2 workbooks

workbook1 has in each sheet in cell a1 has a date of the 1st of each
month
in a year. workbook2, a cell needs to find data in workbook1, if date
in a1 are the current month and year (day does not matter), carry out a
task.
i am not sure how to look in each cell of a workbook though, i have the
following so far but its only for one month not for each month. please
could you advise


Code:
--------------------
=IF($A5=0,"",IF(MONTH(TODAY()-1),SUMPRODUCT(--('[Monthly Data.xls]Feb2006'!$B$4:$B$701="open"),--(ISNUMBER(MATCH('[Monthly Data.xls]Feb2006'!$F$4:$F$701,$B5:$C5,0))))))
--------------------


thanks


--
jay d
------------------------------------------------------------------------
jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487
View this thread: http://www.excelforum.com/showthread...hreadid=553969