searching all sheets in a wb

J

jay d

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

searching all workbook sheets 0
Calendar Logic: Recurring Dates 3
Extract Month and year from Cell containing date, month, year & time 2
Forumal writing for imported sheets 0
YTD SUMIF based on current date 3
Summarizing multiple worksheet data 0
Search & insert 6
if function (if more that 7 nesting) 2

Top