| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| searching and collating values in multiple sheets | Excel Discussion (Misc queries) | |||
| Data searching between sheets | Excel Discussion (Misc queries) | |||
| Data searching between sheets | New Users to Excel | |||
| Want to link several sheets in single workbook for searching purposes. | Excel Discussion (Misc queries) | |||
| Find (Ctrl +F) not searching all open sheets | Excel Worksheet Functions | |||
Linear Mode
