Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
searching all workbook sheets
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 look at 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, please could you advise? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 sheets in workbook, but visible only one? | Excel Discussion (Misc queries) | |||
Copy formatted in several sheets of a workbook | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Sending sheets in workbook | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) |